Beginners Guide: oracle database 12c installation and administration 1z0 062 pdf

Guaranteed of oracle database 12c installation and administration 1z0 062 pdf free download materials and training tools for Oracle certification for client, Real Success Guaranteed with Updated 1z0 062 dumps pdf dumps vce Materials. 100% PASS Oracle Database 12c: Installation and Administration exam Today!


♥♥ 2021 NEW RECOMMEND ♥♥

Free VCE & PDF File for Oracle 1Z0-062 Real Exam (Full Version!)

★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions

Free Instant Download NEW 1Z0-062 Exam Dumps (PDF & VCE):
Available on: http://www.surepassexam.com/1Z0-062-exam-dumps.html

Q71. Examine the query and its output executed In an RDBMS Instance: 

Which three statements are true about the users (other than sys) in the output? 

A. The C # # B_ADMIN user can perform all backup and recovery operations using RMAN only. 

B. The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker. 

C. The C # # A_ADMIN user can perform wallet operations. 

D. The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM). 

E. The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus. 

Answer: B,D,E Explanation: 

B: SYSDG administrative privilege has ability to perform Data Guard operations (including startup and shutdown) using Data Guard Broker or dgmgrl. 

D: SYSASM The new (introduced in 11g) SYSASM role to manage the ASM instance, variable extent sizes to reduce shared pool usage, and the ability of an instance to read from a specific disk of a diskgroup 

E (Not A): SYSDBA is like a role in the sense that it is granted, but SYSDBA is a special built-in privilege to allow the DBA full control over the database 

Incorrect: 

Not C: SYSKM. SYSKM administrative privilege has ability to perform transparent data encryption wallet operations. 

Note: 

Use the V$PWFILE_USERS view to see the users who have been granted administrative privileges. 


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

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. 

Answer: A,E 

Explanation: 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-CDB Database Multi-level resource plans Up to 32 consumer groups Subplans / PDB Database Single-level resource plans only Up to 8 consumer groups (not B) No subplans 


Q73. The persistent configuration settings for RMAN have default for all parameters. 

Identify four RMAN commands that produce a multi-section backup. 

A. BACKUP TABLESPACE SYSTEM SECTION SIZE 100M; 

B. BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M; 

C. BACKUP ARCHIVELOG ALL SECTION SIZE 25M; 

D. BACKUP TABLESPACE "TEMP" SECTION SIZE 10M; 

E. BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M; 

F. BACKUP SPFILE SECTION SIZE 1M; 

G. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M; 

Answer: A,B,C,G 


Q74. You plan to migrate your database from a File system to Automata Storage Management (ASM) on same platform. 

Which two methods or commands would you use to accomplish this task? 

A. RMAN CONVERT command 

B. Data Pump Export and import 

C. Conventional Export and Import 

D. The BACKUP AS COPY DATABASE . . . command of RMAN 

E. DBMS_FILE_TRANSFER with transportable tablespace 

Answer: A,D 

Explanation: A: 

1. Get the list of all datafiles. 

. Use the convert datafile command to convert the datafile from the file system to ASM. 

Note: RMAN Backup of ASM Storage 

There is often a need to move the files from the file system to the ASM storage and vice versa. This may come in handy when one of the file systems is corrupted by some means and then the file may need to be moved to the other file system. 

D: Migrating a Database into ASM 

* To take advantage of Automatic Storage Management with an existing database you must migrate that database into ASM. This migration is performed using Recovery Manager (RMAN) even if you are not using RMAN for your primary backup and recovery strategy. 

* Example: 

Back up your database files as copies to the ASM disk group. 

BACKUP AS COPY INCREMENTAL LEVEL 0 DATABASE FORMAT '+DISK' TAG 'ORA_ASM_MIGRATION' 

Reference: Migrating Databases To and From ASM with Recovery Manager 


Q75. You executed a DROP USER CASCADE on an Oracle 11g release 1 database and immediately realized that you forgot to copy the OCA.EXAM_RESULTS table to the OCP schema. 

The RECYCLE_BIN enabled before the DROP USER was executed and the OCP user has been granted the FLASHBACK ANY TABLE system privilege. 

What is the quickest way to recover the contents of the OCA.EXAM_RESULTS table to the OCP schema? 

A. Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO OCP.EXAM_RESULTS; connected as SYSTEM. 

B. Recover the table using traditional Tablespace Point In Time Recovery. 

C. Recover the table using Automated Tablespace Point In Time Recovery. 

D. Recovery the table using Database Point In Time Recovery. 

E. Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO EXAM_RESULTS; connected as the OCP user. 

Answer:

Explanation: RMAN tablespace point-in-time recovery (TSPITR). 

