1D0-541 Practice Online

Question 1

Consider the relation shown in the exhibit. Which of the following SQL statements would properly add information for a new employee?

A : INSERT INTO Employee VALUES(0005, Tim, Bogart, 03-15-77);

B : INSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date) VALUES(0004, Tim, Bogart, 03-15-77);

C : INSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date) VALUES(0005, Tim, Bogart, 03-05-77);

D : INSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date) VALUES(0005, Tim, Bogart, 03-05-77);

Answer: D

Question 2

Consider the entity-relationship (ER) diagram shown in the exhibit. Which type of relationship between the two entities is shown?

A : m:m

B : m:n

C : 1:1

D : 1:n

Answer: B

Question 3

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

A : Degree of a relation

B : Cardinality of a relation

C : Primary key of a relation

D : Determinant of a relation

Answer: B

Question 4

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?

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;

Answer: B

Question 5

Which of the following best describes a composite key?

A : A composite key is a primary key that consists of the first two attributes of a relation

B : A composite key is a primary or foreign key defined by its parent keys.

C : A composite key is a foreign key that consists of the same attributes as the primary key from a related table.

D : A composite key is a primary or foreign key that consists of two or more attributes of a relation

Answer: D

Name:	CIW Database Design Specialist
Exam Code:	1D0-541
Certification:	CIW Web Foundations
Vendor:	CIW
Total Questions:	125
Last Updated:	May 15, 2024

Download Demo 1D0-541 Dumps

Create Account

Password Recovery

1D0-541 Practice Online

Download Demo 1D0-541 Dumps

Member Login

Create Account

Password Recovery

1D0-541 Practice Online