Deck 1: Introduction to Database Management

Question 1

In most commercial DBMSs,collections of entities are stored in files.

Answer 1

False
Explanation: Collections of entities are stored in tables.

Question 2

SQL can be used to define tables and the relationships among them,but a graphical interface must be used to define integrity constraints and authorization rights.

Answer 2

False
Explanation: SQL can do all of these tasks.

Question 3

In the early DBMSs,there was not a very close connection between the database and the computer programs that accessed it,so as a result the database definition was separate from the computer programs that accessed the database.

Answer 3

False
Explanation: There was a close connection and the database definition was part of the computer programs that accessed the data.

Question 4

In transaction processing,inconsistency in the database is a concern of the user,not the DBMS processing the transaction.

Question 5

A procedural language interface is necessary because nonprocedural access and application development tools are sometimes not efficient enough or do not provide the level of control necessary for application development.

Question 6

Second generation DBMS systems are referred to as navigational because they do not require a programmer to write code to navigate among a network of linked records.

Question 7

Nonprocedural languages do not include looping statements because the user specifies what parts of the database to retrieve,not how retrieval occurs.

Question 8

The external level of the Three Schema Architecture allows for each group of users to have a separate view of a database tailored to that group's specific needs.

Question 9

Data is said to be persistent when it resides on stable storage and is never removed or archived for the life of the business.

Question 10

In the evolution of database technology,second-generation products were the first true DBMSs because they could manage multiple entity types and relationships.

Question 11

To be considered a true DBMS,a database product should be able to obtain access to data without writing a specialized computer program.

Question 12

Data is said to be interrelated when all of the data is stored in the same database and multiple users can access it at the same time.

Question 13

File processing systems can manage only one entity.

Question 14

Database technology is vital to the functioning of modern organizations and dramatically affects most people's lives in many ways.

Question 15

In the Three Schema Architecture,both the external and internal schemas represent the entire database.

Question 16

Over the years,DBMSs have evolved to the point where they are fairly simple to learn and administer.

Question 17

The Three Schema Architecture proposes that there are three levels of database description: internal,external and physical.

Question 18

A database is said to be shared when multiple users can access the same database for multiple uses,but must take turns accessing the database.

Question 19

COBOL and Visual Basic are both examples of a nonprocedural language.

Question 20

The retrieval of summarized data to support long-range decisions is a dominant feature of data warehousing,whereas a mixture of updating and retrieving data is characteristic of databases that support the day to day operations of an organization.

Question 21

A Database is:

A) The collection of disks containing the business data
B) A collection of data
C) A collection of business applications used by the managers
D) A collection of software components that supports data retrieval and processing

Question 22

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

Question 23

Which one of the following is true of a procedural language interface to a database?

A) It is faster to develop by a ratio of 10 than a nonprocedural interface
B) It is faster to develop by a ratio of 100 than a nonprocedural interface
C) It provides more processing capabilities than a nonprocedural interface
D) It is usually developed with the sole use of a language such as SQL

Question 24

Which one of the following is not a nonprocedural access to data in a database?

A) The user types and executes a SQL query
B) The user writes and executes a Cobol program
C) The bank teller types the name of a customer into a form to retrieve this customer's bank account
D) The sales manager executes a report showing a salesperson's sales for the current week

Question 25

Which one of the following does not apply to a database?

A) The data in a database are usually available to all Internet users
B) The data in a database are persistent
C) The data in a database are shared among authorized users
D) The data in a database are interrelated

Question 26

Which of the following is not a characteristic nor a feature of databases?

A) Many users can use the same database at the same time
B) Relationships provide information connecting different entities
C) Only one user at a time can access data from the database
D) Access to data is facilitated by nonprocedural access

Question 27

Which of the following orientation features does not qualify a system as using true database technology?

A) Relational
B) Object
C) Network navigation
D) File orientation

Question 28

The goal of information resource management is to use information technology as a tool for processing,distributing,and integrating information for isolated functions within an organization.

Question 29

Per the author,with the growing importance of the internet and network computing,transaction processing is becoming a crucial function of DBMSs.

Question 30

Since the database administrator has technical responsibilities such as designing and tuning databases,which requires extensive training and expertise,they typically occupy a higher level in the organization than the data administrator.

Question 31

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

Question 32

Which one of the following is not included in the definition of a database?

A) Description of magnetic disks storing the data
B) Entities
C) Relationships
D) Integrity constraints

Question 33

Which one of the following is a feature provided by large DBMS?

A) Transaction processing
B) Procedural Language Interface
C) Database tuning
D) All of the above

Question 34

A Database Management System is:

A) The collection of disks containing the business data
B) A collection of data
C) A collection of business applications used by the managers
D) A collection of software components that supports data retrieval and processing

Question 35

Persistency of business data refers to which of the following?

A) Business data are kept in the computer main memory
B) Business data are saved on stable storage such as magnetic disks for the life of the business
C) Business data are saved on stable storage such as magnetic disks for as long as it is needed by the business
D) Once the business data has been saved, its values never change

Question 36

