Comparison Operators
1.

Which operator is used to compare a value to a specified list of values?

A.  

ANY

B.  

BETWEEN

C.  

ALL

D.  

IN

2.

What operator tests column for absence of data

A.  

NOT Operator

B.  

Exists Operator

C.  

IS NULL Operator

D.  

None of the above

3.

Which operator is used to compare the NULL values in SQL?

A.  

Equal

B.  

IN

C.  

IS

D.  

None of Above

4.

Which of the following statement is correct regarding the difference between TRUNCATE, DELETE and DROP command?

I. DELETE operation can be rolled back but TRUNCATE and DROP operations cannot be rolled back.
II. TRUNCATE and DROP operations can be rolled back but DELETE operations cannot be rolled back.
III. DELETE is an example of DML, but TRUNCATE and DROP are examples of DDL.
IV. All are an example of DDL.

A.  

I and III

B.  

II and III

C.  

II and IV

D.  

II and IV

5.

Which of the following options are correct regarding these three keys (Primary Key, Super Key, and Candidate Key) in a database?

I. Minimal super key is a candidate key
II. Only one candidate key can be a primary key
III. All super keys can be a candidate key
IV. We cannot find a primary key from the candidate key

A.  

I and II

B.  

II and III

C.  

I and III

D.  

II and IV

6.

Which of the following operator can be used with a multiple-row subquery?

A.  

=

B.  

BETWEEN

C.  

NOT IN

D.  

<>

7.

Which of the following is a comparison operator in SQL?

A.  

=

B.  

<>

C.  

`

D.  

/

8.

Which from the following operators is not a comparison operator ?

A.  

==

B.  

!=

C.  

#=

D.  

<=

9.

Which of the following is a comparison operator in SQL?

A.  

=

B.  

LIKE

C.  

Between

D.  

ALL

10.

Which operator is used to return value from JSON columns after evaluating the path and unquoting the result ?

A.  

->

B.  

->>

C.  

<<

D.  

>>