1. Which of the following is a characteristic of databases?
A) Many users can use the same database at the same time
B) Different database entities can be connected to provide more information
C) Relevant business data are stored in a database
D) All of the above
2. A(n) ____ enables a database administrator to define schema components.
A) extensible markup language (XML)
B) data definition language (DDL)
C) unified modeling language (UML)
D) query language
3. Advantages of a DBMS are:
A) Improved data sharing and data security
B) Better data integration
C) Minimized data inconsistency and increase end-user productivity
D) Improved data access and decision making
E) All of the above
4. In a relational table the order of the rows and columns are immaterial to the DBMS
True
False
Use the following to answer Questions 5-8
The following data are in the tables Employee (primary key: Empno) and Department (primary key: Deptno). The questions refer to row numbers of this table. The first row of each table is row #1. Empdeptno in table Employee is a foreign key that refers to Deptno in the table Department. Deptmgr in the table Department is a foreign key that refers to Empno in the table Employee.
Table Employee:
|
Empno
|
Empname
|
Empdeptno
|
Empsalary
|
Emptitle
|
|
555
|
Kearny
|
200
|
7000
|
Manager
|
|
666
|
Williams
|
100
|
8000
|
Manager
|
|
777
|
Haberle
|
200
|
5000
|
Clerk
|
|
888
|
Haberle
|
200
|
5000
|
Clerk
|
|
|
Johnson
|
300
|
4000
|
Analyst
|
|
889
|
Dupont
|
400
|
|
|
|
|
McCabe
|
400
|
6000
|
Programmer
|
|
999
|
Lopez
|
|
9000
|
Manager
|
Table Department:
|
Deptno
|
Deptname
|
Deptcity
|
Deptmgr
|
|
100
|
Logistic
|
Wichita
|
666
|
|
200
|
Finance
|
Boise
|
555
|
|
300
|
Marketing
|
Pierre
|
666
|
5. Which of the following statements is true?
A. Row #7 of table Employee violates neither the entity integrity rule nor the referential integrity rule.
B. Row #7 of table Employee violates the entity integrity rule.
C. Row #7 of table Employee violates the referential integrity rule.
D. Row #7 of table Employee violates both the entity integrity rule and the referential integrity rule.
6. An inner join only returns matched records from the tables that are being joined.
True
False
7. Which of the following columns of the table Department is a foreign key?
A. Deptno
B. Deptname
C. Deptcity
D. Deptmgr
8. The values shown in the table Department:
A. violate neither the entity integrity rule nor the referential integrity rule
B. violate the entity integrity rule
C. violate the referential integrity rule
D. violates both the entity integrity rule and the referential integrity rule
9. In the relational model, ____ are important because they are used to ensure that each row in a table is uniquely identifiable.
A) Relations
B) Indexes
C) Keys
D) Logical structures
10. Entity Supertype Contains unique characteristics of each entity subtype
True
False
11. The ____ is not supported directly in the relational environment.
A) M:N
B) 1:M
C) M:1
D) 1:1
12. A ____ occurs when you have one entity in two 1:M relationships to other entities, thus producing an association among the other entities that is not expressed in the model.
A) Surrogate primary keys
B) time-variant data
C) Design trap
D) Fan trap
Use the following to answer questions 13- 14:
A database table consists of the following columns: employee's name, SS#, job-title, hiring-date, years-in-job, base-salary. A bonus calculation program, a personnel promotion application program, and a payroll application program all use this table. To implement a policy change in personnel promotion, the following column is added to the table: highest-college-degree. This new column is not used by the payroll program or by the bonus calculation program.
13. The following application program will be modified to accommodate the change to the database table:
A) The bonus calculation program
B) The personnel promotion application program
C) The payroll application program
D) All of the above
14. The ability to add the new column without requiring changes to all of the application programs strongly relates to the following feature of modern database systems:
A) Nonprocedural programming
B) Transaction processing
C) Data independence
D) Data sharing
15. The following step occurs first in the process of building an ERD: ____.
A) Develop the initial ERD.
B) Identify the business rules based on the description of operations.
C) Identify the attributes and primary keys that adequately describe the entities.
D) Create a detailed narrative of the organization's description of operations.
16. Entity Relationship Diagrams are input to the following phase of Database Development:
A) Logical Database Design
B) Conceptual Data Modeling
C) Physical Database Design
D) Distributed Database Design
17. When the PK of one entity does not contain the PK of a related entity, the relationship is ____.
A) Weak
B) Strong
C) Neutral
D) Missing
18. In Crow's Foot notation, the symbol
Denotes one or many; the "many" side is optional
True
False
19. The three stage process in natural joins are:
A) Product, Union, Project
B) Product, Select, Intersect
C) Product, Select, Project
20. Composite attribute can be subdivided
True
False
21. In a supertype subtype relationship
A) Subtype entities inherit attributes and relationships of supertype
B) All entity subtypes inherit their primary key attribute from their supertype
C) Entity subtypes inherit all relationships in which supertype entity participates
D) All of the above.
22. Characteristics of Primary Key include:
a. Must have unique values and should be intelligent
b. Should be nonintelligent and not change over time
c. Must not change over time and composed of several attribute
23. Third Normal Form is often as high as needed in normalization
True
False
24. Entities corresponds to table and not to row in relational environment
True
False
25. The ________________ key is an attribute or a combination of attributes in one table whose values must either match the primary key in another table or be be null
A) Super Key
B) Candidate Key
C) Primary Key
D) Foreign Key
E) Secondary Key