Subquery in SQL

________ is a subquery.

• Sub part of a query

• Query within the query

• Clause

• None of the above

Which is/are example of list operator in SQL?

• Relation

• IN

• NOT IN

• Both IN & NOT IN

Which is/are part of subquery?

• Inner query

• Outer query

• Both Inner query & Outer query

• None of the above

Which of the following keywords are equivalent?

• IN, NOT IN

• AND, OR

• NULL, NOT NULL

• ANY, SOME

Which keyword is depends on the existence of the result of the query?

• EXISTS

• NOT EXISTS

• NOT NULL

• WHERE

Subquery contains _________ number of query.

• One

• Two

• Zero

• Any Number

In subquery, =ANY works as given keyword.

• IN

• NOT IN

• <>

• !=

Which of the following operator are equivalent?

• <>ANY, <>SOME

• !=ANY, !=SOME

• =IN,=NOT IN

• Both <>ANY,<>SOME & !=ANY,!=SOME

Which keyword is used to join multiple strings into a single string?

• Join

• Concate

• Concat

• Concatenate

ANY and SOME are the modified version of _______ operator.

• Logical

• Comparison

• Decision

• Aggregate