1Z0-032单项选择题每日一练(2019.01.11)

单项选择题
The database is configured for automatic archive logging. Along with the other required parameters， this entry is in the initialization file：log_archive_dest2="SERVICE=standby_db1 MANDATORY REOPEN=600" From where does the database resolve standby_db1？（）
A.control file
B.tnsnames.ora
C.data dictionary
D.initialization parameter file
单项选择题
Which statement is true regarding the Archiver （ARCn） process，archived log files，and recovery？（）
A.A database backup, combined with archived redo log files, guarantees that all committed data can be recovered to the point of failure.
B.During recovery the ARCn background process copies its redo entries identified for recovery by the control file to the data files.
C.After each write to an archived log, the mandatory background process ARCn writes its log sequence number and the first and last SCN number within the log sequence to the control file.
D.At database recover time, and archived redo log is uniquely identified for recovery use by its redo thread number and destination ID number retrieved from the control file.
单项选择题
Which Oracle background process is responsible for providing information about the instance name associated with the service handlers and services to the listener？（）
A.PMON
B.SMON
C.LGWR
D.CKRT
单项选择题
As a result of a media failure， the current online redo log group is corrupted. The database crashes， as the current online group is inaccessible. Which type of incomplete recovery are you most likely to perform？（）
A.Cancel-based
B.Recovery using a backup control file
C.Time-based
D.Change-based
单项选择题
There is more than one way to set the server to detect and affect long running operations automatically. What is the best choice of you want to reduce the impact of long running operations on other users without aborting the long running operations？（）
A.Define user profiles and set the CPU_PER_CALL limit.
B.Define a SWITCH_TIME for a plan in the Resource Manager.
C.Create a batch job that checks V$SESSION_LONGOPS；the batch job alters the session priority of the long running operations.
D.Create a user defined event in the Oracle Enterprise Manager， which monitors V$SESSION_LONGOPS.