Note! Following 1z0-062 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

1z0-062 Exam Dumps - Oracle Database 12c: Installation and Administration

Go to page:

<< First
Prev
1
2
3
4
5
6
7
Next
Last >>

Question # 25

Which two statements are true about using SQL*Loader? (Choose two.)

It can load data from external files by using the direct path only.

It can load data into multiple tables using the same load statement.

It can load data into only one table at a time.

It can generate unique sequential key values in specified columns.

It can load data from external files by using the conventional path only.

Full Access

Question # 26

Which are two ways for a database service to be recognized by a listener in Oracle Database 12c? (Choose

two.)

Dynamic Registration by the LREG process

Dynamic Registration by the SMON process

Static registration in the listener.ora file using the GLOBAL_DBNAME parameter

Dynamic Registration by the PMON process

Static registration in the listener.ora file using the SERVICE_NAME parameter

Full Access

Question # 27

Which two statements are true about extents? (Choose two.)

Blocks belonging to an extent can be spread across multiple data files.

Data blocks in an extent are logically contiguous but can be non-contiguous on disk.

The blocks of a newly allocated extent, although free, may have been used before.

Data blocks in an extent are automatically reclaimed for use by other objects in a tablespace when all the rows in a table are deleted.

Full Access

Question # 28

You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB).

The characteristics of the non-CDB are as follows:

â€“ Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit

â€“ Character set: AL32UTF8

â€“ National character set: AL16UTF16

â€“ O/S: Oracle Linux 6 64-bit

The characteristics of the CDB are as follows:

â€“ Version: Oracle Database 12c Release 1 64-bit

â€“ Character Set: AL32UTF8

â€“ National character set: AL16UTF16

â€“ O/S: Oracle Linux 6 64-bit

Which technique should you use to minimize down time while plugging this non-CDB into the CDB?

Transportable database

Transportable tablespace

Data Pump full export/import

The DBMS_PDB package

RMAN

Full Access

Question # 29

The HR user receives the following error while inserting data into the sales table:

On investigation, you find that the users tablespace uses Automatic Segment Space Management (ASSM). It is the default tablespace for the HR user with an unlimited quota on it.

Which two methods would you use to resolve this error? (Choose two.)

Altering the data file associated with the USERS tablespace to extend automatically

Adding a data file to the USERS tablespace

Changing segment space management for the USERS tablespace to manual

Creating a new tablespace with autoextend enabled and changing the default tablespace of the HR user to the new tablespace

Enabling resumable space allocation by setting the RESUMABLE_TIMEOUT parameter to a nonzero value

Full Access

Question # 30

Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:

Which two statements are true about redefining the table? (Choose two.)

All the triggers for the table are disabled without changing any of the column names or column types in the table.

The primary key constraint on the EMPLOYEES table is disabled during redefinition.

VPD policies are copied from the original table to the new table during online redefinition.

You must copy the VPD policies manually from the original table to the new table during online redefinition.

Full Access

Question # 31

A database instance is started by using an SPFILE. The database is configured in ARCHIVELOG mode and the control file autobackup is configured. Daily full database backups are performed by using RMAN.

You lost all control files due to media failure.

Given the steps to recover from the error in random order:

1. Shut down the instance, if it is not already down.

2. Restore the control file from autobackup to a new location.

3. Start the database instance to NOMOUNT state.

4. Recover the database to the point of failure of the control file.

5. Open the database with the RESETLOGS option.

6. Mount the database.

7. Update the SPFILE with the new location of the control file by using the ALTER SYSTEM command.

Identify the correct sequence of the required steps.

1, 3, 2, 6, 7, 4, 5

1, 3, 7, 2, 6, 4, 5