Question 1

The general goal of normalization is to construct tables such that every table has at least two topics or themes.

Accepted Answer

A) True 
 B)False

Question 2

Brenda wants to find a particular report containing sales analysis of the second and third quarter.After accessing the DBMS,she should type in the keyword into a ________ form to locate what she is looking for.

Accepted Answer

A) report 
B) file 
C) data 
D) query

Question 3

SQL is used to create databases and database structures.

Accepted Answer

A) True 
 B)False

Question 4

A byte is a ________.

Accepted Answer

A) character of data 
B) file system 
C) primary memory system 
D) record of data

Question 5

A key is a field that identifies a unique column in a table.

Accepted Answer

A) True 
 B)False

Question 6

A database is a self-describing collection of integrated records.

Accepted Answer

A) True 
 B)False

Question 7

"Address" is an example of a customer entity in a database application.

Accepted Answer

A) True 
 B)False

Question 8

An important use of application programs is to ________.

Accepted Answer

A) control that computer's resources 
B) perform memory swapping to enhance the computer's performance 
C) generate data that describe data 
D) enable database processing over the Internet

Question 9

Users access databases through a(n)________.

Accepted Answer

A) operating system 
B) database application program 
C) relational database system 
D) relational report system

Question 10

Describe the elements of a data model.Provide examples.

Accepted Answer

The answer of Describe the elements of a data model.Provide...

Question 11

Registries are data that describe data.

Accepted Answer

A) True 
 B)False

Question 12

An N:M relationship can be interpreted to mean that a variable number,greater than one,is allowed on each side of the relationship.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following statements is true about entities?

Accepted Answer

A) Entity names are always plural. 
B) Entities always represent a logical construct or transaction. 
C) Entities have attributes that describe contents of the entity. 
D) An entity is something that the users want to track.

Question 14

SQL stands for ________.

Accepted Answer

A) Standard Query Language 
B) Standard Question Language 
C) Structured Question Language 
D) Structured Query Language

Question 15

A spreadsheet is used to store data with multiple themes.

Accepted Answer

A) True 
 B)False

Question 16

A hospital is using a software to analyze treatment regimen and recovery times.The software relates the dosages,regularity,and therapeutic procedures to the time taken by patients segmented across age- and illness-groups.This software is an example of a(n)________.

Accepted Answer

A) operating system 
B) application program 
C) data mine 
D) data network

Question 17

Explain the various relationships of entities in a database.

Accepted Answer

The answer of Explain the various relationships of entities in...

Question 18

"The tables are not normalized" means that the tables have irregular,not-normal data.

Accepted Answer

A) True 
 B)False

Question 19

The object-relationship (OR)technique is the most popular tool for creating a data model.

Accepted Answer

A) True 
 B)False

Question 20

An entity has a unique attribute which is known as the ________.

Accepted Answer

A) key attribute 
B) identifier 
C) foreign key 
D) index field

Exam 5: Database Processing

The general goal of normalization is to construct tables such that every table has at least two topics or themes.

Brenda wants to find a particular report containing sales analysis of the second and third quarter.After accessing the DBMS,she should type in the keyword into a ________ form to locate what she is looking for.

SQL is used to create databases and database structures.

A byte is a ________.

A key is a field that identifies a unique column in a table.

A database is a self-describing collection of integrated records.

"Address" is an example of a customer entity in a database application.

An important use of application programs is to ________.

Users access databases through a(n) ________.

Describe the elements of a data model.Provide examples.

Registries are data that describe data.

An N:M relationship can be interpreted to mean that a variable number,greater than one,is allowed on each side of the relationship.

Which of the following statements is true about entities?

SQL stands for ________.

A spreadsheet is used to store data with multiple themes.

A hospital is using a software to analyze treatment regimen and recovery times.The software relates the dosages,regularity,and therapeutic procedures to the time taken by patients segmented across age- and illness-groups.This software is an example of a(n) ________.

Explain the various relationships of entities in a database.

"The tables are not normalized" means that the tables have irregular,not-normal data.

The object-relationship (OR)technique is the most popular tool for creating a data model.

An entity has a unique attribute which is known as the ________.