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


您可能感兴趣的试卷

你可能感兴趣的试题

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

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

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

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

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

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

最新试题

Which of the following operations does not require Oracle to store information in an UNDO segments as part of the transaction?()

题型:单项选择题

You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? ()

题型:单项选择题

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

题型:单项选择题

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 configuring your index to be stored in a tablespace. Which of the following storage parameters are NOT appropriate for indexes?()

题型:单项选择题

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

题型:单项选择题

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 managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?()

题型:单项选择题

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

题型:单项选择题