Free 1Z0-062 Exam Dumps

Question 26

Your database is in NOARCHIVELOG mode. You want to enable archiving for the database. Examine the steps:
1. Execute the ALTER DATABASE ARCHIVELOG command.
2. Execute SHUTDOWN IMMEDIATE.
3. Execute STARTUP MOUNT.
4. Set the DB_RECOVERY_FILE_DEST parameter to $ORACLE_HOME/dbs/.
5. Execute STARTUP NOMOUNT.
6. Open the database.
Identify the required steps in the correct sequence.

A. 4, 2, 5, 1, 6
B. 1, 2, 3, 4, 6
C. 2, 3, 1, 6
D. 2, 5, 1, 6

Correct Answer:C

Question 27

You set the following parameters in the parameter file and restart the database instance:
1Z0-062 dumps exhibit
Which two statements are true? (Choose two.)

A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB.
B. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero.
C. The value of the MEMORY_MAX_TARGET parameter remains zero for the database instance.
D. The lower limits of the PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB respectively.
E. The instance does not start up because Automatic Memory Management (AMM) is enabled but PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to nonzero values.

Correct Answer:AD

Question 28

You install Oracle Grid Infrastructure standalone server and issue the following command: crsctl start has
Which two existing components get automatically added to the Oracle Restart configuration? (Choose two.)

A. Oracle CSSD services
B. the database whose instance is running
C. Oracle Notification services
D. Oracle Healthcheck services
E. Oracle Net Listener

Correct Answer:AC

Question 29

Which statement is true about profiles?

A. Resource limits specified in a profile assigned to a user are always enabled.
B. A user can exist without any profile.
C. A profile can be assigned only to one user.
D. Password management using profiles is always enable

Correct Answer:D

Question 30

Which two statements are true concerning the Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)? (Choose two.)

A. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.
B. In a PDB plan, subplans may be used with up to eight consumer groups.
C. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.
D. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
E. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

Correct Answer:AE
A: Setting a PDB resource plan is optional. If not specified, all sessions within the PDB are treated equally.
*
In a non-CDB database, workloads within a database are managed with resource plans.
In a PDB, workloads are also managed with resource plans, also called PDB resource plans. The functionality is similar except for the following differences:
/ Non-CDBDatabase Multi-level resource plans Up to 32 consumer groups Subplans
/ PDBDatabase
Single-level resource plans only Up to 8 consumer groups
(not B) No subplans