Get Full Version of the Exam
http://www.EnsurePass.com/1z0-062.html

Question No.211

Which two services may you see on the My Service Dashboard page? (Choose two.)

1. Network Cloud Service

2. User Cloud Service

3. Compute Cloud Service

4. Database Cloud Service

Correct Answer: CD

Question No.212

Which statement is true regarding the DEFAULT profile?

1. The values assigned to the resource limits and password parameters in the default profile can be altered.

2. A different DEFAULT profile can be created before each user in a database.

3. It can be dropped and recreated.

4. it must be explicitly assigned to the user.

Correct Answer: A

Question No.213

You want to create a database and you have the following:

Oracle Grid Infrastructure is installed and configured.

Oracle Database Vault is installed in ORACLE_HOME to be used for this database.

Oracle Enterprise Manager Cloud Control is available and an agent is deployed on the database server.

Examine the requirements:

configuring the database instance to support shared server mode

using Automatic Storage Management (ASM) for storing database files.

configuring a naming method to help a remote user connect to a database instance configuring the Fast Recovery Area

configuring Database Vault

configuring Enterprise Manager (EM) Database Express registering with EM Cloud Control

configuring remote log archive destinations enabling daily incremental backups

configuring a nondefault block size for nondefault block size tablespaces

Which of these requirements can be met while creating a database by using the Database Configuration Assistant (DBCA)?

A. 1, 2, 4, 5, 7, 8, 9 and 10

B. 1, 2, 4, 5, 6 and 7

C. 1, 2, 3, 8, 9 and 10

D. 1, 2, 3, 4, 6, 8, 9 and 10

E. 1, 2, 4, 5, 6, 7 and 8

Correct Answer: D

Question No.214

Your database is running in ARCHIVELOG mode.

You want to take a consistent whole database backup.

Which two statements are true in this scenario? (Choose two.)

1. RMAN backups contain only data files.

2. The database instance must be shut down to take a user-managed consistent backup.

3. Consistent RMAN backups can be taken while the database is open.

4. User-managed backups only contain formatted data blocks.

5. The database must be in MOUNT state to take consistent RMAN backups.

Correct Answer: CD

Question No.215

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

1. Enterprise Manager on port 1158

2. telnet on port 23

3. Cloud Control on port 7799

4. SSH on port 22

5. SSL/TLS on port 443

Correct Answer: D

Question No.216

Which two statements are true about resumable space allocation? (Choose two.)

1. A database-level LOGON trigger can be used to automatically configure resumable statement settings for individual sessions.

2. SELECT statements that run out of temporary space for sort areas are candidates for resumable execution.

3. A resumable statement can be suspended and resumed only once during a session.

4. Resumable space allocation does not apply when a database instance uses asynchronous commit.

5. Resumable space allocation does not apply when users exceed their assigned space quota in a tablespace.

6. Free space in a segment is automatically reclaimed when a resumable statement is suspended because of an out-of-space condition.

Correct Answer: AB

Question No.217

Examine the parameters:

Your database instance is started with a PFILE.

You want to increase the size of the buffer cache. Free memory is available to increase the size of the buffer cache.

You execute the command:

SQLgt; ALTER SYSTEM SET DB_CACHE_SIZE=1024M;

Which is the outcome?

1. Change is applied to the current instance, but does not persist after instance restart.

2. The value is changed only in the PFILE and takes effect at the next instance startup.

3. The value is changed for the current instance and in the PFILE.

4. It fails because the SCOPE clause is missing.

Correct Answer: A

Question No.218

Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. Currently, the database is running with peak workload. You want to analyze some of the most resource-intensive statements cached in the library cache. What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance?

1. Automatic Database Diagnostic Monitor (ADDM)

2. SQL Tuning Advisor

3. SQL Access Advisor

4. SQL Performance Analyzer

5. Automatic Workload Repository (AWR) report

Correct Answer: C

Explanation:

https://docs.oracle.com/cd/B28359_01/server.111/b28314/tdpdw_perform.htm#TDPDW008

Question No.219

Unified auditing is enabled in your database. The HR_ADMIN and OE_ADMIN roles exist and are granted system privileges.

You execute the command:

SQLgt;CREATE AUDIT POLICY tab1e_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE ROLES

hr_admin, oe_admin; Which statement is true?

1. It succeeds and needs to be enabled to capture all SQL statements that require either the specified privileges or any privilege granted to the HR_ADMIN and OE_ADMIN role.

2. It fails because system privileges cannot be granted with roles in the same audit policy.

3. It succeeds and starts capturing only successful SQL statements for all users who have either the specified privileges or roles granted to them.

4. It fails because the command does not specify when the unified audit policy should be enforced.

Correct Answer: C

Question No.220

Examine the parameters:

Users complain that their sessions for certain transactions hang. You investigate and discover that some users fail to complete their transactions, causing other transactions to wait on row-level locks.

Which two actions would you take to prevent this problem? (Choose two.)

1. Increase the maximum number of ITL slots for segments on which a blocking user performs a transaction.

2. Decrease the SESSIONS_PER_USER limit in the profiles assigned to blocking users.

3. Set a limit in the proles of blocking users to control the number of data blocks that can be accessed in a session.

4. Use Database Resource Manager to automatically kill the sessions that are idle and are blocking other sessions.

5. Decrease the IDLE_TIME resource limit in the profiles assigned to blocking users.

Correct Answer: BD

Get Full Version of the Exam
1z0-062 Dumps
1z0-062 VCE and PDF