问题:单选题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 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
问题:单选题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 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
问题:单选题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 have many datafilesD One datafile can contain many tablespaces
问题:单选题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
问题:单选题To determine the space allocated for temporary segments, the DBA can access which of the following views? ()A DBA_TABLESPACES B DBA_TABLES C DBA_SEGMENTS D DBA_FREE_SPACE
问题:单选题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't allow new records to be added to the database D The instance crashes
问题:单选题In order to find out how many database objects a user has created, which view would the DBA query in the Oracle data dictionary? ()A DBA_USERS B DBA_OBJECTS C DBA_TS_QUOTAS D DBA_TAB_PRIVS
问题:单选题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
问题:单选题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
问题:单选题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 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?()A DB_CREATE_FILE_DEST B DB_CREATE_ONLINE_LOG_1 C DB_CREATE_ONLINE_LOG_2D The directory is an operating system-specific default value in Oracle that can neigher be specified manually nor changed