Online Access Free 1D0-541 Exam Questions

Consider the Dept1_Parts and Dept2_Parts relations shown in the exhibit. Which of the following SQL statements would create a set difference of the two relations with the widest variety of Structured Query Language dialects?

• A.SELECT * FROM Dept1_Parts EXCEPT (SELECT Part_ID FROM Dept2_Parts);
• B.SELECT * FROM Dept1_Parts DIFFERENCE (SELECT Part_ID FROM Dept2_Parts);
• C.SELECT * FROM Dept1_Parts DIFFERENCE (SELECT Part_ID FROM Dept2_Parts);
• D.SELECT * FROM Dept1_Parts MINUS (SELECT Part_ID FROM Dept2_Parts);

Consider the relation shown in the exhibit. Which of the following SQL statements would properly add information for a new employee?

• A.INSERT INTOEmployee(Emp_ID, First_Name, Last_Name, Birth_Date) VALUES(0005, Tim, Bogart, 03-05-77);
• B.INSERT INTOEmployee(Emp_ID, First_Name, Last_Name, Birth_Date) VALUES(0004, Tim, Bogart, 03-15-77);
• C.INSERT INTO Employee VALUES(0005, Tim, Bogart, 03-15-77);
• D.INSERT INTOEmployee(Emp_ID, First_Name, Last_Name, Birth_Date) VALUES(0005, Tim, Bogart, 03-05-77);

What is the highest normal form of the relation(s) shown in the exhibit?

• A.Second normal form
• B.Third normal form
• C.No normal form
• D.First normal form

In which phase of database design do you identify entities, attribute domains, and relationships?

• A.Logical
• B.Physical
• C.Conceptual
• D.Application

What is a relational database domain?

• A.A group of attributes
• B.A set of permissible attribute values
• C.A set of permissibletuple values
• D.A collection of related data items