Summer Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exc65

examout.co

You enterprise must decide whether to use a database management system. Which of the following lists four advantages of using a DBMS?

A.

Management of data redundancy, increased data integrity, increased data dependence, and increased application program flexibility.

B.

Consistency of data, adherence to standards, managed concurrency, and increased software complexity.

C.

Increased data access, increased data backup and recovery, data sharing, and consistency of data.

D.

Increased datasecurity, increased data integrity, increased data independence, and decreased data separation.

Which term describes the management of simultaneous transactions to prevent conflicts?

A.

Parallelism

B.

Serialization

C.

Database control

D.

Concurrency control

A relation for a construction company is shown in the exhibit. Which of the following best defines the relationship between Cust_ID and Cust_Name?

A.

Cust_Name is the determinant.

B.

Cust_Name is transitively dependent on Cust_ID.

C.

Cust_ID is transitively dependent on Cust_Name.

D.

Cust_Name is functionally dependent on Cust_ID.

Consider the relational database shown in the exhibit.

What is the foreign key in this database?

A.

Employee. Dept_ID

B.

Dept_Mngr

C.

Dept_Name

D.

Department. Dept_ID

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 any child key references a parent key, the record containing the parent key cannot be deleted.

C.

If a parent key is deleted,all child keys are automatically set to a specified value.

D.

If a parent key is deleted, no test is made for referential integrity.

Which pair of relational algebraic operations requires union compatibility?

A.

Union and join

B.

Selection and projection

C.

Intersection and difference

D.

Cartesian product and intersection

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.

Option A

B.

Option B

C.

Option C

D.

Option D

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

What is the output of this SQL statement?

SELECT *

FROM Orders

WHERE NOT (Amount < 1000

AND Sales_Rep_No = 210);

A.

OptionA

B.

OptionB

C.

OptionC

D.

OptionD

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

A.

SELECT *FROM

Dept1_Parts

EXCEPT(SELECT

PartJD FROM

Dept2_Parts);

B.

SELECT * FROM

Dept1_Parts MINUS

(SELECT Part_ID

FROM Dept2_Parts);

C.

SELECT*FROM

Dept1_Parts

DIFFERENCE

(SELECT Part_ID

FROM Dept2_Parts);

D.

SELECT*FROM

Dept1_Parts WHERE

Part_ID NOT IN

(SELECT Part_ID FROM

Dept2_Parts);

Consider the following relation definitions:

STUDENT(

Student_Number: integer NOT NULL

Name: variable length character string length 20)

Primary Key Student_Number

HOUSING(

Housing_ID: integer NOT NULL

Student_Number: integer NOT NULL

Building: variable length character string length 25)

Primary Key Housing_ID

Foreign Key Student_Number References STUDENT(Student_Number)

ON DELETE NO ACTION

ON UPDATE CASCADE

What are the referential constraints for the relations defined in these relation definitions?

A.

There is no relationship between changes in STUDENT(Student_Number) and HOUSING(Student_Number).

B.

When STUDENT(Student_Number) is changed or deleted, this modification or deletion will automatically be reflected in HOUSING(Student_Number).

C.

Modifications to HOUSING(Student_Number) are automatically reflected in changes to STUDENT(Student_Number), but deletions are not permitted.

D.

Modifications to STUDENT(Student_Number) are automatically reflected in changes to HOUSING(Student_Number). For a deletion to occur fromSTUDENT(Student_Number), it must first occur in HOUSING(Student_Number).