Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

CIW 1D0-541 - CIW v5 Database Design Specialist

CIW 1D0-541 Premium Access     Download Demo    
Page: 1 / 4
Total 124 questions

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

A.

25

B.

5

C.

4

D.

20

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

A.

Metadata

B.

Data model

C.

Table data

D.

Metafile

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

Which pair of relational algebraic operations requires union compatibility?

A.

Union and join

B.

Selection and projection

C.

Intersection and difference

D.

Cartesian product and intersection

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

Consider the entity-relationship (ER) diagram shown in the exhibit. Which type of relationship between the two entities is shown?

A.

A recursive relationship

B.

A many-to-many relationship

C.

A one-to-one relationship

D.

A one-to-many relationship

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

A.

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

B.

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

C.

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

D.

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

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

A.

Third normal form

B.

Second normal form

C.

No normal form

D.

First normal form

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

A.

SELECT*FROM Customers,

Employees WHERE Sales_Rep_No = Cust_No;

B.

SELECT Cust_No, Cust_Name, Emp_Name, Emp_Loc FROM

Customers, Employees WHERE Customers.Sales_Rep_No =

Employees.Sales_Rep_No;

C.

SELECT Cust_No, Cust_Name, Emp_Name, Emp_Loc FROM

Customers, Employees WHERE Employees.Sales_Rep_No =

Customers.Sales_Rep_No;

D.

SELECT * FROM Customers, Employees WHERE

Customers.Sales_Rep_No = Employees.Sales_Rep_No;

The exhibit shows a table called Student Relation that tracks all information related to a students courses, professors and sites. What would be the consequence of removing all records for a student with the ID 1311?

A.

Only an update anomaly would occur.

B.

An insertion anomaly would occur.

C.

A deletion anomaly would occur.

D.

An update anomaly and a deletion anomaly would occur.