Which statement accurately describes a characteristic of attributes?

• A. An attribute name can be used only once per table.
• B. An attribute contains values from multiple domains.
• C. The ordering of attributes in a table is significant.
• D. An attribute name can be used only once in a relational database system with multiple tables.

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 RESIDENT (Building_ID)
  ON DELETE NO CHECK);
• 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 BUILDING (Building_ID)
  ON DELETE NO CHECK
  ON UPDATE CASCADE);
• 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);

Consider the Orders relation shown in the exhibit. Which of the following SQL statements would return all complete tuples for order dates in 2002, arranged by amount from lowest to highest?

• A. SELECT *
  FROM Orders
  WHERE Order_Date LIKE %02
  ORDER BY Amount;
• B. SELECT (Order_Date, Amount)
  FROM Orders
  WHERE Order_Date LIKE %02
  ORDER BY Amount;
• C. SELECT *
  FROM Orders
  WHERE Order_Date LIKE _02
  ORDER BY Amount;
• D. SELECT *
  FROM Orders
  WHERE Order_Date LIKE _02
  ORDER BY Order_No;

Which of the following ACID properties requires that a transaction be executed in its entirety or not all?

• A. Atomicity
• B. Durability
• C. Consistency
• D. Isolation

Consider the following relations shown in the exhibit. Which of the following SQL statements would return the Customers2 relation from the Customers relation?

• A. SELECT * FROM Customers WHERE Satisfaction_Rate IN (80 AND 90);
• B. SELECT *FROM Customers WHERE Satisfaction_Rate >= 80 AND Satisfaction_Rate <= 89;
• C. SELECT * FROM Customers WHERE Satisfaction_Rate BETWEEN (80, 90);
• D. SELECT * FROM Customers WHERE Satisfaction_Rate <= 80 OR Satisfaction_Rate >= 90;