1Z0-067 Question #160: Real Exam Question with Answer & Explanation

The correct answer is A. ALTER TA3LESPACE adtbs RESI2E 20G; C. ALTER TABLESPACE adtbs AUTOEXTEND ON;. You can't add a datafile to a bigfile tablespace. A and C seem the most likely. The syntax for E doesn't seem correct either. A & C are the correct answers. SQL> CREATE BIGFILE TABLESPACE bigfile_tbs DATAFILE SQL> '/orabin/nonerp/12102_home/data/CDB/PDB1/bigfile.dbf' SIZE 1G; Tab

Question

You created a tablespace with this statement: CREATE BIGFILE TABLESPACE adtbs DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G; The tablespace is nearly full and you need to avoid any out of space errors for the load of a 5 gig table. Which two alter statements will achieve this?

Options

AALTER TA3LESPACE adtbs RESI2E 20G;
BALTER TA3LESPACE adtbs ADD DATAFILE;
CALTER TABLESPACE adtbs AUTOEXTEND ON;
DALTER TA3LESPACE adtbs ADD DATAFILE '/proddb/data/adtbsl.dbf' SIZE 1QG;
EALTER TA3LESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf AUTOEXTEND ON;

Explanation

You can't add a datafile to a bigfile tablespace. A and C seem the most likely. The syntax for E doesn't seem correct either. A & C are the correct answers. SQL> CREATE BIGFILE TABLESPACE bigfile_tbs DATAFILE SQL> '/orabin/nonerp/12102_home/data/CDB/PDB1/bigfile.dbf' SIZE 1G; Tablespace created. SQL> ALTER TABLESPACE bigfile_tbs resize 1G; Tablespace altered. SQL> ALTER TABLESPACE bigfile_tbs AUTOEXTEND ON; Tablespace altered. SQL> ALTER TABLESPACE bigfile_tbs ADD DATAFILE; ALTER TABLESPACE bigfile_tbs ADD DATAFILE ERROR at line 1: ORA-02236: invalid file name SQL> ALTER TABLESPACE bigfile_tbs ADD DATAFILE SQL> '/orabin/nonerp/12102_home/data/CDB/PDB1/bigfile2.dbf' size 10M; ALTER TABLESPACE bigfile_tbs ADD DATAFILE '/orabin/nonerp/12102_home/data/CDB/PDB1/bigfile2.dbf' size 10M ERROR at line 1: ORA-32771: cannot add file to bigfile tablespace SQL> ALTER TABLESPACE bigfile_tbs MODIFY DATAFILE SQL> '/orabin/nonerp/12102_home/data/CDB/PDB1/bigfile.dbf' AUTOEXTEND ALTER TABLESPACE bigfile_tbs MODIFY DATAFILE '/orabin/nonerp/12102_home/data/CDB/PDB1/bigfile.dbf' AUTOEXTEND ON ERROR at line 1: ORA-02142: missing or invalid ALTER TABLESPACE option

Community Discussion

No community discussion yet for this question.

Full 1Z0-067 Practice