Quiz
Chapter 11 (MC)
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (17)
11. 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.
- Aa.client and server
- Bb.database
- Cc.SQL performance
- Dd.DBMS performance
22. On the server side, the DBMS 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 that goal are commonly referred to as ____ tuning.
- Aa.client and server
- Bb.database
- Cc.SQL performance
- Dd.DBMS performance
33. All data in a database are stored in ____ files.
- Aa.table
- Bb. data
- Cc.RAM
- Dd.system
44. 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 ____.
- Aa.procedure cache
- Bb.file group
- Cc.data files
- Dd.extends
55. A(n) ____ is a logical grouping of several data files that store data with similar characteristics.
- Aa.procedure cache
- Bb.file group
- Cc.data files
- Dd.extends
66. A system table space, a user data table space, an index table space, and a temporary table space are examples of ____.
- Aa.procedure caches
- Bb.file groups
- Cc.data files
- Dd.extends
77. The data cache is where the data read from the database data files are stored ____ the data have been read or ____ the data are written to the database data files.
- Aa. after, before
- Bb. after, after
- Cc. before, before
- Dd. before, after
88. To work with the data, the DBMS must retrieve the data from the ____ and place it in the ____.
- Aa. data files, procedure cache
- Bb. data files, data cache
- Cc. temporary files, RAM
- Dd. temporary files, procedure cache
99. The data cache or ____ is a shared, reserved memory area that stores the most recently accessed datablocks in RAM.
- Aa. buffer cache
- Bb. procedure cache
- Cc. SQL cache
- Dd. permanent storage
1010. The ____ is a shared, reserved memory area that stores the most recently executed SQL statements or PL/SQL procedures, including triggers and functions.
- Aa. buffer cache
- Bb. procedure cache
- Cc. data cache
- Dd. permanent storage
1111. To generate database object statistics manually, you could use the following syntax: ____.
- Aa. ANALYZE <TABLE/INDEX> object_name;
- Bb. CREATE <TABLE/INDEX> object_name;
- Cc. ANALYZE <TABLE/INDEX> object_name COMPUTE STATISTICS;
- Dd. CREATE <TABLE/INDEX> object_name COMPUTE STATISTICS;
1212. The DBMS ____ the SQL query and chooses the most efficient access/execution plan.
- Aa. parses
- Bb. executes
- Cc. fetches
- Dd. Processes
1313. The DBMS ____ the SQL query using the chosen execution plan.
- Aa. parses
- Bb. executes
- Cc. fetches
- Dd. Processes
1414. The DBMS ____ the data and sends the result set back to the client.
- Aa. parses
- Bb. executes
- Cc. fetches
- Dd. Processes
1515. If there is no index, the DBMS will perform a ____ scan.
- Aa. loop
- Bb. range
- Cc. row ID table access
- Dd. full table
1616. ____ refers to the number of different values a column could possibly have.
- Aa. Database statistics
- Bb. Data sparsity
- Cc. Primary keys
- Dd. Query optimization
1717. Knowing the sparsity of a column helps you decide whether the use of ____ is appropriate.
- Aa. query processing
- Bb. query optimization
- Cc. an index
- Dd. a full table scan
Information
- Description
- asdf Quiz on Chapter 11 (MC), created by . . on 07/12/2016.
- Author
- . .
- Language
- English
- Views
- 73
- Tags
- Rating
- No ratings yet Rate this quiz