Free 1Z0-062 Exam Dumps

Question 36

Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):
1Z0-062 dumps exhibit
Which three are prerequisites for successful execution of the command? (Choose three.)

A. The import operation must be performed by a user on the target database by a user with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user with the DATAPUMP_EXP_FULL_DATABASE role on the source database.
B. All the user-defined tablespaces must be in read-only mode on the source database.
C. The export dump file must be created before starting the import on the target database.
D. The source and target database must be running on the same operating system (OS) with the same endianness.
E. The impdp operation must be performed by the same user that performed the expdp operation.

Correct Answer:ABD
In this case we have run the impdp without performing any conversion if endian format is different then we have to first perform conversion.

Question 37

Which two would you recommend to an application developer for reducing locking conflicts on tables in an Oracle database? (Choose two.)

A. Create objects in locally managed tablespaces with Automatic Segment Space Management (ASSM) enabled.
B. Avoid coding long-running transactions.
C. Allow the database to handle locks ln default locking mode.
D. Create objects in locally managed tablespaces with manual segment space management enabled.
E. Enable undo retention guarantee.

Correct Answer:BC

Question 38

Examine the command:
SQL> CREATE TABLESPACE test1
DATAFILE '/u01/app/oracle/oradata/orc1/test01.dbf' SIZE 5M AUTOEXTEND ON UNIFORM;
Which statement is true?

A. The data file, TEST01.DBF, can be auto extended to a maximum size M.
B. The tablespace, TEST1, can contain a maximum of one data file.
C. Allocated and free extents are tracked using bitmaps.
D. Segment free space is tracked in the data dictionar

Correct Answer:C

Question 39

In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer.
Which statement is true?

A. The CDB must be open.
B. The CDB must be in the mount stage.
C. The CDB must be in the nomount stage.
D. Alt existing PDBs must be closed.

Correct Answer:A
* Creating a PDB
Rather than constructing the data dictionary tables that define an empty PDB from scratch, and then populating its Obj$ and Dependency$ tables, the empty PDB is created when the CDB is created. (Here, we use empty to mean containing no customer-created artifacts.) It is referred to as the seed PDB and has the name PDB$Seed. Every CDB non-negotiably contains a seed PDB; it is non-negotiably always open in read-only mode. This has no conceptual significance; rather, it is just an optimization device. The create PDB operation is implemented as a special case of the clone PDB operation. The size of the seed PDB is only about 1 gigabyte and it takes only a few seconds on a typical machine to copy it.

Question 40

Which three operations can be performed as multipartition operations in Oracle? (Choose three.)

A. Merge partitions of a list partitioned table
B. Drop partitions of a list partitioned table
C. Coalesce partitions of a hash-partitioned global index.
D. Move partitions of a range-partitioned table
E. Rename partitions of a range partitioned table
F. Merge partitions of a reference partitioned index

Correct Answer:ABF
Multipartition maintenance enables adding, dropping, truncate, merge, split operations on multiple partitions. A: Merge Multiple Partitions:
The new “ALTER TABLE … MERGE PARTITIONS ” help merge multiple partitions or subpartitions with a single statement. When merging multiple partitions, local and global index operations and semantics for inheritance of unspecified physical attributes are the same for merging two partitions.
B: Drop Multiple Partitions:
The new “ALTER TABLE … DROP PARTITIONS ” help drop multiple partitions or subpartitions with a single statement.
Example:
view plaincopy to clipboardprint?
SQL> ALTER TABLE Tab_tst1 DROP PARTITIONS
Tab_tst1_PART5, Tab_tst1_PART6, Tab_tst1_PART7; Table altered
SQL>
Restrictions :
- You can’t drop all partitions of the table.
- If the table has a single partition, you will get the error: ORA-14083: cannot drop the only partition of a partitioned.