NEW QUESTION 1
Consider the Recreation relation shown in the exhibit. You need to apply a SQL statement to the Recreation relation that will return the following data:

Which SQL statement applied to the Recreation relation will return this data?

• A. SELECT Activity FROM Recreation;
• B. SELECT DISTINCT Activity FROM Recreation;
• C. SELECT Activity FROM Recreation WHERE NOT LIKE Activity;
• D. SELECT Activity FROM Recreation WHERE DISTINCT Activity;

Answer: B

NEW QUESTION 2
Which type of entity must reference another entity for its data to be meaningful?

• A. Weak
• B. Strong
• C. Foreign
• D. Primary

Answer: A

NEW QUESTION 3
For the Employee relation shown in the exhibit, which set of column values holds the complete tuple for the employee named James Smith?

A. 0002, James, Smith

• A. 0002, James, Smith, 10-25-76
• B. First_Name, James, Last_Name, Smith
• C. Emp_ID, 0002, First_Name, James, Last_Name, Smith

Answer: B

NEW QUESTION 4
Consider the following table as well as the Dept1_Parts and Dept2_Parts relations shown in the exhibit:

Which of the following relational algebraic expressions would result in the given table?

• A.
• B.
• C.
• D.

Answer: A

NEW QUESTION 5
Which type of relational integrity is violated if a primary key in a database has a null value?

• A. Entity integrity
• B. Domain integrity
• C. Domain constraints
• D. Referential integrity

Answer: A

NEW QUESTION 6
Your enterprise is creating a relation (shown in the exhibit) that tracks parts and suppliers. Which situation would occur if new supplier information were entered in the relation before any information about specific parts?

• A. An update anomaly and an insertion anomaly would occur.
• B. An insertion anomaly would occur.
• C. A deletion anomaly would occur.
• D. A deletion anomaly and an update anomaly would occur.

Answer: B

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

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

Answer: D

NEW QUESTION 8
Which of the following best describes a composite key?

• A. A composite key is a primary key and foreign key that consists of the first two attributes of a relation.
• B. A composite key is a primary or foreign key defined by its parent key attributes.
• C. A composite key is a foreign key that consists of the same attributes as the primary key from a related table.
• D. A composite key is a primary or foreign key that consists of two or more attributes of a relation.

Answer: D

NEW QUESTION 9
Which statement accurately describes a characteristic of attributes?

• A. Mastered
• B. Not Mastered

Answer: A

NEW QUESTION 10
Consider the following SQL statement and the Orders relation shown in the exhibit:

What is the output of this SQL statement?

• A.
• B.
• C.
• D.

Answer: D

NEW QUESTION 11
Consider the following SQL statement and the Orders relation shown in the exhibit:

What is the output of this SQL statement?

• A. [MISSING]
• B. [MISSING]
• C. [MISSING]
• D. [MISSING]

Answer: C

NEW QUESTION 12
Which subset of Structured Query Language (SQL) is used to limit access to a database or its data?

• A. Data Definition Language
• B. Data Control Language
• C. Data Entity Language
• D. Data Manipulation Language

Answer: B

NEW QUESTION 13
What is a relational database domain?

• A. A group of attributes
• B. A set of permissible tuple values
• C. A collection of related data items
• D. A set of permissible attribute values

Answer: D

NEW QUESTION 14
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

Answer: D

NEW QUESTION 15
The creation of intermediate entities occurs during the logical database design phase for an enterprise. It is used to resolve which types of relationships?

• A. One-to-many, complex, and recursive
• B. Complex, recursive, and many-to-many
• C. Redundant, recursive, and many-to-many
• D. One-to-many and one-to-one

Answer: B

NEW QUESTION 16
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 CHECKON 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 CHECKON 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 CHECKON UPDATE CASCADE);

Answer: C

NEW QUESTION 17
Consider the following relation definition:
STUDENT(
Student_Number: integer NOT NULL
Name: variable length character string length 20 NOT NULL) Primary Key Student_Number
HOUSING(
Housing_ID: integer NOT NULL Student_Number: integer NOT NULL
Building: variable length character string length 25 NOT NULL) Primary Key Housing_ID
Foreign Key Student_Number References STUDENT(Student_Number)
ON DELETE NO CHECK ON UPDATE
Which integrity constraint is violated in this relation definition?

• A. Entity integrity
• B. Domain constraint
• C. Referential integrity
• D. Enterprise constraint

Answer: C

NEW QUESTION 18
Consider the relation shown in the exhibit. Which of the following SQL statements would properly add information for a new employee?

• A. Mastered
• B. Not Mastered

Answer: A

NEW QUESTION 19
......