Question No 1

Examine this command ALTER DATABASE MOVE DATAFILE '/u01/sales01.dbf' TO '/u02/sales02.dbf'; Which two statements are true?

Choose the Choices:

DML may be performed on tables with one or more extents in this data file during the execution of this command.

It overwrites any existing file with the name sales02.dbf in /u02 by default.

The "TO" clause containing the new file name must be specified even if Oracle Managed Files (OMF) is used.

Compressed objects in sales01.dbf will be uncompressed in sales02.dbf after the move.

Tables with one or more extents in this data file may be queried during the execution of this command.

Question No 2

You execute this command CREATE SMALLFILE TABLESPACE sales DATAFILE '/u01/app/oracle/sales01.dbf' SIZE 5G SEGMENT SPACE MANAGEMENT AUTO; Which two statements are true about the SALES tablespace?

Choose the Choices:

Free space is managed using freelists.

It uses the database default block size.

It must be smaller than the smallest BIGFILE tablespace.

It is a locally managed tablespace.

Any data files added to the tablespace must have a size of 5 gigabytes.

Question No 3

Your data center uses Oracle Managed Files (OMF) for all databases. All tablespaces are smallfile tablespaces. SALES_Q1 is a permanent user - defined tablespace in the SALES database. The following command is about to be issued by a DBA logged in to the SALES database ALTER TABLESPACE sales_q1 ADD DATAFILE; Which two actions independently ensure that the command executes successfully?

Choose the Choices:

Specify a path in the DATAFILE clause of the command specifying a location with at least 100 MB of available space.

Add the AUTOEXTEND ON clause with NEXT set to 100M.

Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 MB of available space.

Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 MB of available space.

Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 MB of available space.

Question No 4

Which three are benefits of using temp UNDO when performing DML on global temporary tables?

Choose the Choices:

It permits DML on global temporary tables even if the database is opened read - only.

It reduces the amount of UNDO stored in the UNDO tablespace.

It reduces I/Os to the SYSTEM tablespace.

It reduces the amount of redo generated.

It reduces I/Os to the SYSAUX tablespace.

Question No 5

You want to view the initialization parameter settings for only a specific PDB. Which of the following statements is true?

Choose the Choices:

From the PDB, execute SELECT db_uniq_name, pdb_uid, name, value$ FROM pdb_spfile$;

From the CDB root, execute SELECT NAME, VALUE, ISPDB_MODIFIABLE FROM v$parameter;

From the CDB root, execute SELECT db_uniq_name, pdb_uid, name, value$ FROM pdb_spfiles;

From the PDB, execute SELECT NAME, VALUE, ISPDB_MODIFIABLE FROM v$parameter;

Practice Oracle 1Z0-182 Exam Questions

Question No 1

Question No 2

Question No 3

Question No 4

Question No 5

1Z0-182 Exam Features

1Z0-182 PDF Dumps