问题：单选题You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）A One tablespace has only one datafileB Many tablespaces can share one datafileC One tablespace can...
Wednesday, February 12, 2025
问题：单选题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...
Saturday, January 4, 2025
问题：单选题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 ...
Saturday, June 14, 2025
问题：单选题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 ...
问题：单选题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...
问题：单选题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 ar...
Tuesday, May 13, 2025
问题：单选题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 in...
问题：单选题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 R...
问题：单选题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...
问题：单选题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...
问题：单选题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...
问题：单选题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
问题：单选题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...
问题：单选题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...
问题：单选题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...
问题：单选题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...
Friday, February 21, 2025
