CIW 1D0-541 問題集

質問 1：
Consider the following relation definitions:
STUDENT(
Student_Number: integer NOT NULL
Name: variable length character string length 20 )
Primary Key Student_Number
HOUSING(
Housing_ID: integer NOT NULL Student_Number: integer NOT NULL Building: variable length character string length 25 ) Primary Key Housing_ID Foreign Key Student_Number References STUDENT(Student_Number) ON DELETE NO ACTION ON UPDATE CASCADE What are the referential constraints for the relations defined in these relation definitions?
A. There is no relationship between changes inSTUDENT(Student_Number) and HOUSING(Student_Number).
B. Modifications toHOUSING(Student_Number) are automatically reflected in changes to STUDENT(Student_Number), but deletions are not permitted.
C. WhenSTUDENT(Student_Number) is changed or deleted, this modification or deletion will automatically be reflected in HOUSING(Student_Number).
D. Modifications toSTUDENT(Student_Number) are automatically reflected in changes to HOUSING(Student_Number). For a deletion to occur from STUDENT(Student_Number), it must first occur in HOUSING(Student_Number).
正解：D

質問 2：
FROM Registration WHERE
Consider the following relational algebraic expression: Which of the following SQL Course_Code =
'A4343';
statements is equivalent to this relational algebraic expression?

A. INSERT INTO Orders VALUES(Sales_Rep_No = 108) WHERE Sales_Rep_No = NULL;
B. SELECTSales_Rep_No(108) FROM Orders;
C. SELECT'FROM Orders WHERE Sales_Rep_No = ?08?
D. SELECT'FROM Orders WHERE Sales_Rep_No = 108;
正解：D

質問 3：
Consider the entity-relationship (ER) diagram shown in the exhibit. Which type of relationship between the two entities is shown?

A. 1:1
B. 1:n
C. m:n
D. m:m
正解：C

質問 4：
Which statement accurately describes a characteristic of attributes?
A. An attribute contains values from multiple domains.
B. An attribute name can be used only once in a relational database system with multiple tables.
C. The ordering of attributes in a table is significant.
D. An attribute name can be used only once per table.
正解：D

質問 5：
Your enterprise must decide whether to use a database management system. Which of the following best describes the functionality of a DBMS?
A. A DBMS provides the ability to control data access and limit the number of users at one time.
B. A DBMS provides the ability to define, create and maintain databases while providing controlled access to databases.
C. A DBMS allows users to access the database while allowing the database administrator to define views particular to individual sets of users.
D. A DBMS provides the ability to maintain databases while providing increased security for the database.
正解：B

質問 6：
A foreign key maps to a:
A. prime key.
B. indirect key.
C. composite key.
D. parent key.
正解：D

質問 7：
The exhibit shows a table called Activity Relation that relates a unique student identification number with a sports activity and a fee for participating in that activity. A student can participate in only one activity. The key for the relation is Student_ID. What consequence would occur if the tuple for Student_ID 1001 were removed?

A. Both an insertion anomaly and a deletion anomaly would occur.
B. An update anomaly would occur.
C. An insertion anomaly would occur.
D. A deletion anomaly would occur.
正解：D