CIW 1D0-541 Online Practice Questions and Exam Preparation

CIW 1D0-541 Online Questions & Answers

• Question 1:

  Which term best defines a database system in which data records are stored with no structured relationships between the records?

  A. Flat-file database
  B. Relational database
  C. Distributed database
  D. Object-oriented database
  A. Flat-file database

• Question 2:

  Consider the Project relation shown in the exhibit as well as the following SQL statement:

  

  DELETE FROM Project WHERE Cust_Name = Acme;

  Which of the following tables shows the Project relation after execution of this SQL statement?

  

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

• Question 3:

  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;

• Question 4:

  Your enterprise has reached the conceptual design phase for a database project. What is the desired goal at the end of this design phase?

  A. A set of normalized relations
  B. A reviewed entity-relationship (ER) model
  C. An entity-relationship (ER) model with no redundant data
  D. A set of denormalized relations
  B. A reviewed entity-relationship (ER) model

• Question 5:

  Which of the following occurs in a relation when records are added or removed?

  A. The number of domains changes.
  B. The attributes in the table change.
  C. The cardinality of the relation is fixed but the degree varies.
  D. The degree of the relation is fixed but the cardinality varies.
  D. The degree of the relation is fixed but the cardinality varies.

• Question 6:

  Consider the entity-relation (ER) diagram shown in the exhibit. When the logical database design phase is completed, which of the following is a valid DBDL description of the base relations for the ER diagram?

  

  A. STUDENT( Student_Number: integer NOT NULL Name: variable length character string length 20 NOT NULL) Primary Key Student_Number CLASS( Class_Num: integer NOT NULL Class_Name: integer NOT NULL) Primary Key Class_Num
  B. STUDENT( Student_Number: integer NOT NULL Name: variable length character string length 20 NOT NULL) Primary Key Student_Number CLASS( Class_Num: integer NOT NULL Class_Name: integer NOT NULL) Primary Key Class_Num Foreign Key Class_Num References STUDENT
  C. STUDENT( Student_Number: integer NOT NULL Name: variable length character string length 20 NOT NULL) Primary Key Student_Number STU_CLASS( Student_Number: integer NOT NULL Class_Num: integer NOT NULL) Primary Key Student_Number CLASS( Class_Num: integer NOT NULL Class_Name: integer NOT NULL) Primary Key Class_Num
  D. STUDENT( Student_Number: integer NOT NULL Name: variable length character string length 20 NOT NULL) Primary Key Student_Number STU_CLASS( Student_Number: integer NOT NULL Class_Num: integer NOT NULL) Primary Key Student_Number CLASS( Class_Num: integer NOT NULL Class_Name: integer NOT NULL) Primary Key Class_Num
  D. STUDENT( Student_Number: integer NOT NULL Name: variable length character string length 20 NOT NULL) Primary Key Student_Number STU_CLASS( Student_Number: integer NOT NULL Class_Num: integer NOT NULL) Primary Key Student_Number CLASS( Class_Num: integer NOT NULL Class_Name: integer NOT NULL) Primary Key Class_Num

• Question 7:

  A large enterprise uses a two-tier database architecture and runs complex database processing on the client. Which term best describes the client in this system?

  A. Fat client
  B. Thin client
  C. Terminal client
  D. Enterprise client
  A. Fat client

• Question 8:

  Consider the following relations shown in the exhibit. Which of the following SQL statements would return the Customers2 relation from the Customers relation?

  

  A. SELECT * FROM Customers WHERE Satisfaction_Rate = 90;
  B. SELECT * FROM Customers WHERE Satisfaction_Rate IN (80 AND 90);
  C. SELECT * FROM Customers WHERE Satisfaction_Rate >= 80 AND Satisfaction_Rate
  D. SELECT * FROM Customers WHERE Satisfaction_Rate BETWEEN (80, 90);
  C. SELECT * FROM Customers WHERE Satisfaction_Rate >= 80 AND Satisfaction_Rate

• Question 9:

  Which type of entity must reference another entity for its data to be meaningful?

  A. Weak
  B. Strong
  C. Foreign
  D. Primary
  A. Weak

• Question 10:

  Which statement best describes a procedural data manipulation language command?

  A. It contains a query language for retrieving data;
  B. It can be used only to manipulate data through a SQL interface.
  C. The user is not required to know how the underlying data structures are implemented.
  D. It requires that the user know how the underlying data structures are implemented.
  D. It requires that the user know how the underlying data structures are implemented.