Labour Day Sale - Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 575363r9

Welcome To DumpsPedia
  1. Home
  2. CIW
  3. CIW Web Development Series
  4. 1D0-541
  5. CIW v5 Database Design Specialist Questions and Answers

1D0-541 Sample Questions Answers

Questions 4

Consider the following DBDL description of an entity: Teachers (teach_num: variable length character string length 10 NOT NULL teach_name: variable length character string length 10 NOT NULL) Primary Key: teach_num which integrity constraint is satisfied?

Options:

A.

Entity integrity

B.

Necessary data

C.

Referential integrity

D.

Referential foreign integrity

Buy Now
Questions 5

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

Options:

A.

Normalization

B.

Denormalization

C.

Referential integrity

D.

Domain constraints

Buy Now
Questions 6

The exhibit shows a relation for a company projects. Which candidate key(s) would best serve as the primary key for this relation?

Options:

A.

S_Date and E_Date

B.

ProjJD

C.

ltem_Num and E_Date

D.

Proj_ID and Item_Num

Buy Now
Questions 7

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

Options:

A.

6

B.

20

C.

4

D.

25

Buy Now
Questions 8

Consider the following table as well as the Dept1_Parts and Dept2_Parts relations shown in the exhibit: Which of the following relational algebraic expressions would result in the given table?

Options:

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Buy Now
Questions 9

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

Options:

A.

Weak

B.

Strong

C.

Foreign

D.

Primary

Buy Now
Questions 10

Which of the following best describes the ON DELETE CASCADE referential integrity constraint?

Options:

A.

If a parent key is deleted, any child keys referenced by the parent key are automatically deleted.

B.

If any child key references a parent key, the record containing the parent key cannot be deleted.

C.

If a parent key is deleted,all child keys are automatically set to a specified value.

D.

If a parent key is deleted, no test is made for referential integrity.

Buy Now
Questions 11

Consider the following relational algebraic expression as well as the Employee and Department relations shown in the exhibit: Which of the following relations would result from the given relational algebraic expression?

Options:

A.

OptionA

B.

OptionB

C.

OptionC

D.

OptionD

Buy Now
Questions 12

Consider the Project relation shown in the exhibit as well as the following SQL statement: Which of the following tables shows the Project relation after execution of this SQL statement?

Options:

A.

OptionA

B.

OptionB

C.

OptionC

D.

OptionD

Buy Now
Questions 13

Consider the following relations shown in the exhibit. Which of the following SQL statements would return the Customers2 relation from the Customers relation?

Options:

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

Buy Now
Questions 14

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?

Options:

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;

Buy Now
Questions 15

What is the highest normal form of the relation(s) shown in the exhibit?

Options:

A.

Third normal form

B.

Second normal form

C.

No normal form

D.

First normal form

Buy Now
Questions 16

Which database security technique prevents invalid data from being entered into the database?

Options:

A.

File locking

B.

User authorization

C.

Parity checks

D.

Integrity controls

Buy Now
Questions 17

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?

Options:

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

Buy Now
Questions 18

Consider the Stu_Act and Act_Fee tables shown in the exhibit. Which relational algebraic operation would yield the Activity Relation table in the exhibit?

Options:

A.

Union

B.

Intersection

C.

Natural join

D.

Cartesian product

Buy Now
Exam Code: 1D0-541
Exam Name: CIW v5 Database Design Specialist
Last Update: Apr 23, 2024
Questions: 124
$64  $159.99
$48  $119.99
$40  $99.99
buy now 1D0-541