The data administrator has primarily a planning role because they view the information resources in a broad context and must consider all kinds of data.

Question 37

Which of the following assertions is not true about DBMS market domination?

A) Oracle dominates the Unix environment
B) DB2 dominates the IBM mainframe environment
C) Open source DBMS products have begun to challenge the commercial DBMS products at the high end of the enterprise DBMS market.
D) Microsoft Access dominates the desktop environment

Question 38

Which one of the following languages is not a procedural language?

A) SQL
B) Oracle PL/SQL
C) Microsoft Access VBA
D) Microsoft SQL Server Transact-SQL

Question 39

Which one of the following is the least likely to be viewed as a transaction?

A) Retrieving an employee hiring date
B) Transferring $1000 from a customer's savings account to the customer's checking account
C) Reserving a seat on a train
D) Reserving a hotel room

Question 40

The schema mapping between the conceptual and internal levels shows how entities are stored in files.

Question 41

____________________ is an industry standard language that can be used for database definition and manipulation.

Question 42

_____________________ are used to indicate connections among tables.

Question 43

Tools included in DBMSs that are used to monitor and improve database performance are called ____________________ tools.

Question 44

On a typical client/server architecture system that consists of one server and three clients:

A) The database resides on the server
B) The database resides on one client
C) The database resides on all clients
D) The database resides on all clients and the server

Question 45

___________________ ,which allows users with limited computing skills to submit queries to a database,can provide reduced software development costs and increased software productivity.

Question 46

Which database user is the most capable to make an unplanned use of a database?

A) Indirect user
B) Parametric user
C) Power user
D) Either an indirect user or a parametric user

Question 47

In a client/server architecture the client software typically not responsible for:

A) accepting user input
B) displaying results
C) locating remote databases
D) all of the above

Question 48

The database characteristic of ______________ means that data is stored on a stable medium as long as it is relevant to a business purpose.

Question 49

Who is in charge of controlling information resources in an enterprise?

A) The data administrator
B) The database administrator
C) Analyst/programmers
D) Power users

Question 50

A(n)_______________ is a named,two-dimensional arrangement of data consisting of a heading part and a body part.

Question 51

A(n)______________ is a cluster of data usually about a single topic that can be accessed together.

Question 52

Database administrators:

A) Have technical responsibilities
B) Have non technical responsibilities
C) Participate in database design
D) All of the above

Question 53

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

Question 54

Which one is not a typical position of the data administrator in an organization?

A) Just below the MIS director
B) At a lower level than the database administrator
C) At the same level as the MIS director
D) At a higher level than the database administration

Question 55

When a database can be used by multiple users at one time,the database is said to be ______________.

Question 56

Which of the following is not a level of the three-schema architecture?

A) Procedural
B) External
C) Internal
D) Conceptual

Question 57

When data stored as separate units can be connected to form useful information for decision making,that data is ________________.

Question 58

The three-schema architecture is strongly related to the following feature of database systems:

A) Transaction processing
B) Data independence
C) Nonprocedural access
D) Data sharing

Question 59

A DBMS provides software that can execute:

A) On the client
B) On the server
C) On both the client and the server
D) None of the above

Question 60

In addition to application development tools,most DBMSs provide a(n)_________________________,which is a method to combine a nonprocedural language with a programming language.

Question 61

In a typical organization,a(n)______________________ is a support position that specializes in managing DBMSs.

Question 62

In the Three Schema Architecture model,the ____________ schema defines the entities and the relationships among them.

Question 63

A(n)________________ is a unit of work that should be processed reliably without interference from other users and without loss of data.

Question 64

An arrangement of components and data among computers connected by a network is known as a(n)__________________ architecture.

Question 65

A crucial function of DBMSs,______________________ allows geographically dispersed computers to cooperate when providing data access.

Question 66

In a passive interaction with a database,a(n)______________ user is given a report or some other data extracted from a database.

Question 67

Databases that run on powerful servers and are often critical to the functioning of an organization are known as ________________ DBMSs.

Question 68

___________________ is the reliable and efficient processing of large volumes of repetitive work.

Question 69

A recent development in fourth-generation DBMSs is the _______________________,which is a database that supports mid-range and long-range decision making in organizations with the retrieval of summarized data.

Question 70

Many organizations now have a(n)_____________________ ,which is a management position responsible for planning the development of new databases.

Question 71

When interacting with a database,a(n)________________ user requests existing forms and reports using input values that change from usage to usage.

Question 72

____________________ is the concept that a database should have an identity separate from the applications that use it.

Question 73

In the Three Schema Architecture,the internal schema represents the storage view of the database whereas the ______________ schema represents the logical meaning of the database.

Question 74

In the evolution of database technology,third-generation systems are known as ______________ DBMSs because their foundation is based on mathematical relations and associated operators.

Question 75

The goal of _______________________ is to use information technology as a tool for processing,distributing,and integrating information throughout an organization.

Question 76

With regards to the Three Schema Architecture,the _____________________ provides the knowledge to convert a request using an external view into a request using the tables in the conceptual schema.