1z0-062 sample questions

Question 1

Examine the structure of the SALES table, which is stored in a locally managed tablespace with Automatic Segment Space Management (ASSM) enabled.

You want to perform online segment shrink to reclaim fragmented free space below the high water mark.

What should you ensure before the start of the operation?

Accepted Answer

Row movement is enabled.

Answer

Referential integrity constraints for the table are disabled.

Answer

No queries are running on this table.

Answer

Extra disk space equivalent to the size of the segment is available in the tablespace.

Answer

No pending transaction exists on the table.

Question 2

Which task would you recommend before using the Database Upgrade Assistant (DBUA) to upgrade a single-instance Oracle 11g R2 database to Oracle Database 12c?

Accepted Answer

running the Pre-Upgrade Information Tool

Answer

shutting down the database instance that is being upgraded

Answer

executing the catctl.pl script to run the upgrade processes in parallel

Answer

copying the listener.ora file to the new ORACLE_HOME

Question 3

Your database is open and the listener LISTENER is up. You issue the command: LSNRCTL > RELOAD What is the effect of RELOAD on sessions that were originally established by LISTENER?

Accepted Answer

The sessions are not affected and continue to function normally.

Answer

Only sessions based on static listener registrations are disconnected.

Answer

Existing connections are not disconnected; however, they cannot perform any operations until the listener completes the re-registration of the database instance and service handlers.

Answer

All the sessions are terminated and active transactions are rolled back.

Question 4

Which statement is true regarding the startup of a database instance?

Accepted Answer

Instance recovery is not required if the database instance was shut down by using SHUTDOWN IMMEDIATE.

Answer

The instance does not start up normally and requires manual media recovery after a shutdown using the ABORT option.

Answer

Uncommitted transactions are rolled back during the startup of the database instance after a shutdown using the immediate option.

Answer

There is no difference in the underlying mechanics of the startup whether the database is shut down by using the IMMEDIATE option or the ABORT option.

Answer

Media recovery is required when the database is shut down by using either the IMMEDIATE option or the ABORT option.

Question 5

Examine the memory-related parameters set in the SPFILE of an Oracle database below. Which statement is true?

Accepted Answer

Memory is dynamically re-allocated between the SGA and PGA as needed.

Answer

Only SGA components are sized automatically.

Answer

The size of the PGA cannot grow automatically beyond 500 M

Answer

The value of the MEMORY_TARGET parameter cannot be changed dynamically.

Question 6

Examine the parameters for your database instance below. You execute the following command: SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE; Which statement is true in this scenario?

Accepted Answer

An attempt is made to keep inactive undo for 1200 seconds but transactions may overwrite the undo before that time has elapsed.

Answer

Undo data is written to flashback logs after 1200 seconds.

Answer

Inactive undo data is retained for 1200 seconds even if subsequent transactions fail due to lack of space in the undo tablespace.

Answer

You can perform a Flashback Database operation only within the duration of 1200 seconds.

Question 7

A user establishes a connection to a database instance by using an Oracle Net connection. You want to ensure the following:

The user account must be locked after five unsuccessful login attempts.
Data read per session must be limited for the user.
The user cannot have more than three simultaneous sessions.
The user must have a maximum of 10 minutes session idle time before being logged off automatically.

How would you accomplish this?

Accepted Answer

by assigning a profile to the user

Answer

by granting a secure application role to the user

Answer

by implementing Database Resource Manager

Answer

by using Oracle Label Security options

Question 8

As a user of the ORCL database, you establish a database link to the remote HQ database such that all users in the ORCL database may access tables only from the SCOTT schema in the HQ database. SCOTT’s password is TIGER. The service mane “HQ' is used to connect to the remote HQ database.

Which command would you execute to create the database link?

Accepted Answer

CREATE PUBLIC DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING 'HQ';

Answer

CREATE DATABASE LINK HQ USING 'HQ';

Answer

CREATE DATABASE LINK HQ CONNECT TO CURRENT_USER USING ‘HQ’;

Answer

CREATE DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING 'HQ';

Question 9

What happens if a maintenance window closes before a job that collects optimizer statistics completes?

Accepted Answer

The job is terminated and statistics for the remaining objects are collected the next time the maintenance window opens.

Answer

The job is terminated and the gathered statistics are not saved.

Answer

The job is terminated but the gathered statistics are not published.

Answer

The job continues to run until all statistics are gathered.

Question 10

You plan to create a database by using the Database Configuration Assistant (DBCA), with the following specifications:

Applications will connect to the database via a middle tier.
The number of concurrent user connections will be high.
The database will have mixed workload, with the execution of complex BI queries scheduled at night.

Which DBCA option must you choose to create the database?

Accepted Answer

a General Purpose database template, with the shared server mode option and Automatic Memory Management (AMM) enabled

Answer

a General Purpose database template with default memory allocation

Answer

a Data Warehouse database template, with the dedicated server mode option and AMM enabled

Answer

a default database configuration

1z0-062 Oracle Database 12c: Installation and Administration Practice Questions

Create an account to continue.

Create an account to continue.

Related exams