网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
Which background process of a database instance,using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?()
A
ASMB
B
PMON
C
RBAL
D
SMON
参考答案
参考解析
解析:
暂无解析
更多 “单选题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” 相关考题
考题
多选题If you back up a database without connecting to the recovery catalog, which operations will cause the recovery catalog to be updated?()AThe next time you back up the database when you are also connected to the recovery catalog and the target databaseBThe next time you are connected to the target database and the recovery catalog database and issue the resync commandCThe next time you connect RMAN to just the recovery catalogDThe next time you connect to the recovery catalog and the target database with RMANEConnecting to the recovery catalog and issuing the resync all databases command
考题
单选题When setting arguments for a job, which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype?()A
SET_JOB_ARGUMENT_VALUEB
SET_JOB_VALUE_ANYDATAC
SET_JOB_ANYDATA_VALUED
SET_SPECIAL_JOB_VALUEE
SET_JOB_ANYTYPE_VALUE
考题
单选题Which statement is true regarding virtual private catalogs?()A
A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.B
The virtual private catalog owner cannot create and modify the stored scripts.C
The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.D
To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database
考题
单选题David managed to accidentally delete the datafiles for database called DSL. He called Heber and Heber tried to help but he managed to delete the control files of the database. Heber called Bill and Bill saved the day. They are using a recovery catalog for this database. What steps did Bill perform to recover the database and in what order?() a. Restored the control file with the RMAN restore controlfile command. b. Mounted the DSL instance with the alter database mount command. c. Restored the datafiles for the DSL database with the RMAN restore command. d. Opened the DSL database with the alter database open resetlogs command. e. Recovered the datafiles for the DSL database with the RMAN recover command. f. Started the DSL instance. g. Connected to the recovery catalog with RMAN.A
a, b, c, d, e, f, gB
b, c, d, g, f, e, aC
g, f, a, b, c, e, dD
c, a, d, b, f, e, gE
g, f, a, b, e, c, d
考题
单选题Evaluate the following command: SQLALTER SYSTEM SET db_securefile = ’IGNORE’; What is the impact of this setting on the usage of SecureFiles?()A
It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOBB
It forces SecureFiles to be created even if the BASICFILE option is specified to create the LOBC
It does not allow the creation of SecureFiles and generates an error if the SECUREFILE option is specified to create the LOBD
It ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is used and creates a BasicFile
考题
单选题Examine the following command: SQL ALTER TABLE booking SHRINK SPACE COMPACT; Which activity is performed when the preceding command is executed?()A
The shrink operation touches every block in the BOOKING tableB
The high-water mark (HWM) for the BOOKING table is shifted from its original positionC
The progress of the shrink operation is saved in the bitmap blocks of the BOOKING tableD
The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation
考题
单选题When youre performing active database duplication,a backup of what kind is required?()A
A current RMAN backup-set backup is required.B
No backup is required.C
An RMAN image backup is required.D
A manual backup is required.E
A duplicate preparatory backup is required.
考题
单选题What does the SCN represent?()A
The system change number, which is a point in time relative to transactions within a given database.B
A number that represents time. Thus, at 1300 hours, the SCN is the same on all databases. C
The security change number, which represents the security code that is needed to access any database structure.D
A conversion factor that converts internal database time to external clock time.E
UTC time in the database,providing a standardized way of tracking time in Oracle.
考题
单选题You create a new Automatic Database Diagnostic Monitor (ADDM) task: instance_analysis_mode_task. To view the ADDM report, you use the following command: SQL SELECT dbms_addm.get_report(’my_instance_analysis_mode_task’) FROM dual; You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT’s segments. What would you do to achieve this?()A
Add a finding directive for the ADDM task.B
Add a segment directive for the ADDM task.C
Add a parameter directive for the ADDM task.D
Disable the Segment Advisor from the Automatic Maintenance Task.
考题
多选题Why would you run the delete obsolete command?()ATo remove missing backup set pieces physically from diskBTo remove metadata related to backup set pieces in the control file and the recovery catalogCTo mark as deleted records in the control file and the recovery catalog associated with obsolete backup setsDTo delete backup set pieces associated with backups that are no longer needed due to retention criteriaETo remove old versions of RMAN backups
考题
多选题You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database. Which two statements are true about this backup operation? ()(Choose two.)ABackup compression should be enabledBParallelism for the channel should be set to 2CAll the files must be backed up as backup setsDThe backup may be stored either on disk or on media with media manager
热门标签
最新试卷