当前分类： 1Z0-032
问题：单选题There is more than one way to set the server to detect and affect long running operations automatically. What is the best choice of you want to reduce the impact of long running operations on other users without aborting the long running operations？（）A...
查看答案
问题：单选题Which Oracle background process is responsible for providing information about the instance name associated with the service handlers and services to the listener？（）A PMONB SMONC LGWRD CKRT...
问题：单选题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...
问题：多选题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 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...
问题：多选题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 of the following environment variables specifies a non-default location for the listener configuration file？（）A LSN_ADMINB TNS_ADMINC ADMIN_TNSD TSN_ADMIN...
问题：单选题How can you make a shared server-side initialization parameter file available to all instances of a Real Application Clusters database？（）A Include an SPFILE parameter in each instance-specified initialization file.B Create an SPFILE copy on each client...
问题：单选题Which of the following commands cannot be executed when the database open？（）A RECOVER DATABASEB RECOVER TABLESPACEC RECOVER DATAFILED ALTER DATABASE RECOVER DATAFILE...
问题：单选题What is the new Oracle Shared Server?（）A An improved version of multithreaded server configuration. B A connection pooling configuration where several clients are connected to the same server process. C Two more database servers, which share data by me...
问题：单选题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 configura...
问题：单选题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...
问题：单选题Which of the following file should be configured for dynamic service registration？（）A LISTENER.ORAB SQLNET.ORAC INIT.ORAD TNSNAMES.ORA...
问题：单选题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 d...
问题：单选题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...
问题：单选题Management has decided that the database must be available 24 hours a day， 7 days a week. Given this requirement， which type of backup is required？（）A user-managed backups.B partial database backups.C consistent database backups.D inconsistent database...
问题：单选题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...
问题：单选题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 ...
