多项选择题

Which statements are true regarding table compression? （）(Choose all that apply.)

A. It saves disk space and reduces memory usage.
B. It saves disk space but has no effect on memory usage.
C. It incurs extra CPU overhead during DML as well as direct loading operations.
D. It incurs extra CPU overhead during DML but not direct loading operations.
E. It requires uncompress operation during I/O.

<上一题目录下一题>

热门试题

单项选择题WhichstatementistrueregardingtheretentionpolicyfortheincidentsaccumulatedintheAutomaticDiagnosticRepository（ADR）？（）

A. The incident metadata is purged when the problem is resolved and the DBA closes the SR
B. The incident files and dumps are not retained in the ADR for the manually created incidents
C. The incident files are retained but the incident metadata is purged when the problem is resolved and the DBA closes the SR
D. The default setting is for one year after which the incident metadata is purged from the ADR and the files are retained for one month

单项选择题Examine the following values of the initialization parameters in the database having the SID ORCL: BACKGROUND_DUMP_DEST= u01 app oracle product 11.1.0 db_1 bdump USER_DUMP_DEST= u01 app oracle product 11.1.0 db_1 udump CORE_DUMP_DEST= u01 app oracle product 11.1.0 db_1 cdump DIAGNOSTIC_DEST= The environment variables have the following value: ORACLE_BASE= u01 app oracle ORACLE_HOME= u01 app oracle product 11.1.0 db_1 What is the location of the Automatic Diagnostic Repository (ADR) home?（）

A./u01/app/oracle/product/11.1.0/db_1
B./u01/app/oracle
C.$ORACLE_HOME/bdump
D.$ORACLE_HOME/log

单项选择题Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement: ALTER TABLESPACE data1 BEGIN BACKUP; While you are performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true?（）

A. The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.
B. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.
C. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.
D. If you restart the database, the database will not be opened.

多项选择题The database Is configured in ARCHIVELOG mode. The database needs to be up 24 X 7. You want to perform user managed backup for the data files of the HR_DATA tablespace. To accomplish the task， you issued the following command： SQL> ALTER TABLESPACE hi_data BEGIN BACKUP； Which two statements are true in this scenario？（）

A. No transaction on the tablespace is allowed but you can perform queries.
B. The tablespace will automatically come out of backup mode when the file copy is complete.
C. The checkpoint change number is frozen in headers of the data files until the file is removed from backup mode.
D. The database writes the before image of an entire block to the redo stream before modifying. block tor the first time.

多项选择题You want to enable resumable space allocation at the instance level.Which two actions would enable resumable space allocation at the instance level? （）(Choose two.)

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