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

Free CIW 1D0-541 Practice Exam with Questions & Answers

Questions 1

A foreign key maps to a:

Options:
A.

Prime key

B.

Indirect key

C.

Parent key

D.

Composite key

CIW 1D0-541 Premium Access
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;

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.

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.

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

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.

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

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

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

Questions 10

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

Options:
A.

Normalization

B.

Denormalization

C.

Referential integrity

D.

Domain constraints