Free Oracle 1z0-068 Exam Dumps Questions & Answers

Examine this command and output:

You want to relocate this database online to node 016n2.
Which two statements must be true for a successful online migration? (Choose two.)

• A.  Database clients must disconnect before the online relocation timeout expires.
• B.  The database must have at least two redo threads defined by the DBA.
• C.  The database must have at least two UNDO tablespaces.
• D.  The database must be stored on shared storage.
• E.  The database must be open.
• F.  Database clients must use Transaction Guard to prevent them from losing their connection.

Which three statements are true about Quality of Service Management (QoS)? (Choose three.)

• A.  The command-line utility qosct1 can be used to change the password of the internal user QOSADMIN.
• B.  It requires a resource manager plan to be active on databases managed by QoS.
• C.  It supports RAC One Node databases if they are assigned to server pools with a maximum size of one server.
• D.  One QoS policy can span multiple clusters if they contain server pools, assigned to be managed by QoS.
• E.  A server pool directive override can be used to modify the database parameter CPU_COUNT for all databases within one server pool.

A clustered ASM Instance has the DATA diskgroup mounted.
Which two can be used to display information about databases accessing files in the DATA diskgroup?

• A.  asmcmd lsct
• B.  v$asm_client
• C.  v$process
• D.  asmcmd lsdg
• E.  v$session

You created a RAC database with DBCA and decide to verify it.
The server pool large_db has four servers.
Examine the output shown:

Which two statements are true based on this output? (Choose two.)

• A.  The concurrency values are not shown because sales has only one of its four instances running.
• B.  The sales database resource will be restarted automatically after an instance failure.
• C.  The concurrency values are not shown because sales in not a RAC One Node database.
• D.  The sales database resource will be started and the database instances will be started automatically when restarting the clusterware stack after normal shutdown of the sales database.
• E.  The sales database resource will be restored to its previous running condition when restarting the clusterware stack after normal shutdown of the sales database.

You are developing a user callout procedure to send an email to the helpdesk whenever a RAC database instance fails to restart after node failure.
Examine these tasks (see exhibit):

Identify the minimum steps required, in the correct sequence, to implement this.

• A.  1, 3, 7
• B.  1, 4, 6
• C.  2, 5, 8
• D.  1, 4, 7, 8
• E.  2, 4, 7
• F.  2, 4, 7, 8