How can you rebuild an index?

Correct Answer: ALTER DATABASE DATAFILE RESIZE ;

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: 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

Correct Answer: SQL * DBA - This allows DBA to monitor and control an ORACLE database SQL * Loader - It loads data from standard operating system files (Flat files) into ORACLE database tables Export (EXP) and Import (imp) utilities allow you to move existing data in ORACLE format to and from ORACLE database