1Z0-062 Practice Questions

You have the following entry in the tnsnames.ors file of your hq.us.example.com host machine: ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADRESS = (PROTOCOL = TCP)(HOST = hq.us.example....

Which statement is true about redo log files during instance recovery?

A database uses Automatic storage Management (ASM) as database storage, which has diskgroup, DATA1, which is created as follows: What happens when the FAILGRP1 failure group is cor...

Your single-instance Oracle 12c database home currently supports conventional auditing and uses Automatic Storage Management (ASM). You want to enable unified auditing by executing...

Which three factors influences the optimizer's choice of an execution plan?

Which three statements are true about Oracle Data Pump?

The DEFERRED_SEGMENT_CREATION parameter is set TRUE in your database instance. (erfasst) You execute the following command to create a table: SQL> CREATE TABLE acctl (ac_no NUMBER,...

The HR.DEPARTMENTS table is the parent of the HR.EMPLOYEES table. The EMPLOYEES.DEPARTMENT_ID column has foreign key constraint with the ON DELETE CASCADE option that refers to the...

Which set of statements is true about data dictionary views? 1) They are stored in the SYSTEM tablespace. 2) They are based on virtual tables 3) They are owned by the SYS user 4) T...

Which three statements are true about space usage alerts?

You use multiple temporary tables frequently in your database. Which two are benefits of configuring temporary undo?

Which two statements are true about Oracle Data Pump export and import operations?

Your database is running in NOARCHIVING mode. Examine the following parameters: You execute the following command after performing a STARTUP MOUNT: SQL> ALTER DATABASE ARCHIVELOG;...

Your production database uses file system storage. You want to move storage to Oracle Automatic Storage Management (ASM). How would you achieve this?

Which two statements are true about Oracle network connections?

Which two actions does an incremental checkpoint perform?

Which statement is true aboutusing the Database Upgrade Assistant (DBUA) to upgrade your database from Oracle Database 11g to Oracle Database 12c?

Examine the parameters for a database instance: Your database has three undo tablespaces and the default undo tablespace is not autoextensible. Resumable space allocation is not en...

What should you do to ensure that a job stored minimal job metadata and runtime data on disk, and uses only existing PL/SQL programs?

You want to schedule a job to rebuild atable's indexes after a bulk insert, which must be scheduled as soon as a file containing data arrives on the system. What would you do to ac...

You plan to install the Oracle Database 12c software on a new server. The database will use Automatic Storage Management (ASM) and Oracle Restart. Oracle Grid Infrastructure for a...

Which two statements are true about the (PMON) background process in Oracle Database 12c?

You want to upgrade an Oracle Database running Oracle Database 11g to Oracle Database 12c. Which three tasks should be performed before a manual upgrade?

You want to create a database and you have the following: - Oracle Grid Infrastructure is installed and configured. - Oracle Database Vault is installed in ORACLE_HOME to be used f...

Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)?

Which two statements are true about availability audit features after migration to unified auditing?

What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?

Which statement is true about unified auditing?

What is the benefit of running the catctl.pl script during an upgrade of a pre-12c database to an Oracle 12c database?

Which two statements are true about SQL *Loader Express Mode in an Oracle 12c database?

Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. Currently, thedatabase is running with peak workload. You want to an...

Your production database PROD uses file system storage. You want to migrate storage including the Fast Recovery Area for the PROD database to Oracle Automatic Storage Management (A...

You have successfully taken a database backup by using the command: RMAN>BACKUP AS BACKUPSET DATABASE; Now you execute this command: RMAN> BACKUP INCREMENTAL LEVEL 1 DATABASE; What...

In your Oracle 12c database, you plan to execute the command: SQL>CREATE TABLESPACE tbs1 DATAFILE `/u02/oracle/data/tbs01.dbf' SIZE 50M; The u02 file system has 1 GB of free space...

What is the effect of setting the STATISTICS_LEVEL initialization parameter to BASIC?

Your database is configured in ARCHIVELOG mode. Examine the RMAN configuration parameters: Examine the command: RMAN>BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT; What is the outco...

You want to create a role that: - is protected from unauthorized usage - does not use a password embedded in the application source code or stored in a table - is enabled for a use...

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 r...

Which three files must you copy from the Oracle home of the database that is being upgraded to the new Oracle home for Oracle Database 12c? (Choose three.)

When is the UNDO_RETENTION parameter value ignored by a transaction?

Which two statements are true about the Database Configuration Assistant (DBCA)? (Choose two.)

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...

Which three tools or tasks are run by default as part automated maintenance tasks? (Choose three.)

Which four statements are true about the components of the Oracle Scheduler? (Choose four.)

Which three statements are true about checkpointing? (Choose three.)

You install Oracle Grid Infrastructure for a standalone server. Which two components are automatically included in the Oracle Restart configuration? (Choose two.)

Which two statements are true about resumable space allocation? (Choose two.)

You want to create a file watcher and an event-based job for detecting the arrival of files on the local server from various locations. To achieve this, you enable the raising of f...

Which statement is true about the Oracle central inventory directory (oraInventory)?

Which three statements are true about server-generated alerts? (Choose three.)