Multiple choice technology programming languages

A database administrator needs to create a tablespace for an Oracle database. He formulates the following statement: CREATE TABLESPACE frgr DATAFILE ‘/g01/oracle/data/sasa01.dbf’ SIZE 100M EXTENT MANAGEMENT DICTIONARY AUTOALLOCATE DEFAULT STORAGE ( INITIAL 100K NEXT 100K MINEXTENTS 5 MAXEXTENTS 25 PCTINCREASE 0); LOGGING TEMPORARY

  1. By default, tables within the tablespace will not have all its changes written to redo.

  2. It is a locally managed tablespace.

  3. A temporary tablespace has been created.

  4. An error will be produced; the AUTOALLOCATE parameter should be removed
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In Oracle, the AUTOALLOCATE clause is only valid with EXTENT MANAGEMENT LOCAL. Specifying EXTENT MANAGEMENT DICTIONARY along with AUTOALLOCATE will result in a syntax error, so the statement fails and produces an error.

Keep practicing — related questions