网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
多选题
The database is configured in ARCHIVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option?()
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
参考答案
参考解析
解析:
暂无解析
更多 “多选题The database is configured in ARCHIVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option?()AControl filesBPassword filesCInactive online redo log fileDArchived log files required to perform recoveryENewly created tablespace which is not backed up” 相关考题
考题
单选题Which DBMS_RESOURCE_MANAGER procedure prioritizes consumer-group mappings?()A
CREATE_MAPPING_PRIORITYB
SET_MAPPING_PRIORITYC
SET_MAPPING_ORDERD
PRIORITIZE_MAPPING_ORDERE
This functionality is not available through the DBMS_RESOURCE_MANAGER package.
考题
多选题Which three statements are true about persistent configuration?() (Choose three.)AA user cannot set privileges on the persistent lightweight jobsBPersistent lightweight jobs generate a large amount of metadataCIt is possible to create fully self-contained persistent lightweight jobsDThe use of a template is mandatory to create persistent lightweight jobsEPersistent lightweight jobs are useful when users need to create a large number of jobs in a short time
考题
单选题Given the following steps, which would be the correct order to create a backup of an Oracle database in NOARCHIVELOG mode?() 1.shutdown immediate from RMAN 2.Log into RMAN 3.startup mount from RMAN 4.backup database 5.alter database open 6.backup database plus archivelog delete inputA
2,3,1,4,5B
2,1,3,6,5C
1,3,5,4D
2,1,3,5,6E
2,1,3,4,5
考题
单选题Which background process of a database instance,using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?()A
ASMBB
PMONC
RBALD
SMON
考题
多选题The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance. SQL STARTUP; Which two activities are performed during a successful start up operation? ()(Choose two.)AThe databases configured to use the ASM instance are mountedBThe disk groups are mounted as per the ASM_DISKGROUPS initialization parameterCASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not startedDASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters
考题
单选题Which setting enables the baselines by default in Oracle Database 11g?()A
setting the STATISTICS_LEVEL parameter to TYPICALB
adding filters to the Automatic Database Diagnostic Monitor (ADDM)C
enabling Automated Maintenance Task using Oracle Enterprise ManagerD
setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
考题
多选题Which two statements are true about the Automatic Diagnostic Repository (ADR)?()AThe ADR base keeps all diagnostic information in binary formatBSQL*Plus provides the ADRI script, which can be used to work with ADRCThe ADR can be used for problem diagnosis only when the database is openDThe ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to nullEThe ADR can be used for problem diagnosis even when the database instance is downFThe ADR base is shared across multiple instances
考题
多选题In a Database Replay workload capture, what client request information is gathered?()ASQL textBShared server requests (Oracle MTS)CBind variable valuesDInformation about transactionsERemote DESCRIBE and COMMIT operations
考题
多选题Which statements are true regarding table compression?()AIt saves disk space and reduces memory usage.BIt saves disk space but has no effect on memory usage.CIt incurs extra CPU overhead during DML as well as direct loading operations.DIt incurs extra CPU overhead during DML but not direct loading operations.EIt requires uncompress operation during I/O.
热门标签
最新试卷