Section 1
Preview this deck
In standard SQL, the optimizer hint ALL_ROWS is generally used for _____ mode processes.
Front
| 5 | 0 | ||
| 4 | 0 | ||
| 3 | 0 | ||
| 2 | 0 | ||
| 1 | 0 |
Active users
0
All-time users
0
Favorites
0
Last updated
4 years ago
Date created
Mar 1, 2020
Cards (75)
Section 1
(50 cards)
In standard SQL, the optimizer hint ALL_ROWS is generally used for _____ mode processes.
batch
_____ transparency exists when the end user or programmer must specify both the fragment names and their locations.
Local mapping
If there is no index, the DBMS will perform a _____ scan.
full table
In the context of RAID levels, striped arrays provide:
increased read performance but no fault tolerance.
_____ fragmentation refers to the division of a relation into subsets of tuples.
Horizontal
A(n) _____ is a logical grouping of several data files that store data with similar characteristics.
table space
A system table space, a user data table space, an index table space, and a temporary table space are examples of _____.
file groups
Distributed processing does not require:
an existing distributed database.
The _____ cache is used as a temporary storage area for ORDER BY or GROUP BY operations, as well as for index-creation functions.
Sort
Under the _____ scenario, all record- and file-locking activities are performed at the end-user location.
multiple-site processing, single-site data
In the context of RAID levels, _____ refers to writing the same data blocks to separate drives.
Mirroring
The _____ table space is used for transaction-recovery purposes.
Rollback Segment
_____ transparency exists when the end user or programmer must specify the database fragment names but does not need to specify where these fragments are located.
Location
A _____ contains the description of the entire database as seen by the database administrator.
distributed data dictionary
The _____ table space is used to store the data dictionary tables.
System
When moving data from permanent storage to RAM, an I/O disk operation retrieves:
an entire physical disk block.
The LIKE conditional operator is used by the _____ OPERAND1.
V_CONTACT
_____ transparency allows the integration of several different local database management systems (DBMS) under a common, or global, schema.
Heterogeneity
_____ transparency allows the system to operate as if it were a centralized database management system.
Performance
A distributed database is composed of several parts known as database _____.
Fragments
The _____ processor is the software component residing on each computer that stores and retrieves data located at the site.
Data
_____ is the delay imposed by the amount of time required for a data packet to make a round trip from point A to point B.
Network latency
The _____ must be set large enough to permit as many data requests to be serviced from cache as possible.
Data cache
The data cache or _____ is a shared, reserved memory area that stores the most recently accessed data blocks in RAM.
Buffer cache
A centralized database management is subject to a problem such as _____.
a growing number of remote locations
The DBMS _____ the SQL query and chooses the most efficient access/execution plan.
Parses
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 _____.
extends
_____ distributed database systems integrate different types of centralized database management systems (DBMS) over a network.
Heterogeneous
A(n) _____ database stores each database fragment at a single site.
unreplicated
The _____ is a shared, reserved memory area that stores the most recently executed SQL statements or PL/SQL procedures, including triggers and functions.
Procedure Cache
In theory, a(n) _____ can be an independent centralized database management system with proper interfaces to support remote access from other independent database management systems in the network.
data processor
Bitmap indexes tend to use less space than a _____ because they use bits instead of bytes to store their data.
B-Tree Index
Knowing the sparsity of a column helps you decide whether the use of _____ is appropriate.
an index
_____ transparency allows a physically dispersed database to be managed as though it were centralized.
Distribution
_____ transparency allows data to be updated simultaneously at several network sites.
Transaction
_____ transparency is the highest level of transparency. The end user or programmer does not need to know that a database is partitioned.
Fragmentation
To generate database object statistics manually, following syntax should be used in Oracle: _____.
ANALYZE <TABLE/INDEX> object_name COMPUTE STATISTICS;
In RAID level 5,:
the data and the parity data are striped across separate drives.
The _____ rule requires that all copies of data fragments be identical.
mutual consistency
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.
DBMS performance
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.
two-phase commit protocol (2PC)
_____ is a disadvantage of a distributed database management system (DDBMS).
Security lapse
_____ refers to the number of different values a column could possibly have.
Data sparsity
From the performance point of view, _____ databases eliminate disk access bottlenecks.
in memory
In standard SQL, the optimizer hint FIRST_ROWS is generally used for _____ mode processes.
interactive
A _____ lets a single SQL statement access the data that are to be processed by a single remote database processor.
remote request
_____ transparency ensures that the system will continue to operate in the event of a node or network malfunction.
Failure
A _____ distributed database system will support different database management systems (DBMS) that may even support different models running under different computer systems.
Fully heterogeneous
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.
SQL Performance
A database management system needs _____ to prepare the data for presentation to the end user or to an application program.
formatting
Section 2
(25 cards)