WorksheetsDDL
Total questions: 10
Worksheet time: 5mins
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
