CIW Web Development Series Changed 1D0-541 Questions

CIW v5 Database Design Specialist Questions and Answers

Question 9

Which subset of Structured Query Language (SQL) is used to create and name database entities?

Options:

Data Query Language

Database Entity Language

Data Definition Language

Data Manipulation Language

Question 10

Consider the relations shown in the exhibit. Due to restructuring, the sales department has been eliminated and the employees working in that department have been dismissed. All ID information is stored as integers. Which SQL statement would be used to return a relation with all information for the employees who have been dismissed?

Options:

SELECT *

FROM Employee;

SELECT ID, Last_Name

FROM Employee;

WHERE ID = 0004;

SELECT *

FROM Employee

WHERE Dept_ID = 022;

SELECT *

FROM Employee

WHERE Dept_ID = 022;

Question 11

Consider the entity-relationship (ER) diagram shown in the exhibit. What do the characters at the ends of the connecting line indicate?

Options:

Degree of a relation

Cardinality of a relation

Primary key of a relation

Determinant of a relation

Question 12

Consider the following four database design activities:

1 - Design user views.

2 - Select a DBMS.

3 - Apply normalization.

4 - Determine entities.

Which choice shows the correct ordering of these activities, from first to last, by assigned numbers?

Options:

1,2,3,4

3,4,1,2

4,3,1,2

4,2,3,1

Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

CIW Web Development Series Changed 1D0-541 Questions

CIW v5 Database Design Specialist Questions and Answers

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer: