CIW 1D0-541 Online Practice Questions and Exam Preparation

CIW 1D0-541 Online Questions & Answers

• Question 51:

  Which area of database security involves maintaining access to enterprise data?

  A. Integrity
  B. Privacy
  C. Availability
  D. Confidentiality
  C. Availability

• Question 52:

  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 53:

  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 54:

  Consider the following four database design activities:

  1 - Design user views.

  2 - Select a DBMS.

  3 - Apply normalization.

  4 - Determine entities.

  Which choice shows the correct ordering of these activities, from first to last, by assigned numbers?

  A. 1, 2, 3, 4
  B. 3, 4, 1, 2
  C. 4, 1, 3, 2
  D. 4, 2, 3, 1
  D. 4, 2, 3, 1

• Question 55:

  Which of the following best describes the information contained in the data dictionary (or system catalog)?

  A. Metadata
  B. Data model
  C. Table data
  D. Metafile
  A. Metadata

• Question 56:

  Your 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 complexity
  B. Consistency of data, adherence to standards, managed concurrency, and increased software complexity
  C. Increased data access, increased data backup and recovery, data sharing, and consistency of data
  D. Increased data security, increased data integrity, increased data independence, and decentralization of data
  C. Increased data access, increased data backup and recovery, data sharing, and consistency of data

• Question 57:

  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. If any child key references a parent key, the record containing the parent key cannot be deleted.

• Question 58:

  Which of the following definitions best describes an entity?

  A. A single relation
  B. Data about data
  C. Data stored in a table column
  D. An item about which information is stored
  D. An item about which information is stored

• Question 59:

  Which type of relational integrity is violated if a primary key in a database has a null value?

  A. Entity integrity
  B. Domain integrity
  C. Domain constraints
  D. Referential integrity
  A. Entity integrity

• Question 60:

  The exhibit shows a table called Housing Relation. This table relates a unique student identification number with a dormitory building and a room fee for that building. The key for the Housing Relation is Student_ID. If each building charges only one fee and a student can live in only one building, then this table is in which normal form?

  

  A. 1NF
  B. 1NF and 2NF
  C. 1NF, 2NF, and 3NF
  D. 1NF, 2NF, 3NF, and BCNF
  B. 1NF and 2NF