站内搜索
1Z0-032 问题列表
问题
单选题What is the maximum number of ARCn processes that can be defined using the initialization parameter LOG_ARCHIVE_MAX_PROCESSES？（）A
1B
5C
10D
15E
Depends on system memory resources
问题
多选题Which four occur during the processing of a request using Oracle Shared Server？（）AThe dispatcher returns the response to the user.BThe dispatcher places the request into the request queue.CThe shared server places the response in the response queue.DThe response is handed off to the next available dispatcher.EA shared server picks up the request from the request queue and processes the request.
问题
单选题To perform a database point-in-time recovery using RMAN， after database restoration， you must ensure that the database is in which of the following states？（）A
OPENB
MOUNTC
NOMOUNTD
CLOSE
问题
单选题You are attempting to create an Oracle-Managed Files （OMF） tablespace in a production database with the following statement and receive the following error message： CREATE TABLESPACE tbsl； ORA-02199： missing DATAFILE/TEMPFILE clause oerr ora 2199 02199， 00000， “missing DATAFILE/TEMPFILE clause” *Cause： A CREATE TABLESPACE statement has no DATAFILE/TEMPFTLE clause. *Action： specify DATAFILE/TEMPFILE clause. What is the corrective action to create the OMF based tablespace？（）A
AB
BC
CD
D
问题
单选题You configured automatic archive logging for the database. On the next startup the database runs for a while， but then hangs. After checking the alert log， you determine that all the online redo logs need archiving. Which step was skipped when you set up automatic archive log？（）A
LOG_ARCHIVE_DEST was not set in the parameter file.B
LOG_ARCHIVE_START was not set in the parameter file.C
alter database archivelog； was not executed in MOUNT mode.D
LOG_ARCHIVE_MAX processes were not set in the parameter file.
问题
单选题Which of the following statement is incorrect regarding RMAN？（）A
It detects corrupt blocks.B
It performs only offline database backups.C
It omits empty blocks during backups.D
It performs tablespace point-in-time recovery （TSPITR）.
问题
单选题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.
问题
多选题You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback？（）AOracle Flashback uses undo information to construct consistent data.BYou can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session.CYou can only use Oracle Flashback view of the data if the required records are still in the online redo log files.DOracle Flashback lists the DML that was executed during the period you identify when initiating your session.
问题
单选题You issue this SQL statement： ALTER DATABASE RENAME FILE ’/ORADATA/u02/user_data01.dbf’ TO ’/ORADATA/u04/user_data01.dbf’； What does this SQL statement do？（）A
It updates the control file with the new location of the data file. B
It updates only the data dictionary with the new location of the data file. C
It changes the location of the user_data01.dbf file in the operating system. D
It changes the location of the user_data01.dbf file in the operating system and updates the control file with the new location of the data file.
问题
多选题Automatic Consumer Group Switching is an important new feature of the Database Resource Manager. Which three plan directive parameters are used to control this feature？（）ASWITCH_TIMEBSWITCH_GROUPCMAX_SESS_POOLDSWITCH_ESTIMATE
问题
单选题The list below displays four steps that you need to execute in order to switch from the primary database role to the standby database role. Choose the correct order of execution for the steps.（） 1. Shot down and start up the former primary instance without mounting the instance. 2. Issue the ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY command. 3. Issue the ALTER DATABASE MOUNTS STANDBY DATABASE command. 4. End read or update activity on the former primary and standby database.A
1，2，3，4B
3，2，4，1C
4，2，1，3D
4，3，2，1
问题
单选题Which RMAN command do you use to verify that the RMAN repository information is synchronized with the actual files that exist on disk？（）A
LISTB
CHANGEC
CATALOGD
CROSSCHECK
问题
单选题Assume your situation can be described as follows： x A full backup taken using RMAN is available on disk. x The current control files were NOT damaged and do not need to be restored. x All data files are damaged or lost. x The database is in NOARCHIVELOG mode. Which RMAN command would be most appropriate to use in line 3 of the following RMAN command set to restore and fully recover your database？（） 1. RMAN STARTUP MOUNT 2. RMAN RESTORE DATABASE; 3. RMAN （） 4. RMAN ALTER DATABASE OPEN;A
RECOVER DATABASE；B
SWITCH DATAFILE ALL；C
RESTORE CONTROL FILE；D
RECOVER DATABASE USING BACKUP CONTROL FILE；
问题
单选题Which of the following commands cannot be executed when the database open？（）A
RECOVER DATABASEB
RECOVER TABLESPACEC
RECOVER DATAFILED
ALTER DATABASE RECOVER DATAFILE
问题
单选题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 stored RMAN 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.