Winter Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: v4s65

  1. Home
  2. Oracle
  3. Oracle Database 12c
  4. 1z0-060 - Upgrade to Oracle Database 12c
Note! Following 1z0-060 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

1z0-060 Exam Dumps - Upgrade to Oracle Database 12c

Go to page:
Question # 25

Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart.

Examine the following command and its output:

What does this imply?

A.

When you start an instance on a host with SQL*Plus, the dependent listeners and ASM disk groups are automatically started.

B.

When a database instance is started by using the SRVCTL utility and the listener startup fails, the instance is still started.

C.

When a database is created by using SQL*Plus, it is automatically added to the Oracle Restart configuration.

D.

When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.

Full Access
Question # 26

Your multitenant container database (CDB) contains several pluggable databases (POBs). A common user c##a_admin, Is created with connect privileges. You execute this command from the root container: SQL> GRANT create tablespace to C##A_ADMIN; Which statement is true?

A.

The command fails because the container=all clause is not used.

B.

The command executes successfully, enabling the c*#a_admin user to create a tablespace only In the root container.

C.

The command executes successfully, enabling the c*#a_admin user to create tablespaces in the root container as well as In the PDBs.

D.

The command fails because the CONTAINER=CURRENT clause is not used.

Full Access
Question # 27

Which three statements are true about using flashback database in a multitenant container database (CDB)? (Choose three.)

A.

The root container can be flashed back without flashing back the pluggable databases (PDBs).

B.

To enable flashback database, the CDB must be mounted.

C.

Individual PDBs can be flashed back without flashing back the entire CDB.

D.

The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB.

E.

A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.

Full Access
Question # 28

Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the PDB HR_PDB. You execute the following command:

What is the result?

A.

It executes successfully and creates an UNDO tablespace in HR_PDB.

B.

It fails and reports an error because there can be only one UNDO tablespace in a CDB.

C.

It fails and reports an error because the CONTAINER=ALL clause is not specified in the command.

D.

It fails and reports an error because the CONTAINER=CURRENT clause is not specified in the command.

E.

It executes successfully but neither tablespace nor the data file is created.

Full Access
Question # 29

You notice a performance change in your production Oracle database and you want to know which change has made this performance difference.

You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation.

Which three findings would you get from the report? (Choose three.)

A.

It detects any configuration change that caused a performance difference in both time periods.

B.

It identifies any workload change that caused a performance difference in both time periods.

C.

It detects the top wait events causing performance degradation.

D.

It shows the resource usage for CPU, memory, and I/O in both time periods.

E.

It shows the difference in the size of memory pools in both time periods.

F.

It gives information about statistics collection in both time periods.

Full Access
Question # 30

Which three statements are true about Automatic Workload Repository (AWR)? (Choose three.)

A.

All AWR tables belong to the SYSTEM schema.

B.

The AWR data is stored in memory and in the database.

C.

The snapshots collected by AWR are used by the self-tuning components in the database.

D.

AWR computes time model statistics based on time usage for activities, which are displayed in the V$SYS_TIME_MODEL and V$SESS_TIME_MODEL views.

E.

AWR contains systemwide tracing and logging information.

Full Access
Question # 31

You Execute the following command to create a password file in the database server:

$ orapwd file=‘+DATA/PROD/orapwprod entries=5 ignorecase=N format=12’

Which two statements are true about the password file? (Choose two.)

A.

It records the usernames and passwords of users when granted the DBA role.

B.

It contains the usernames and passwords of users for whom auditing is enabled.

C.

It is used by Oracle to authenticate users for remote database administration.

D.

It records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups.

E.

It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.

Full Access
Go to page:

Hot Exams

ADM-201 Dumps
Platform-App-Builder Dumps
AZ-500 Dumps
350-701 Dumps
SY0-601 Dumps
NCSE-Core Dumps
PDP9 Dumps
DP-203 Dumps
AZ-700 Dumps
NSE7_EFW-7.0 Dumps
Integration-Architect Dumps
CS0-003 Dumps