Note! Following 1z0-062 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

1z0-062 Exam Dumps - Oracle Database 12c: Installation and Administration

Go to page:

<< First
Prev
1
2
3
4
5
6
7
Next
Last >>

Question # 9

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

Enterprise Manager on port 1158

telnet on port 23

Cloud Control on port 7799

SSH on port 22

SSL/TLS on port 443

Full Access

Question # 10

Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report:

What are three possible causes for the latch-related wait events?

The size of the shared pool is too small.

Cursors are not being shared.

A large number COMMITS are being performed.

There are frequent logons and logoffs.

The buffers are being read into the buffer cache, but some other session is changing the buffers.

Full Access

Question # 11

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 true? (Choose two.)

It fails because the DELETE INPUT option can be used only with the BACKUP AS COPY command

It creates image copies of the archivelogs

It creates a backupset of archive log files

It creates image copies of the database files

It fails because the DELETE INPUT option can be used only with the BACKUP AS BACKUPSET command

Full Access

Question # 12

You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.

You issue the following statements:

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;

For which database users is the audit policy now active?

All users except SYS

All users except SCOTT

All users except sys and SCOTT

All users except sys, system, and SCOTT

Full Access

Question # 13

Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

By default, EM express is available for a database after database creation.

You can use EM express to manage multiple databases running on the same server.

You can perform basic administrative tasks for pluggable databases by using the EM express interface.

You cannot start up or shut down a database Instance by using EM express.

You can create and configure pluggable databases by using EM express.

Full Access

Question # 14

You execute the following piece of code with appropriate privileges:

User SCOTT has been granted the CREATE SESSION privilege and the MGR role.

Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table? (Choose two.)

Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.

Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.

Data is never redacted for the EMP_V.SAL column.

Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.

Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.

Full Access

Question # 15

Your database has been running with a peak load for the past hour. You want to preserve the performance statistics collected during this period for comparison when you analyze the performance of the database later.

What must you do to achieve this?

Increase the window size of the moving window baseline so that it equals the Automatic Workload Repository (AWR) snapshot retention period.

Create a baseline on a pair of snapshots that span the peak load period.

Generate Active Session History reports for the peak load period.

Set the snapshot retention period in AWR to 60 to avoid automatic purging of snapshots for the past hour.

Full Access

Question # 16

You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c.

Examine the table definition:

Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table? (Choose three.)

The valid time columns employee_time_start and employee_time_end are automatically created.

The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.

The valid time columns are not populated by the Oracle Server automatically.

The valid time columns are visible by default when the table is described.

Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.

Full Access

Go to page: