CIW CIW Certifications 1D0-541 Questions & Answers

• Question 101:

  Consider the table for an employee database shown in the exhibit. What is the cardinality of the table?

  

  B. 20

  C. 4

  D. 25

  Correct Answer: C

• Question 102:

  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

  Correct Answer: A

• Question 103:

  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

  Correct Answer: B

• Question 104:

  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

  Correct Answer: B

• Question 105:

  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

  Correct Answer: A

• Question 106:

  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

  Correct Answer: D

• Question 107:

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

  A. Integrity

  B. Privacy

  C. Availability

  D. Confidentiality

  Correct Answer: C

• Question 108:

  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

  Correct Answer: A

• Question 109:

  Consider the relational database shown in the exhibit. What is the foreign key in this database?

  

  A. Employee.Dept_ID

  B. Dept_Mngr

  C. Dept_Name

  D. Department.Dept_ID

  Correct Answer: A

• Question 110:

  Consider the Information Engineering diagram shown in the exhibit for a building management company. Referential integrity must be maintained such that a building cannot be deleted when it has residents. Building_ID, R_ID, Room_Count and Room_Num are integer numbers, whereas Bldg_Name, Location and Res_Name are all represented by variable-length strings with a maximum of 20 characters. Which SQL statement best implements the relations shown in this diagram?

  

  A. CREATE TABLE BUILDING ( Building_ID INTEGER NOT NULL PRIMARY KEY, Bldg_Name VARCHAR (20), Location VARCHAR (20), Room_Count INTEGER ); CREATE TABLE RESIDENT ( R_ID NOT NULL PRIMARY KEY, Room_Num INTEGER, Res_Name VARCHAR (20), Building_ID INTEGER NOT NULL, FOREIGN KEY Building_ID REFERENCES RESIDENT (Building_ID) ON DELETE NO CHECK);

  B. CREATE TABLE BUILDING ( Building_ID INTEGER NOT NULL PRIMARY KEY, Bldg_Name VARCHAR (20), Location VARCHAR (20), Room_Count INTEGER ); CREATE TABLE RESIDENT ( R_ID NOT NULL PRIMARY KEY, Room_Num INTEGER, Res_Name VARCHAR (20), Building_ID INTEGER NOT NULL, FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID) ON DELETE NO CHECK ON UPDATE CASCADE);

  C. CREATE TABLE BUILDING ( Building_ID INTEGER NOT NULL PRIMARY KEY, Bldg_Name VARCHAR (20), Location VARCHAR (20), Room_Count INTEGER ); CREATE TABLE RESIDENT ( R_ID NOT NULL PRIMARY KEY, Room_Num INTEGER, Res_Name VARCHAR (20), Building_ID INTEGER NOT NULL, FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID) ON DELETE NO CHECK ON UPDATE CASCADE);

  D. CREATE TABLE BUILDING ( Building_ID INTEGER NOT NULL PRIMARY KEY,

  Bldg_Name VARCHAR (20),

  Location VARCHAR (20),

  Room_Count INTEGER );

  CREATE TABLE RESIDENT (

  R_ID NOT NULL PRIMARY KEY,

  Room_Num INTEGER,

  Res_Name VARCHAR (20),

  Building_ID INTEGER NOT NULL,

  FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID)

  ON DELETE NO CHECK

  ON UPDATE CASCADE);

  Correct Answer: C