Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

Ch 11 MSQL

memorize.ai (lvl 286)

(0)

25 cards

()

Section 1

Preview this deck

The data cache or _____ is a shared, reserved memory area that stores the most recently accessed data blocks in RAM. a. SQL cache b. procedure cache c. buffer cache d. permanent storage

Front

1 / 25

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (25)

Section 1

(25 cards)

The data cache or _____ is a shared, reserved memory area that stores the most recently accessed data blocks in RAM. a. SQL cache b. procedure cache c. buffer cache d. permanent storage

Front

c. buffer cache In

Back

Knowing the sparsity of a column helps you decide whether the use of _____ is appropriate. a. query optimization b. a full table scan c. query processing d. an index

Front

d. an index

Back

The _____ must be set large enough to permit as many data requests to be serviced from cache as possible. a. sort cache b. SQL cache c. data cache d. optimizer mode

Front

c. data cache

Back

The _____ cache is used as a temporary storage area for ORDER BY or GROUP BY operations, as well as for index-creation functions. a. data b. SQL c. sort d. optimizer

Front

c. sort

Back

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

Front

d. procedure cache

Back

When moving data from permanent storage to RAM, an I/O disk operation retrieves: a. an entire table. b. an entire physical disk block. c. only the row containing the attribute requested. d. only the attribute which was requested.

Front

b. an entire physical disk block.

Back

In standard SQL, the optimizer hint ALL_ROWS is generally used for _____ mode processes. a. batch b. interactive c. real-time d. transaction

Front

a. batch

Back

In RAID level 5,: a. the data and the parity data are striped across separate drives. b. the data blocks are spread over separate drives and are duplicated. c. the array requires a minimum of two drives and is known as a striped array. d. the array requires a minimum of five drives and is known as duplexing.

Front

a. the data and the parity data are striped across separate drives.

Back

In the context of RAID levels, _____ refers to writing the same data blocks to separate drives. a. partitioning b. aggregating c. mirroring d. striping

Front

c. mirroring

Back

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 _____. a. procedure cache b. buffer cache c. supplements d. extends

Front

d. extends

Back

The _____ table space is used for transaction-recovery purposes. a. user data b. system c. temporary d. rollback segment

Front

d. rollback segment

Back

Bitmap indexes tend to use less space than a _____ because they use bits instead of bytes to store their data. a. hash index b. sparse index c. B-tree index d. reverse index

Front

c. B-tree index

Back

_____ refers to the number of different values a column could possibly have. a. Database statistics b. Data sparsity c. A bitmap index d. Clustering

Front

b. Data sparsity

Back

The LIKE conditional operator is used by the _____ OPERAND1. a. P_PRICE b. V_STATE c. P_QOH d. V_CONTACT

Front

d. V_CONTACT

Back

If there is no index, the DBMS will perform a _____ scan. a. full table b. range c. loop d. row ID table access

Front

a. full table

Back

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. a. client and server b. database SQL c. SQL performance d. DBMS performance

Front

d. DBMS performance

Back

In standard SQL, the optimizer hint FIRST_ROWS is generally used for _____ mode processes. a. real-time b. interactive c. batch d. transaction

Front

b. interactive

Back

The DBMS _____ the SQL query and chooses the most efficient access/execution plan. a. executes b. processes c. fetches d. parses

Front

d. parses

Back

In the context of RAID levels, striped arrays provide: a. neither fault tolerance nor good performance. b. increased fault tolerance but decreased performance. c. increased read performance but no fault tolerance. d. increased read performance and fault tolerance.

Front

d. increased read performance and fault tolerance.

Back

A(n) _____ is a logical grouping of several data files that store data with similar characteristics. a. procedure cache b. table space c. data cache d. listener

Front

b. table space

Back

To generate database object statistics manually, following syntax should be used in Oracle: _____. a. CREATE <TABLE/INDEX> object_name; b. CREATE <TABLE/INDEX> object_name COMPUTE STATISTICS; c. ANALYZE <TABLE/INDEX> object_name; d. ANALYZE <TABLE/INDEX> object_name COMPUTE STATISTICS;

Front

d. ANALYZE <TABLE/INDEX> object_name COMPUTE STATISTICS; In

Back

From the performance point of view, _____ databases eliminate disk access bottlenecks. a. in-memory b. index-organized c. RAID d. distributed

Front

a. in-memory

Back

The _____ table space is used to store the data dictionary tables. a. user data b. rollback segment c. temporary d. system

Front

d. system

Back

A system table space, a user data table space, an index table space, and a temporary table space are examples of _____. a. data caches b. file groups c. operation modes d. procedure caches

Front

b. file groups

Back

On the client side, the objective is to generate an SQL query that returns a 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. a. client SQL b. database SQL c. SQL performance d. DBMS performance

Front

c. SQL performance

Back