Question 1

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

Question 2

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 3

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 4

What improvement can be made to file-based databases to overcome their limitations?

Options :

A : Implement a tabular structure.

B : Gather files in a distributed repository

C : Use a hierarchical database file system.

D : Tightly couple database structure to database application programs.

Answer: A

Question 5

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

Free 1D0-541 Mock Exam – Practice Online Confidently

Buying Options: