网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?()
A
It returns space usage of only BasicFile LOB chunks.
B
It returns space usage of only SecureFile LOB chunks.
C
It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.
D
It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.
参考答案
参考解析
解析:
暂无解析
更多 “单选题Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?()A It returns space usage of only BasicFile LOB chunks.B It returns space usage of only SecureFile LOB chunks.C It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.D It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.” 相关考题
考题
单选题What is the result of increasing the value of the parameter ASM_POWER_LIMIT during a rebalance operation?()A
The ASM rebalance operation will likely consume fewer resources and complete in a shorter amount of time.B
The ASM rebalance operation will consume fewer resources and complete in a longer amount of time.C
The ASM rebalance operation will be parallelized and should complete in a shorter amount of time.D
There is no ASM_POWER_LIMIT setting used in ASM.E
None of the above.
考题
单选题You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery?()A
You will need to open the database with the resetlogs command.B
All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C
You will use the resetlogs version of the create controlfile command.D
You will use the noresetlogs version of the create controlfile command.E
You will use the trace file to create a backup control file, and then you will recover the database with the recover database using backup controlfile command
考题
单选题Which type of database file is spread across all disks in a disk group?()A
All types of files are spread across all disks in the disk group.B
DatafilesC
Redo log filesD
Archived redo log filesE
Control files
考题
单选题You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option. After some days, you want to change the status of the database backup and you issued the following command: RMANCHANGE BACKUPSET 231 NOKEEP; What is the implication of this command?()A
The backup is deleted.B
The backup is marked unavailable.C
The backup overrides the backup retention policy.D
the backup becomes eligible for deletion according to the existing retention policy.
考题
单选题You issue the following command on the RMAN prompt. REPORT NEED BACKUP DAYS 5; Which statement is true about executing this command?()A
It will display a list of files that need incremental backupB
It will display a list of files that need backup after five daysC
It will display a list of files that were backed up in the last five daysD
It will display a list of files that have not been backed up in the last five daysE
It will apply the current retention policy to determine the files that need to be backed up
考题
单选题Which command would you use to determine what database backups are currently available for restore?()A
list database backupB
report database backupC
list backup of databaseD
list summary backupE
report backup of database
考题
多选题Which of the following are valid until command options when attempting point-in-time recovery in RMAN?()Auntil timeBuntil changeCuntil sequenceDuntil SCNEuntil commit
考题
多选题Which two statements are true about a job chain? ()(Choose two.)AA job chain can contain a nested chain of jobs.BThe jobs in a job chain cannot have more than one dependency.CA job of the CHAIN type can be run using event-based or time-based schedules.DThe jobs in a job chain can be executed only by using the events generated by the Scheduler
考题
多选题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
考题
单选题You want the ability to recovery any time within the last seven days and therefore you configured the recovery window retention policy using the command: RMAN CONFIGURE RETENTIOH POLICY TO RKCOVFRY WINDOW OF 7 DAYS; After configuring the recovery window, you performed the database backup as follows:()A
Backup RB1 at log sequence number 12871 on 5th JanB
Backup RB2 at log sequence number 15622 on 12th JanC
Backup RB3 at log sequence 16721 on 15th JanD
On 20th Jan when the log sequence number was 18112 you realize that there Is a need to a point in time at the beginning of the recovery window. You have all an hived redo log files to date.
热门标签
最新试卷