当前分类： 1Z0-032
问题：单选题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 NOARCHI...
查看答案
问题：单选题What is true regarding a shared， server-side parameter file for a Real Application Cluster database？ （）A It can contain parameters with distinct values for each distance.B It can contain only parameters with identical values for each instance.C It must...
问题：单选题What is the purpose of importing from an export，and specifying that no rows be imported and that the output goes to a log file？（）A To verify space requirements in the target database before importing.B To generate the SQL for the DDL operations that wo...
问题：多选题Which two file types must be included in a closed database backup taken with operating system commands？（）Adata filesBcontrol fileCpassword fileDonline redo log filesEinitialization parameter file...
问题：单选题Which of the following files cannot be cataloged using the CATALOG command？（）A Data filesB Control filesC Archived log filesD Files storing RMAN scripts...
问题：单选题You are operating your database in NOARCHIVELOG mode. Your most recent backup includes a copy of all of the data files and the control files taken when the current log sequence number was 45. You experience disk failure on the drive on which your SYSTE...
问题：单选题When you use the Oracle Net Configuration Assistant to specify the naming method， which file is updated？（）A INIT.ORAB SQLNET.ORAC LISTENER.ORAD TNSNAMES.ORA...
问题：单选题Which of the following commands cannot use the functionality assosciated with theNLS_DATE_FORMAT variable？（）A RESTOREB RECOVERC REPORTD BACKUP...
问题：多选题Media recovery can sometimes be stopped by the inability to read past a certain point in the redo stream. This is often referred to as “stuck recovery”. Before Oracle9i， the Database Administrator had few options to deal with stuck recovery. If the co...
问题：单选题You can control instance recover performance by setting parameters to define targets for（）A The size of the redo buffer in SGA. B The instance that will perform recovery in Real Application Cluster database. C The number of blocks to be read during ins...
问题：多选题Some data storage and transfer media have fixed-length physical records. When the data records are short， more then one can be stored in a single， physical record to use the storage space efficiently. Consider this data： 1119 Smith 1120 Yvonne 1121 ...
问题：单选题When performing an incomplete recover of the whole database， which data files must you restore？ （）A Only the damaged or lost data files.B All of the data files of the database.C Only the data files belonging to the SYSTEM tablespace.D The data files be...
问题：多选题What are three benefits of performing data definition language （DDL） statements against a partitioned table with the UPDATE GLOBAL INDEXES clause？（）AGlobal indexes are rebuilt automatically at the end of the DDL operation thereby avoiding problems with...
问题：多选题Which two statements regarding the control file and Recover Manager are true？ （）AThe control file can grow in size.BThe control file can store RMAN scripts.CCONTROL_FILE_RECORD_KEEP_TIME determines retention time for RMAN records.DThe RMAN catalog can ...
问题：单选题Which background process reads the redo log buffer and writes it to a file？（）A ARCnB DBWnC CKPTD LGWRE PMONF SMON...
问题：单选题Your company decided to start using RMAN in its backup strategy. Previously your company used operating system file copies. Which command is used to make RMAN aware of existing backups made by copying files at the operating system？（）A CHANGEB RESYNCC C...
问题：单选题What is true regarding direct-load insert？（）A A direct-load insert can be invoked by suing the APPEND hint.B Inserting using the NOLOGGING option is the default for direct-load inserts.C All data loaded using direct-load insert is loaded below the high...
问题：多选题Which three resource plan parameters are used to enable Automatic Consumer Group Switching to estimate job execution times automatically， and to perform a switch to a low priority consumer group before they are initiated？（）ASWITCH_TIMEBSWITCH_GROUPCMAX...
