Weekend Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = simple70

Home
CIW
CIW Web Development Series
1D0-541
CIW v5 Database Design Specialist Questions and Answers

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

Practice at least 50% of the questions to maximize your chances of passing.

Exam 1D0-541 Premium Access

View all detail and faqs for the 1D0-541 exam

Go to Exam

383 Students Passed

89% Average Score

98% Same Questions

Viewing page 1 out of 4 pages

Viewing questions 1-10 out of questions

Questions # 1:

Consider the following table as well as the Dept1_Parts and Dept2_Parts relations shown in the exhibit: Which of the following relational algebraic expressions would result in the given table?

Question # 1

Options:

Option A

Option B

Option C

Option D

Answer

Questions # 2:

Your enterprise is developing a database system that will contain highly sensitive data. Security of the data will take priority over database processing speed. Which database protection technique should be employed?

Options:

Backups

User views

Encryption

Integrity controls

Answer

Questions # 3:

Consider the Dept1_Parts and Dept2_Parts relations shown in the exhibit. Which of the following SQL statements would create a set difference of the two relations with the widest variety of Structured Query Language dialects?

Question # 3

Options:

SELECT *

FROM Dept1_Parts

EXCEPT

(SELECT Part_ID

FROM Dept2_Parts);

SELECT *

FROM Dept1_Parts

MINUS

(SELECT Part_ID

FROM Dept2_Parts);

SELECT *

FROM Dept1_Parts

DIFFERENCE

(SELECT Part_ID

FROM Dept2_Parts);

SELECT *

FROM Dept1_Parts

DIFFERENCE

(SELECT Part_ID

FROM Dept2_Parts);

Answer

Questions # 4:

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 # 4

Options:

OptionA

OptionB

OptionC

OptionD

Answer

Questions # 5:

Which concurrency control method should be used only when conflicts between transactions rarely occur?

Options:

Locking

Time stamps

Optimistic

Serialization

Answer

Questions # 6:

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

Options:

Attribute, domain, and tuple

Entity, relation name, and domain

Table name, primary key, and entity

Attribute, relation name, and primary key

Answer

Questions # 7:

Your database administrator has disallowed a group of users from making alterations to the Employees table in your corporate database. The users, known as Group_2, previously had full privileges with the Employees table. Which of the following SQL statements properly removes any alteration privileges from Group_2?

Options:

REVOKE INSERT,

UPDATE, DELETE ON

Employees FROM Group_2;

REVOKE

UPDATE FOR

Employees

FROM Group_2;

REVOKE INSERT,

UPDATE, DELETE ON

Employees FOR Group_2;

REVOKE

UPDATE, DELETE

FOR Employees

FROM Group_2;

Answer

Questions # 8:

FROM Registration WHERE

Consider the following relational algebraic expression: Which of the following SQL Course_Code = 'A4343';

statements is equivalent to this relational algebraic expression?

Question # 8

Options:

SELECT Sales_Rep_No(108)

FROM Orders;

INSERT INTO Orders

VALUES(Sales_Rep_No = 108)

WHERE Sales_Rep_No = NULL;

SELECT'FROM Orders

WHERE Sales_Rep_No = 108;

SELECT'FROM Orders

WHERE Sales_Rep_No = ?08?

Answer

Questions # 9:

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

Options:

A Web browser is used as the application server.

The application logic is centralized on a dedicated server.

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

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

Answer

Questions # 10:

Consider the Recreation relation in the exhibit. A data operation that changes one of the tuples for Student_ID 1003 must be performed. It is necessary to change one of the activities from swimming to tennis. The Student_ID and Activity attributes make up the primary key for the Recreation relation. All related information must be altered, as well. Which SQL statement or statements would best accomplish this?

Question # 10