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.

In a relational database, which term describes a single table consisting of rows and columns?

A. Entity

B. Matrix

C. Relation

D. Data dictionary

Consider the entity-relationship (ER) diagram shown in the exhibit. What do the characters at the ends of the connecting line indicate?

A. Degree of a relation

B. Cardinality of a relation

C. Primary key of a relation

D. Determinant of a relation

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

B. 20

C. 4

D. 25

Consider the Orders relation shown in the exhibit. Which of the following SQL statements would return all complete tuples for order dates in 2002, arranged by amount from lowest to highest?

A. SELECT * FROM Orders WHERE Order_Date LIKE _02 ORDER BY Amount;

B. SELECT (Order_Date, Amount) FROM Orders WHERE Order_Date LIKE %02 ORDER BY Amount;

C. SELECT * FROM Orders WHERE Order_Date LIKE _02 ORDER BY Order_No;

D. SELECT * FROM Orders WHERE Order_Date LIKE %02 ORDER BY Amount;

The exhibit shows a relation for a companys projects. Which candidate key(s) would best serve as the primary key for this relation?

A. S_Date and E_Date

B. Proj_ID

C. Item_Num and E_Date

D. Proj_ID and Item_Num

For the Employee relation shown in the exhibit, which set of column values holds the complete tuple for the employee named James Smith?

A. 0002, James, Smith

B. 0002, James, Smith, 10-25-76

C. First_Name, James, Last_Name, Smith

D. Emp_ID, 0002, First_Name, James, Last_Name, Smith

Which process is used to prevent the current database operation from reading or writing a data item while that data item is being accessed by another operation?

A. Lock

B. Deadlock

C. Timestamp

D. Batch

Which of the following best describes a composite key?

A. A composite key is a primary key and foreign 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 key attributes.

C. A composite key is a foreign key that consists of the same attributes as the primary key from a related table.

D. A composite key is a primary or foreign key that consists of two or more attributes of a relation.

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. B. C. D.