A.clusters

B.sequences

C.index

D.tables

E.stored procedures

F.undo

A.The file is renamed and stored in the same location

B.If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.

C.DML may be performed on tables with one or more extents in this data file during the execution of this command.

D.The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.

E.The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.

A.Oracle Managed Files (OMF)

B.Online table segment shrink

C.Online index segment shrink

D.Automatic data file extension (AUTOEXTEND)

E.Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR)

A.Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error

B.Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error

C.The WITH CHECK clause prevents certain rows from being updated or inserted

D.The WITH CHECK clause prevents certain rows from being displayed when querying the view

E.Tables in the defining query of a view must always exist in order to create the view

F.Views can be updated without the need to re-grant privileges on the view

G.Data Manipulation Language (DML) can always be used on views

A.It uses the database default blocksize

B.It is a locally managed tablespace

C.It must be smaller than the smallest BIGFILE tablespace

D.Any data files added to the tablespace must have a size of 5 gigabytes

E.Free space is managed using freelists