최신 Certified Administrator 000-919 무료샘플문제:

1. When running an onstat -u, what does a 'Y' in the first column of the flags signify?

A) The userthread is waiting for a thread to yield a cpu vp.
B) The userthread is waiting for a thread with a higher priority.
C) The userthread is waiting on a condition.
D) The userthread is waiting for end user I/O to complete.

2. What two onconfig parameters will help improve performance of new network connections? (Choose two.)

A) FET_BUF_SIZE
B) NS_CACHE
C) NETTYPE
D) NUMFDSERVERS
E) VPCLASS

3. Which connection type can be used for network connections?

A) Shared memory
B) Sockets
C) Named Pipes
D) Stream Pipes

4. What does the following SQL statement do? execute function task("reset sysadmin", "admindbs");

A) Purges all "mon_*" tables in sysadmin database as user admindbs.
B) Turns the whole Database Scheduler off and finally drops sysadmin database.
C) Renames sysadmin database to admindbs.
D) Locks sysadmin database in exclusive mode and recreates it in dbspace admindbs.

5. When executing the SQL Admin API "defragment table" and "table repack" commands on the customer table, what will happen to the table? (Choose two.)
execute function sysadmin:task("defragment table","customer"); execute function sysadmin:task("table repack", "customer");

A) The table will be locked preventing inserts from happening for the duration of the commands.
B) Fragments of a table will be combined.
C) Free space at the end of the table will be released to the dbspace for other tables to use.
D) Given sufficient resources the number of extents in the table will be reduced.
E) Rows will be moved to the beginning of table.

질문과 대답: