Quiz_SBD

DDL adalah singkatan dari ...

• Data definition language

• Data dummy language

• Dummy definition language

• Data definition learning

(DDL) commands are used to work on ....

• table and data structure

• table structure

• data

• database

DML (Data Manipulation Language) Command are used to work on...

(a)  

The SQL data definition statements include:

• CREATE

• ALTER

• DROP

• Insert

To modify the structure and/or characteristics of database objects is called ...

• make

• create

• modify

• alter

X can be change with Foreign Key (FK)

Which one is correct, True or False?

(a)  

Try to understand the picture. Which one is correct to substitute Y?

(*substitute: menggantikan)

• primary key

• foreign key

• constraint key

• constraint

DROP statement will not permanently remove the object and all data

• false

• true

ALTER TABLE Employee DROP CONSTRAINT EmpFK

alter means ..

• change data on Employee table

• delele data on Employee table

• create data on Employee table

• view data on Employee table

Which one is correct to make new constraint?

• MAKE CONSTRAINT EmpFK FOREIGN KEY (DeptID)

• ADD CONSTRAINT EmpFK FOREIGN KEY (DeptID)

• CREATE CONSTRAINT EmpFK FOREIGN KEY (DeptID)

• VIEW CONSTRAINT EmpFK FOREIGN KEY (DeptID)