Oracle
1Z0-497 · Question #56
1Z0-497 Question #56: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-497 to reveal the answer and full explanation for question #56. The question stem and answer options stay visible for context.
Question
Examine the statements: SQL> CREATE TABLESPACE MYTBS DATAFILE '/disk1/mytbs_l.dbf ' SIZE 10M; SQL> CREATE TABLE mytab (id NUMBER, descr VARCHAR2 (100) ) PARTITION BY RANGE(id) ( partition pi values loss than (100000) tablespacemytbs storage (initial lm), partition p2 values less than (MAXVALUE) tablespacemytbs storage (initial 1m) ); When inserting data, you get the error: ORA-01688: unable to extend table SYS.MYTAB partition P2 by 128 in tablespace MYTBS Which three operations would allow you to insert data without getting the error message?
Options
- AExtend the logical volume by 10 MB where the data files are stored; # lvextend -L+10M /diskl
- BAdd a data file:
- CMove a partition to another tablespace:
- DResize the existing data file:
Unlock 1Z0-497 to see the answer
You've previewed enough free 1Z0-497 questions. Unlock 1Z0-497 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.