Summer Special 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: bestdeal

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

Questions 1

A foreign key maps to a:

Options:

A.

Prime key

B.

Indirect key

C.

Parent key

D.

Composite key

Buy Now
Questions 2

Consider the Orders relation shown in the exhibit. Which of the following SQL statements would replace the value in the Sales_Rep_No column with 110 everywhere that Sales_Rep_No 108 is listed?

Options:

A.

UPDATE Sales_Rep_No

IN Orders

SET(Sales_Rep_No = 110

WHERE Sales_Rep_No = 108);

B.

UPDATE Orders

SET Sales_Rep_No = 110

WHERE Sales_Rep_No = 108;

C.

UPDATE Orders

SET Sales_Rep_No = 110;

D.

UPDATE Orders

WHERE Sales_Rep_No = 108

SET Sales_Rep_No = 110;

Buy Now
Questions 3

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

Options:

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.

Buy Now
Questions 4

Which statement best describes a candidate key?

Options:

A.

It is the primary key for an entity.

B.

It uniquely identifies every instance of an entity.

C.

One or more keys are joined together to form a composite key.

D.

One or more keys may be used to form a primary key.

Buy Now
Questions 5

Which statement is used to define a named group of related tables, views, domains and other database objects?

Options:

A.

CREATE

B.

CREATE TABLE

C.

CREATE DOMAIN

D.

CREATE SCHEMA

Buy Now
Questions 6

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

Options:

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.

Buy Now
Questions 7

Which subset of Structured Query Language (SQL) is used to limit access to a database or its data?

Options:

A.

Data Markup Language

B.

Data Control Language

C.

Data Formatting Language

D.

Data Manipulation Language

Buy Now
Questions 8

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

1D0-541 Question 8

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 9

Which subset of Structured Query Language (SQL) is used to perform operations such as data retrieval or deletion on the data contained in a database?

Options:

A.

Data Control Language

B.

Data Definition Language

C.

Data Formatting Language

D.

Data Manipulation Language

Buy Now
Questions 10

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

Options:

A.

Normalization

B.

Denormalization

C.

Referential integrity

D.

Domain constraints

Buy Now