Oracle 1Z0-030: Oracle 9i: New Features For Administrators
#11. You use the TABLESPACES option of the Export command to export, not transport, the contents of a set of tablespaces. What are the only contents of the dump file?
#13. A switchover to a standby database differs from a failover to the standby in a number of ways. What are two of the key differences that characterize a switchover? (Choose two.)
#14. The multithreaded agent architecture for heterogeneous services is similar to the Oracle multithreaded server architecture. The principal difference is that it uses threads instead of processes. What are three kinds of threads that it uses? (Choose three.)
#15. Examine the list of variables and their data types:
Name Data Type
TS, TS1 TIMESTAMP
TSZ TIMESTAMP WITH TIME ZONE
TLZ TIMESTAMP WITH LOCAL TIME ZONE
IYM INTERVAL YEAR TO MONTH
IDS, IDS1 INTERVAL YEAR TO SECOND
Which three expressions using the new date and time data types are valid? (Choose three.)
#16. The direct handoff connection method to an Oracle9i Shared Server involves fewer messages than in previous releases of the multithreaded architecture. Which type of message has been eliminated?
#19. The EMPLOYEES table is stored in the SAMPLE tablespace. The corresponding IPK_EMP index for the EMPLOYEES table's primary key is stored in the INDX tablespace. Out of 12 partitions, only partition P1 of the SALES table is stored in the SAMPLE tablespace. Which objects will be exported by this command? exp system/manager tablespaces=SAMPLE