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

A. Durability

B. Consistency

C. Isolation

D. Atomicity

Consider the following relational algebraic expression:

Which of the following SQL statements is equivalent to this relational algebraic expression?

A. SELECT Sales_Rep_No(108) FROM Orders;

B. INSERT INTO Orders VALUES(Sales_Rep_No = 108) WHERE Sales_Rep_No = NULL;

C. SELECT * FROM Orders WHERE Sales_Rep_No = 108;

D. SELECT * FROM Orders WHERE Sales_Rep_No = 108;

Which of the following definitions best describes an entity?

A. A single relation

B. Data about data

C. Data stored in a table column

D. An item about which information is stored

Which subset of Structured Query Language (SQL) is used to create and name database entities?

A. Data Control Language

B. Database Entity Language

C. Data Definition Language

D. Data Manipulation Language

Which component in the three-tier database architecture handles the data-processing and business logic?

A. Thin client

B. Fat client

C. Database server

D. Application server

Consider the Dept1_Parts and Dept2_Parts relations shown in the exhibit. Which of the following SQL statements would create an intersection of the two relations with the widest variety of Structured Query Language dialects?

A. SELECT * FROM Dept1_Parts AND (SELECT * FROM Dept2_Parts);

B. SELECT * FROM Dept1_Parts INTERSECTION (SELECT * FROM Dept2_Parts);

C. SELECT * FROM Dept1_Parts WHERE Dept1_Parts.Part_ID = Dept2_Parts.Part_ID;

D. SELECT * FROM Dept1_Parts WHERE Dept1_Parts.Part_ID = Dept2_Parts.Part_ID;

Your enterprise must decide whether to use a database management system. Which of the following best describes the overall functionality of a DBMS?

A. A DBMS provides the ability to control data access using Data Manipulation Language.

B. A DBMS provides the ability to maintain databases while providing increased security for the database.

C. A DBMS allows users to access the database while allowing only the database administrator to define user views.

D. A DBMS provides the ability to define, create and maintain databases while providing controlled access to databases.

Which of the following occurs in a relation when records are added or removed?

A. The number of domains changes.

B. The attributes in the table change.

C. The cardinality of the relation is fixed but the degree varies.

D. The degree of the relation is fixed but the cardinality varies.

Which of the following describes two desirable characteristics of a primary key?

A. A primary key should be a value that may be null and may change over time.

B. A primary key should be a value that is not null and will never change.

C. A primary key should consist of meaningful data and a value that can be changed if needed.

D. A primary key should not consist of meaningful data and a value that can be changed if needed.

Consider the Project relation shown in the exhibit as well as the following SQL statement:

DELETE FROM Project WHERE Cust_Name = Acme;

Which of the following tables shows the Project relation after execution of this SQL statement?

A.

B. C. D.