Weekend Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

examout.co

Consider the table for an employee database shown in the exhibit. What is the degree of the table?

A.

25

B.

5

C.

4

D.

20

Which statement best describes a candidate key?

A.

It is the primary key for an entity.

B.

It uniquely identifies every instance of an entity.

C.

One or more keys are joined together to form a composite key.

D.

One or more keys may be used to form a primary key.

Which statement accurately describes a characteristic of attributes?

A.

The ordering of attributes in a table is significant.

B.

An attribute contains values from multiple domains.

C.

An attribute name can be used only once per table.

D.

An attribute name can be used only once in a relational database system with multiple tables.

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;

Which mechanism provides database users with controlled access to the database through the use of virtual tables?

A.

View

B.

Data dictionary

C.

Database control language

D.

Database management system

Consider the relation shown in the exhibit. Which of the following SQL statements would return a relation that excludes all customers with a Satisfaction_Rate of less than or equal to 80 unless the Sales_Office is located in Atlanta?

A.

SELECT * FROM Customers

WHERE Satisfaction_Rate > 80

OR Sales_Office = Atlanta

B.

SELECT * FROM Customers

WHERE Satisfaction_Rate <= 80

AND Sales_Office = Atlanta

C.

SELECT * FROM Customers

WHERE Satisfaction_Rate >= 80;

D.

SELECT * FROM Customers

WHERE Satisfaction_Rate >= 80

AND NOT Sales Office = Atlanta

A large enterprise uses a two-tier database architecture and runs complex database applications.

Which term best describes the client in this system?

A.

Fat client

B.

Enterprise client

C.

Thin client

D.

Terminal client