1Z0-062 Exam Questions

You want to import the schema objects of the HR user from the development database DEVDB to the production database PRODDB by using Oracle Data Pump. A database link devdb.us.oracl...

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

Which two statements are true about Automatic Storage Management (ASM)? (Choose two.)

You want to create a test database as a replica of your production database with minimum intervention from a DBA. Which method would you use?

You want to load data from a large file into your database without causing an overhead on the SGA. Which tool would you use.

You are using RMAN to back up your database. All the data files are in read/write mode. Examine the RMAN configuration parameters: Which two statements are true about a whole consi...

As part of a manual upgrade of your database to Oracle Database 12c, you plan to issue the command: SQL> STARTUP UPGRADE Which three statements are true about the upgrade process?...

Which statement is true about using the Export/Import method for migrating data when upgrading to Oracle Database 12c?

Your database is in ARCHIVELOG mode and you want to automate the backup scheduling for your database. Which two tools or utilities would you use to achieve this? (Choose two.)

Which two would you recommend to an application developer for reducing locking conflicts on tables in an Oracle database? (Choose two.)

Which three functions can be performed by the SQL Tuning Advisor? (Choose three.)

Examine the parameters: Users complain that their sessions for certain transactions hang. You investigate and discover that some users fail to complete their transactions, causing...

Which statement is true about the loss of a data file belonging to the default undo tablespace?

Examine the following steps: A DBA grants the CREATE TABLE system privilege with ADMIN OPTION to the user SIDNEY. grants the CREATE TABLE system privilege to the HR user. SIDNEY Wh...

What is pre-requisite to alter a role?

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

Identify the access that is initially available to connect to your Database as a Service (DBaaS) environment.

Which statement is true about profiles?

Which three statements are true about naming methods? (Choose three.)

Which task is performed by a background process in a database instance?

Your database instance is started with a PFILE. You want to increase the size of the buffer cache. Free memory is available to increase the size of the buffer cache. You execute th...

Which statement is true redo log files during instance recovery?

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

What is the outcome of the SHUTDOWN ABORT command?

Which component resides in the System Global Area (SGA) of a database instance only in shared server connections?

Identify three situations in which messages are written to the alert log file. (Choose three.)

Which three statements are true about Enterprise Manager Database Express? (Choose three.)

When does a database checkpoint occur?

What action must you take to ensure complete database recovery till the point of failure?

You want to create a table, DAILY_ORDERS, for an OLTP application, where data should be compressed during both direct path INSERT and conventional DML. The table will also be used...

An application repeatedly accesses small lookup tables, causing a lot of physical I/O operations. What do you recommend to minimize this?

Examine the command: SQL> CREATE TABLESPACE test1 DATAFILE '/u01/app/oracle/oradata/orc1/test01.dbf' SIZE 5M AUTOEXTEND ON UNIFORM; Which statement is true?

Your database is open in read/write mode and multiple users are connected to the database instance. You execute the following command: SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;...

You want to distribute a set of structured data to your customers who can integrate this data into their existing databases irrespective of the platform. Which method provides the...

You create a locally managed tablespace ORDERS_TBS with automatic segment management. You then create the table DAILY_ORDS_LST in the ORDERS_TBS tablespace using the command. CREAT...

What must you use to read data from a table in your database and write it to an external table?

Which three statements are true about user account administration? (Choose three.)

Which two statements are true about initialization parameter files? (Choose two.)

You configured the Fast Recovery Area (FRA) for your database. The database instance is in ARCHIVELOG mode. The default location for the archived redo log files is the FRA. Which t...

Which three database operations can be performed only at MOUNT state? (Choose three.)

Which statement is true about a database in ARCHIVELOG mode?

You want to create a locally managed tablespace called NEWTBS to store segments with different extent sizes. Which set of tablespace attributes can be specified for a tablespace th...

The schema SALES exists in two databases, ORCL1 and ORCL2, and has the same password, SALES123. User SALES has CREATE DATABASE LINK and CREATE SESSION privileges on both databases....

Which two services may you see on the My Service Dashboard page? (Choose two.)

What is a requirement for creating a remote database scheduler job?

The HR schema exists in two databases, BOSTON and DENVER, and has the same password, HR. You have the CREATE DATABASE LINK and CREATE SESSION privileges on both the database. BOSTO...

Examine the command: SQL> CONNECT hr/hr@orcl Which two configurations allow this command to execute successfully? (Choose two.)

Which users are created and can be used for database and host management of your DBaaS database servers?

Which three statements are true about Oracle Data Pump? (Choose three.)

In your database, archive logging and control file autobackup are enabled. The data files and redo log files are intact but control files are impacted due to media failure. In whic...