1Z0-031 题目列表
单选题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? （）AALTER DATABASE BSET TRANSACTION CALTER ROLLBACK SEGMENT DALTER TABLE
单选题You are trying to alter the initial segment size given to a table in a dictionary-managed tablespace. Which of the following keywords would be used as part of this process?（）ADROP TABLE BALTER TABLE CRESIZE DCOALESCE
单选题To determine the space allocated for temporary segments, the DBA can access which of the following views? （）ADBA_TABLESPACES BDBA_TABLES CDBA_SEGMENTS DDBA_FREE_SPACE
单选题Flushing dirty buffers out of the buffer cache is influenced to the greatest extent by which of the following process?（）AARCH BSMON CLGWRDSERVER
单选题The DBA is defining role for users. Which of the following is not an acceptable method for defining a default role?（）AALTER USER DEFAULT ROLE ALLBALTER USER DEFAULT ROLE ALL EXCEPT ROLE_1CALTER USER DEFAULT ROLE NONEDALTER USER DEFAULT ROLE NONE EXCEPT ROLE_1
单选题By default, checkpoints happen at least as often as（）.ARedo log switches. BUPDATE statements are issued against the database. CThe SYSTEM tablespace is accessed. DSMON coalesces free space in a tablespase.
单选题To allocate another role to a user, which command is most appropriate?（）AALTER USER BALTER DATABASE CALTER SYSTEM DGRANT
单选题You are analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?（）AWrites buffers to disk BWrites current redo log number to datafile headers CWrites redo log information to disk DReads information into memory for users
单选题You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?（）AV$DATABASE BDBA_TABLES CSYSAUD$ DEMP
单选题When determining the number of UNDO segments in a database, which of the following choices identifies a factor to consider? （）ASize of typical transactions BConcurrent transactions CSize of rows in table most frequently changed DNumber of anticipated disk sorts
单选题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? （）AClone BCopy CTemplate DTerminal
单选题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?（）Alog01.log BlogORCL01.log C1_2.logALTER ROLLBACK SEGMENT Dora_1_asdf1234.log
单选题In a situation where no multiplexing of redo logs takes place, what happens when Oracle cannot read data from the online redo log group for archiving?（）ANothing happensBOracle will automatically switch redo logs when detected COracle eventually won't allow new records to be added to the database DThe instance crashes
单选题You are analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?（）AWrites buffers to disk BWrites current redo log number to datafile headers CWrites redo log information to disk DReads information into memory for users
单选题When an UNDO segment is created manually by you, its availability status is set to which of the following automatically by Oracle?（）AOnline BPending online COffline DStale