问题:多选题Using a bitmap structure to manage database object space has several benefits over using freelist structures. Which three are benefits of managing space using automatic-segment-space managed objects?()AIt readily responds to dynamic changes for concurr...
查看答案
问题:多选题Which four occur during the processing of a request using Oracle Shared Server?()AThe dispatcher returns the response to the user.BThe dispatcher places the request into the request queue.CThe shared server places the response in the response queue.DTh...
问题:多选题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 ...
问题:单选题What is the maximum database block size supported for the Oracle9i database?()A 16KBB 32KBC 64KBD 128KB...
问题:多选题Automatic Consumer Group Switching is an important new feature of the Database Resource Manager. Which three plan directive parameters are used to control this feature?()ASWITCH_TIMEBSWITCH_GROUPCMAX_SESS_POOLDSWITCH_ESTIMATE...
问题:单选题Which step is required for recover from an instance failure? ()A Start up only.B Restore needed data files, then start up.C Complete restore from backup, then start up.D Perform point in time recovery, then start up....
问题:多选题SQ L*Loader is a utility that can perform which two tasks?()ALoad data from a disk, tape, or named pipes.BLoad data into an Oracle database using DML statements.CExtract, reorganize, and insert data within an Oracle database.DLoad data from external fi...
问题:单选题Which statement correctly describes the function of Oracle9i Cache Fusion feature?()A It provides each session with its own view of the database at a different point in the past. B It enables you to execute scalable applications on a clustered database...
问题:单选题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 ...
问题:单选题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...
问题:单选题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 of the following statement is incorrect regarding RMAN...
问题:When performing an incomplete recover of the whole database,...
问题:单选题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...
问题:多选题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...
问题:单选题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...
问题:多选题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...
问题:单选题Consider this syntax: MERGE INTO t1 USING t2 ON (join predicate)….. What does the MERGE syntax do?()A It performs a merge join of the row from T2 only if it doesn’t exist in the T1 table. B It creates a natural join of tables T1 and T2 for all col...
问题:单选题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...