当前分类： 1Z0-031
问题：单选题he DBA is about to enable auditing on the Oracle database in an attempt to discover some suspicious activity. Audit trail information is stored in which of the following database object names?（）A SYS.SOURCE$ B SYS.AUD$ C DBA_SOURCE D DBA_AUDIT_TRAIL...
查看答案
问题：单选题The DBA is defining role for users. Which of the following is not an acceptable method for defining a default role?（）A ALTER USER DEFAULT ROLE ALLB ALTER USER DEFAULT ROLE ALL EXCEPT ROLE_1C ALTER USER DEFAULT ROLE NONED ALTER USER DEFAULT ROLE NONE EX...
问题：单选题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?（）A Nothing happensB Oracle will automatically switch redo logs when detected C Oracle eventually won'...
问题：单选题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 informati...
问题：单选题Flushing dirty buffers out of the buffer cache is influenced to the greatest extent by which of the following process?（）A ARCH B SMON C LGWRD SERVER...
问题：单选题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 analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? （）A Library cache B Row cacheC Dictionary cache D Large area E Buffer cache...
问题：单选题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...
问题：单选题To allocate another role to a user, which command is most appropriate?（）A ALTER USER B ALTER DATABASE C ALTER SYSTEM D GRANT...
问题：单选题You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?（）A V$DATABASE B DBA_TABLES C SYSAUD$ D EMP...
问题：单选题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 attempting to increase the checkpoint interval on your database. Each of the following choices will affect the duration and/or frequency of checkpoints, except one. Which is it?（）A Size of redo logs B Number of datafiles C LOG_CHECKPOINT_INTER...
问题：单选题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?（）A DROP TABLE B ALTER TABLE C RESIZE D COALESCE...
问题：单选题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...
问题：单选题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...
问题：单选题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...
问题：单选题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 anticipat...
问题：单选题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 identifi...
