Oracle Exam 1Z0-497 Topic 2 Question 53 Discussion

Actual exam question for Oracle's 1Z0-497 exam

Question #: 53
Topic #: 2

[All 1Z0-497 Questions]

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?

AExtend the logical volume by 10 MB where the data files are stored;
# lvextend -L+10M /diskl

BAdd a data file:
SQL>ALTER TABLESPACE MYTBS ADD DATAFILE ' /disk1/mytbs_2 .dbf SIZE 10M;

CMove a partition to another tablespace:
SQL> CREATE TABLESPACE ADDITIONAL_TBS DATAFILE '/disk1/additional_tbs_1 .dbf' SIZE 10M;
SQL> ALTER TABLE MYTAB MOVE PARTITION P2 TABLESPACE ADDlTIONAL_TBS;

DResize the existing data file:
SQL> ALTER DATABASE DATAFILE '/diskl/mytbs_l .dbf' RESIZE 20M;
E) Remove a data file:
SQL> ALTER TABLESPACE MYTBS DROP DATAFILE '/diskl/mytbs_l - dbf';

Show Suggested Answer

Suggested Answer: B, C, D

by Sarah at May 05, 2022, 01:05 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-497 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!