Oracle认证考试
单选题 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?()
单选题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?()
单选题You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?()
单选题Which component of the SGA stores parsed SQL statements is used for process sharing?()
单选题You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?()
单选题Flushing dirty buffers out of the buffer cache is influenced to the greatest extent by which of the following process?()
单选题Which of the following choices correctly describes the difference between a data load via the conventional path and the direct path?()
单选题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?()
单选题When an UNDO segment is created manually by you, its availability status is set to which of the following automatically by Oracle?()
单选题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?()
单选题You are attempting to clear an unarchived redo log file. In order to manually enact a log switch, which of the following statements is appropriate?()
单选题In order to find out how many database objects a user has created, which view would the DBA query in the Oracle data dictionary? ()
单选题You are configuring your index to be stored in a tablespace. Which of the following storage parameters are NOT appropriate for indexes?()
单选题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? ()
单选题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 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?()
单选题The user is trying to execute a SELECT statement. Which of the following background processes will obtain data from a disk for the user?()
单选题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?()
单选题When determining the number of UNDO segments in a database, which of the following choices identifies a factor to consider? ()
单选题The rows inside three Oracle tables supporting a customer order entry system are frequently accessed together by means of a table join. Because data is always being added to the tables, you leave a lot of extra space inside each block to accommodate growth. Which of the following types of tables would be useful for storing the data in this context?()
当前列表仅展示前20条试题,搜“题王”小程序查看更多考题~