Online Access Free 1D0-541 Practice Test

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

• A.A recursive relationship
• B.A many-to-many relationship
• C.A one-to-one relationship
• D.A one-to-many relationship

Several SQL operations are performed by User 1 to access the Fee information for Bowling in the Act_Fee relation (shown in the exhibit). The first access returns a fee of 50. An unrelated SQL operation by another user updates the Bowling fee to 60. The second access by User 1 returns a fee of 60. What problem has occurred?

• A.Deadlock
• B.No problem has occurred.
• C.Rollback
• D.Dirty read

Which of the following best describes the ON DELETE CASCADE referential integrity constraint?

• A.If a parent key is deleted, any child keys referenced by the parent key are automatically deleted.
• B.If a parent key isdeleted, all child keys are automatically set to a specified value.
• C.If a parent key is deleted, no test is made for referential integrity.
• D.If any child key references a parent key, the record containing the parent key cannot be deleted.

Consider the Information Engineering diagram shown in the exhibit for a building management company. Referential integrity must be maintained such that a building cannot be deleted when it has residents. Building_ID, R_ID, Room_Count and Room_Num are integer numbers, whereas Bldg_Name, Location and Res_Name are all represented by variable-length strings with a maximum of 20 characters. Which SQL statement best implements the relations shown in this diagram?

• A.CREATE TABLE BUILDING (
  Building_ID INTEGER NOT NULL PRIMARY KEY,
  Bldg_Name VARCHAR (20),
  Location VARCHAR (20),
  Room_Count INTEGER );
  CREATE TABLE RESIDENT (
  R_ID NOT NULL PRIMARY KEY,
  Room_Num INTEGER,
  Res_Name VARCHAR (20),
  Building_ID INTEGER NOT NULL,
  FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID)
  ON DELETE NO CHECK
  ON UPDATE CASCADE);
• B.CREATE TABLE BUILDING (
  Building_ID INTEGER NOT NULL PRIMARY KEY,
  Bldg_Name VARCHAR (20),
  Location VARCHAR (20),
  Room_Count INTEGER );
  CREATE TABLE RESIDENT (
  R_ID NOT NULL PRIMARY KEY,
  Room_Num INTEGER,
  Res_Name VARCHAR (20),
  Building_ID INTEGER NOT NULL,
  FOREIGN KEY Building_ID REFERENCES RESIDENT (Building_ID)
  ON DELETE NO CHECK);
• C.CREATE TABLE BUILDING (
  Building_ID INTEGER NOT NULL PRIMARY KEY,
  Bldg_Name VARCHAR (20),
  Location VARCHAR (20),
  Room_Count INTEGER );
  CREATE TABLE RESIDENT (
  R_ID NOT NULL PRIMARY KEY,
  Room_Num INTEGER,
  Res_Name VARCHAR (20),
  Building_ID INTEGER NOT NULL,
  FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID)
  ON DELETE NO CHECK
  ON UPDATE CASCADE);
• D.CREATE TABLE BUILDING (
  Building_ID INTEGER NOT NULL PRIMARY KEY,
  Bldg_Name VARCHAR (20),
  Location VARCHAR (20),
  Room_Count INTEGER );
  CREATE TABLE RESIDENT (
  R_ID NOT NULL PRIMARY KEY,
  Room_Num INTEGER,
  Res_Name VARCHAR (20),
  Building_ID INTEGER NOT NULL,
  FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID)
  ON DELETE NO CHECK
  ON UPDATE CASCADE);

Which three pieces of information did E.F. Codd describe as necessary to retrieve a data value from a relational database?

• A.Attribute, relation name, and primary key
• B.Table name, primary key, and entity
• C.Entity, relation name, and domain
• D.Attribute, domain, andtuple