No DATAFILE sub clause is specified for the UNDO TABLESPACE clause - Oracle DB

Q.  Which sub clause is specified for the UNDO TABLESPACE clause in Specifying Oracle-Managed Files at Database creation?

- Published on 30 Jul 15

a. No LOGFILE
b. No SYSAUX DATAFILE
c. No DATAFILE
d. No TEMPFILE

ANSWER: No DATAFILE

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 30 Sep 15
    - You can minimize the number of clauses and parameters that you specify in your CREATE DATABASE statement by using the Oracle-managed files feature.

    - You do this by specifying either a directory or Automatic Storage Management (ASM) disk group in which your files are created and managed by Oracle Database.

    No LOGFILE
    - These clauses are included, so that the database creates two Oracle-managed redo log file groups.

    No SYSAUX DATAFILE
    - This is included, so that the database creates an Oracle-managed datafile for the SYSAUX tablespace.

    No DATAFILE
    - This subclause is specified for the UNDO TABLESPACE and DEFAULT TABLESPACE clauses, so the database creates an Oracle-managed datafile for each of these tablespaces.

    No TEMPFILE
    - This subclause is specified for the DEFAULT TEMPORARY TABLESPACE clause, so the database creates an Oracle-managed tempfile.

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