Explain the backup mechanisms used by Oracle9i.
What will be an ideal response?
Oracle has utilities to perform the logical backup or physical backup at the data level. The
logical backup utility export, or EXP, copies all SQL statements to re-create all database
objects and insert data as well. The export can be at the database, schema, table or user
level. The backed up data with EXP can be recovered on different platforms with different
operating systems and different versions of Oracle. The backup format with EXP is
proprietary to Oracle. The import or IMP utility copies the logical backup of data back to the
database. A cold backup is performed on database, when it is down, or “cold.” When a
database is running in archive log mode, Oracle saves the redo log into archive log
files. These files can be used to reconstruct transactions after the last backup. The database
can be backed up while it is running, or “hot”; such a backup is called the hot backup. The
archive log files can be used with cold as well as hot backups. The recovery manager
(RMAN) manages cold backup, hot backup, and the archive log files. The RMAN also
enables you to perform incremental hot backups but does not support export. There are
many third-party tools available for backup and recovery of a database.
You might also like to view...
When a video is created, the resulting file is saved as a(n):
A) temporary file in the Videos library. B) Windows Media Video file on the Desktop. C) MP3 file in the Videos library. D) .mp4 file in the same location as the presentation file.
Answer the following statements true (T) or false (F)
1) The foreach statement can be used only with one-dimensional arrays. 2) One could iterate through multi-dimensional arrays by using nested for loops. 3) Variable-length argument lists allow you to create methods that receive an arbitrary number of arguments. 4) The params modifier can be used anywhere in the method’s header. 5) When an app is executed from the Command Prompt, the execution environment passes the command-line arguments to the Main method as a string.
The file type GIF shown in the accompanying figure is an abbreviation for ____________________.
Fill in the blank(s) with the appropriate word(s).
Which of the following will set a cookie to expire in 30 days?
a. ``` time() + 30 ``` b. ``` time() + (24 * 60 * 60) + 30 ``` c. ``` time() + (30 * 86400) ``` d. ``` time(30 * 60 * 60) ```