MODULE-3-DATABASE MANAGEMENT SYSTEMS

Which of the following command is a type of Data Definition language command?

• A. Create
• B. Update
• C. Delete
• D. Merge

Which of the following is used in the application programs to request data from the database management system?

• A. Data Manipulation Language
• B. Data Definition Language
• C. Data Control Language
• D. All of the above

Which one of the following commands is used for removing (or deleting) a relation forms the SQL database?

• A. Delete
• B. Drop
• C. Remove
• D. All of the above

Which of the following keys is generally used to represents the relationships between the tables?

• A. Primary key
• B. Foreign key
• C. Secondary key
• D. None of the above

Which one of the following commands is used to modify a column inside a table?

• A. Update
• B. Drop
• C. Alter
• D. Set

Which of the following defines the structure of a relation that consists of a fixed set of attribute-domain pairs.

• A. Instance
• B. Schema
• C. Program
• D. Super key

A relational database developer refers to a record as -----------.

• A. Domain
• B. Relation
• C. Tuple
• D. Attribute

Grant and revoke are ……. statements.

• A. DDL
• B. DML
• C. TCL
• D. DCL

The candidate key that you choose to identify each row uniquely is called ……….

• A. Super key
• B. Primary key
• C. Alternate key
• D. Unique key

……… is used to eliminate duplicate rows

• A. UNIQUE
• B. NO DUPLICATE
• C. DISTINCT
• D. None of these