1Z0-062 Online Practice Questions and Answers

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

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

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

C. The job continues to run until all statistics are gathered.

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

Examine these two statements:

Which three are true about the MRKT tablespace? (Choose three.)

A. The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.

B. The MRKT tablespace may be dropped if it has no contents.

C. Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.

D. No more data files can be added to the tablespace.

E. The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.

Which two actions does an incremental checkpoint perform? (Choose two.)

A. It signals CKPT to write the checkpoint position to the data file headers.

B. It writes the checkpoint position to the data file headers.

C. It advances the checkpoint position in the checkpoint queue.

D. It writes the checkpoint position to the control file.

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 user based on security policies defined in a PL/SQL package

How would you create this role?

A. as a secure application role

B. with definer's rights

C. with global authentication

D. with external authentication

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

A. A resource plan change can be automated by using the Oracle Scheduler.

B. It can be used to control the consumption of only physical I/Os where excessive physical I/Os can trigger an automatic session termination but excessive logical I/Os cannot.

C. It can be used to control the usage of the undo tablespace by consumer groups.

D. A resource plan can have multiple resource plan directives, each of which controls resource allocation for a different consumer group.

E. It can be used to enable resumable timeout for user sessions.

F. It can be used to control the usage of the temp tablespace by consumer groups.

You are administering 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 to 12 minutes.

The user SCOTT queries a large table during peak activity.

The query runs for more than 15 minutes and then SCOTT receives the following error:

ORA-01555: snapshot too old

Which is possible reason for this?

A. The Oracle server is unable to generate a read-consistent image for a block containing updates.committed after the query began.

B. The query is unable to place data blocks in the UNDO tablespace.

C. The flashback data archive is not enabled for the table on which the query is issued.

D. There is not enough space in Fast Recovery Area.

E. The Oracle server is unable to generate a read-consistent image for a block containing uncommitted updates.

Which two statements are true about the Database Configuration Assistant (DBCA)? (Choose two.)

A. It can be used to create a database template from an existing database.

B. It can be used to add a new tablespace.

C. It can generate SQL database creation scripts.

D. It can be used to copy an existing Oracle database to a new host and apply any patches necessary in the new host.

E. It can configure Automatic Storage Management (ASM) diskgroups.

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

A. recommending creation of indexes based on SQL workload

B. recommending restructuring of SQL statements that have suboptimal plans

C. checking schema objects for missing and state statistics

D. recommending optimization of materialized views

E. generating SQL profiles

In your database, the RESOURCE_LIMIT parameter is set to TRUE. You create the profile:

Which two statements are true about users and their sessions that are subject to this profile? (Choose two.)

A. The CPU_PER_CALL is ignored in the user sessions because of the unlimited value of CPU_PER_CALL

B. These users can never reuse a password

C. The PASSWORD_LIFE_TIME value is ignored because of the unlimited value of PASSWORD_REUSE_MAX.

D. In each user session, the limit for LOGICAL_READS_PER_SESSION in the same as defined in the DEFAULT profile.

You must upgrade your Oracle 11g to Database to Oracle 12c R2. Which method can you use?

A. Perform a rolling upgrade.

B. Perform a direct upgrade by running the Database Upgrade Assistant (DBUA).

C. Use Enterprise Manager Express.

D. Use SQL*Developer

E. Use the Database Creation Assistant (DBCA) to upgrade