Tag: databases

Quizzes (243) Questions (4862)

Questions Related to databases

Multiple choice technology databases

Archived Redo Log is

  1. It consists of Redo Log files that have archived before being reused.

  2. It consists of Redo Log files that have archived after being reused.

  3. It consists of Redo Log files that is archiving when currently being reused.

  4. It consists of Redo Log files that have archived not being reused.
Reveal answer Fill a bubble to check yourself
A Correct answer
Full explanation
Multiple choice technology databases

What is a Parallel Server

  1. Multiple instances accessing the same database (Only In Multi-CPU environments)

  2. Multiple instances accessing the same database (Only In single-CPU environments)

  3. Multiple instances accessing the different database (Only In single-CPU environments)

  4. Single instance accessing the multiple database (Only In Multi-CPU environments)
Reveal answer Fill a bubble to check yourself
A Correct answer
Full explanation
Multiple choice technology databases

To re-create a database, all existing database files should be reused. The following SQL statement is issued: CREATE DATABASE ABC DATAFILE '/u01/oradata/abc/system0l.dbf' SIZE 100M REUSE LOGFILE GROUP 1 ('/u01/oradata/abc/logla.rdo', '/u02/oradata/abc/loglb.rdo') SIZE 50K REUSE, GROUP 2 ('/u01/oradata/abc/log2a.rdo', '/u02/oradata/abc/log2b.rdo') SIZE 50K REUSE MAXLOGFILES 5 MAXLOGHISTORY 100 MAXDATAFILES 10; Why does the CREATE DATABASE statement fail?

  1. The MAXLOGFILES are set too low

  2. The CONTROLFILE REUSE clause is omitted

  3. The online redo log files cannot be reused

  4. The data file belonging to the SYSTEM tablespace cannot be reused
Reveal answer Fill a bubble to check yourself
B Correct answer
Full explanation