1D0-541 CIW Exam Questions and Free Practice Test

Question 13

What is the highest normal form of the relation(s) shown in the exhibit?
1D0-541 dumps exhibit

A. Third normal form

B. Second normal form

C. Boyce-Codd normal form

D. First normal form

Correct Answer:D

Question 14

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.

Correct Answer:D

Question 15

Consider the Dept1_Parts and Dept2_Parts relations shown in the exhibit. Which of the following SQL statements would create an intersection of the two relations with the widest variety of Structured Query Language dialects?
1D0-541 dumps exhibit
Solution:

Does this meet the goal?

A. Yes

B. No

Correct Answer:A

Question 16

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?
1D0-541 dumps exhibit

A. 1D0-541 dumps exhibit 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 CHECKON 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 CHECKON UPDATE CASCADE);

D. 1D0-541 dumps exhibit 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 CHECKON UPDATE CASCADE);

Correct Answer:C

Question 17

Your enterprise has created a database and database application. The testing phase for the project has started. Which of the following best describes white-box testing of the projects software?

A. The database designer tests the software because he or she is able to make necessary changes to the underlying code for the software.

B. A user who has no knowledge of the softwares underlying code tests the software.

C. Someone other than the database designer tests the softwar

D. This person has no access to the underlying code and attempts to use thesoftware only in ways not considered by the software designers.

E. A person tests the software and submits suggestions to the software's underlying code.This person is someone other than the databasedesigner, but has access to the softwares underlying code.

Correct Answer:D
1D0-541 dumps exhibit

Question 18

What is the most important service provided by a database management system?

A. Provides support for a data manipulation language

B. Allows users to store data in a distributed data repository

C. Provides support for data formatting language commands

D. Translates procedural commands into non-procedural commands

Correct Answer:A

START 1D0-541 EXAM