Independence Day Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sale65best

Your Path to Success: How to Pass the CIW 1D0-541 CIW v5 Database Design Specialist Exam

Questions 21

Consider the following database information:

domain s_id: integer domain grd: fixed length

character string length 1

STUDENT_GRADE(

Student_Number: s_id NOT NULL

Grade: grd ) Primary Key

Student_Number

During which phase of the database design process would this information be developed?

Options:

A.

Logical

B.

Physical

C.

Conceptual

D.

Implementation

Buy Now
Questions 22

Which of the following best describes the information contained in the data dictionary (or system catalog)?

Options:

A.

Metadata

B.

Data model

C.

Table data

D.

Metafile

Buy Now
Questions 23

Consider the Registration relation shown in the exhibit. Which of the following SQL statements would return all tuples that have course codes beginning with the letter M?

1D0-541 Question 23

Options:

A.

SELECT * FROM

Registration WHERE

Course_Code = #

B.

SELECT * FROM

Registration WHERE

Course_Code LIKE _

C.

SELECT * FROM

Registration WHERE

Course_Code LIKE %

D.

SELECT * FROM

Registration WHERE

Course Code = %

Buy Now
Questions 24

Consider the Dept1_Parts and Dept2_Parts relations shown in the exhibit. Which of the following SQL statements would create a set difference of the two relations with the widest variety of Structured Query Language dialects?

1D0-541 Question 24

Options:

A.

SELECT *FROM

Dept1_Parts

EXCEPT(SELECT

PartJD FROM

Dept2_Parts);

B.

SELECT * FROM

Dept1_Parts MINUS

(SELECT Part_ID

FROM Dept2_Parts);

C.

SELECT*FROM

Dept1_Parts

DIFFERENCE

(SELECT Part_ID

FROM Dept2_Parts);

D.

SELECT*FROM

Dept1_Parts WHERE

Part_ID NOT IN

(SELECT Part_ID FROM

Dept2_Parts);

Buy Now
Questions 25

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
Questions 26

Consider the relations shown in the exhibit. Due to restructuring, the sales department has been eliminated and the employees working in that department have been dismissed. All ID information is stored as integers. Which SQL statement would be used to return a relation with all information for the employees who have been dismissed?

1D0-541 Question 26

Options:

A.

SELECT *

FROM Employee;

B.

SELECT ID, Last_Name

FROM Employee;

WHERE ID = 0004;

C.

SELECT *

FROM Employee

WHERE Dept_ID = 022;

D.

SELECT *

FROM Employee

WHERE Dept_ID = 022;

Buy Now
Questions 27

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

Options:

A.

One-to-many and recursive

B.

Complex, recursive, and many-to-many

C.

Redundant, recursive, and one-to-many

D.

One-to-many and one-to-one

Buy Now
Questions 28

Consider the Information Engineering diagram in the exhibit showing a conceptual data model of the relations BUILDING and RESIDENT. What is the next step in refining the data model?

1D0-541 Question 28

Options:

A.

Create intermediate entities.

B.

Create a logical data model.

C.

Resolve many-to-manyrelationships.

D.

Identify and resolve complex relationships.

Buy Now
Questions 29

Which process is used to prevent the current database operation from reading or writing a data item while that data item is being accessed by another operation?

Options:

A.

Lock

B.

Deadlock

C.

Time stamp

D.

Transaction

Buy Now
Questions 30

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 Question 30

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