多項(xiàng)選擇題

You are managing an Oracle Database 11g instance.You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication?（）

A. The source database backup must be copied over the net for test database.
B. The source database must be run in ARCHIVELOG mode if the database is open.
C. The source database must be shut down cleanly if the database is in mounted state.
D. A net service name should be set up and a listener configured with the target as well as the source database.

你可能感興趣的試題

多項(xiàng)選擇題

View the Exhibit and examine the resource consumption details for the current plan in use by the database instance.Which two statements are true based on the output?（）

A. An attempt to start a new session by the user belonging to DSS_QUERIES fails with an error
B. A user belonging to DSS_QUERIES can log in to a new session but the session will be queued
C. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management .
D. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management, I/O waits, and latch or enqueue contention

單項(xiàng)選擇題

A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition. What happens to the PL/SQL procedure after the online table redefinition?（）

A. It remains valid.
B. It becomes invalid for all options of online table redefinition but automatically gets revalidated the next time it is used.
C. It becomes invalid for all options of online table redefinition and is automatically recompiled during online redefinition of the table.
D. It becomes invalid only if the storage parameters have been modified and it automatically gets revalidated the next time it is used.

无码高清视频|成人自拍视频|欧美成人午夜无码A片秀色直播|草美女视频网站|美女被操网站在线观看

You are managing an Oracle Database 11g instance.You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication?（）

你可能感興趣的試題

View the Exhibit and examine the resource consumption details for the current plan in use by the database instance.Which two statements are true based on the output?（）

A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition. What happens to the PL/SQL procedure after the online table redefinition?（）