SQL Basics Questions Answers for Beginners PDF Download - 2

MCQ 6: The select clause of the nested query is able to produce a collection of values, known to be

1. Function
2. Set
3. Set difference
4. Instances

MCQ 7: The keyword proposed by SQL for the elimination of duplicates in a result is said to be

1. Abort-duplicate
2. Eliminate
3. Distinct
4. Define unique

MCQ 8: For a like comparison SQL defines the escape character using the

1. Like keyword
2. AS keyword
3. IN keyword
4. Escape keyword

MCQ 9: Programs are allowed to construct a SQL query as a character string with the help of dynamic query at the

1. Initiation
2. Compile time
3. Runtime
4. Output

MCQ 10: In SQL, multilingual data is stored via the data type

1. varchar type
2. float type
3. nvarchar type
4. longint type