1Z0-031 题目列表
单选题To allocate another role to a user, which command is most appropriate?（）AALTER USER BALTER DATABASE CALTER SYSTEM DGRANT
单选题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?（）AIssue ALTER DATABASE BACKUP CONTROLFILE TO filenameBMake a copy of the control file with the database shut downCIssue ALTER DATABASE BACKUP CONTROLFILE TO traceDMake a copy of the control file with the database still running
单选题Which of the following choices identifies a database component that will be used for multiplexing control files?（）AV$CONTROLFILE BV$DATABASE Cinit.ora DDBA FILES
单选题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?（）AV$SESSION BV$SYSSTAT CDBA_SEGMENTS DV$SORT_USAGE
单选题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?（）ALOGICAL_READS_PER_SESSION BCONNECT_TIME CCOMPOSITE_LIMIT DCPU_PER_SESSION EPRIVATE_SGA
单选题Which of the following choices identifies a database component that will be used for multiplexing control files?（）AV$CONTROLFILE BV$DATABASE Cinit.ora DDBA FILES
单选题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?（）AAcquire locks on table queried BGenerate redo for statement CFetch data from disk into memory DWrite changes to disk
单选题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 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
单选题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?（）AThe value for MINEXTENTS setting BThe value for PCTINCREASE setting CThe value for MAXEXTENTS setting DBy default, Oracle allocates six extents to all database objects
单选题Which of the following operations does not require Oracle to store information in an UNDO segments as part of the transaction?（）AINSERT BSELECT CUPDATE DDELETE
单选题Your application regularly issues the following statement: SELECT * FROM BANK_ACCT WHERE ACCT_BALANCE BETWEEN 1000 and 10000; Which of the following database objects would be inappropriate for use with this statement?（）AMaterialized views BIndexes CIndex-organized tables DHash clusters
单选题You issue the following command in Oracle: CREATE TABLESPACE DAT_TBS DATAFILE "dat_tbs.dbf" SIZE 2M;. Later queries against the database reveal that the tablespace is located in the /u01/oradata/oracle directory. Which of the following choices identifies how Oracle likely determined what directory to place dat_tbs.dbf file in?（）ADB_CREATE_FILE_DEST BDB_CREATE_ONLINE_LOG_1 CDB_CREATE_ONLINE_LOG_2DThe directory is an operating system-specific default value in Oracle that can neigher be specified manually nor changed
单选题During regular database operation, which background process will take smaller blocks of free space in a dictionary-managed tablespace and move things around to make bigger pieces of free space?（）ADBW0 BLGWR CARCH DSMON EPMON
单选题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.