Weekend Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

examout.co

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?

A.

Extend the logical volume by 10 MB where the data files are stored;

# lvextend -L+10M /diskl

B.

Add a data file:

SQL>ALTER TABLESPACE MYTBS ADD DATAFILE ' /disk1/mytbs_2 .dbf SIZE 10M;

C.

Move 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;

D.

Resize 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';

Which statement about Storage Snapshot Optimization is correct?

A.

It enables you to use third-party technologies to take a storage snapshot of your database without putting the database in BACKUP mode. You can then use the snapshot to recover all or part of the database.

B.

It enables you to use RMAN to take a storage snapshot of your database. The database must be in BACKUP mode. You can then use the snapshot to recover all or part of the database.

C.

It enables you to use RMAN to take a storage snapshot of your database. The database doesn't have to be in BACKUP mode. You can then use the snapshot to recover all or part of the database.

D.

It enables you to use third-party technologies to take a storage snapshot of your database. The database must be in BACKUP mode. You can then use the snapshot to recover all or part of the database.

You need to recover a database running In NOARCHIVELOG mode. Which two statements are true in this scenario?

A.

You can perform complete recovery by using the command:

RESTORE DATABASE

FROM TAG“consistent_whole_backup”;

RECOVER DATABASE;

B.

You can perform incomplete recovery by using the command:

RESTORE DATABASE;

FROM TAG "consistent_whole_backup";

RECOVER DATABASE NOREDO;

C.

Only consistent backups can be used for restoring a database in NOARCHIVELOG mode.

D.

Media recovery is possible in most cases.

Which logical storage relationship is correct?

A.

Tablespace< Segment < Extent < Oracle Datablock

B.

B) Segment < Extent < Oracle Datablock

C.

Tablespace< Extent < Segment < Oracle Datablock

D.

Data File

Which tool is recommended for moving a PDB to a non-CDB?

A.

RMAN

B.

Cold Backup

C.

Traditional Export / Import

D.

Data Pump

E.

SQL*Plus