CIW 1D0-541 Online Practice Questions and Exam Preparation

CIW 1D0-541 Online Questions & Answers

• Question 11:

  Which security technique limits access by unauthorized users to parts of an enterprise database?

  A. Views
  B. Concurrency
  C. Locking
  D. Integrity controls
  A. Views

• Question 12:

  Consider the Registration relation shown in the exhibit. Which of the following SQL statements would return the Registration2 relation from the Registration relation?

  

  A. SELECT Course_Code FROM Registration;
  B. SELECT * FROM Registration WHERE Registration_ID = 1003 AND Registration_ID = 1005;
  C. SELECT * FROM Registration WHERE Course_Code = 'A4343';
  D. SELECT Registration_ID, Student_ID, First_Name, Last_Name FROM Registration WHERE Course_Code = 'A4343';
  C. SELECT * FROM Registration WHERE Course_Code = 'A4343';

• Question 13:

  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
  C. A definition of permissible values for one or more attributes

• Question 14:

  Consider the entity-relationship (ER) diagram shown in the exhibit. What do the characters at the ends of the connecting line indicate?

  

  A. Degree of a relation
  B. Cardinality of a relation
  C. Primary key of a relation
  D. Determinant of a relation
  B. Cardinality of a relation

• Question 15:

  Consider the relation shown in the exhibit. Which of the following SQL statements would properly add information for a new employee?

  

  A. INSERT INTO Employee VALUES(0005, Tim, Bogart, 03-15-77);
  B. INSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date) VALUES(0004, Tim, Bogart, 03-15-77);
  C. INSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date) VALUES(0005, Tim, Bogart, 03-05-77);
  D. INSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date) VALUES(0005, Tim, Bogart, 03-05-77);
  D. INSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date) VALUES(0005, Tim, Bogart, 03-05-77);

• Question 16:

  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
  C. Option C

• Question 17:

  Which of the following definitions applies to all types of databases?

  A. Data that is stored as tables
  B. Software that manipulates data
  C. Data that is stored in a structured manner
  D. Data records that are stored sequentially in a file
  C. Data that is stored in a structured manner

• Question 18:

  Which of the following ACID properties requires that a transaction be executed in its entirety or not all?

  A. Durability
  B. Consistency
  C. Isolation
  D. Atomicity
  D. Atomicity

• Question 19:

  Consider the following relational algebraic expression:

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

  A. SELECT Sales_Rep_No(108) FROM Orders;
  B. INSERT INTO Orders VALUES(Sales_Rep_No = 108) WHERE Sales_Rep_No = NULL;
  C. SELECT * FROM Orders WHERE Sales_Rep_No = 108;
  D. SELECT * FROM Orders WHERE Sales_Rep_No = 108;
  C. SELECT * FROM Orders WHERE Sales_Rep_No = 108;

• Question 20:

  Which concurrency control method should be used only when conflicts between transactions rarely occur?

  A. Locking
  B. Time stamps
  C. Optimistic
  D. Serialization
  C. Optimistic