Question 1

Which SQL keyword is used to specify the table(s) from which data should be retrieved?

Accepted Answer

FROM

Answer

INTO

Answer

SELECT

Answer

WHERE

Question 2

Logical operators 'IN' syntax can consist of multiple values

Accepted Answer

true

Answer

false

Question 3

In BigQuery, what can you do to reduce query cost and improve query performance?

Accepted Answer

Use efficient data partitioning and clustering

Answer

Always retrieve all columns in your SELECT statement

Answer

Avoid using indexes

Answer

Write longer and more complex queries

Question 4

Order the syntax

Accepted Answer

SELECT.... FROM.... WHERE.... ORDER BY...

Answer

SELECT.... WHERE.... FROM.... ORDER....

Answer

SELECT.... WHERE.... FROM.... ORDER BY....

Answer

SELECT.... FROM.... WHERE.... ORDER....

Question 5

What SQL clause is used to filter rows based on a specified condition?

Accepted Answer

WHERE

Answer

FROM

Answer

SELECT

Answer

ORDER BY

Question 6

Logical operators "<>" and "!=" will NOT have the same result

Accepted Answer

false

Answer

true

Question 7

BigQuery is case sensitive

Accepted Answer

true

Answer

false

Question 8

What is the operator for 'not similar' in query expression?

Accepted Answer

!=

Answer

/=

Answer

not =

Answer

==

Question 9

Which data types need quote ('.....') or (".....")?

Accepted Answer

Date

Answer

Integer

Answer

Float

Answer

Boolean

Question 10

To exclude several values, you can use "NOT IN" logical operators

Accepted Answer

true

Answer

false

Related quizzes