当前分类： 1Z0-032
问题：单选题Examine this statement： RMAN BACKUP FORMAT ’/BACKUP/df_%d_%s_%p.bus1 DATABASE filesperset = 2； What state must the target database be in for you to use this RMAN command？（）A The target database must be open.B The target database must be closed.C The ...
查看答案
问题：单选题SQL*Loader reads a set of records from a file， generates INSERT commands， and passes them to the Oracle kernel. Oracle then finds places for those records in free blocks in the table and updates any associated indexes. Which SQL*Loader mode is used in ...
问题：单选题You are configuring the listener on your server. Which listener.ora parameter contains the information needed to detect session requests from different client types？（）A ADDRESS_LISTB SID_NAMEC LISTENERD SERVICE_LIST...
问题：多选题The RMAN BACKUP command using the DELETE INPUT option can be used with which three types of files？ （）Adata filesBbackup setsCcontrol filesDarchived redo log files...
问题：单选题An index-organized table （IOT） called SPARSE has had many records deleted. Which command reorganizes the IOT so that the empty space is removed， while minimizing the impact for users？（）A EXPORT with TABLES and IMPORT with the INDEX and IGNORE options.B...
问题：单选题When performing recover of a database in NOARCHIVELOG mode with RMAN， the target database must be in the （） state to restore the control file.A OPENB IDLEC MOUNTD NOMOUNT...
问题：单选题Examine this syntax which allocates channels during a parallel image copy： RMAN CONFIGURE DEVICE TYPE disk parallelism 4： 2 COPY 3 datafile 1 TO ‘/BACKUP/datafile1.dbf’， 4 datafile 2 TO ‘/BACKUP/datafile2.dbf’， 5 datafile 3 TO ‘/BACKUP/datafile3....
问题：单选题Which of the following environment variables specifies a non-default location for the listener configuration file？（）A LSN_ADMINB TNS_ADMINC ADMIN_TNSD TSN_ADMIN...
问题：多选题Oracle9i provides a database package called dbms_redefinition to perform an online rebuild of a table. Which two steps are you recommended to do prior to issuing thedbms_redefinition_start_redef table procedure call？（）AGrand privileges on the interim ...
问题：单选题Which background process reads the redo log buffer and writes it to a file？（）A ARCnB DBWnC CKPTD LGWRE PMONF SMON...
问题：单选题Which of the following files can be used to configure connection pooling in the shared server environment？（）A INIT.ORAB SQLNET.ORAC TNSNAMES.ORAD SERVICES.ORAE LISTENER.ORA...
问题：多选题You notice that your RMAN script used to copy the datafiles， control files， and archived redo log files is performing very slowly. Which two changes might you want to include in your RMAN script to speed up the COPY commands？（）ANOCHECKSUMBMAXCORRUPTCCH...
问题：To perform a database point-in-time recovery using RMAN， aft...
问题：多选题Which two statements are true regarding the use of UTF-16 encoding？ （）AEnables easier loading of multinational data.BUses a fixed-width Multibyte encoding sequence.CAsian characters are represented in three characters.DUsed a variable-width Multibyte e...
问题：单选题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 dynamic performance view displays the information about the files associated with the locally managed temporary tablespaces in Oracle9i？（）A V$DATAFILEB V$TEMPFILEC V$DBFILED V$DATAFILE_HEADER...
问题：单选题You want to create an RMAN recovery catalog in the RC01 database to help you manage the databases named DB01 and DB02. You need to create a recovery catalog owner in which of your databases？（）A RCO1 only.B DB01 only.C DB02 only.D DB01 and DB02 only.E D...
问题：单选题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...
问题：单选题RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）A ’SQL ALTER DATABASE OPEN’；B SQL ALTER DATABASE ’OPEN’；C OPEN DATABASE；D DATABASE OPEN...
