1D0-541 Exam Dumps : CIW v5 Database Design Specialist

Data Query Language

Database Entity Language

Data Definition Language

Data Manipulation Language

Attribute, domain, and tuple

Entity, relation name, and domain

Table name, primary key, and entity

Attribute, relation name, and primary key

INSERT INTO Atlanta_Customers

VALUES( SELECT * FROM

Customer s WHERE Sales_Office =

Atlanta

INSERT INTO Atlanta_Customers

SELECT * FROM Customers

WHERE Sales_Office = Atlanta

INSERT INTO Atlanta_Customers SELECTCust_No,

Cust_Name, Satisfaction_Rate, Sales_Rep_No FROM Customers

WHERE Sales_Office = Atlanta

INSERT INTO Atlanta_Customers SELECT Cust_No,

Cust_Name, Sales_Office, Sales_Rep_No FROM Customers

WHERE Sales_Office = Atlanta