NEW QUESTION 1
Consider the Information Engineering diagram in the exhibit showing a conceptual data model of the relations BUILDING and RESIDENT. What is the next step in refining the data model?

• A. Create intermediate entities.
• B. Create a logical data model.
• C. Resolve many-to-many relationahips.
• D. Identify and resolve complex relationships.

Answer: B

NEW QUESTION 2
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 OrdersWHERE Order_Date LIKE _02 ORDER BY Amount;
• B. SELECT (Order_Date, Amount) FROM OrdersWHERE Order_Date LIKE %02 ORDER BY Amount;
• C. SELECT *FROM OrdersWHERE Order_Date LIKE _02 ORDER BY Order_No;
• D. SELECT *FROM OrdersWHERE Order_Date LIKE %02 ORDER BY Amount;

Answer: D

NEW QUESTION 3
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 4
Your enterprise is creating a relation (shown in the exhibit) that tracks parts and suppliers. Which situation would occur if new supplier information were entered in the relation before any information about specific parts?

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

Answer: B

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

• A. Attribute, domain, and tuple
• B. Entity, relation name, and domain
• C. Table name, primary key, and entity
• D. Attribute, relation name, and primary key

Answer: D

NEW QUESTION 6
Which subset of Structured Query Language (SQL) is used to limit access to a database or its data?

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

Answer: B

NEW QUESTION 7
Consider the following SQL statement and the Orders relation shown in the exhibit:

What is the output of this SQL statement?

• A.
• B.
• C.
• D.

Answer: D

NEW QUESTION 8
Consider the Recreation relation in the exhibit. A data operation that changes one of the tuples for Student_ID 1003 must be performed. It is necessary to change one of the activities from swimming to tennis. The Student_ID and Activity attributes make up the primary key for the Recreation relation. All related information must be altered, as well. Which SQL statement or statements would best accomplish this?

• A. Mastered
• B. Not Mastered

Answer: A

NEW QUESTION 9
Consider the relations shown in the exhibit. Which of the following SQL statements would enter data from the Customers relation into the Atlanta_Customers relation?

• A. INSERT INTO Atlanta_Customers VALUES(SELECT *FROM Customer sWHERE Sales_Office = Atlanta);
• B. INSERT INTO Atlanta_Customers SELECT *FROM CustomersWHERE Sales_Office = Atlanta;
• C. INSERT INTO Atlanta_CustomersSELECT Cust_No, Cust_Name, Satisfaction_Rate, Sales_Rep_No FROM CustomersWHERE Sales_Office = Atlanta;
• D. INSERT INTO Atlanta_CustomersSELECT Cust_No, Cust_Name, Sales_Office, Sales_Rep_No FROM CustomersWHERE Sales_Office = Atlanta;

Answer: C

Explanation:

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

• A. Mastered
• B. Not Mastered

Answer: A

NEW QUESTION 11
Consider the relational database shown in the exhibit. What is the foreign key in this database?

• A. Employee.Dept_ID
• B. Dept_Mngr
• C. Dept_Name
• D. Department.Dept_ID

Answer: A

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

Answer: D

NEW QUESTION 13
A theta-join can be viewed as:

• A. the intersection of two relations.
• B. a Cartesian product of two relations.
• C. a restricted Cartesian product of two relations.
• D. the Cartesian product of two union-compatible relations.

Answer: C

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

• A. Mastered
• B. Not Mastered

Answer: A

NEW QUESTION 15
Which type of entity must reference another entity for its data to be meaningful?

• A. Weak
• B. Strong
• C. Foreign
• D. Primary

Answer: A

NEW QUESTION 16
The database manager wants to give Rubio and Doe the ability to modify the Project Relation shown in the exhibit. A temporary employee named Temp needs to access the data in the database to generate reports. Which group of SQL statements will perform this task?

• A. Mastered
• B. Not Mastered

Answer: A

NEW QUESTION 17
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 18
What is the most important service provided by a database management system?

• A. Provides support for a data manipulation language
• B. Allows users to store data in a distributed data repository
• C. Provides support for data formatting language commands
• D. Translates procedural commands into non-procedural commands

Answer: A

NEW QUESTION 19
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 20
......