1z0-043单项选择题每日一练(2019.01.22)

单项选择题
Your database operates in ARCHIVELOGmode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence， 230， is not archived and it contained information from 10：35 a.m. onwards. The current time is 11：00 a.m. Because of a disk crash， you executed the following command to perform an incomplete recovery： RMAN> RUN { 2> SET UNTIL SEQUENCE 230 THREAD 1；3> ALTER DATABASE MOUNT； 4> RESTORE DATABASE； 5> RECOVER DATABASE； 6> ALTER DATABASE OPEN RESETLOGS； 7> }； With reference to this scenario， which statement is true？（）
A. RMAN recovers up to log sequence 230， but not including 230.
B. RMAN returns an error because the log sequence number mentioned in the command should be 229.
C. RMAN returns an error because the log sequence number mentioned in the command may never be missing.
D. RMAN recovers up to and including log sequence 229 but then returns an error because log sequence 230 is missing.
单项选择题
You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. While studying the parameter file of the ASM instance， you find the following entry： ASM_DISKSTRING = /devices/* What could be the reason for this setting？（）
A.to enable the ASM instance to identify the alert log file
B.to enable the ASM instance to identify the server parameter file
C.to enable the ASM instance to define the locations for Oracle Managed Files （OMF）
D.to enable the ASM instance to identify all disks that can be accessed by it in the /devices directory
单项选择题
While designing your database， you have created the EMPLOYEEStable as an index-organized （IOT）. You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）
A. A primary key must have been created.
B. A mapping table must have been created.
C. An overflow tablespace must have been specified.
D. The PCTTHRESHOLD option must have been specified.
单项选择题
You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and usermanaged consistent backups are performed every Sunday night. On Thursday morning， you find that an important table has been dropped and purged. With reference to this scenario， up to what point in time can the data be recovered？（）
A.until Thursday morning
B.until last Sunday’s backup
C.until Wednesday evening
D.until that point in time when the database is opened
E.until that point in time when the recovery is performed
F.until that point in time when the table is dropped and purged
单项选择题
Which view will you use to view information regarding the jobs that are currently running in a database？（）
A.DBA_SCHEDULER_RUNNING_JOBS
B.DBA_SCHEDULER_JOB_RUN_DETAILS
C.DBA_SCHEDULER_JOBS
D.DBA_SCHEDULER_JOB_LOG