问题:单选题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-water mark.D An object that is modifies using parallel direct-load can be queried within the same Transaction.
查看答案
问题:单选题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
问题:单选题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
问题:单选题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
问题:单选题Examine the statement: DROP TABLESPACE IND2 INCLUDING CONTENTS AND DATAFILES; What is the result of the statement?()AABBCCDD
问题:多选题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 encoding sequence.EEuropean characters are represented on one or two bytes.
问题:单选题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;
问题:多选题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?()ANOCHECKSUMBMAXCORRUPTCCHECK LOGICALDBACKUP INCREMENTALECONFIGURE DEVICE TYPE ... PARALLELISM
问题:单选题Which statement is true regarding checkpoints and recovery?()A A checkpoint defines the highest system change number (SCN).B All redo entries higher or at the SCN are known to be written to the data files.C Only the redo records containing SCNs higher then the checkpoint need to be applied during recovery.D The LOG_CHECKPOINT_INTERVAL initialization parameter specifies the amount of time between incremental checkpoints.
问题:多选题Which three attributes of the LOG_ARCHIVE_DEST_n initialization parameter control the data availability mode of a Data Guard standby database? ()ASYNC or ASYNC to identify the network transmission mode.BLGWR or ARCH to identify the primary database process responsible for sending redo information to the standby.CAFFIRM or NOAFFIRM to control whether log archiving disk write operations are to be performed synchronously or asynchronously.DPROTECTED or UNPROTECTED to control the degree of divergence and data loss at the standby database.
问题:单选题Examine the RMAN command: SWITCH DATAFILE ’/DISK3/user_data01.dbf’; Which command do you need to issue before you issue the above command, so that RMAN finds the file in the restored location of ’DISK2/user_data01.dbf’? ()A RESTORE DATAFILE ’/DISK2/user_data01.dbf’B RESTORE DATAFILE ’/DISK3/user_data01.dbf’C SET NEWNAME FOR ’/DISK3/user_data01.dbf’ TO’/DISK2/user_data01.dbf’D SET NEWNAME FOR ’/DISK2/user_data01.dbf’ TO’/DISK3/user_data01.dbf’
问题:单选题Which of the following roles must be granted to a user to perform a full database import?()A CONNECTB IMP_FULL_DATABASEC FULL_EXPORT_PRIVSD RESOURCEE FULL_IMPORT_PRIVS
问题:单选题The EMPLOYEES table is stored in the SAMPLE tablespace. The corresponding IPK_EMP index for the EMPLOYEES table’s primary key is stored in the INDX tablespace. Out of 12 partitions, only partition P1 of the SALES table is stored in the SAMPLE tablespace. Which object will be exported by this command?() exp system/manager tablespaces=SAMPLEA Only the EMPLOYEES table.B Only the EMPLOYEES table and its corresponding primary key index.C The EMPLOYEES table and partition P1.D The EMPLOYEES table, IPK_EMP index, and the SALES table.
问题:单选题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
问题:单选题What criterion does Oracle9i use to determine whether a database file is an Oracle Managed File?()A The filename format. B Information stored inside a data dictionary table. C Information stored in the ALERT.LOG file for the corresponding instance. D Information stored inside the corresponding initialization parameter file for the instance.
问题:单选题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 belonging to the SYSTEM tablespace and the damaged or lost data files.
问题:多选题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.EDirect-path export can be used to export rows containing LOBs and BFILEs.
问题:多选题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 table.BInvoke the dbms_redefinition.can_redef_table procedure.CInvoke the dbms_redefinition.sync_interim_table procedure.DCreate any triggers, indexes, or constraints on the interim table.ECreate an empty interim table with all the desired characteristics.
问题:单选题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 DB01,DB02,and RC01.
问题:单选题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 this scenario?()A direct-path loadB conventional path load