Backup and Recovery short questions for exercise

1. TCO E - Oracle backup and recovery is actually broken up into ____
separate actions. (Points: 2)
i) three
ii) four
iii) five
iv) six


2. TCO E - ____ logs are copies of old redo log files, copied just
before redo log files are reused. (Points: 2)
i) Archive
ii) Recovery
iii) Control
iv) Undo


3. TCO E - A(n) ____ backup is the easiest method of backup and
recovery. (Points: 2)
i) cold
ii) hot
iii) automated
iv) manual


4. TCO E - A(n) ____ backup or recovery requires a database to be
completely shut down for the backup, and sometimes the recovery
process as well. (Points: 2)
i) cold
ii) hot
iii) automated
iv) manual


5. TCO E - A(n) ____ backup is a backup performed when the database is
online, active, and available for use. (Points: 2)
i) cold
ii) hot
iii) online
iv) active


6. TCO E - A(n) ____ standby database can potentially pass log entries
to a standby database server, log entry by log entry. In other words,
each transaction is applied to the standby immediately after
application to the primary database. (Points: 2)
i) dynamic
ii) online
iii) logical
iv) physical


7. TCO E - ____ logs are files that are copied from redo logs when a
redo log file is switched out for recycling. (Points: 2)
i) Archive
ii) Undo
iii) Backup
iv) Recovery


8. TCO E - Flashback technology relies generally on a combination of
undo data, and ____. (Points: 2)
i) archive logs
ii) redo logs
iii) the recycle bin
iv) undo logs


9. TCO E - A ____ backup creates both DDL commands and DML commands,
to re-create a database object (it uses the database SQL engine).
(Points: 2)
i) tablespace
ii) logical
iii) physical
iv) consistent


10. TCO E - What mode do you need to start the database in if you are
going to put it in Archive Log mode? (Points: 2)
i) Open
ii) Nomount
iii) Mount
iv) Suspended

1. Describe how PL/SQL uses blocks to structure a query. Describe at
least three characteristics of blocks. (Points: 15)

2. TCO G: Many experts state that all DML executed by an application
should be performed through a stored procedure. This is especially
true of update statements. State the reasons for this position,
including performance, security, and any other relevant rationale.
(Points: 15)