1D0-541 Online Practice Questions and Answers

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 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

The exhibit shows a table called Recreation Relation that relates a unique student identification number and a sports activity with a fee for participating in that activity. The Student_ID and Activity columns in the table are used together as a composite key. Which statement about the relation is correct?

A. Activity_Fee is a determinant of Activity.

B. Activity_Fee is partially dependent on the primary key.

C. The table contains a transitive dependency.

D. Activity_Fee is a determinant of Activity and Student_ID.

Consider the following relations shown in the exhibit. Which of the following SQL statements would return the Customers2 relation from the Customers relation?

A. SELECT * FROM Customers WHERE Satisfaction_Rate <= 80 OR Satisfaction_Rate >= 90;

B. SELECT * FROM Customers WHERE Satisfaction_Rate IN (80 AND 90);

C. SELECT * FROM Customers WHERE Satisfaction_Rate >= 80 AND Satisfaction_Rate <= 89;

D. SELECT * FROM Customers WHERE Satisfaction_Rate BETWEEN (80, 90);

What is the most important service provided by a database management system?

A. Provides support for a data manipulation language

B. Allows users to store data in a distributed data repository

C. Provides support for data formatting language commands

D. Translates procedural commands into non-procedural commands

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

A theta-join can be viewed as:

A. the intersection of two relations.

B. a Cartesian product of two relations.

C. a restricted Cartesian product of two relations.

D. the Cartesian product of two union-compatible relations.

Consider the following four database design activities:

1 - Design user views.

2 - Select a DBMS.

3 - Apply normalization.

4 - Determine entities.

Which choice shows the correct ordering of these activities, from first to last, by assigned numbers?

A. 1, 2, 3, 4

B. 3, 4, 1, 2

C. 4, 1, 3, 2

D. 4, 2, 3, 1

The exhibit shows a table called Student Relation that tracks all information related to a students courses, professors and sites. What would be the consequence of removing all records for a student with the ID 1311?

A. Only an update anomaly would occur.

B. An insertion anomaly would occur.

C. A deletion anomaly would occur.

D. An update anomaly and a deletion anomaly would occur.

Which characteristic is an advantage of a database management system?

A. Data files are owned and maintained by the users.

B. Database administration is simplified.

C. A standard method can be used to access the database.

D. Data is decentralized.