1D0-541 Online Practice Questions and Answers

Your company must choose which type of database to use for a new project. Which of the following lists three characteristics of file-based database systems?

A. Repetition of data, application program flexibility, and data centralization

B. Incompatibility of files, tabular data structures, and data dependence

C. Separation of data, repetition of data, and data independence

D. Application program inflexibility, data dependence, and separation of data

Which database security technique prevents invalid data from being entered into the database?

A. File locking

B. User authorization

C. Parity checks

D. Integrity controls

Your database administrator has disallowed a group of users from making alterations to the Employees table in your corporate database. The users, known as Group_2, previously had full privileges with the Employees table. Which of the following SQL statements properly removes any alteration privileges from Group_2?

A. REVOKE INSERT, UPDATE, DELETE ON Employees FROM Group_2;

B. REVOKE UPDATE FOR Employees FROM Group_2;

C. REVOKE INSERT, UPDATE, DELETE ON Employees TO Group_2;

D. REVOKE UPDATE, DELETE FOR Employees FROM Group_2;

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

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

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 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 Registration relation shown in the exhibit. Which of the following SQL statements would return all tuples that have course codes beginning with the letter M?

A. SELECT * FROM Registration WHERE Course_Code = M#;

B. SELECT * FROM Registration WHERE Course_Code LIKE M_;

C. SELECT * FROM Registration WHERE Course_Code LIKE M%;

D. SELECT * FROM Registration WHERE Course_Code = M%;

Which of the following best describes the information contained in the data dictionary (or system catalog)?

A. Metadata

B. Data model

C. Table data

D. Metafile

Which term describes an attribute or combination of attributes that uniquely identifies a row in a relation?

A. Entity

B. Domain

C. Primary key

D. Attribute group