1Z0-062 Exam 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 two statements are true about the Automatic Database Diagnostic Monitor (ADDM)?

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

Your database instance has the following parameter setting: OS_AUTHENT_PREFIX = OPS$ You execute the following command: And then grantOPS$GUEST_USER the CREATE SESSION privilege. W...

Your database is configured for ARCHIVELOG mode, and a daily full database backupis taken. RMAN is configured to perform control file autobackup. In which three scenarios do you ne...

Your database has been running with a peak load for the past hour. You want to preserve the performance statistics collected during this period forcomparison when you analyze the p...

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?

You execute this command: Which two statements are true about segment space management for segments in thistablespace?

You have just completed a manual upgrade of an Oracle 11g Database to Oracle Database 12c. The Post-Upgrade Status Tool reports an INVALID status for some of the components after t...

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

Examine the parameter settings in your local ORCL database: Examine the parameter settings for the remote SALES database: As the SYS user, you issue the following command on ORCL:...

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

Your database instance has started using an SPFILE. Examine the RMAN configuration settings: You execute the command: RMAN> BACKUP AS COPY TABLESPACETEST; Which three types of file...

You set the following parameters in the parameter file and restart the database instance: Which two statements are true?

Your database is running in ARCHIVELOG mode. You want to take a consistent whole database backup. Which two statements are true in this scenario?

Which three statements are true about the purpose of checkpoints?

Which three statements are true about Oracle Restart?

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

Automatic Shared Memory Management (ASMM) is enabled for your database instance. You execute the following command: SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M; Which statement is t...

The HR user owns the BONUSES table. HR grants privileges to the user TOM by using the command: SQL> GRANT SELECT ON bonuses TO tom WITH GRANT OPTION; TOM then executes this command...

You want to prevent a group of users in your database from performing long-running transactions that consume huge amounts of space in the undo tablespace. If the quota for these us...

Your database instance is started by using a server parameter file (SPFILE). You execute the following command to change thevalue of the LOG_BUFFER initialization parameter: ALTER...

Which four operations performed after the Oracle Restart installation are automatically added to the Oracle Restart configuration?

A database instance is started by using an SPFILE. he database is configured in ARCHIVELOG mode and the control file autobackup is configured. Dailyfull database backups are perfor...

Which three statements are true about Database Resource Manager?