SQL Data Definition Quiz PDF: Questions and Answers - 419

MCQ 2091: The set of relations in a database must be specified to the system by means of a

1. Data Declaration language
2. Data Definition language
3. Data processing language
4. Data manipulation language

MCQ 2092: In SQL, the user defined data type can be declared as

1. Define type
2. Create type
3. Create datatype
4. Define datatype

MCQ 2093: The types of Data Manipulation language (DML) are

1. Procedural and Declarative
2. Procedural And Definitive
3. Definitive and Declarative
4. Query and Procedural

MCQ 2094: To deal with the exceptions, a value that is used to indicate failure/success status, is said to be the

1. sqldefine
2. sqlstate
3. sqlline
4. sqlparameter

MCQ 2095: We can test for the existence of duplicate tuples in a subquery by using the

1. Like
2. Not Like
3. Unique
4. Not Unique