问题：单选题By default, checkpoints happen at least as often as（）.A Redo log switches. B UPDATE statements are issued against the database. C The SYSTEM tablespace is accessed. D SMON coalesces free space in a tablespase.
查看答案
问题：单选题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
问题：单选题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
问题：单选题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 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
问题：单选题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
问题：单选题When determining the number of UNDO segments in a database, which of the following choices identifies a factor to consider? （）A Size of typical transactions B Concurrent transactions C Size of rows in table most frequently changed D Number of anticipated disk sorts
问题：单选题When an UNDO segment is created manually by you, its availability status is set to which of the following automatically by Oracle?（）A Online B Pending online C Offline D Stale
问题：单选题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
问题：单选题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
问题：单选题If you wanted to find the name and location of your control files, you could find that information in each of the following locations except one. Which is it?（）A V_CONTROLFILE_RECORD_SECTION B V_CONTROLFILE C V$PARAMETER D init.ora file
问题：单选题You are configuring your index to be stored in a tablespace. Which of the following storage parameters are NOT appropriate for indexes?（）A OPTIMAL B INITIAL C PCTINCREASE D NEXT
问题：单选题You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?（）A Immediately following statement execution B After the ALTER TABLE DROP UNUSED COLUMNS command is issued C After the ALTER TABLE SET UNUSED COLUMN command is issued D After the ALTER TABLE MODIFY command is issued
问题：单选题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?（）A Materialized views B Indexes C Index-organized tables D Hash clusters
问题：单选题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
问题：单选题To allocate another role to a user, which command is most appropriate?（）A ALTER USER B ALTER DATABASE C ALTER SYSTEM D GRANT
问题：单选题In order to enable remote administration of users and tablespaces on an Oracle database, which of the following types of files must exist in the database?（）A Password file B Initialization file C Datafile D Control file E Nothing - SYSDBA privileges are not required for these actions
