问题：单选题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...
查看答案
问题：单选题What is true if you want to switch undo tablespaces from the current one， called UNDO1， to a new one called UNDO2？（）A It is NOT possible to switch unless no active transaction exist in UNDO1. B It is possible to switch to UNDO2； but current active tran...
问题：多选题Archive file format LOG_ARCHIVE_FORMAT is defined as arch_%s.arc. A week ago， you just archived arch_4.arch to tape， then removed all archived files to save disk space. Yesterday you saw arch_10.arc and arch_11.arc on the disk. Today， you see arch_3.ar...
问题：单选题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...
问题：单选题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...
问题：多选题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 tool can be used to create and configure listeners to receive client connections？（）A Oracle Net ManagerB Oracle Net Control UtilityC Oracle Net Configuration Assistant...
问题：多选题Which two are true regarding direct-path exports？（）ADirect-path export is typically faster.BDirect-path export can be invoked interactively.CDirect-path export is character set independent.DDirect-path export bypasses the SQL-command processing layer.E...
问题：单选题Which one of the following files includes the parameter NAMES.DIRECTORY_PATH（hostname）？（）A Listener.oraB Tnsnames.oraC Cman.oraD Sqlnet.ora...
问题：单选题Why can setting too low a value for the FAST_START_MTTR_TARGET parameter reduce your overall database performance？（）A Data blocks have to be written more frequently by DBWR. B Redo blocks have to be written more frequently by LGWR. C You need to substa...
问题：单选题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 three types of information does the control file contain？（）ACurrent log sequence.BRecover tuning parameters.CRedo log names and locations.DData file names and locations.EUndo segment names and locations....
问题：多选题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...
问题：多选题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...
问题：单选题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...
问题：单选题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 ...
问题：单选题When importing a table into a database，the import process performs these tasks： 1. Triggers are imported. 2. Data is imported. 3. New tables are created. 4. Indexes are built. 5. Any bitmap， functional， and/or domain indexes are built. 6. Integri...
问题：单选题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...
问题：单选题With dynamic service registration， which process registers instance information with the listener？（）A SMONB PMONC shared serverD dedicated server...
问题：单选题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...
