CIW 1D0-541 Online Practice Questions and Exam Preparation

CIW 1D0-541 Online Questions & Answers

• Question 31:

  Consider the following table as well as the Dept1_Parts and Dept2_Parts relations shown in the exhibit:

  

  Which of the following relational algebraic expressions would result in the given table?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  A. Option A

• Question 32:

  Consider the Registration relation shown in the exhibit. Which of the following SQL statements would return all tuples that have course codes beginning with the letter M?

  

  A. SELECT * FROM Registration WHERE Course_Code = M#;
  B. SELECT * FROM Registration WHERE Course_Code LIKE M_;
  C. SELECT * FROM Registration WHERE Course_Code LIKE M%;
  D. SELECT * FROM Registration WHERE Course_Code = M%;
  C. SELECT * FROM Registration WHERE Course_Code LIKE M%;

• Question 33:

  Which mechanism provides database users with controlled access to the database through the use of virtual tables?

  A. View
  B. Data dictionary
  C. Database control language
  D. Database management system
  A. View

• Question 34:

  Which relational algebraic operation is used to select specific columns (attributes) from a relation?

  A. Union
  B. Difference
  C. Projection
  D. Intersection
  C. Projection

• Question 35:

  To create a view, what are the minimal privileges that a user must have for the relations used to make the view?

  A. GRANT
  B. REVOKE
  C. SELECT
  D. CREATE VIEW
  C. SELECT

• Question 36:

  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. An update anomaly would occur.
  B. An insertion anomaly would occur.
  C. A deletion anomaly would occur.
  D. Both an insertion anomaly and a deletion anomaly would occur.
  C. A deletion anomaly would occur.

• Question 37:

  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 Sales_Rep_No IN Orders SET(Sales_Rep_No = 110 WHERE Sales_Rep_No = 108);
  B. UPDATE 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;
  B. UPDATE Orders SET Sales_Rep_No = 110 WHERE Sales_Rep_No = 108;

• Question 38:

  Consider the Information Engineering diagram in the exhibit showing the relations BUILDING and RESIDENT. What is the relationship between BUILDING and RESIDENT?

  

  A. 11
  B. 1n
  C. n:m
  D. m:n
  B. 1n

• Question 39:

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

  A. CREATE ENTITY
  B. CREATE INDEX
  C. CREATE DOMAIN
  D. CREATE SCHEMA
  D. CREATE SCHEMA

• Question 40:

  What is a virtual table?

  A. A virtual table is a relation created as the result of data manipulation, and is not a permanent part of the database.
  B. A virtual table is a relation stored in the databases memory; it is used when multiple users access the same relation in a database.
  C. A virtual table is a relation created from a defined base table; it contains metadata about the base relation.
  D. A virtual table is a relation that consists of primary and foreign keys for a particular set of relations in a database.
  A. A virtual table is a relation created as the result of data manipulation, and is not a permanent part of the database.