How do you add a data file to a tablespace?

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: You get this error when you get a snapshot too old within rollback It can usually be solved by increasing the undo retention or increasing the size of rollbacks You should also look at the logic involved in the application getting the error message

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