Question 1

true

Accepted Answer

The mainframe environment enables an OLAP system to be divided into several components that define its architecture.

Question 2

unrelated

Accepted Answer

As long as two transactions, T1 and T2, access ____ data, there is no conflict, and the order of execution is irrelevant to the final outcome. shared common unrelated locked

Question 3

high normalization

Accepted Answer

A characteristic of operational data is ____. summarized data hundreds of gigabytes high normalization historic data

Question 4

Failure

Accepted Answer

____ transparency ensures that the system will continue to operate in the event of a node failure. Transaction Distribution Failure Performance

Question 5

exclusive lock

Accepted Answer

A(n) ____ specifically reserves access to the transaction that locked the object. shared lock exclusive lock binary lock deadlock

Question 6

SQL performance

Accepted Answer

On the client side, the objective is to generate a SQL query that returns the correct answer in the least amount of time, using the minimum amount of resources at the server end. The activities required to achieve that goal are commonly referred to as ____ tuning. client and server database SQL performance DBMS performance

Question 7

when the first SQL statement is encountered

Accepted Answer

The implicit beginning of a transaction is _____.   1) when the database is started 2) when a table is accessed for the first time 3) when the first SQL statement is encountered 4) when the COMMIT command is issued

Question 8

True

Accepted Answer

The transaction recovery write-ahead-log protocol ensures that transaction logs are always written before any database data are actually updated.    True  False

Question 9

The end of a program is successfully reached

Accepted Answer

ANSI defines four events that signal the end of a transaction. Of the following events, which is defined by ANSI as being equivalent to a COMMIT?  1) Five SQL statements are executed. 2) The end of a program is successfully reached 3) The program is abnormally terminated. 4) The database is shut down for maintenance.

Question 10

True

Accepted Answer

To work with data, the DBMS must retrieve the data from permanent storage and place it in RAM. 1) True 2) False

Question 11

INDEX(P_QOH_NDX)

Accepted Answer

When setting optimizer hints, _____ instructs the optimizer to minimize the overall execution time, that is, to minimize the time it takes to return the total number of rows in the query result set. This hint is generally used for batch mode processes.  1) ALL_ROWS 2) FIRST_ROWS 3) INDEX(P_QOH_NDX) 4) OPTIMIZATION_ROWS

Question 12

full table

Accepted Answer

If there is no index, the DBMS will perform a _____ scan. 1) loop 2) range 3) row ID table access 4) full table

Question 13

sort

Accepted Answer

The _____ cache is used as a temporary storage area for ORDER BY or GROUP BY operations, as well as for index-creation functions. 1) data 2) SQL 3) sort 4) optimizer

Question 14

procedure cache

Accepted Answer

The _____ is a shared, reserved memory area that stores the most recently executed SQL statements or PL/SQL procedures, including triggers and functions.  1) buffer cache 2) procedure cache 3) data cache 4) permanent storage

Question 15

Parsing

Accepted Answer

Which of the following is the first step of query processing at the DBMS server end? 1) Executing 2) Parsing 3) Fetching 4) Delivering

Question 16

False

Accepted Answer

Character field comparisons are faster than numeric, date, and NULL comparisons. 1) True 2) False

Question 17

False

Accepted Answer

The SQL cache stores the end-user written SQL. 1) True 2) False

Question 18

False

Accepted Answer

A cost-based optimizer uses a set of preset rules and points to determine the best approach to execute a query. 1) True 2) False

Question 19

False

Accepted Answer

An index scan is less efficient than a full table scan.  1) True 2) False

Question 20

data

Accepted Answer

The majority of primary memory resources will be allocated to the _____ cache. 1) data 2) SQL 3) sort 4) optimizer

Question 21

DBMS performance

Accepted Answer

On the server side, the database environment must be properly configured to respond to clients\' requests in the fastest way possible, while making optimum use of existing resources. The activities required to achieve this goal are commonly referred to as _____ tuning.  1) client and server 2) database SQL 3) SQL performance 4) DBMS performance

Question 22

parses

Accepted Answer

The DBMS _____ the SQL query and chooses the most efficient access/execution plan. 1) parses 2) executes 3) fetches 4) processes

Question 23

False

Accepted Answer

DBMS implementations are typically similar in complexity to two-tier client/server configurations. 1) True 2) False

Question 24

file groups

Accepted Answer

A system table space, a user data table space, an index table space, and a temporary table space are examples of _____.  1) procedure caches 2) file groups 3) data caches 4) operation modes

Question 25

extends

Accepted Answer

A DBA determines the initial size of the data files that make up the database; however, as required, the data files can automatically expand in predefined increments known as _____.  1) procedure cache 2) buffer cache 3) supplements 4) extends

Question 26

True

Accepted Answer

The data cache caches system catalog data and the contents of the indexes. 1) True 2) False

Question 27

False

Accepted Answer

All transaction management commands are processed during the parsing and execution phases of query processing. 1) True 2) False

Question 28

SQL performance

Accepted Answer

On the client side, the objective is to generate an SQL query that returns a correct answer in the least amount of time, using a minimum amount of resources at the server end. The activities required to achieve this goal are commonly referred to as _____ tuning. 1) client SQL 2) database SQL 3) SQL performance 4) DBMS performance

Question 29

True

Accepted Answer

The primary factor in determining the most efficient access plan is the I/O cost. 1) True 2) False

Question 30

True

Accepted Answer

The purpose of an I/O operation is to move data to and from different computer components or devices. 1) True 2) False

Question 31

False

Accepted Answer

Good database performance is easy to evaluate. 1) True 2) False

Question 32

increased read performance but no fault tolerance.

