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: 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: ALTER SYSTEM SWITCH LOGFILE;

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 TABLESPACE ADD DATAFILE SIZE

Correct Answer: ALTER DATABASE DATAFILE RESIZE ;

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