How do you resize a data file?

Correct Answer: ALTER TABLESPACE ADD DATAFILE SIZE

Correct Answer: Coalescing is only valid for dictionary-managed tablespaces and de-fragments space by combining neighboring free extents into large single extents

Correct Answer: ALTER SYSTEM SWITCH LOGFILE;

Correct Answer: Redo logs are logical and physical structures that are designed to hold all the changes made to a database and are intended to aid in the recovery of a database

Correct Answer: A Control file records the physical structure of the database It contains the following information Database Name ,Names and locations of a database?s files and redolog files Time stamp of database creation

Correct Answer: ALTER INDEX REBUILD;

Correct Answer: Use the DBMS_SESSIONSET_SQL_TRACE or Use ALTER SESSION SET SQL_TRACE = TRUE;

Correct Answer: A distributed database is a network of databases managed by multiple database servers that appears to a user as single logical database The data of all databases in the distributed database can be simultaneously accessed and modified

Correct Answer: Group of tables physically stored together because they share common columns and are often used together is called Cluster

Correct Answer: To perform one of these function on an index, table, or cluster: - To collect statistics about object used by the optimizer and store them in the data dictionary - To delete statistics about the object used by object from the data dictionary - To validate the structure of the object - To identify migrated and chained rows off the table or cluster