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


您可能感兴趣的试卷

你可能感兴趣的试题

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

最新试题

When an UNDO segment is created manually by you, its availability status is set to which of the following automatically by Oracle?()

题型:单项选择题

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

题型:单项选择题

In order to enable remote administration of users and tablespaces on an Oracle database, which of the following types of files must exist in the database?()

题型:单项选择题

The DBA is defining role for users. Which of the following is not an acceptable method for defining a default role?()

题型:单项选择题

You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?() 

题型:单项选择题

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

题型:单项选择题

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

题型:单项选择题

he DBA is about to enable auditing on the Oracle database in an attempt to discover some suspicious activity. Audit trail information is stored in which of the following database object names?()

题型:单项选择题

Which of the following choices correctly describes the difference between a data load via the conventional path and the direct path?()

题型:单项选择题

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

题型:单项选择题