NEW QUESTION 1
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

Answer: A

NEW QUESTION 2
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

Answer: D

NEW QUESTION 3
Consider the Stu_Act and Act_Fee tables shown in the exhibit. Which relational algebraic operation would yield the Activity Relation table in the exhibit?

• A. Union
• B. Intersection
• C. Natural join
• D. Cartesian product

Answer: C

NEW QUESTION 4
Consider the Dept1_Parts and Dept2_Parts relations shown in the exhibit. Which of the following SQL statements would create an intersection of the two relations with the widest variety of Structured Query Language dialects?

• A. Mastered
• B. Not Mastered

Answer: A

NEW QUESTION 5
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.

Answer: C

NEW QUESTION 6
A large enterprise uses a two-tier database architecture and runs complex database processing on the client. Which term best describes the client in this system?

• A. Fat client
• B. Thin client
• C. Terminal client
• D. Enterprise client

Answer: A

NEW QUESTION 7
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 CustomersWHERE Satisfaction_Rate <= 80 OR Satisfaction_Rate >= 90;
• B. SELECT *FROM CustomersWHERE Satisfaction_Rate IN (80 AND 90);
• C. SELECT *FROM CustomersWHERE Satisfaction_Rate >= 80 AND Satisfaction_Rate <= 89;
• D. SELECT *FROM Customers WHERE Satisfaction_Rate BETWEEN (80, 90);

Answer: C

NEW QUESTION 8
Which relational algebraic operation is used to select specific columns (attributes) from a relation?

• A. Mastered
• B. Not Mastered

Answer: A

NEW QUESTION 9
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.

Answer: B

NEW QUESTION 10
Which type of dependency occurs when one attribute of a composite primary key is removed and the dependency still exists?

• A. 1:1
• B. Transitive
• C. Functional
• D. Partial functional

Answer: D

Explanation:

NEW QUESTION 11
Your enterprise is developing a database system that will contain highly sensitive data. Security of the data will take priority over database processing speed. Which database protection technique should be employed?

• A. Backups
• B. User views
• C. Encryption
• D. Integrity controls

Answer: C

NEW QUESTION 12
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. REVOKEINSERT, UPDATE, DELETEON Employees FROM Group_2;
• B. REVOKE UPDATEFOR Employees FROM Group_2;
• C. REVOKEINSERT, UPDATE, DELETEON Employees TO Group_2;
• D. REVOKE UPDATE, DELETEFOR Employees FROM Group_2;

Answer: A

NEW QUESTION 13
Which mechanism provides database users with controlled access to the database through the use of virtual tables?

• A. View
• B. Data dictionary
• C. Database control language
• D. Database management system

Answer: A

NEW QUESTION 14
What is a virtual table?

• A. A virtual table is a relation created as the result of data manipulation, and is not a permanent part of the database.
• B. A virtual table is a relation stored in the databases memory; it is used when multiple users access the same relation in a database.
• C. A virtual table is a relation created from a defined base table; it contains metadata about the base relation.
• D. A virtual table is a relation that consists of primary and foreign keys for a particular set of relations in a database.

Answer: A

NEW QUESTION 15
Consider the Registration relation shown in the exhibit. Which of the following SQL statements would return the Registration2 relation from the Registration relation?

• A. SELECT Course_Code FROM Registration;
• B. SELECT *FROM RegistrationWHERE Registration_ID = 1003 AND Registration_ID = 1005;
• C. SELECT *FROM RegistrationWHERE Course_Code = 'A4343';
• D. SELECT Registration_ID, Student_ID, First_Name, Last_Name FROM RegistrationWHERE Course_Code = 'A4343';

Answer: C

NEW QUESTION 16
What is a candidate key?

• A. The primary key for an entity
• B. The key that identifies every instance of an entity
• C. Multiple primary keys that are joined together to form a composite key
• D. A key that may be used to form the primary key

Answer: D

NEW QUESTION 17
The exhibit shows a table called Activity Relation that relates a unique student identification number with a sports activity and a fee for participating in that activity. A student can participate in only one activity. The key for the relation is Student_ID. What consequence would occur if the tuple for Student_ID 1001 were removed?

• A. An update anomaly would occur.
• B. An insertion anomaly would occur.
• C. A deletion anomaly would occur.
• D. Both an insertion anomaly and a deletion anomaly would occur.

Answer: C

NEW QUESTION 18
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 RegistrationWHERE Course_Code = M#;
• B. SELECT *FROM RegistrationWHERE Course_Code LIKE M_;
• C. SELECT *FROM RegistrationWHERE Course_Code LIKE M%;
• D. SELECT *FROM RegistrationWHERE Course_Code = M%;

Answer: C

NEW QUESTION 19
......