Question 1

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

Options :

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 following database information:domain s_id: integer domain grd: fixed lengthcharacter string length 1STUDENT_GRADE(Student_Number: s_id NOT NULL -Grade: grd ) Primary Key -Student_Number -During which phase of the database design process would this information be developed?

Options :

A : Logical

B : Physical

C : Conceptual

D : Implementation

Answer: A

Question 3

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

Options :

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?

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;

Answer: B

Question 5

Which area of database security involves maintaining access to enterprise data?

Options :

A : Theft

B : Privacy

C : Availability

D : Confidentiality

Answer: C

Free 1D0-541 Mock Exam – Practice Online Confidently

Buying Options: