Deck 4: Database Processing

Question 1

SQL can be used to create databases and database structures.

Answer 1

True

Question 2

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

Answer 2

True

Question 3

One of the development tasks of the database administrator is to develop a system to record and manage resolution of problems.

Answer 3

False

Question 4

In a relational database, every table must have a key.

Question 5

Access and SQL Server are examples of DBMS products.

Question 6

A DBMS is a software program; a database is a collection of tables of data, relationships, and metadata.

Question 7

The format of metadata is consistent across all software products used to process databases.

Question 8

The database management system is a program used to create, process, and administer a database.

Question 9

Database management systems are mostly developed by the organizations that use them.

Question 10

To determine processing rights/restrictions on each table and column is an important operational task of the database administrator.

Question 11

Database developers use the DBMS to create tables, relationships, and other structures in the database.

Question 12

In a database, records refer to the data in columns.

Question 13

Metadata are data that describe data.

Question 14

If the structure of a list is complex, it is better to use a spreadsheet than a database.

Question 15

Relationships between tables in a relational database are accomplished by associating a foreign key in one table with a key field in another.

Question 16

A group of similar rows or records is called a field.

Question 17

Adaptation tasks for a database refer to backup and recovery processes.

Question 18

Structured Query Language is an international standard language for processing a database.

Question 19

One of the functions of a DBMS is to provide tools to assist in the administration of the database.

Question 20

A database is called self-describing because it reduces data duplication.

Question 21

User requirements from a database are summarized in a data model.

Question 22

The lost update problem can be solved by locking, which allows coordination of user activities.

Question 23

Normalization is the process of converting a poorly structured table into two or more well-structured tables.

Question 24

Both the E-R data model and UML are tools used for constructing data models.

Question 25

Enterprise DBMS products process large organizational and workgroup databases.

Question 26

All entity relationships are represented using crow's foot diagrams.

Question 27

Application programs do not allow database processing over the Internet.

Question 28

A database application is a collection of forms, reports, queries, and application programs that use the DBMS to process a database.

Question 29

A single database can have only one application and user.

Question 30

Unified Modeling Language (UML)is the most commonly used tool for data modeling.

Question 31

An identifier is an attribute (or group of attributes)whose value is associated with one and only one entity instance.

Question 32

An entity is something that the users want to track, and attributes are those that describe their characteristics.

Question 33

Access is both a DBMS and an application development product.

Question 34

Pure database data are valuable, but they are not pertinent or useful in raw form.

Question 35

In a data model, entities always represent physical objects.

Question 36

Attributes describe the characteristics of an entity.

Question 37

When there are same number of entities on each side of the relationship, an N:M relationship can be referred to as an N:N relationship.

Question 38

A single-user database cannot be converted to a multi-user database.

Question 39

The crow's-foot notation can show the maximum cardinality involved in a relationship.

Question 40

Before building a database, developers construct a logical representation of its data called a data model.

Question 41

The database design team transforms entities into tables and expresses relationships by defining foreign keys.

Question 42

In a relational database, every table must have a ________.

A) client
B) field
C) key
D) query

Question 43

A database is considered self-describing because ________.

A) all the users' data are in one place
B) it contains data about the data
C) it contains a listing of all the programs that use it
D) it does not allow data duplication

Question 44

A foreign key must be added to at least one of the tables when using the relational model.

Question 45

Normalization is the only criterion for evaluating database designs.

Question 46

Databases that are organized in the form of tables and represent interconnections using foreign keys are called ________.

A) object databases
B) network databases
C) relational databases
D) hierarchical databases

Question 47

A(n)________ is a self-describing collection of integrated records.

A) identifier
B) key
C) entity
D) database

Question 48

A ________ is a column or group of columns that identifies a unique row in a table.

A) query
B) record
C) form
D) key

Question 49

In a database, a ________ refers to a character of data.

A) byte
B) form
C) query
D) key

Question 50

Bytes are grouped into columns, which are also called ________.

A) rows
B) fields
C) files
D) bits

Question 51

The easiest time to change the database structure is during the data modeling stage.

Question 52

Which of the following is a license-free, open-source database management system?

A) DB2
B) Microsoft Access
C) MySQL
D) Oracle Database

Question 53

A data integrity problem is created due to inconsistent data in the database.

Question 54

In a database, rows are also known as ________.

A) fields
B) bytes
C) forms
D) records

Question 55

Database administrators are the final judges as to what data the database should contain and how the records in that database should be related to one another.

Question 56

Normalized tables cannot eliminate data duplication, but they can be faster to process.

Question 57

A ________ is a program used to create, process, and administer a database.

A) distributed data store
B) database model
C) database transaction
D) database management system

Question 58

Surrogate keys are unique identifiers assigned by the DBMS.

Question 59

The general goal of normalization is to construct tables such that every table has a single topic or theme.

Question 60

The data integrity problem occurs only if data are duplicated.

Question 61

A multi-user data base must implement ________ to prevent a lost update problem.

A) encryption
B) locking
C) decryption
D) anti-virus software

Question 62

Joanna wants to find a particular report containing the sales analyses of the company for the second and third quarters of the year. After accessing the DBMS, she should type in the keyword into a ________ to locate what she is looking for.

A) surrogate key
B) foreign key
C) query form
D) data model

Question 63

Which of the following database administration tasks is associated with database operation?

A) evaluating application design
B) forming a steering committee
C) tracking and resolving problems
D) conducting training

Question 64

Which of the following database administration tasks is associated with database backup and recovery?

A) managing security and ensuring that security system works
B) conducting training for users and operations personnel on various procedures
C) developing a system to record and prioritize requests for change
D) ensuring that all appropriate user input is considered when designing a database

Question 65

________ is an international standard language for processing a database and is supported by all major DBMS products.

A) D4
B) SQL
C) MXML
D) DB2

Question 66

Enterprise DBMS products ________.

A) support a maximum of two users
B) process large organizational and workgroup databases
C) support only a single database application
D) support only personal or workgroup applications

Question 67

Which of the following is a popular DBMS product from Microsoft?

A) PowerPoint
B) Outlook
C) Silverlight
D) Access

Question 68

Qtopia Inc. needs a database system which can support approximately 20 trillion bytes of data and 5000 users within the organization. Which of the following DBMS products would be appropriate?

A) Paradox
B) FoxPro
C) Access
D) SQL Server

Question 69

In which of the following cases would the user(s)use a personal rather than an enterprise DBMS?

A) A startup company needs a database that can accommodate its 150 employees and be expanded to include more users.
B) A professor needs to maintain a database of his students' attendance and marks for the term.
C) Gensys needs a DBMS that is accessible across its locations around the world.
D) A university needs a database that can be accessed by students from all its departments.

Question 70

Which of the following database administration tasks is associated with database development?

A) monitoring database performance
B) monitoring backup procedures
C) managing configuration change
D) validating the data model

Question 71

A ________ is a collection of forms, reports, queries, and application programs that use the DBMS to process a database.

A) foreign key
B) surrogate key
C) database application
D) data model

Question 72

The lost update problem occurs when ________.

A) multiple users make changes to a database
B) a single row holds multiple values
C) a user uses a personal rather than an enterprise database
D) a multi-user database is converted to a single-user database

Question 73

A ________ is a software program; while a ________ is a collection of tables of data, relationships, and metadata.

A) database; DBMS
B) DBMS; database
C) spreadsheet; DBMS
D) database; spreadsheet

Question 74

An important use of database application programs is to ________.

A) control a particular computer's resources
B) enhance the computer's performance
C) generate data that describe data
D) enable database processing over the Internet

Question 75

Before building a database, a developer must construct a logical representation of the database called a(n)________.

A) flowchart
B) data model
C) algorithm
D) data flow diagram

Question 76

Which of the following is true of database application programs?

A) They cannot enable database processing over the Internet.
B) They are less effective than forms for non-standard functions.
C) They allow modification, but not deletion, of database data.
D) They process logic that is specific to a given business need.

Question 77

Reports are used to ________.

A) read, insert, modify, and delete data
B) create and administer a database
C) show data in a structured context
D) minimize the use of SQL in a database

Question 78

Which of the following is a database adaptation task?

A) monitoring database performance
B) managing configuration change
C) monitoring backup procedures
D) tracking problems and managing resolution

Question 79

Which of the following statements about Structured Query Language is true?

A) SQL is a product-specific language used only with MySQL applications.
B) SQL is the industry standard language used in the U.S., but not elsewhere.
C) SQL is an international standard language for processing a database.
D) Major DBMS products do not accept and process SQL statements.

Question 80

Which of the following is a popular enterprise DBMS product?

A) Access
B) SQL Server
C) dBase
D) FoxPro