Tag: databases

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).

data file

password file

archivelog file

temporary file

online redo log file

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.

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.

Hot backup

Online backup

consistent backup

incremental backup

inconsistent backup

col$

aud$

row$

none

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

SQL Programming Using File Input

SQL Processing Using File Input

SQL Processor Using File Input

Sequence Processing Using File Input

Complex Key

Secondary Key

Composite Key

Foreign Key

a database directory

a database tablespace

a database bufferpool

a database column