当前分类: 1Z0-031
问题:单选题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...
查看答案
问题:单选题To allocate another role to a user, which command is most appropriate?()A ALTER USER B ALTER DATABASE C ALTER SYSTEM D GRANT...
问题:单选题Which of the following choices correctly describes the difference between a data load via the conventional path and the direct path?()A One runs faster than the otherB A conventional path data load bypasses most of the Oracle RDBMS, whereas a direct pa...
问题:单选题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...
问题:单选题You are creating tablespaces in Oracle. Which of the following keywords or clauses permits the datafiles of a database to grow automatically in order to accommodate data growth?()A DEFAULT STORAGE B EXTENT MANAGEMENT C AUTOEXTEND D DATAFILE...
问题:单选题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 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...
问题:单选题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 managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?()A When the instance is started B When the database is mounted C When the database is opened D When the datab...
问题:单选题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...
问题:单选题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 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 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 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 operations does not require Oracle to store information in an UNDO segments as part of the transaction?()A INSERT B SELECT C UPDATE D DELETE...
问题:单选题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....