Quiz (1-4)

Question 1

A DBMS is

Answer 1

A collection of software that creates and manages databases

Question 2

How can a database system solve the problems with traditional file processing system?

Answer 2

By separating a program from data.

Question 3

Which of the following is NOT true about “unstructured data” type?

Answer 3

Unstructured data is often stored in a table with rows and columns.

Question 4

A mid-managerial, highly technical position in charge of DB (database) resources best defines ______________.

Answer 4

Database administrator (DBA)

Question 5

Compared with the file processing system, a database system ____________.

Answer 5

Is more complex
Is more expensive

Answers 1 and 2

Question 6

The goal of DB conceptual design (modeling) is:

Answer 6

To define the information contents to be included in a database

Question 7

The DBMS function that handles data backup and data recovery best defines:

Answer 7

Data administration

Question 8

A DB designer is concerned with _______________ during the physical DB deign phase.

Answer 8

DB efficiency (performance)

Question 9

We discussed differences between data and information. Which of the following provides an example of “DATA”?

Answer 9

An employee’s hire date

Question 10

With DBMS, you can do ___________.

Answer 10

• Data definition
• Data manipulation
• Data administration (control)

Answer - All of the above

Question 11

What is the “cardinality” of the relationship between the following two entities?

Answer 11

One-to-One

Question 12

In ER Modeling, a bubble (circle) is used to represent ________________.

Answer 12

Optional situation

Question 13

An attribute that has more than one values at any given time, best defines a(an) _______________.

Answer 13

Multi-valued attribute

Question 14

Name and Address of EMPLOYEE are examples of a(an) ___________.

Answer 14

Attribute

Question 15

In a Video Rental System, VIDEO, RENTAL, and EMPLOYEE are examples of a(n):

Answer 15

Entity

Question 16

What is the output of the conceptual design (modeling)?

Answer 16

ER model

Question 17

In ER modeling,

Answer 17

An entity must be uniquely identified

Question 18

In a payroll system, Gross Pay is calculated by multiplying Number of Hours Worked and Hourly Wage. The Gross Pay is an example of:

Answer 18

Derived attribute

Question 19

Which of the following provides an example of a composite attribute?

Answer 19

Address (e.g., 13 “A” street, Little Rock, AR)

Question 20

Which of the following is a true statement about ERM (Entity Relationship Model)?

Answer 20

Its purpose is to define the information contents to be included in the target Database

Question 21

The goal of the logical modeling is to specify the ____________ of the database.

Answer 21

structure

Question 22

An input to the relational modeling is a(n) _____________?

Answer 22

Entity-Relationship model

Question 23

Which of the following is NOT an option for enforcing “referential integrity constraint” in the relational model?

Answer 23

Assertion

Question 24

In the relational model, which of the following is a possible answer for a cardinality?

Answer 24

Ten (10)

Question 25

Which of the following is a true statement about the relational model?

Answer 25

1. SQL is a data manipulation language for the relational model.
2. Data integrity constraints make sure that a database does not give false information about the data it stores
3. “Relation” is a single data structure in the relational model.

Answer - 1, 2, and 3

Question 26

In the ORDER table, there is an order with the OrderDate of 2/1/2020 and ShippingDate of 1/1/2020. This must be an error. The shippingDate cannot be earlier than the order date. Which data integrity constraint can catch this error?

Answer 26

Semantic integrity constraint

Question 27

In the EMPLOYEE table, a primary key (i.e., EmpID) value for John is missing. Which data integrity constraint catch the error?

Answer 27

Entity integrity constraint

Question 28

An attribute that is common in two tables and used for linking the tables best defines a ________________.

Answer 28

Foreign key

Question 29

In the general business applications, _________ is acceptable.

Answer 29

3 NF

Question 30

When you add a row, you’ll have to enter null for PK. This is an example of __________ anomaly

Answer 30

Insertion

Question 31

The normalization is the process of _____________.

Answer 31

Breaking a table into smaller and well structured tables

Question 32

If a table’s non-key attribute functionally determines other non-key attribute, the table has ____________.

Answer 32

Transitive (functional) dependency

Question 33

_______ normal form has __________ integrity than __________ normal form.

Answer 33

Higher, higher, lower

Question 34

If a table has only one multi-valued attribute, _______________________.

Answer 34

It is not even in the 1 NF

Question 35

A highly normalized table (e.g., a table in BCNF) ______________.

Answer 35

Has a minimal update anomaly