What does a Control file Contain?

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: Use the buffer cache advisory over a given workload and then query the v$db_cache_advice table If a change was necessary then I would use the alter system set db_cache_size command

Correct Answer: Disable the foreign key constraint to the parent, drop the table, re-create the table, enable the foreign key constraint

Correct Answer: UPDATE and DELETE Restrict - A referential integrity rule that disallows the update or deletion of referenced data DELETE Cascade - When a referenced row is deleted all associated dependent rows are deleted

Correct Answer: Complete database recovery from disk failure is possible only in ARCHIVELOG mode Online database backup is possible only in ARCHIVELOG mode

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 ;