问题:单选题You are attempting to clear an unarchived redo log file. In order to manually enact a log switch, which of the following statements is appropriate?()A ALTER DATABASE B ALTER SYSTEM C ALTER USER D ALTER REDO LOG
Tuesday, March 26, 2024
问题:单选题You are trying to determine how many disk sorts are happening on the database right now. Which of the following dictionary tables would you use to find that information?()A V$SESSION B V$SYSSTAT C DBA_SEGMENTS D V$SORT_USAGE
Thursday, March 14, 2024
问题:单选题Which of the following datatypes are used in situations where you want an ordered set of data elements, where every element is the same datatype, and where you predefine the number of elements that appear in the set?()A REF B TABLE C CLOB D VARRAY
Friday, April 12, 2024
问题:单选题You are analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?()A Writes buffers to disk B Writes current redo log number to datafile headers C Writes redo log information to disk D Reads information into memory for users
问题:单选题To allocate another role to a user, which command is most appropriate?()A ALTER USER B ALTER DATABASE C ALTER SYSTEM D GRANT
Friday, May 3, 2024
问题:单选题To determine the space allocated for temporary segments, the DBA can access which of the following views? ()A DBA_TABLESPACES B DBA_TABLES C DBA_SEGMENTS D DBA_FREE_SPACE
问题:单选题Which of the following choices identifies a database component that will be used for multiplexing control files?()A V$CONTROLFILE B V$DATABASE C init.ora D DBA FILES
问题:单选题ou are implementing control file multiplexing. Which of the following choices identifies the method you can use in order to generate the control file copies that Oracle will maintain?()A Issue ALTER DATABASE BACKUP CONTROLFILE TO filenameB Make a copy of the control file with the database shut downC Issue ALTER DATABASE BACKUP CONTROLFILE TO traceD Make a copy of the control file with the database still running
问题:单选题You are defining areas on your Oracle database. Which of the following profile areas can be used to control the resource usage for the other four?()A LOGICAL_READS_PER_SESSION B CONNECT_TIME C COMPOSITE_LIMIT D CPU_PER_SESSION E PRIVATE_SGA
问题:单选题You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?()A SYSTEM B OUTLN C INTERNAL D SYS
问题:单选题You are using the Database Configuration Assistant to configure your Oracle database. Which of the following terms pertains to the creation of an object from which creation of the other database can be based? ()A Clone B Copy C Template D Terminal
问题:单选题A user issues a SELECT command against the Oracle database. Which of the following choices describes a step that Oracle will execute in support of this statement?()A Acquire locks on table queried B Generate redo for statement C Fetch data from disk into memory D Write changes to disk
问题:单选题A table was just created on your Oracle database with six extents allocated to it. Which of the following factors most likely caused the table to have so many extents allocated?()A The value for MINEXTENTS setting B The value for PCTINCREASE setting C The value for MAXEXTENTS setting D By default, Oracle allocates six extents to all database objects
问题:单选题Which component of the SGA stores parsed SQL statements is used for process sharing?()A Buffer cache B Redo log buffer C Private SQL area D Library cache E Row cache
Wednesday, January 3, 2024
问题:单选题You have a long-running process you want to assign to a specific UNDO segment brought online for that express purpose. You are not using automatic UNDO management. What statement can be used for this task? ()A ALTER DATABASE B SET TRANSACTION C ALTER ROLLBACK SEGMENT D ALTER TABLE
问题:单选题Which of the following choices correctly describes the difference between a data load via the conventional path and the direct path?()A One runs faster than the otherB A conventional path data load bypasses most of the Oracle RDBMS, whereas a direct path load is a high-speed version of the SQL INSERTC A direct path data load bypasses most of the Oracle RDBMS, whereas a conventional path load is a high-speed version of the SQL INSERTD The conventional path runs when the CONVENTIONAL command-line parameter is set to TRUE
问题:单选题Which of the following operations does not require Oracle to store information in an UNDO segments as part of the transaction?()A INSERT B SELECT C UPDATE D DELETE
问题:单选题You have implemented OMF for redo log management. Which of the following choices reflects a log filename that might be employed when OMF is enabled?()A log01.log B logORCL01.log C 1_2.logALTER ROLLBACK SEGMENT D ora_1_asdf1234.log