Online 1D0-541 Practice TestMore CIW Products >

Free CIW 1D0-541 Exam Dumps Questions

CIW 1D0-541: CIW v5 Database Design Specialist

- Get instant access to 1D0-541 practice exam questions

- Get ready to pass the CIW v5 Database Design Specialist exam right now using our CIW 1D0-541 exam package, which includes CIW 1D0-541 practice test plus an CIW 1D0-541 Exam Simulator.

- The best online 1D0-541 exam study material and preparation tool is here.

4.5

(3180 ratings)

Question 1

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

A. 1D0-541 dumps exhibit SELECT *FROM OrdersWHERE Order_Date LIKE _02 ORDER BY Amount;

B. SELECT (Order_Date, Amount) FROM OrdersWHERE Order_Date LIKE ORDER BY Amount;

C. SELECT *FROM OrdersWHERE Order_Date LIKE _02 ORDER BY Order_No;

D. SELECT *FROM OrdersWHERE Order_Date LIKE ORDER BY Amount;

Correct Answer:D

Question 2

Consider the following SQL statement and the Orders relation shown in the exhibit:
1D0-541 dumps exhibit
How many records should be returned?

A. Two records

B. Three records

C. Four records

D. Five records

Correct Answer:C

Question 3

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 4

Consider the following SQL statement and the Orders relation shown in the exhibit:
1D0-541 dumps exhibit
What is the output of this SQL statement?

A. [MISSING]

B. [MISSING]

C. [MISSING]

D. [MISSING]

Correct Answer:C

Question 5

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

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

Correct Answer:D

Question 6

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

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 CHECKON UPDATE CASCADE);

Correct Answer:C

START 1D0-541 EXAM