CIW 1D0-541 Exam Questions Free Practice Test

Viewing page 3 out of 4 pages

Viewing questions 21-30 out of questions

Questions # 21:

Consider the Project relation shown in the exhibit as well as the following SQL statement:

DELETE FROM Project

WHERE Cust_Name = Acme;

Which of the following tables shows the Project relation after execution of this SQL statement?

Question # 21

Options:

OptionA

OptionB

OptionC

OptionD

Expert Solution

Questions # 22:

In which situation would the DBMS use a serial schedule to execute the transactions?

Options:

Concurrent transactions read data from the same data structure.

Concurrent transactions write data to different data structures.

Concurrent transactions read or write the same data structure.

Concurrent transactions read or write from different data structures.

Expert Solution

Questions # 23:

What improvement can be made to file-based databases to overcome their limitations?

Options:

Implement a tabular structure.

Gather files in a distributed repository.

Use a hierarchical database file system.

Tightly couple database structure to database application programs.

Expert Solution

Questions # 24:

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?

Question # 24

Options:

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

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

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

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

Expert Solution

Questions # 25:

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

Options:

Weak

Strong

Foreign

Primary

Expert Solution

Questions # 26:

Which of the following definitions best describes an entity?

Options:

A relation

Data about data

Data stored in a table column

An item about which information is stored

Expert Solution

Questions # 27:

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?

Question # 27

Options:

OptionA

OptionB

OptionC

OptionD

Expert Solution

Questions # 28:

Which term best defines a database system in which data records are stored in one or more files with no structured relationship?

Options:

Flat-file database

Relational database

Distributed database

Object-oriented database

Expert Solution

Questions # 29:

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

Question # 29

Options:

S_Date and E_Date

ProjJD

ltem_Num and E_Date

Proj_ID and Item_Num

Expert Solution

Questions # 30:

Consider the following relational algebraic expression as well as the Dept1_Parta and Dept2_Parts relations shown in the exhibit: Which of the following relations would result form the given relational algebraic expression?

Question # 30

Options:

Option A

Option B

Option C

Option D

Expert Solution

Viewing page 3 out of 4 pages

Viewing questions 21-30 out of questions

Pass the CIW CIW Web Development Series 1D0-541 Questions and answers with CertsForce