You enterprise must decide whether to use a database management system. Which of the following lists four advantages of using a DBMS?
A. Consistency of data, adherence to standards, managed concurrency, and increased software complexity.
B. Increased datasecriry, increased data integrity, increased data independence, and decreased data separation.
C. Management of data redundancy, increased data integrity, increased data dependence, and increased application program flexibility.
D. Increased data access, increased data backup and recovery, data sharing, and consistency of data.
正解:D
質問 2:
Consider the entity-relationship (ER) diagram shown in the exhibit. Which type of relationship between the two entities is shown?
A. A one-to-many relationship
B. A one-to-one relationship
C. A many-to-many relationship
D. A recursive relationship
正解:C
質問 3:
Which of the following is a characteristic of the three-tier database architecture?
A. A Web browser is used as the application server.
B. A thick client is used to perform business application logic functions locally.
C. Database application logic and database functionality are integrated and reside on a common server.
D. The application logic is centralized on a dedicated server.
正解:D
質問 4:
Consider the relational database shown in the exhibit. What is the foreign key in this database?
A. Department.Dept_ID
B. Dept_Name
C. Employee.Dept_ID
D. Dept_Mngr
正解:C
質問 5:
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 DIFFERENCE (SELECT Part_ID FROM Dept2_Parts);
B. SELECT * FROM Dept1_Parts EXCEPT (SELECT Part_ID FROM Dept2_Parts);
C. SELECT * FROM Dept1_Parts MINUS (SELECT Part_ID FROM Dept2_Parts);
D. SELECT * FROM Dept1_Parts DIFFERENCE (SELECT Part_ID FROM Dept2_Parts);
正解:A
Miyamoto -
無事合格です。Pass4Testおかげです。本当にお世話になりました。
試験の内容にほぼあってて凄すぎた。