1D0-541

1D0-541 practice questions, page 5 of 5, with answer review and explanations.

Question 21

Consider the table for an employee database shown in the exhibit. What is the degree of the table?

  1. 25
  2. 5
  3. 4
  4. 20

Question 22

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

  1. Implement a tabular structure.
  2. Gather files in a distributed repository.
  3. Use a hierarchical database file system.
  4. Tightly couple database structure to database application programs.

Question 23

NULL) Primary Key Class_Num - Consider the Information Engineering diagram shown in the exhibit. Which DBDL definition best describes this diagram?

  1. BUILDING(Building_ID, Bldg_Name, Location, Room_Count) Primary Key Building_ID RESIDENT(R_ID, Room_Num, Res_Name, Building_ID) Primary Key R_ID
  2. BUILDING(Building_ID, Bldg_Name, Location, Room_Count) Primary Key BUILDING RESIDENT(R_ID, Room_Num, Res_Name, Building_ID) Primary Key RESIDENT
  3. BUILDING(Building_ID, Bldg_Name, Location, Room_Count) Primary Key BUILDING Foreign Key BUILDING(Building_ID) references RESIDENT (Building_ID) RESIDENT(R_ID, Room_Num, Res_Name, Building_ID) Primary Key RESIDENT
  4. BUILDING(Building_ID, Bldg_Name, Location, Room_Count) Primary Key Building_ID RESIDENT(R_ID, Room_Num, Res_Name, Building_ID) Primary Key R_ID Foreign Key Building_ID references BUILDING(Building_ID)

Question 24

Consider the Information Engineering diagram in the exhibit showing the relations BUILDING and RESIDENT. What is the relationship between BUILDING and RESIDENT?

  1. 1:1
  2. 1:N
  3. N:1
  4. M:N