Online Access Free 1D0-541 Exam Questions

To create a view, what are the minimal privileges that a user must have for the relations used to make the view?

• A.CREATE VIEW
• B.GRANT
• C.REVOKE
• D.SELECT

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

• A.A DBMS provides the ability to define, create and maintain databases while providing controlled access to databases.
• B.A DBMS provides the ability to maintain databases while providing increased security for the database.
• C.A DBMS provides the ability to control data access and limit the number of users at one time.
• D.A DBMS allows users to access the database while allowing the database administrator to define views particular to individual sets of users.

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

• A.4
• B.20
• C.25
• D.5

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.Redundant, recursive, and one-to-many
• B.Complex, recursive, and many-to-many
• C.One-to-many and recursive
• D.One-to-many and one-to-one

Which of the following best describes a composite key?

• A.A composite key is a primary 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 keys.
• C.A composite key is a primary or foreign key that consists of two or more attributes of a relation.
• D.A composite key is a foreign key that consists of the same attributes as the primary key from a related table.