Question 1

Consider the following relational algebraic expression as well as the Employee and Department relations shown in the exhibit: Which of the following relations would result from the given relational algebraic expression?

Options :

A :

B :

C :

D :

Answer: D

Question 2

Consider the following database information:

domain s_id: integer domain grd: fixed length

character string length 1

STUDENT_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 relation shown in the exhibit. Which of the following SQL statements would return a relation that excludes all customers with a Satisfaction_Rate of less than or equal to 80 unless the Sales_Office is located in Atlanta?

Options :

A : SELECT * FROM Customers WHERE Satisfaction_Rate > 80 OR Sales_Office = Atlanta

B : SELECT * FROM Customers WHERE Satisfaction_Rate <= 80 AND Sales_Office = Atlanta

C : SELECT * FROM Customers WHERE Satisfaction_Rate >= 80;

D : SELECT * FROM Customers WHERE Satisfaction_Rate >= 80 AND NOT Sales Office = Atlanta

Answer: A

Question 4

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 5

Consider the Information Engineering diagram in the exhibit showing a conceptual data model of the relations BUILDING and RESIDENT. What is the next step in refining the data model?

Options :

A : Create intermediate entities

B : Create a logical data model.

C : Resolve many-to-many relationships

D : Identify and resolve complex relationships.

Answer: B

Higher Test Marks with Free Online 1D0-541 Exam Practice

Buying Options: