You issue the following SQL statement to re-create your database and reuse all the existing database files:

CREATE DATABASE Sales

DATAFILE

'/u01/oradata/Sales/system0l.dbf'

SIZE 100M REUSE

LOGFILE

GROUP 1 ('/u01/oradata/Sales/logla.rdo',

'/u02/oradata/Sales/loglb.rdo')

SIZE 50K REUSE,

GROUP 2 ('/u01/oradata/Sales/log2a.rdo',

'/u02/oradata/Sales/log2b.rdo')

SIZE 50K REUSE

MAXLOGFILES 5

MAXLOGHISTORY 100

MAXDATAFILES 10;

The CREATE DATABASE statement fails. Why?

Your company hires a DBA named Allen. He will be starting the database remotely, as he is going to work from home. You created a password file for your database and set REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE in the parameter file. Which of the following commands will help you add Allen to the password file to allow him to have remote DBA access?

You check the alert log for your database and discover that there are many lines that say 'Checkpoint Not Complete' Which of the following options help solve this problem?

Extents are logical collection of contiguous _________________.