Accepted Answer

In the context of RAID levels, striped arrays provide: 1) increased read performance and fault tolerance. 2) increased fault tolerance but decreased performance. 3) increased read performance but no fault tolerance. 4) neither fault tolerance nor good performance.

Question 33

True

Accepted Answer

Working with data in the data cache is many times faster than working with data in the data files. 1) True 2) False

Question 34

rollback segment

Accepted Answer

The _____ table space is used for transaction-recovery purposes. 1) system 2) user data 3) temporary 4) rollback segment

Question 35

True

Accepted Answer

All factors must be checked to ensure that each system component operates at its optimum level and has sufficient resources to minimize the occurrence of bottlenecks. 1) True 2) False

Question 36

False

Accepted Answer

RAID systems use a single disk to create storage volumes. 1) True 2) False

Question 37

False

Accepted Answer

Indexes do not facilitate join operations. 1) True 2) False

Question 38

True

Accepted Answer

Using index characteristics, a database designer can determine the best type of index to use. 1) True 2) False

Question 39

True

Accepted Answer

Fully equivalent means that the optimized query results are always the same as the original query. 1) True 2) False

Question 40

data cache

Accepted Answer

The _____ must be set large enough to permit as many data requests to be serviced from cache as possible. 1) data cache 2) SQL cache 3) sort cache 4) optimizer mode

Question 41

True

Accepted Answer

DBMS performance tuning includes global tasks such as managing the DBMS processes in primary memory and managing the structures in physical storage. 1) True 2) False

Question 42

False

Accepted Answer

Most current-generation relational DBMSs perform automatic query optimization at the client end. 1) True 2) False

Question 43

table space

Accepted Answer

A(n) _____ is a logical grouping of several data files that store data with similar characteristics.  1) procedure cache 2) table space 3) data cache

Question 44

DBMS finds the most cost-effective access path without user intervention.

Accepted Answer

Automatic query optimization means that the: 1) optimization takes place at compilation time by the programmer. 2) DBMS finds the most cost-effective access path without user intervention. 3) optimization process is scheduled and selected by the end user or programmer. 4) database access strategy is defined when the program is executed.

Question 45

data files; procedure cache

Accepted Answer

To work with data, a DBMS must retrieve the data from _____ and place them in _____. 1) data files; procedure cache 2) RAM; data cache 3) permanent storage; RAM 4) temporary files; procedure cache

Question 46

batch

Accepted Answer

In standard SQL, the optimizer hint ALL_ROWS is generally used for _____ mode processes. 1) interactive 2) real-time 3) batch 4) transaction

Question 47

in-memory

Accepted Answer

From the performance point of view, _____ databases eliminate disk access bottlenecks. 1) RAID 2) distributed 3) index-organized 4) in-memory

Question 48

procedure/SQL

Accepted Answer

The _____ cache stores the most recently executed SQL statements. 1) data  2) procedure 3) sort 4) optimizer

Question 49

an entire physical disk block.

Accepted Answer

When moving data from permanent storage to RAM, an I/O disk operation retrieves: 1) an entire table. 2) an entire physical disk block. 3) only the row containing the attribute requested. 4) only the attribute which was requested.

Question 50

mirroring

Accepted Answer

In the context of RAID levels, _____ refers to writing the same data blocks to separate drives. 1) striping 2) mirroring 3) partitioning 4) aggregating

Question 51

true

Accepted Answer

A fully replicated database stores multiples copies of each database fragment at multiple sites.

Question 52

true

Accepted Answer

A partially replicated database stores multiples copies of some database fragment at multiple sites.

Question 53

True

Accepted Answer

One of the advantages of a DDBMS is growth facilitation. True False

Question 54

False

Accepted Answer

A remote transaction, composed of several requests, may access data at multiple sites. 1) True 2) False

Question 55

two-phase commit protocol (2PC)

Accepted Answer

The _____ guarantees that if a portion of a transaction operation cannot be committed, all changes made at the other sites participating in the transaction will be undone to maintain a consistent database state. 1) DO-UNDO-REDO protocol 2) two-phase commit protocol (2PC) 3) coordinator protocol 4) write-ahead protocol

Question 56

False

Accepted Answer

One of the advantages of a distributed database management system (DDBMS) is that the data is located near the site with the least demand. 1) True 2) False

Question 57

unreplicated

Accepted Answer

A(n) _____ database stores each database fragment at a single site.  1) partially replicated 2) unreplicated 3) fully replicated 4) partitioned

Question 58

query

Accepted Answer

The objective of _____ optimization is to minimize the total cost associated with the execution of a request.  1) data 2) remote 3) transaction 4) query

Question 59

True

Accepted Answer

The World Wide Web is the repository for distributed data. 1) True 2) False

Question 60

Heterogeneous

Accepted Answer

_____ distributed database systems integrate different types of centralized database management systems (DBMS) over a network. 1) Homogeneous 2) Heterogeneous 3) Fully homogeneous 4) Combination

Question 61

True

Accepted Answer

In order to manage distributed data, copies or parts of the database processing functions must be distributed to all data storage sites. 1) True 2) False

Question 62

False

Accepted Answer

A transaction processor (TP) is the software component residing on each computer that stores and retrieves data located at the site. 1) True 2) False

Question 63

distributed data dictionary

Accepted Answer

A _____ contains the description of the entire database as seen by the database administrator. 1) distributed global dictionary 2) distributed data dictionary 3) distributed global schema 4) distributed data schema

Question 64

True

Accepted Answer

Performance transparency ensures that the system finds the most cost-effective path to access remote data. 1) True 2) False

CSIS 304 Chapter 10-13 – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards