CIW 1D0-541 Online Practice Questions and Exam Preparation

CIW 1D0-541 Online Questions & Answers

• Question 111:

  Which characteristic is an advantage of a database management system?

  A. Data files are owned and maintained by the users.
  B. Database administration is simplified.
  C. A standard method can be used to access the database.
  D. Data is decentralized.
  C. A standard method can be used to access the database.

• Question 112:

  Your enterprise must decide whether to use a database management system. Which of the following best describes the overall functionality of a DBMS?

  A. A DBMS provides the ability to control data access using Data Manipulation Language.
  B. A DBMS provides the ability to maintain databases while providing increased security for the database.
  C. A DBMS allows users to access the database while allowing only the database administrator to define user views.
  D. A DBMS provides the ability to define, create and maintain databases while providing controlled access to databases.
  D. A DBMS provides the ability to define, create and maintain databases while providing controlled access to databases.

• Question 113:

  Which subset of Structured Query Language (SQL) is used to perform operations such as data retrieval or deletion on the data contained in a database?

  A. Data Control Language
  B. Data Definition Language
  C. Data Formatting Language
  D. Data Manipulation Language
  D. Data Manipulation Language

• Question 114:

  Consider the following SQL statement and the Orders relation shown in the exhibit:

  

  What is the output of this SQL statement?

  

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

• Question 115:

  What is a data dictionary?

  A. A system catalog containing user data
  B. An area of the database that is directly accessible by the user
  C. Data that is stored in tables and is only accessible by the DBMS
  D. Metadata that is stored in tables and is only accessible by the DBMS
  D. Metadata that is stored in tables and is only accessible by the DBMS

• Question 116:

  Which database security technique prevents invalid data from being entered into the database?

  A. File locking
  B. User authorization
  C. Parity checks
  D. Integrity controls
  D. Integrity controls

• Question 117:

  Consider the table shown in the exhibit. Which relational algebraic operation would return Row 3?

  

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

• Question 118:

  Which pair of relational algebraic operations requires union compatibility?

  A. Projection and Cartesian product
  B. Selection and projection
  C. Intersection and difference
  D. Cartesian product and intersection
  C. Intersection and difference

• Question 119:

  What is a relational database domain?

  A. A group of attributes
  B. A set of permissible tuple values
  C. A collection of related data items
  D. A set of permissible attribute values
  D. A set of permissible attribute values

• Question 120:

  Consider the Orders relation shown in the exhibit. Which of the following SQL statements would return all complete tuples for order dates in 2002, arranged by amount from lowest to highest?

  

  A. SELECT * FROM Orders WHERE Order_Date LIKE _02 ORDER BY Amount;
  B. SELECT (Order_Date, Amount) FROM Orders WHERE Order_Date LIKE %02 ORDER BY Amount;
  C. SELECT * FROM Orders WHERE Order_Date LIKE _02 ORDER BY Order_No;
  D. SELECT * FROM Orders WHERE Order_Date LIKE %02 ORDER BY Amount;
  D. SELECT * FROM Orders WHERE Order_Date LIKE %02 ORDER BY Amount;