1z1-062 by Oracle Actual Free Exam Q&As

Question 1

Which two statements are true about Oracle Data Pump export and import operations? (Choose two.)

A. You cannot specify how partitioned tables should be handled during an import operation. B. Only data can be compressed during an export operation. C. Tables cannot be renamed during an import operation. D. Existing dump files can be overwritten during an export operation. E. Metadata that is exported and imported can be filtered based on objects and object types.

Discussion 0

Correct Answer: A,E Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 2

In your database instance, the UNDO_RETENTION parameter is set to 1000 and undo retention is not guaranteed for the fixed size undo tablespace.
Which statement is true about undo retention?

A. Undo becomes expired obsolete after 1000 seconds. B. Inactive undo is retained for at least 1000 seconds if free undo space is available. C. Undo is retained in the UNDO tablespace for 1000 seconds, and then moved to the SYSTEM tablespace to provide read consistency. D. Inactive undo is retained for 1000 seconds even if new transactions fall due to lack of space in the undo tablespace.

Discussion 0

Correct Answer: B Vote an answer

Question 3

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?

A. RMAN B. Data Pump full export/import C. Transportable database D. The DBMS_PDB package E. Transportable tablespace

Discussion 0

Correct Answer: E Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 4

You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c.
Examine the table definition:

Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table? (Choose three.)

A. The valid time columns are visible by default when the table is described. B. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses. C. The valid time columns employee_time_start and employee_time_end are automatically created. D. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session. E. The valid time columns are not populated by the Oracle Server automatically.

Discussion 0

Correct Answer: B,C,E Vote an answer

Question 5

Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not database auditing is enabled?

A. usage of the AUDIT statement B. configuration of unified auditing mode C. creation of a fine-grained audit policy D. execution of SQL statements by users connected with the SYSDBA privilege

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 6

DEFERRED_SEGMENT_CREATION is TRUE in one of your databases.
You execute this command:

Which three statements are true immediately after this statement executes successfully?

A. No database segment is created. B. No table definition is stored in the data dictionary. C. The table and column definitions are stored in the data dictionary. D. A database object is created. E. No object definition is stored in the data dictionary. F. No column definitions are stored in the data dictionary.

Discussion 0

Correct Answer: A,C,D Vote an answer

Question 7

You are managing an Oracle Database 12c database. The database is open, and you plan to perform Recovery Manager (RMAN) backups.
Which three statements are true about these backups? (Choose three.)

A. The backups need to be restored and the database has to be recovered in case of a media failure. B. The backups would be consistent. C. The backups would be possible only if the database is running in ARCHIVELOG mode. D. The backups by default consist of all the data blocks within the chosen files or the full database. E. The backups would be inconsistent.

Discussion 0

Correct Answer: A,C,E Vote an answer

Question 8

In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database?
Both local and global partitioned B-tree Indexes are defined on the table.
A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends.
Minimal disrupt ion to availability is required.
Which three statements are true about this requirement? (Choose three.)

A. The partitions can be compressed in the same tablespaces. B. Local indexes must be rebuilt manually after moving the partitions. C. The partitions can be compressed in the new tablespaces. D. The partitions can be moved online to new tablespaces. E. Global indexes must be rebuilt manually after moving the partitions.

Discussion 0

Correct Answer: A,C,D Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 9

Your database is in NOARCHIVELOG mode. You want to enable archiving for the database.
Examine the steps:
1. Execute the ALTER DATABASE ARCHIVELOG command.
2. Execute SHUTDOWN IMMEDIATE.
3. Execute STARTUP MOUNT.
4. Set the DB_RECOVERY_FILE_DEST parameter to $ORACLE_HOME/dbs/.
5. Execute STARTUP NOMOUNT.
6. Open the database.
Identify the required steps in the correct sequence.

A. 1, 2, 3, 4, 6 B. 2, 5, 1, 6 C. 2, 3, 1, 6 D. 4, 2, 5, 1, 6

Discussion 0

Correct Answer: C Vote an answer

Question 10

To enable the Database Smart Flash Cache, you configure the following parameters:
DB_FLASH_CACHE_FILE = '/dev/flash_device_1' , '/dev/flash_device_2'
DB_FLASH_CACHE_SIZE=64G
What is the result when you start up the database instance?

A. One 64G flash cache file will be used. B. It results in an error because these parameter settings are invalid. C. Two 32G flash cache files will be used. D. Two 64G flash cache files will be used.

Discussion 0

Correct Answer: B Vote an answer

Question 11

You executed this command to create a password file:
$ orapwd file = orapworcl entries = 10 ignorecase = N
Which two statements are true about the password file? (Choose two.)

A. It contains username and passwords of database users who are members of the OSOPER operating system group. B. It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role. C. It contains usernames and passwords of database users who are members of the OSDBA operating system group. D. It will permit the use of lowercase passwords for database users who have granted the SYSDBA role. E. It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.

Discussion 0

Correct Answer: D,E Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Oracle Database 12c: Installation and Administration - 1z1-062 Exam Practice Test