Online Access Free 1D0-541 Exam Questions

Your enterprise is involved in planning a database project. The exhibit shows the result of one phase of the database design life cycle. Which term best describes the diagram shown in the exhibit?

• A.Database requirements model
• B.Information Engineering (IE) data model
• C.ERD model
• D.Corporate data model

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 following four database design activities:
1 - Design user views. 2 - Select a DBMS. 3 - Apply normalization. 4 - Determine entities.
Which choice shows the correct ordering of these activities, from first to last, by assigned numbers?

• A.1,2,3,4
• B.4,2,3,1
• C.4,3,1,2
• D.3,4,1,2

Several SQL operations are performed by User 1 to access the Fee information for Bowling in the Act_Fee relation (shown in the exhibit). The first access returns a fee of 50. An unrelated SQL operation by another user updates the Bowling fee to 60. The second access by User 1 returns a fee of 60. What problem has occurred?

• A.Dirty read
• B.Rollback
• C.No problem has occurred.
• D.Deadlock

The exhibit shows a table called Housing Relation that relates a unique student identification number with a dormitory building and a room fee for that building. Each building charges only one fee and a student can live in only one building. The key for the Housing Relation is Student_ID.
This table is in which normal form?

• A.1NF, 2NF and 3NF
• B.1NF
• C.1NF, 2NF, 3NF and BCNF
• D.1NF and 2NF