Limited Time Discount Offer
30% Off - Ends in 02:00:00

X

CIW 1D0-541 Dumps

verified by experts

  • Verified by experts

1D0-541 Premium File

  • 124 Questions & Answers

$21.41

$14.99
CIW
CIW v5 Database Design Specialist
CIW
CIW v5 Database Design Specialist

Files

File Name
Views
Size
Downloads

209

2.6 MB

242

Files

Views

209

Size

2.6 MB

Downloads

242

Questions & Answers for CIW 1D0-541

Showing 1-15 of 128 Questions

Question #1 - Topic 0

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

Question #2 - Topic 0

Consider the following relational algebraic expression as well as the Dept1_Parts and
Dept2_Parts relations shown in the exhibit:

Which of the following relations would result from the given relational algebraic expression?

A.

B.

C.

D.

Question #3 - Topic 0

Consider the relation shown in the exhibit. Which of the following SQL statements would
return a relation that excludes all customers with a Satisfaction_Rate of less than or equal
to 80 unless the Sales_Office is located in Atlanta?

A. SELECT * FROM Customers WHERE Satisfaction_Rate > 80 OR Sales_Office = Atlanta;

B. SELECT * FROM Customers WHERE Satisfaction_Rate <= 80 AND Sales_Office = Atlanta;

C. SELECT * FROM Customers WHERE Satisfaction_Rate >= 80;

D. SELECT * FROM Customers WHERE Satisfaction_Rate >= 80 AND NOT Sales_Office = Atlanta;

Question #4 - Topic 0

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

A. Weak

B. Strong

C. Foreign

D. Primary

Question #5 - Topic 0

Consider the relations shown in the exhibit. Which of the following SQL statements would
enter data from the Customers relation into the Atlanta_Customers relation?

A. INSERT INTO Atlanta_Customers VALUES( SELECT * FROM Customer s WHERE Sales_Office = Atlanta);

B. INSERT INTO Atlanta_Customers SELECT * FROM Customers WHERE Sales_Office = Atlanta;

C. INSERT INTO Atlanta_Customers SELECT Cust_No, Cust_Name, Satisfaction_Rate, Sales_Rep_No FROM Customers WHERE Sales_Office = Atlanta;

D. INSERT INTO Atlanta_Customers SELECT Cust_No, Cust_Name, Sales_Office, Sales_Rep_No FROM Customers WHERE Sales_Office = Atlanta;

Question #6 - Topic 0

Which concurrency control method should be used only when conflicts between
transactions rarely occur?

A. Locking

B. Time stamps

C. Optimistic

D. Serialization

Question #7 - Topic 0

Consider the Registration relation shown in the exhibit. Which of the following SQL
statements would return the Registration2 relation from the Registration relation?

A. SELECT Course_Code FROM Registration;

B. SELECT * FROM Registration WHERE Registration_ID = 1003 AND Registration_ID = 1005;

C. SELECT * FROM Registration WHERE Course_Code = 'A4343';

D. SELECT Registration_ID, Student_ID, First_Name, Last_Name FROM Registration WHERE Course_Code = 'A4343';

Question #8 - Topic 0

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 <= 80 OR 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 <= 89;

D. SELECT * FROM Customers WHERE Satisfaction_Rate BETWEEN (80, 90);

Question #9 - Topic 0

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

Question #10 - Topic 0

Consider the following relational algebraic expression:

Which of the following SQL statements is equivalent to this relational algebraic expression?

A. SELECT Sales_Rep_No(108) FROM Orders;

B. INSERT INTO Orders VALUES(Sales_Rep_No = 108) WHERE Sales_Rep_No = NULL;

C. SELECT * FROM Orders WHERE Sales_Rep_No = 108;

D. SELECT * FROM Orders WHERE Sales_Rep_No = 108;

Question #11 - Topic 0

Which statement accurately describes a characteristic of attributes?

A. The ordering of attributes in a table is significant.

B. An attribute contains values from multiple domains.

C. An attribute name can be used only once per table.

D. An attribute name can be used only once in a relational database system with multiple tables.

Question #12 - Topic 0

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;

Question #13 - Topic 0

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

Question #14 - Topic 0

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

Question #15 - Topic 0

Your enterprise is creating a relation (shown in the exhibit) that tracks parts and suppliers.
Which situation would occur if new supplier information were entered in the relation before
any information about specific parts?

A. An update anomaly and an insertion anomaly would occur.

B. An insertion anomaly would occur.

C. A deletion anomaly would occur.

D. A deletion anomaly and an update anomaly would occur.

×