DBMS Q1

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

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

A set of possible data values is called

• A. Attributes
• B. Tuple
• C. Domain
• D. Degree

When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a ………..

• A. Transitive dependency
• B. Referential integrity constraint
• C. Partial dependency
• D. Primary key