Pre-Summer Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

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

728 Students Passed

87% Average Score

93% Same Questions

Viewing page 4 out of 4 pages

Viewing questions 31-40 out of questions

Questions # 31:

For the Employee relation shown in the exhibit, which set of column value holds the complete tuple for the employee named James Smith?

Question # 31

Options:

0002, James, Smith

0002, James, Smith, 10-25-76

First_Name, James, Last_Name, Smith

Emp_ID, 0002, First_Name, James, Last_Name, Smith

Answer

Questions # 32:

The database manager wants to give Rubio and Doe the ability to modify the Project Relation shown in the exhibit. A temporary employee named Temp needs to access the data in the database to generate reports. Which group of SQL statements will perform this task?

Options:

GRANT UPDATE ON Project TO Rubio, Doe;

GRANT SELECT ON Project TO Temp;

GRANT ALL PRIVILEGES ON Project TO Rubio, Doe;

GRANT UPDATE ON Project TO Temp;

GRANT SELECT ON Project

WHERE Manager = 'Rubio';

GRANT SELECT ON Project

WHERE Manager = 'Doe';

GRANT UPDATE ON Project

WHERE Manager = 'Rubio';

GRANT UPDATE ON Project

WHERE Manager = 'Doe';

GRANT SELECT ON Project TO Temp;

Answer

Questions # 33:

What is a domain?

Options:

A normalized set of data applicable to a particular relation

A combination of attributes for a relation

A definition of permissible values for one or more attributes

A set of permissible values for one or more relations

Answer

Questions # 34:

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

Answer

Questions # 35:

What is the most important service provided by a database management system?

Options:

Provides support for a data manipulation language

Allows users to store data in a distributed data repository

Provides support for data formatting language commands

Translates procedural commands into non-procedural commands

Answer

Questions # 36:

Consider the following relation definitions:

STUDENT(

Student_Number: integer NOT NULL

Name: variable length character string length 20)

Primary Key Student_Number

HOUSING(

Housing_ID: integer NOT NULL

Student_Number: integer NOT NULL

Building: variable length character string length 25)

Primary Key Housing_ID

Foreign Key Student_Number References STUDENT(Student_Number)

ON DELETE NO ACTION

ON UPDATE CASCADE

What are the referential constraints for the relations defined in these relation definitions?

Options:

There is no relationship between changes in STUDENT(Student_Number) and HOUSING(Student_Number).

When STUDENT(Student_Number) is changed or deleted, this modification or deletion will automatically be reflected in HOUSING(Student_Number).

Modifications to HOUSING(Student_Number) are automatically reflected in changes to STUDENT(Student_Number), but deletions are not permitted.

Modifications to STUDENT(Student_Number) are automatically reflected in changes to HOUSING(Student_Number). For a deletion to occur fromSTUDENT(Student_Number), it must first occur in HOUSING(Student_Number).

Answer

Questions # 37:

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