DDL

Below is an acronym for DDL

• Database Definition Language

• Data Definition Language

• Description Data Language

• Digital Data Language

Which of the following is/are the DDL statements?

• Create

• Drop

• Alter

• All of the Mentioned

SQL has how many main commands for DDL:

• 1

• 2

• 3

• 4

Which of the following statement removes database including its related components?

• DROP DATABASE

• DELETE DATABASE

• REMOVE DATABASE

• None of the mentioned

Which of the following statement removes sales and suppliers database?

• DROP DATABASE Sales, NewSales

• DROP DATABASE Sales, suppliers

• DROP DATABASE Sales and suppliers

• DROP DATABASE Sales-suppliers

View used used for displaying current status of database is ___________

• system.databases

• current.databases

• sys.databases

• status.databases

Command that is used to add attributes to an existing relation, is said to be

• Alter

• Modify

• Tailor

• Eliminate

Which requirements can be implemented using a CHECK constraint?

• Customer must be greater than 21 years old

• Customer must have a residence in an Asian Country

• Both A and B

• None of the above

Which of the following statements are TRUE?

• A Unique constraint allows multiple rows to have NULL value

• Integrity constraint can be added to a table even if table data is in violation

• A PRIMARY KEY allows a single row to contain NULL

• Both A and B

Which statement would add a column CGPA to a table Student which is already created

• ALTER TABLE Student ADD COLUMN (CGPA NUMBER(3,1));

• ALTER TABLE Student CGPA NUMBER(3,1);

• ALTER TABLE Student ADD (CGPA NUMBER(3,1));

• Both A and C