1Z0-062 Exam Questions

The HR user executes the following query on the EMPLOYEES table but does not issue COMMIT, ROLLBACK, or any data definition language (DDL) command after that: HR then opens a secon...

The HR user updates the salary of one of the employees in the non-partitioned EMPLOYEES table, but does not commit the transaction. Which two types of lock exist in this situation?

Which two categories of segments are analyzed by the Automatic Segment Advisor?

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

Your database is configured in ARCHIVELOG mode, and daily full database backups are taken. RMAN is configured to perform control file autobackups. Which statement is true about the...

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

You create an Oracle 12c database and then import schemas that are required by an application which has not yet been developed. You want to get advice on creation of or modificatio...

Examine the parameters for a database instance: Which two statements are true?

You perform RMAN backups for your database and use a recovery catalog for managing the backups. To free space, you execute this command: RMAN> DELETE OBSOLETE; Which three statemen...

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

You have a production Oracle 12c database runningon a host. You want to install and create databases across multiple new machines that do not have any Oracle database software inst...

You install "Oracle Grid Infrastructure for a standalone server" on a host on which the ORCL1 and ORCL2 databases both have their instances running. Which two statements are true?

Which two statements describe the relationship between a scheduler window, a resource manager plan, and a job class?

You areadministering a database that supports an OLTP workload. The default UNDO tablespace is a fixed size tablespace with the RETENTION NOGUARATNEE clause and undo retention set...

You plan to install the Oracle Database 12c software. You want to use Oracle Automatic Storage Management (ASM) for storage and Oracle Restart for managing components. Oracle Grid...

For which three requirements would you use the Database Resource Manager?

Which three are activities performed by SMON?

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

In which situations does the Database Writer process (DBWn) write to data files?

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

In your database, USERS is the default permanent tablespace. Examine the commands and their outcome: You plan to execute the commands: Which two statements are true?

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

SMD is a smallfile locally managed tablespace with manual segment space management. The SH user receives the following error while inserting data into the sales table: Which three...

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

In your Oracle 12c database, you invoke SQL *Loader Express Mode command to load data: $> sqlldr hr/hr table=employees Which two statements are true about this command? (Choose two...

Backup requirements for a database: * Level 0 backup on Sunday * Cumulative incremental level 1 backup on Monday, Wednesday, and Saturday * Differential incremental level 1 backup...

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

You plan to upgrade your Oracle Database 9i to Oracle Database 12c. Which two methods can you use? (Choose two.)

Examine the following command: SQL> DBMS_STATS. SET_TABLE_PREFS ('SH', 'CUSTOMERS', 'PUBLISH', 'false'); What is the effect of executing this command?

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

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

Your database instance has Automatic Memory Management enabled and supports shared server connections. Examine the following: 1. Parallel execution messages and control structures...

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

The performance of your database degrades between 11:00 AM and 3:00 PM. Automatic Workload Repository (AWR) snapshots are collected on an hourly basis. What is the most efficient w...

Automatic Shared Memory Management is enabled for your database instance. You notice that there are SQL statements performing poorly because of repeated parsing activity. Which act...

In your database, the STATISTICS_LEVEL parameter is set to TYPICAL and an Automatic Workload Repository (AWR) snapshot is taken every 30 minutes. Which two statements are true abou...

Which two statements are true about a server parameter file (SPFILE)? (Choose two.)

Your database is configured in ARCHIVELOG mode, and a daily full database backup is taken by using RMAN. Control file autobackup is configured. Loss of which three database files c...

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

Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. Th...

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

Unified auditing is enabled in your database. The HR_ADMIN and OE_ADMIN roles exist and are granted system privileges. You execute the command: SQL>CREATE AUDIT POLICY tab1e_aud PR...

You determine that database performance is sub-optimal due to hard parsing statements. Automatic Shared Memory Management (ASMM) is disabled for your database instance. Which tool...

Identify three uses of the CROSSCHECK command (Choose three.)

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

Which three statements are true about Automatic Workload Repository (AWR)? (Choose three.)