1D0-541 Online Practice Questions and Answers

Which statement best describes a procedural data manipulation language command?

A. It contains a query language for retrieving data;

B. It can be used only to manipulate data through a SQL interface.

C. The user is not required to know how the underlying data structures are implemented.

D. It requires that the user know how the underlying data structures are implemented.

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

A. GRANT

B. REVOKE

C. SELECT

D. CREATE VIEW

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. A set of normalized relations

B. A reviewed entity-relationship (ER) model

C. An entity-relationship (ER) model with no redundant data

D. A set of denormalized relations

Consider the following relational algebraic expression:

Which of the following SQL statements is equivalent to this relational algebraic expression?

A. SELECT Sales_Rep_No(108) FROM Orders;

B. INSERT INTO Orders VALUES(Sales_Rep_No = 108) WHERE Sales_Rep_No = NULL;

C. SELECT * FROM Orders WHERE Sales_Rep_No = 108;

D. SELECT * FROM Orders WHERE Sales_Rep_No = 108;

Consider the entity-relationship (ER) diagram shown in the exhibit. Which type of relationship between the two entities is shown?

A. m:m

B. m:n

C. 11

D. 1n

Consider the Orders relation shown in the exhibit. Which of the following SQL statements would replace the value in the Sales_Rep_No column with 110 everywhere that Sales_Rep_No 108 is listed?

A. UPDATE Sales_Rep_No IN Orders SET(Sales_Rep_No = 110 WHERE Sales_Rep_No = 108);

B. UPDATE Orders SET Sales_Rep_No = 110 WHERE Sales_Rep_No = 108;

C. UPDATE Orders SET Sales_Rep_No = 110;

D. UPDATE Orders WHERE Sales_Rep_No = 108 SET Sales_Rep_No = 110;

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

A. A DBMS provides the ability to control data access using Data Manipulation Language.

B. A DBMS provides the ability to maintain databases while providing increased security for the database.

C. A DBMS allows users to access the database while allowing only the database administrator to define user views.

D. A DBMS provides the ability to define, create and maintain databases while providing controlled access to databases.

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.

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 from STUDENT(Student_Number), it must first occur in HOUSING(Student_Number).