CIW 1D0-541 - CIW v5 Database Design Specialist Exam
Page: 3 / 25
Total 124 questions
Question #11 (Topic: Single Topic)
Which statement is used to define a named group of related tables, views, domains and other database objects?
A. CREATE
B. CREATE TABLE
C. CREATE DOMAIN
D. CREATE SCHEMA
Answer: D
Question #12 (Topic: Single Topic)
Which of the following best describes the ON DELETE NO ACTION referential integrity constraint?
A. If a parent key is deleted, any child keys referenced by the parent key are automatically deleted.
B. If a parent key is deleted, no test is made for referential integrity.
C. If any child key references a parent key, the record containing the parent key cannot be deleted.
D. If a parent key is deleted, all child keys are automatically set to a specified value. C
Answer: Explanation
Question #13 (Topic: Single Topic)
Consider the following relational algebraic expression: Which of the following SQL statements is equivalent to this relational algebraic expression?
A. SELECT * FROM Customers, Employees WHERE Sales_Rep_No = Cust_No;
B. SELECT Cust_No, Cust_Name, Emp_Name, Emp_Loc FROM Customers, Employees WHERE Customers.Sales_Rep_No = Employees.Sales_Rep_No;
C. SELECT Cust_No, Cust_Name, Emp_Name, Emp_Loc FROM Customers, Employees WHERE Employees.Sales_Rep_No = Customers.Sales_Rep_No;
D. SELECT * FROM Customers, Employees WHERE Customers.Sales_Rep_No = Employees.Sales_Rep_No;
Answer: B
Question #14 (Topic: Single Topic)
What is a domain?
A. A normalized set of data applicable to a particular relation
B. A combination of attributes for a relation
C. A definition of permissible values for one or more attributes
D. A set of permissible values for one or more relations
Answer: C
Question #15 (Topic: Single Topic)
For the Employee relation shown in the exhibit, which set of column value holds the complete tuple for the employee named James Smith?
A. 0002, James, Smith
B. 0002, James, Smith, 10-25-76
C. First_Name, James, Last_Name, Smith
D. Emp_ID, 0002, First_Name, James, Last_Name, Smith
Answer: B
