New Year Sale Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmas50

CIW 1D0-541 - CIW v5 Database Design Specialist

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

Consider the following SQL statement and the Orders relation shown in the exhibit:

How many records should be returned?

A.

Two records

B.

Three records

C.

Four records

D.

Five records

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?

A.

OptionA

B.

OptionB

C.

OptionC

D.

OptionD

What is a virtual table?

A.

A virtual table is a relation created as the result of data manipulation; it exists only in computer memory, and is not a permanent part of the database.

B.

A virtual table is a relation stored in the database; it is used when multiple users access the same relation in a database.

C.

A virtual table is a relation derived from the database data dictionary; it contains metadata about a base relation.A virtual table is a relation derived from the database? data dictionary; it contains metadata about a base relation.

D.

A virtual table is a relation that consists of primary and foreign keys for a particular set of relations in a database.

Which of the following is a characteristic of the three-tier database architecture?

A.

A Web browser is used as the application server.

B.

The application logic is centralized on a dedicated server.

C.

A thick client is used to perform business application logic functions locally.

D.

Database application logic and database functionality are integrated and reside on a common server.

Which three pieces of information did E.F. Codd describe as necessary to retrieve a data value from a relational database?

A.

Attribute, domain, and tuple

B.

Entity, relation name, and domain

C.

Table name, primary key, and entity

D.

Attribute, relation name, and primary key

Which database architecture is best suited to implementation in the World Wide Web environment?

A.

Two-tier using thin client

B.

Three-tier using fat client

C.

Three-tier using thin client

D.

Centralized mainframe with terminal client

Your enterprise has reached the conceptual design phase for a database project. What is the desired goal at the end of this design phase?

A.

A set of normalized relations

B.

A reviewed entity-relationship (ER) model

C.

An entity-relationship (ER) model with no redundant data

D.

A set of denormalized relations