Which would provide the greatest performance benefit in a warehousing environment?
A. Indexes on searched data.
B. Large number of bufferpool buffers.
C. Short checkpoint durations.
D. Optimize decision support memory.
正解:D
質問 2:
When a SELECT statement is executed which statement is true?
A. If COMMITTED READ isolation is in place then the SELECT will never encounter any locking errors.
B. If the SELECT is part of an UPDATE cursor then the database server will place an exclusive lock on the entire dataset.
C. The number and duration of the locks is dependent on the ISOLATION LEVEL.
D. Within a transaction the database server will place row or page locks on a nonlogging table.
正解:C
質問 3:
Why do automatic checkpoints cause the database server to trigger more frequent
checkpoints?
A. To avoid LRU flushes.
B. To avoid transaction blocking during checkpoints.
C. To ensure the onstat -g ckp report is accurate.
D. To ensure the buffer pool is always available.
正解:B
質問 4:
Which SQL Administration API command will merge non-contiguous table extents?
A. shrink
B. table repack
C. defragment
D. merge extents
正解:C
質問 5:
Which statement regarding default roles is true?
A. The privileges associated with a default role takes precedence over the privileges granted to an individual user.
B. When a user connects to a database, it is necessary to use the SET ROLE DEFAULT statement in order to gain the default role privileges.
C. An administrator can define a default role to assign only to the PUBLIC group for a particular database.
D. An administrator can define a default role to assign to individual users or to the PUBLIC group for a particular database.
正解:D
質問 6:
The following shrink command has what effect on the customer table? execute function sysadmin:task("table shrink","customer")
A. Locks the table in exclusive mode and releases all free space at the end of the table.
B. Locks the table in exclusive mode and moves all rows to the beginning of the table.
C. Moves all rows to the beginning of the table while users can modify the table.
D. Releases all free space at the end of the table to the dbspace while users can modify the table.
正解:D
質問 7:
By default, the alarm program gets executed for which event(s)?
A. All events.
B. Only for events with Severity code 1.
C. Only for events with Severity code greater than 1.
D. Only for events with Severity code 5.
正解:C