单项选择题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


您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题To allocate another role to a user, which command is most appropriate?()

A.ALTER USER 
B.ALTER DATABASE 
C.ALTER SYSTEM 
D.GRANT

3.单项选择题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 information to disk 
D.Reads information into memory for users

4.单项选择题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 ALL
B.ALTER USER DEFAULT ROLE ALL EXCEPT ROLE_1
C.ALTER USER DEFAULT ROLE NONE
D.ALTER USER DEFAULT ROLE NONE EXCEPT ROLE_1

6.单项选择题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 happens
B.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

8.单项选择题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 datafile
B.Many tablespaces can share one datafile
C.One tablespace can have many datafiles
D.One datafile can contain many tablespaces

最新试题

You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?()

题型:单项选择题

To allocate another role to a user, which command is most appropriate?()

题型:单项选择题

You are analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?()

题型:单项选择题

Your application regularly issues the following statement: SELECT * FROM BANK_ACCT WHERE ACCT_BALANCE BETWEEN 1000 and 10000; Which of the following database objects would be inappropriate for use with this statement?()

题型:单项选择题

Records from the data dictionary information are stored in which of the following database memory areas?()

题型:单项选择题

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?()

题型:单项选择题

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?()

题型:单项选择题

During regular database operation, which background process will take smaller blocks of free space in a dictionary-managed tablespace and move things around to make bigger pieces of free space?()

题型:单项选择题

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?()

题型:单项选择题

 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?()

题型:单项选择题