1Z0-062 Exam Questions

Examine the command to perform a data pump export operation on a source database: $> expdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLE=emp_dept On the target database,...

Examine the details of the uncompressed, non-partitioned heap table CITIES. Examine the command: SQL> ALTER TABLE cities SHRINK SPACE COMPACT; What must you do before executing it?

Your database has archive logging enabled and RMAN backups are taken at regular intervals. A data file in the USERS tablespace is damaged. Which command must you execute before sta...

Which statement is true regarding the DEFAULT profile?

Examine this command executed on a client that is remote from the database server. SQL> CONNECT hr/hr@orcl Which two are required for this command to connect the SQLPLUS client to...

One of your databases supports an OLTP workload. The default UNDO tablespace is fixed size with: 1. RETENTION NOGUARANTEE 2. UNDO_RETENTION is 12 minutes User SCOTT gets this error...

One of your databases has archive logging enabled and RMAN backups are taken at regular intervals. The data file for the USERS tablespace is corrupt. Which command must you execute...

Which three statements are true about Oracle checkpoint processing? (Choose three.)

You want a job that performs a bulk insert as soon as the loader file arrives on the local file system. Which two would you do to accomplish this? (Choose two.)

Which four are true about creating and running a remote database scheduler jobs? (Choose four.)

Your database is configured in ARCHIVELOG mode. Examine the RMAN configuration parameters: Examine the command: RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT; Which two are tr...

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

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

DAILY_ORDS_LST is created in locally managed tablespace ORDERS_TBS which uses automatic segment space management. Which two are true? (Choose two.)

You ran this command on a source database: $> expdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLES=emp_dept On the target database, you run this command: $> impdp hr/hr...

Which two must be installed or configured either manually or by DBCA in order to use Enterprise Manager Database Express (EM Express)? (Choose two.)

Which four statements are true about database instance behavior? (Choose four.)

Which three statements are true PFILEs, SPFILEs or both? (Choose three.)

Examine this command: SQL> ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE; Which two statements are true? (Choose two.)

Your database is in ARCHIVELOG mode. You want to disable archiving for the database. Examine these steps: 1. Execute the ALTER DATABASE NOARCHIVELOG command 2. Execute SHUTDOWN IMM...

A database is open READ WRITE and the instance has multiple sessions some of which have active transactions. You execute this command: SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;...

Which three statements are true about a job chain? (Choose three.)

An employee salary in the non-partitioned EMPLOYEES table, has been updated but the transaction is uncommitted. Which two types of lock are held by the transaction? (Choose two.)

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 PFILE exists for your database. You want to increase the value of the PROCESSES parameter from 300 to 400 and make it persistent for your database instance. You plan to use the A...

In one of your databases, unified auditing is enabled and an SH.SALES table exists. You can successfully execute these commands: Which statement is true about SALES_POL?

What should you do for a Scheduler to start a job when a file arrives on a remote system?

The HR schema exists in databases, BOSTON and DENVER, with the same password, HR. You have CREATE DATABASE LINK and CREATE SESSION privileges in both databases. DENVER is defined a...

Examine these statements: DESC emp INSERT INTO emp VALUES ( 101, 'John', 12000); 1 row created. SAVEPOINT after_insert; Savepoint created. UPDATE emp SET salary=16000 WHERE empno=1...

All of your database instances use SPFILES. You executed this command in one of them: ALTER SYSTEM SET MEMORY_MAX_TARGET=1024M; Which statement is true?

Which two utilities can NOT configure a new listener on port 1526? (Choose two.)

In which three situations can you use threshold server-generated alerts to help diagnose and fix problems? (Choose three.)

Examine these statements: Which three are true about the effects of executing these statements? (Choose three.)

Which three are true about the default database buffer cache? (Choose three.)

One of your databases runs in ARCHIVELOG mode. Examine this command: Now examine these steps executed from RMAN: 1) SHUTDOWN IMMEDIATE 2) STARTUP MOUNT 3) BACKUP DATABASE; 4) BACKU...

Which are three of the input sources for the SQL Tuning Advisor? (Choose three.)

Examine these steps: CONNECT / AS SYSDBA CREATE DIRECTORY dumpdir AS '/u01/app/'; Directory created. GRANT READ, WRITE ON DIRECTORY dumpdir TO PUBLIC; Grant succeeded. CREATE USER...

Which two can be recommendations given by SQL Access Advisor? (Choose two.)