CIW 1D0-541 Online Practice Questions and Exam Preparation

CIW 1D0-541 Online Questions & Answers

• Question 71:

  Which of the following is a characteristic of the three-tier database architecture?

  A. A Web browser is used as the application server.
  B. The application logic is centralized on a dedicated server.
  C. A thick client is used to perform business application logic functions locally.
  D. Database application logic and database functionality are integrated and reside on a common server.
  B. The application logic is centralized on a dedicated server.

• Question 72:

  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);
  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);

• Question 73:

  Your enterprise is developing a database system that will contain highly sensitive data; Security of the data will take priority over database processing speed. Which database protection technique should be employed?

  A. Backups
  B. User views
  C. Encryption
  D. Integrity controls
  C. Encryption

• Question 74:

  The creation of intermediate entities occurs during the logical database design phase for an enterprise. It is used to resolve which types of relationships?

  A. One-to-many, complex, and recursive
  B. Complex, recursive, and many-to-many
  C. Redundant, recursive, and many-to-many
  D. One-to-many and one-to-one
  B. Complex, recursive, and many-to-many

• Question 75:

  The exhibit shows a table called Student Relation that tracks all information related to a students courses, professors and sites. What would be the consequence of removing all records for a student with the ID 1311?

  

  A. Only an update anomaly would occur.
  B. An insertion anomaly would occur.
  C. A deletion anomaly would occur.
  D. An update anomaly and a deletion anomaly would occur.
  C. A deletion anomaly would occur.

• Question 76:

  Using the Customer and Sales_Rep relations shown in the exhibit, you must datermine a relational

  

  algebraic expression that will result in the following relation:

  Which of the following relational algebraic expressions would result in this relation?

  

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

• Question 77:

  Which three pieces of information did E. F. Codd describe as necessary to retrieve a data value from a relational database?

  A. Attribute, domain, and tuple
  B. Entity, relation name, and domain
  C. Table name, primary key, and entity
  D. Attribute, relation name, and primary key
  D. Attribute, relation name, and primary key

• Question 78:

  Consider the Information Engineering diagram shown in the exhibit. 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 RESIDENT relation shown in this diagram?

  

  A. CREATE TABLE RESIDENT ( R_ID INTEGER NULL PRIMARY KEY, Room_Num FLOAT, Res_Name VARCHAR, Building_ID INTEGER NULL, FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID));
  B. CREATE TABLE RESIDENT ( R_ID INTEGER NOT NULL PRIMARY KEY, Room_Num BINARY, Res_Name VARCHAR (20), Building_ID INTEGER NOT NULL, FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID));
  C. CREATE TABLE RESIDENT ( R_ID INTEGER NOT NULL PRIMARY KEY, Room_Num INTEGER, Res_Name VARCHAR (20), Building_ID INTEGER NOT NULL);
  D. CREATE TABLE RESIDENT ( R_ID INTEGER NOT NULL PRIMARY KEY, Room_Num INTEGER, Res_Name VARCHAR (20), Building_ID INTEGER NOT NULL, FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID));
  D. CREATE TABLE RESIDENT ( R_ID INTEGER NOT NULL PRIMARY KEY, Room_Num INTEGER, Res_Name VARCHAR (20), Building_ID INTEGER NOT NULL, FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID));

• Question 79:

  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
  A. Employee.Dept_ID

• Question 80:

  Which term describes the rejoining of relations that have been decomposed?

  A. Normalization
  B. Denormalization
  C. Referential integrity
  D. Domain constraints
  B. Denormalization