多項選擇題

You want to enable resumable space allocation at the instance level. Which two actions would enable resumable space allocation at the instance level？（）

A. issuing the ALTER SYSTEM ENABLE RESUMABLE；statement
B. issuing the ALTER SESSION ENABLE RESUMABLE；statement
C. modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero value
D. issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=；statement

你可能感興趣的試題

多項選擇題

You want to analyze a SQL Tuning Set （STS） using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set？（）

A. Every SQL statement in the STS is considered only once for execution.
B. The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics.
C. The execution plan and execution statistics are computed for each SQL statement in the STS.
D. The effects of DDL and DML are considered to produce the execution plan and execution statistics.

多項選擇題

The database is configured in ARCHIVELOG mode and regular complete database backups are taken. Theloss of which two types of files may require a recovery with the RESETLOGS option? （）(Choose two)

A. Control files
B. Password files
C. Inactive online redo log file
D. Archived log files required to perform recovery
E. Newly created tablespace which is not backed up

You want to enable resumable space allocation at the instance level. Which two actions would enable resumable space allocation at the instance level？（）

你可能感興趣的試題

You want to analyze a SQL Tuning Set （STS） using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set？（）

The database is configured in ARCHIVELOG mode and regular complete database backups are taken. Theloss of which two types of files may require a recovery with the RESETLOGS option? （）(Choose two)

You want to enable resumable space allocation at the instance level. Which two actions would enable resumable space allocation at the instance level？（）