1Z0-032單項選擇題每日一練(2019.01.24)

單項選擇題
Oracle9i extends the cursor sharing functionality with the new value of SIMILAR for the CURSOR_SHARING parameter. With CURSOR_SHARING = SIMILAR， cursors are shared for safe literals only. What is meant by ‘safe literals only’？（）
A.No literal value is substituted for a shared cursor.
B.Different execution plans are generated for substituted literal values.
C.The substitution of a literal value will produce different execution plans.
D.The substitution of any literal value will produce exactly the same execution plan.
單項選擇題
You have configured the following： RMAN> CONFIGURE DEFAULT DEVICE TYPE TO ’sbt’； new RMAN configuration parameters： CONFIGURE DEFAULT DEVICE TYPE TO ’sbt’； new RMAN configuration parameters are successfully storedRMAN> SHOW DEVICE TYPE； RMAN configuration parameters are： CONFIGURE DEVICE TYPE SBT PARALLELISM 1； # CONFIGURE DEVICE TYPE DISK PARALLELISM 1； # RMAN> CONFIGURE DEVICE TYPE SET PARALLELISM 5； RMAN> SHOW DEVICE TYPE； RMAN configuration parameters are： CONFIGURE DEVICE TYPE SBT PARALLELISM 5； CONFIGURE DEVICE TYPE DISK PARALLELISM 1； # How many channels are allocated to SBT？（）
A.0， because channels have not been defined.
B.3， as indicated by the degree of parallelism.
C.1， the default value when device is configured.
D.5， as indicated by the last parallelism command.
單項選擇題
Two data files have been deleted at the operating system level by accident. Your database is running in ARCHIVELOG mode and online backups are taken nightly. One of the data files that has been deleted belongs to the USERS tablespace on the other belongs to the SYSTEM tablespace. How can you recover from this situation？（）
A.Shut down the database, restore the two data files and then start up the database.
B.Take the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online.
C.Shut down the database, restore the two data files, start up the database in MOUNT mode, recover the two data files, and then alter the database open.
D.Take the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.
單項選擇題
The database is being restored from a closed backup. The data files， control files， password file， and parameter file are available， but the online redo logs are not. Because the online redo logs are not available， you must simulate recovery and alter the database open with the reset logs option so the online redo logs are created while the database opens. Which type of recover is used in this situation？（）
A.until SCN
B.until time
C.until cancel
D.using backup control file
單項選擇題
You company has four DBAs. You need to know which DBA added a column to the JOB_HISTORY table. The database cannot be offline during work hours. Which LogMiner command can you use to find out which user made the table change？（）
A.A
B.B
C.C
D.D