Recovery Manager (RMAN) TSPITR enables quick recovery of one or more tablespaces in a database to an earlier time without affecting the rest of the tablespaces and objects in the database. 

Fully Automated (the default) 

In this mode, RMAN manages the entire TSPITR process including the auxiliary instance. 

You specify the tablespaces of the recovery set, an auxiliary destination, the target time, and you allow RMAN to manage all other aspects of TSPITR. 

The default mode is recommended unless you specifically need more control over the location of recovery set files after TSPITR, auxiliary set files during TSPITR, channel settings and parameters or some other aspect of your auxiliary instance. 


Q76. You use a recovery catalog for maintaining your database backups. 

You execute the following command: $rman TARGET / CATALOG rman / cat@catdb RMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL; 

Which two statements are true? 

A. Corrupted blocks, if any, are repaired. 

B. Checks are performed for physical corruptions. 

C. Checks are performed for logical corruptions. 

D. Checks are performed to confirm whether all database files exist in correct locations 

E. Backup sets containing both data files and archive logs are created. 

Answer: B,D 

Explanation: B (not C): You can validate that all database files and archived redo logs can be backed up by running a command as follows: 

RMAN> BACKUP VALIDATE DATABASE ARCHIVELOG ALL; 

This form of the command would check for physical corruption. To check for logical corruption, 

RMAN> BACKUP VALIDATE CHECK LOGICAL DATABASE ARCHIVELOG ALL; 

D: You can use the VALIDATE keyword of the BACKUP command to do the following: 

Check datafiles for physical and logical corruption 

Confirm that all database files exist and are in the correct locations. 

Note: You can use the VALIDATE option of the BACKUP command to verify that database files exist and are in the correct locations (D), and have no physical or logical corruptions that would prevent RMAN from creating backups of them. When performing a BACKUP...VALIDATE, RMAN reads the files to be backed up in their entirety, as it would during a real backup. It does not, however, actually produce any backup sets or image copies (Not A, not E). 


Q77. Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyze impact on the performance of SQL statements. 

A. Change in the Oracle Database version 

B. Change in your network infrastructure 

C. Change in the hardware configuration of the database server 

D. Migration of database storage from non-ASM to ASM storage 

E. Database and operating system upgrade 

Answer: A,C,E 

Explanation: Oracle 11g/12c makes further use of SQL tuning sets with the SQL Performance Analyzer, which compares the performance of the statements in a tuning set before and after a database change. The database change can be as major or minor as you like, such as: 

* (E) Database, operating system, or hardware upgrades. 

* (A,C) Database, operating system, or hardware configuration changes. 

* Database initialization parameter changes. 

* Schema changes, such as adding indexes or materialized views. 

* Refreshing optimizer statistics. 

* Creating or changing SQL profiles. 


Q78. On your Oracle 12c database, you Issue the following commands to create indexes 

SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE; 

SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id); 

Which two statement are correct? 

A. Both the indexes are created; however, only the ORD_COSTOMER index is visible. 

B. The optimizer evaluates index access from both the Indexes before deciding on which index to use for query execution plan. 

C. Only the ORD_CUSTOMER_IX1 index is created. 

D. Only the ORD_CUSTOMER_IX2 index is created. 

E. Both the indexes are updated when a new row is inserted, updated, or deleted In the orders table. 

Answer: A,E 

Explanation: 11G has a new feature called Invisible Indexes. An invisible index is invisible to the optimizer as default. Using this feature we can test a new index without effecting the execution plans of the existing sql statements or we can test the effect of dropping an index without dropping it. 


Q79. Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source): 

Which three are prerequisites for successful execution of the command? 

A. The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXD_FULL_DATABASE role. 

B. All the user-defined tablespaces must be in read-only mode on the source database. 

C. The export dump file must be created before starting the import on the target database. 

D. The source and target database must be running on the same platform with the same endianness. 

E. The path of data files on the target database must be the same as that on the source database. 

F. The impdp operation must be performed by the same user that performed the expdp operation. 

Answer: A,B,D 

Explanation: In this case we have run the impdp without performing any conversion if 

endian format is different then we have to first perform conversion. 


Q80. You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories. 

You plan to create the database using SQL statements. 

Which three techniques can you use to achieve this? 

A. Use Oracle Managed Files (OMF). 

B. Specify the SEED FILE_NAME_CONVERT clause. 

C. Specify the PDB_FILE_NAME_CONVERT initialization parameter. 

D. Specify the DB_FILE_NAMECONVERT initialization parameter. 

E. Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF). 

Answer: A,B,C 

Explanation: You must specify the names and locations of the seed's files in one of the following ways: 

* (A) Oracle Managed Files 

* (B) The SEED FILE_NAME_CONVERT Clause 

* (C) The PDB_FILE_NAME_CONVERT Initialization Parameter