Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/6

Click to flip

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