Tag: technology

Quizzes (307) Questions (36705)

Questions Related to technology

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
Full explanation