Question 1
On a client/server network, the server is a computer that provides data to the clients.
True
False
Question 2
A characteristic of a DDBMS that states that users do not need to be aware of the location of the data in a database is known as replication transparency.
True
False
Question 3
Another term for production system is the test system.
True
False
Question 4
The DBA is responsible for DBMS maintenance, data dictionary management, and training.
True
False
Question 5
Seek delay refers to the fixed amount of time that is required for every message.
True
False
Question 6
Programmers monitor database usage to detect potential security violations.
True
False
Question 7
An XML document should begin with an XML declaration.
True
False
Question 8
Accessing data using messages over a network is substantially slower than accessing data on a disk.
True
False
Question 9
A file server stores the files required by the users on a network.
True
False
Question 10
The CEO of the company determines the database access privileges for all users.
True
False
Question 11
Management approval is not required before the security policies and procedures can be implemented.
True
False
Question 12
Each Web page is assigned an Internet address called a Uniform Resource Locator (URL).
True
False
Question 13
To implement and enforce security, the DBA uses such features as encryption and views.
True
False
Question 14
When relational databases store complex objects, these special data types are known as VLOBs.
True
False
Question 15
When a company decides to purchase a new DBMS, the CEO leads the DBMS evaluation and selection effort.
True
False
Question 16
If the client only performs the presentation functions (and not the business functions), then the client is known as a fat client.
True
False
Question 17
In a DDBMS, the site where the user is located is called the remote site.
True
False
Question 18
A global deadlock occurs at a single site in a distributed database.
True
False
Question 19
A distributed database is a single logical database that is physically divided among computers at several sites on a network.
True
False
Question 20
A local deadlock involves one transaction that requires a record held by a second transaction at one site, while the second transaction requires a record held by the first transaction at a different site.
True
False
Question 21
____integrity is the constraint that says that the values in foreign keys must match values already in the database.
a.
Referential
b.
Relational
c.
Parallel
d.
Conditional
Question 22
Which of the following DBMS evaluation categories does the following question relate to: Does the DBMS allow partial copies and how does the DBMS handle updates to the same data from two or more replicas?
a.
Backup and recovery
b.
Security
c.
Replication and distributed databases
d.
Integrity
Question 23
Each ____ contains a single-part primary key that serves as an index for the fact table and also contains other fields associated with the primary key value.
a.
primary table
b.
dimension table
c.
star table
d.
fact table
Question 24
____ converts a table that is in third normal form to a table no longer in third normal form.
a.
Normalization
b.
Conversion
c.
Denormalization
d.
Replication
Question 25
Which of the following DBMS evaluation categories does the following question relate to: Does the vendor of the DBMS supply printed or online training manuals and how good are the manuals?
a.
Performance
b.
Cost
c.
Documentation and training
d.
Portability
Question 26
____ implies that the performance of functions such as adding sites, changing versions of DBMSs, creating backups, and modifying hardware should not require planned shutdowns of the entire distributed database.
a.
Continuous operation
b.
Local autonomy
c.
Location transparency
d.
Fragmentation transparency
2 points
Question 27
With respect to the definition of data warehouse, ____ means that data in a data warehouse represents snapshots of data at various points in time in the past.
a.
time-variant
b.
nonvolatile
c.
subject-oriented
d.
integrated
Question 28
A ____ is a place where a record of certain corporate data is kept.
a.
storage
b.
depository
c.
data bank
d.
data archive
Question 29
It is possible for local DBMSs to commit updates at some sites and undo updates at other sites. This inconsistency can be prevented by using a ____.
a.
two-step rollback
b.
two-phase commit
c.
two-phase transaction
d.
two-phase rollback
Question 30
After the database designers complete the information-level design, the DBA does the ____-level design.
a.
logical
b.
graphical
c.
physical
d.
information
Question 31
Which of the following DBMS evaluation categories does the following question relate to: Is it a simple catalog or can it contain more content, such as information about programs and the various data items these programs access?
a.
Data dictionary
b.
Integrity
c.
Backup and recovery
d.
Security
Question 32
When users interact with an RDBMS, they use transactions. These types of systems are called ____ systems.
a.
OLAP
b.
ODBMS
c.
ODBC
d.
OLTP
Question 33
If the client, in a client/server system, performs the business functions (calculations, etc.), then this client is known as a(n) ____.
a.
thin client
b.
fat client
c.
external client
d.
overweight client
Question 34
After the DBMS is purchased, the ____ has primary responsibility for installation and maintenance.
a.
IT manager
b.
DBA
c.
user
d.
CEO
Question 35
____ is a metalanguage derived from a restricted subset of SGML, and designed for the exchange of data on the Web.
a.
UML
b.
XML
c.
URL
d.
HTTP
Question 36
____ is the data communication method used by Web clients and Web servers to exchange data on the Internet.
a.
IIS
b.
HTTP
c.
UML
d.
URL
Question 37
Which of the following DBMS evaluation categories does the following question relate to: How many files can you open at the same time?
a.
Concurrent update
b.
Integrity
c.
Limitations
d.
Security
Question 38
A ____ is a subject-oriented, integrated, time-variant, nonvolatile collection of data in support of management’s decision-making process.
a.
back-end processor
b.
fat client
c.
data warehouse
d.
thin client
Question 39
In ____ systems, you create actions as part of data manipulation rather than as part of data definition.
a.
relational
b.
object-oriented
c.
parallel
d.
simple
Question 40
____ implies that users should not need to be concerned with the location of any specific data in the database.
a.
Fragmentation transparency
b.
Distributed query processing
c.
Replication transparency
d.
Location transparency
Question 41
When computers at one site need to be connected with computers at another site, the connection must be within a ____.
a.
building
b.
room
c.
network
d.
combination
Question 42
Computers in a network communicate through ____.
a.
messages
b.
notes
c.
tokens
d.
letters
Question 43
Because the clients and the server perform different functions and can run two different operating systems, there is an arrangement of client/server architecture known as ____.
a.
three-tier architecture
b.
two-tier architecture
c.
four-tier architecture
d.
single-tier architecture
Question 44
When users are unaware of the steps taken by the DDBMS to update the various copies of data, this characteristic of the DDBMS is called ____.
a.
location transparency
b.
fragmentation transparency
c.
replication transparency
d.
location site license
Question 45
Changing the database design to improve the performance is called ____.
a.
focusing the design
b.
tuning the design
c.
tending the design
d.
modifying the design
Question 46
____ locks forbid any other user from accessing the data in any way.
a.
Shared
b.
Exclusive
c.
Concurrent
d.
Limited
Question 47
When a centralized database becomes unavailable for any reason, no users can continue processing. In contrast, if a local database in a distributed database becomes unavailable, only users who need that data are affected. Because of this, distributed databases have a(n) ____ advantage over a centralized database.
a.
system availability
b.
increasing database capacity
c.
local control of data
d.
added efficiency
Question 48
The ____ is responsible for providing training in the use of the DBMS.
a.
programmer
b.
CEO
c.
analyst
d.
DBA
Question 49
With respect to the definition of data warehouse, ____ means that data is stored in one place, even though it originates from everywhere in the organization and from a variety of external sources.
a.
subject-oriented
b.
time-variant
c.
integrated
d.
nonvolatile
Question 50
Which of the following DBMS evaluation categories does the following question relate to: What is the unit that may be locked and are exclusive locks the only ones permitted?
a.
Data recovery
b.
Concurrent update
c.
Security
d.
Data dictionary