Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
6 Cards in this Set
- Front
- Back
Which statement is NOT correct regarding higher compression levels for database and log dumps?
A: Results in the smallest archive file size B: Uses more CPU than lower compression levels C: Causes dumps to take more time D: Uses significantly less I/O than lower compression levels. |
D: Uses significantly less I/O than lower compression levels.
|
|
Which of the following cache or I/O tuning methods can reduce the spinlock contention on a single ‘hot’ table that is already bound to a named cache?
A: Create 16K buffer pool in the named cache B: Change the cache replacement strategy of the named cache to relaxed LRU C: Partition the named cache D: Increase the named cache size |
C: Partition the named cache
|
|
The housekeeper task …
A: Reclaims space in APL tables B: Flushes statistics generated from data modifications in cache memory to systabstats C: Enforces license use D: Dynamically reconfigures procedure cache as needed |
B: Flushes statistics generated from data modifications in cache memory to systabstats
|
|
Which statement about ASE backup compression is TRUE?
A: Different compression levels can be specified for each stripe of a dump B: DB’s must be loaded specifying the same compression level they were dumped with C: Remote dump & load operations can be compressed, to any compression level D: Remote dump & load operations can be compressed, but to only up to the default compression level |
A: Different compression levels can be specified for each stripe of a dump
|
|
User-defined segments can be used to …
A: enable parallel bcp B: Reduce lock contention on heap tables C: Improve the access performance on large tables D: Isolate a table in a separate section of memory |
C: Improve the access performance on large tables
|
|
The ASE software architecture is described as … (choose 3)
A: Process per user B: Multi-threaded C: Multi-engine D: Client-server E: Anticipated-multitasking |
B: Multi-threaded
C: Multi-engine D: Client-server |