SQL Data Types and Schemas Multiple Choice Questions (MCQ) PDF Download

MCQ 1: SQL supports forms of user-defined data types, in the form of

1. 1 form
2. 2 forms
3. 3 forms
4. 4 forms

MCQ 2: Many current-generation database applications need to store photographs, or of the order megabytes and gigabytes using

1. Large-index type
2. Large-object type
3. Large-location type
4. Large-locator type

MCQ 3: SQL allows comparison operations on the data types i.e.

1. time
2. date
3. timestamp
4. All datatypes

MCQ 4: All the usual SQL statements, operate in the context of schema, including the

1. DDL statements
2. DML statements
3. Both A and B
4. Data definition statements

MCQ 5: The current date is returned by the method

1. system.date
2. current.date
3. machine.date
4. today.date