1D0-541

1D0-541 practice questions, page 3 of 5, with answer review and explanations.

Question 11

Which statement is used to define a named group of related tables, views, domains and other database objects?

  1. CREATE
  2. CREATE TABLE
  3. CREATE DOMAIN
  4. CREATE SCHEMA

Question 12

Which of the following best describes the ON DELETE NO ACTION referential integrity constraint?

  1. If a parent key is deleted, any child keys referenced by the parent key are automatically deleted.
  2. If a parent key is deleted, no test is made for referential integrity.
  3. If any child key references a parent key, the record containing the parent key cannot be deleted.
  4. If a parent key is deleted, all child keys are automatically set to a specified value. C

Question 13

Consider the following relational algebraic expression: Which of the following SQL statements is equivalent to this relational algebraic expression?

  1. SELECT * FROM Customers, Employees WHERE Sales_Rep_No = Cust_No;
  2. SELECT Cust_No, Cust_Name, Emp_Name, Emp_Loc FROM Customers, Employees WHERE Customers.Sales_Rep_No = Employees.Sales_Rep_No;
  3. SELECT Cust_No, Cust_Name, Emp_Name, Emp_Loc FROM Customers, Employees WHERE Employees.Sales_Rep_No = Customers.Sales_Rep_No;
  4. SELECT * FROM Customers, Employees WHERE Customers.Sales_Rep_No = Employees.Sales_Rep_No;

Question 14

What is a domain?

  1. A normalized set of data applicable to a particular relation
  2. A combination of attributes for a relation
  3. A definition of permissible values for one or more attributes
  4. A set of permissible values for one or more relations

Question 15

For the Employee relation shown in the exhibit, which set of column value holds the complete tuple for the employee named James Smith?

  1. 0002, James, Smith
  2. 0002, James, Smith, 10-25-76
  3. First_Name, James, Last_Name, Smith
  4. Emp_ID, 0002, First_Name, James, Last_Name, Smith