Which statement regarding an incomplete recovery is true(10g)?
You do not need to restore all the data files.
You do not need to open the database with the RESETLOGS operation
You do not need to perform a full backup after the RESETLOGS operation.
You do not need to recover all the data files to the same system change number (SCN).
Which file is not supported with RMANBACKUP command?
data file
password file
archivelog file
temporary file
online redo log file
Which condition in your database forces you to perform only consistent backups?
The database is in mount state.
One of the tablespaces is offline.
One of the tablespaces is read only.
The database operates in ARCHIEVELOG mode.
The database operates in NOARCHIEVELOG mode.
Which statement regarding the contents of the V$PARAMETER view is true?
Displays only the list of default values
Displays only the list of all basic parameters
Displays the currently in effect parameter values
Displays only the list of all advanced parameters
Displays the list of all the parameter files of a database
Displays the current contents of the server parameter file.
Which type of backup would be appropriate in NOARCHIVELOG mode?
Hot backup
Online backup
consistent backup
incremental backup
inconsistent backup
Which is the only sys view which can be modified ?
col$
aud$
row$
none
What is meant by an index scan
When an entire index is scanned to locate rows we call it as index scan
When only part of the index is scanned to locate rows we call it as index scan
When all the rows are scanned we call it as index scan
None of the above
What does SPUFI stands for
SQL Programming Using File Input
SQL Processing Using File Input
SQL Processor Using File Input
Sequence Processing Using File Input
A key made up of more than one column is called
Complex Key
Secondary Key
Composite Key
Foreign Key
For which database object can a lock be obtained
a database directory
a database tablespace
a database bufferpool
a database column