CIW 1D0-541 問題集

質問 1：
In a relational database, which term describes a single table consisting of rows and columns?
A. Relation
B. Matrix
C. Data dictionary
D. Entity
正解：A

質問 2：
You enterprise must decide whether to use a database management system. Which of the following lists four advantages of using a DBMS?
A. Management of data redundancy, increased data integrity, increased data dependence, and increased application program flexibility.
B. Increased data access, increased data backup and recovery, data sharing, and consistency of data.
C. Consistency of data, adherence to standards, managed concurrency, and increased software complexity.
D. Increased datasecriry, increased data integrity, increased data independence, and decreased data separation.
正解：B

質問 3：
Which component in the three-tier database architecture handles the data-processing and business logic?
A. Fat client
B. Thin client
C. Application server
D. Database server
正解：C

質問 4：
Consider the Orders relation shown in the exhibit. Which of the following SQL statements would replace the value in the Sales_Rep_No column with 110 everywhere that Sales_Rep_No 108 is listed?

A. UPDATE Orders SET Sales_Rep_No = 110 WHERE Sales_Rep_No = 108;
B. UPDATESales_Rep_No IN Orders SET(Sales_Rep_No = 110 WHERE Sales_Rep_No = 108);
C. UPDATE Orders
SET Sales_Rep_No = 110;
D. UPDATE Orders
WHERE Sales_Rep_No = 108
SET Sales_Rep_No = 110;
正解：A

質問 5：
Consider the following relational algebraic expression as well as the Employee and Department relations shown in the exhibit: Which of the following relations would result from the given relational algebraic expression?

A. D
B. A
C. B
D. C
正解：A