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

Answer: D

NEW QUESTION 2
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 3
Consider the following database information:
domain s_id: integer
domain grd: fixed length character string length 1
STUDENT_GRADE(
Student_Number: s_id NOT NULL Grade: grd )
Primary Key Student_Number
During which phase of the database design process would this information be developed?

• A. Logical
• B. Physical
• C. Conceptual
• D. Implementation

Answer: A

Explanation:

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

Answer: B

NEW QUESTION 5
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 6
Consider the Employee relation shown in the exhibit. A database manager wants to set up a view called Emp_Dept that allows users to find employees and their department ID numbers. Which SQL statement will accomplish this?

• A. CREATE VIEW Emp_DeptAS SELECT Last_Name, First_Name, Dept_ID FROM Employee;
• B. UPDATE VIEW Emp_Dept AS SELECT *FROM Employee;
• C. UPDATE VIEW Emp_DeptAS SELECT Last_Name, First_Name, Dept_ID FROM Employee;
• D. CREATE VIEW Emp_Dept AS SELECT *FROM Employee WHERE ID = 0001 AND ID = 0002 AND ID = 0003 AND ID = 0004;

Answer: A

NEW QUESTION 7
Which three pieces of information did E.F. Codd describe as necessary to retrieve a data value from a relational database?

• A. Mastered
• B. Not Mastered

Answer: A

NEW QUESTION 8
Which subset of Structured Query Language (SQL) is used to perform operations such as data retrieval or deletion on the data contained in a database?

• A. Data Control Language
• B. Data Definition Language
• C. Data Formatting Language
• D. Data Manipulation Language

Answer: D

Explanation:

NEW QUESTION 9
Which pair of relational algebraic operations requires union compatibility?

• A. Projection and Cartesian product
• B. Selection and projection
• C. Intersection and difference
• D. Cartesian product and intersection

Answer: C

NEW QUESTION 10
A foreign key maps to a:

• A. prime key.
• B. indirect key.
• C. parent key.
• D. composite key.

Answer: C

NEW QUESTION 11
Which term describes the rejoining of relations that have been decomposed?

• A. Normalization
• B. Denormalization
• C. Referential integrity
• D. Domain constraints

Answer: B

NEW QUESTION 12
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 13
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 14
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_NameFROM RegistrationWHERE Course_Code = 'A4343';

Answer: C

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

Answer: D

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

Answer: D

NEW QUESTION 17
Consider the relations shown in the exhibit. Due to restructuring, the sales department has been eliminated and the employees working in that department have been dismissed. All ID information is stored as integers. Which SQL statement would be used to return a relation with all information for the employees who have been dismissed?

• A. SELECT *FROM Employee;
• B. SELECT ID, Last_Name FROM Employee;WHERE ID = 0004;
• C. SELECT *FROM Employee WHERE Dept_ID = 022;
• D. SELECT *FROM Employee WHERE Dept_ID = 022;

Answer: C

NEW QUESTION 18
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 inHOUSING(Student_Number).
• C. Modifications to HOUSING(Student_Number) are automatically reflected in changes to STUDENT(Student_Number), but deletions are notpermitted.
• D. Modifications to STUDENT(Student_Number) are automatically reflected in changes to HOUSING(Student_Number). For a deletion to occurfrom STUDENT(Student_Number), it must first occur in HOUSING(Student_Number).

Answer: D

NEW QUESTION 19
What is the highest normal form of the relation(s) shown in the exhibit?

• A. Mastered
• B. Not Mastered

Answer: A

NEW QUESTION 20
......