Latest [Nov 23, 2021] 1z0-062 Exam with Accurate Oracle Database 12c: Installation and Administration PDF Questions
Take a Leap Forward in Your Career by Earning Oracle 380 Questions
Conclusion
In summary, it should be recalled that Oracle Database 12c designations accentuate the full set of skills required to work with the DBMS for daily operational management and maintenance. Currently, in the competitive market, it is common practice to validate your skills and experience through certification by nailing the corresponding exam. So, successfully passing the Oracle Database 12c Administration 1Z0-062 test will not only be a shining point on your CV but will also open new doors for you on your path to mastering the Oracle Database environment. All you have to do is make a firm decision, register for the actual exam, and start preparing. You have all the power here!
Oracle 1z0-062 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
Those candidates who are used to referring themselves to self-study and have enough time & motivation in reserve can utilize such study guides and books from the Amazon website:
- ‘OCA Oracle Database 12c Installation and Administration Exam Guide (Exam 1Z0-062)’ by John Watson is an exclusive Oracle Press manual that covers all of the associate-level objectives to prepare for 1Z0-062. Its author, John Watson, as an OCP-level database administrator, will show readers how to install and upgrade Oracle Database software, how to manage Oracle instances alongside database storage structures, and how to implement Oracle Database auditing. Furthermore, upon completion of this book, you will demonstrate expertise in automating tasks, data movement, and installing Oracle Grid infrastructure for a standalone server. What is peculiar about this manual is that each chapter of this resource includes realistic exercises, two-minute drills for every topic, and self-check tests so you can observe the results of your work. This guide is available in Kindle and Paperback versions for anyone interested. However, it should be noted that the electronic version of the book provides access to more than 185 practice exam questions, as well as a test engine so that you will not only get a valuable source of information for quality preparation for your forthcoming 1Z0-062 exam, but also a handy reference for further use in the workplace.
- For those wishing to begin efficient preparation for 1Z0-062, you should take a look at ‘OCA: Oracle Database 12c Administrator Certified Associate Study Guide: Exams 1Z0-061 and 1Z0-062 1st Edition’ written by an industry expert with hands-on Oracle database experience, Biju Thomas. With an extensive set of study tools, including flashcards, summary questions for each chapter, assessment tests, as well as practical labs, you will not only have a comprehensive resource for preparation but will also discover the world of day-to-day work as a database administrator. As a result, you will have honed the skills required for certification, such as restricting and sorting data, creating an Oracle Database, administering user security, and more. You can find this guide on Amazon in both Kindle and paperback versions, and in exchange, you get a convenient preparation source, including real-world scenarios, hands-on exercises, and access to exam prep software.
As you can see, there are more than enough ways for comprehensive and productive revision. Thus, each candidate can choose the preparation tool that suits his or her learning style.
NEW QUESTION 24
You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB).
The characteristics of the non-CDB are as follows:
- Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit
- Character set: AL32UTF8
- National character set: AL16UTF16
- O/S: Oracle Linux 6 64-bit
The characteristics of the CDB are as follows:
- Version: Oracle Database 12c Release 1 64-bit
- Character Set: AL32UTF8
- National character set: AL16UTF16
- O/S: Oracle Linux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?
- A. Data Pump full export/import
- B. The DBMS_PDB package
- C. Transportable tablespace
- D. RMAN
- E. Transportable database
Answer: C
Explanation:
* Overview, example:
- Log into ncdb12c as sys
- Get the database in a consistent state by shutting it down cleanly.
- Open the database in read only mode
- Run DBMS_PDB.DESCRIBE to create an XML file describing the database.
- Shut down ncdb12c
- Connect to target CDB (CDB2)
- Check whether non-cdb (NCDB12c) can be plugged into CDB(CDB2)
- Plug-in Non-CDB (NCDB12c) as PDB(NCDB12c) into target CDB(CDB2).
- Access the PDB and run the noncdb_to_pdb.sql script.
- Open the new PDB in read/write mode.
* You can easily plug an Oracle Database 12c non-CDB into a CDB. Just create a PDB manifest file for the non-CDB, and then use the manifest file to create a cloned PDB in the CDB.
* Note that to plug in a non-CDB database into a CDB, the non-CDB database needs to be of version 12c as well. So existing 11g databases will need to be upgraded to 12c before they can be part of a 12c CDB.
NEW QUESTION 25
Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report:
What are three possible causes for the latch-related wait events?
- A. A large number COMMITS are being performed.
- B. Cursors are not being shared.
- C. The buffers are being read into the buffer cache, but some other session is changing the buffers.
- D. There are frequent logons and logoffs.
- E. The size of the shared pool is too small.
Answer: B,C,E
NEW QUESTION 26
You are administering a database that supports an OLTP workload.
The default UNDOtablespace is a fixed size tablespace with the RETENTION NOGUARATNEEclause and undo retention set to 12 minutes.
The user SCOTTqueries a large table during peak activity.
The query runs for more than 15 minutes and then SCOTTreceives the following error:
ORA-01555: snapshot too old
Which is possible reason for this?
- A. There is not enough space in Fast Recovery Area.
- B. The Oracle server is unable to generate a read-consistent image for a block containing updates.committed after the query began.
- C. The flashback data archive is not enabled for the table on which the query is issued.
- D. The query is unable to place data blocks in the UNDOtablespace.
- E. The Oracle server is unable to generate a read-consistent image for a block containing uncommitted updates.
Answer: B
NEW QUESTION 27
In which two scenarios do you use SQL* Loader to load data?
- A. Load data into multiple tables during the same load statement.
- B. Generate unique sequential key values in specified columns.
- C. Use transparent parallel processing without having to split the external data first.
- D. Transform the data while it is being loaded into the database.
Answer: B,D
Explanation:
You can use SQL*Loader to do the following:
/ (A) Manipulate the data before loading it, using SQL functions.
/ (D) Generate unique sequential key values in specified columns.
etc:
/ Load data into multiple tables during the same load session.
/ Load data across a network. This means that you can run the SQL*Loader client on a different
system from the one that is running the SQL*Loader server.
/ Load data from multiple datafiles during the same load session.
/Specify the character set of the data.
/ Selectively load data (you can load records based on the records' values).
/Use the operating system's file system to access the datafiles.
/ Load data from disk, tape, or named pipe.
/ Generate sophisticated error reports, which greatly aid troubleshooting.
/ Load arbitrarily complex object-relational data.
/ Use secondary datafiles for loading LOBs and collections.
/ Use either conventional or direct path loading. While conventional path loading is very flexible,
direct path loading provides superior loading performance.
Note:
* SQL*Loader loads data from external files into tables of an Oracle database. It has a powerful data parsing engine that puts little limitation on the format of the data in the datafile.
NEW QUESTION 28
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. DBMS_FILE_TRANSFER with transportable tablespace
- B. RMAN CONVERT command
- C. Data Pump Export and import
- D. Conventional Export and Import
- E. The BACKUP AS COPY DATABASE . . . command of RMAN
Answer: B,E
Explanation:
Explanation/Reference:
Explanation:
A:
1. Get the list of all datafiles.
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';
References:
NEW QUESTION 29
Identify two situations in which the alert log file is updated.
- A. Running a query on a table returns ORA-600: Internal Error.
- B. Rebuilding an index using ALTER INDEX . . . REBUILD fails with an ORA-01578:
ORACLE data block corrupted (file # 14, block # 50) error. - C. Inserting a value into a table returns ORA-01722: invalid number.
- D. Inserting a value into a table returns ORA-00001: unique constraint (SYS.OK_TECHP) violated.
- E. Creating a table returns ORA-00955: name us already in used by an existing objects.
Answer: A,B
Explanation:
The alert log is a chronological log of messages and errors, and includes the following items:
*All internal errors (ORA-600), block corruption errors (ORA-1578), and deadlock errors (ORA-60) that occur
* Administrative operations, such as CREATE, ALTER, and DROP statements and STARTUP, SHUTDOWN, and ARCHIVELOG statements
* Messages and errors relating to the functions of shared server and dispatcher processes
* Errors occurring during the automatic refresh of a materialized view
* The values of all initialization parameters that had nondefault values at the time the database and instance start Note:
* The alert log file (also referred to as the ALERT.LOG) is a chronological log of messages and errors written out by an Oracle Database. Typical messages found in this file is:
database startup, shutdown, log switches, space errors, etc. This file should constantly be monitored to detect unexpected messages and corruptions.
NEW QUESTION 30
You find this query being used in your Oracle 12c database:
Which method a used by the optimizer to limit the rows being returned?
- A. A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows
- B. A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.
- C. All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application.
- D. A TOP-N query is created to limit the rows to 20 percent of the total rows
Answer: B
NEW QUESTION 31
Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the root container.
The steps to recover the tablespace are as follows:
1 . Mount the CDB.
2 . Close all the PDBs.
3 . Open the database.
4 . Apply the archive redo logs.
5 . Restore the data file.
6 . Take the SYSAUX tablespace offline.
7 . Place the SYSAUX tablespace online.
8 . Open all the PDBs with RESETLOGS.
9 . Open the database with RESETLOGS.
1 0. Execute the command SHUTDOWN ABORT.
Which option identifies the correct sequence to recover the SYSAUX tablespace?
- A. 6, 5, 4, 7
- B. 10, 1, 5, 8, 10
- C. 10, 1, 2, 5, 8
- D. 10, 1, 2, 5, 4, 9, 8
Answer: A
Explanation:
RMAN> ALTER TABLESPACE sysaux OFFLINE IMMEDIATE;
RMAN> RESTORE TABLESPACE sysaux;
RMAN> RECOVER TABLESPACE sysaux;
RMAN> ALTERTABLESPACE sysaux ONLINE;
* Example:
While evaluating the 12c beta3 I was not able to do the recover while testing "all pdb files lost".
Cannot close the pdb as the system datafile was missing...
So only option to recover was:
Shutdown cdb (10)
startup mount; (1)
restore pluggable database
recover pluggable database
alter database open;
alter pluggable database name open;
Oracle support says: You should be able to close the pdb and restore/recover the system tablespace of PDB.
* Inconsistent backups are usually created by taking online database backups. You can also make an inconsistent backup by backing up data files while a database is closed, either:
/ Immediately after the crash of an Oracle instance (or, in an Oracle RAC configuration, all instances)
/After shutting down the database using SHUTDOWN ABORT
Inconsistent backups are only useful if the database is in ARCHIVELOG mode and all archived redo logs created since the backup are available.
* Open the database with the RESETLOGS option afterfinishing recovery:
SQL> ALTER DATABASE OPEN RESETLOGS;
NEW QUESTION 32
You perform RMAN backups for your database and use a recovery catalog for managing the backups. To free space, you execute this command:
RMAN> DELETE OBSOLETE;
Which three statements are true is this scenario?
- A. The backups deleted are based on the backup retention policy.
- B. A backup sets marked as expired are deleted.
- C. The information related to the backups is removed from the recovery catalog and the control file.
- D. The physical filesrelated to the backup are deleted automatically.
- E. The physical files related to the backup need to be manually deleted.
Answer: A,C,D
NEW QUESTION 33
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. Specify all files inthe CREATE DATABASE statement without using Oracle managed
Files (OMF). - B. Use Oracle Managed Files (OMF).
- C. Specify the DB_FILE_NAMECONVERT initialization parameter.
- D. Specify the SEED FILE_NAME_CONVERT clause.
- E. Specify the PDB_FILE_NAME_CONVERT initialization parameter.
Answer: B,D,E
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
NEW QUESTION 34
Which set of statements is true about data dictionary views?
1 . They are stored in the SYSTEM tablespace.
2 . They are based on virtual tables.
3 . They are owned by the SYS user.
4. They can be queried by a normal user only if the 07_DICTIONARY_ACCESSIBILITY parameter is set to TRUE.
5 . The V$FIXED_TABLE view can be queried to list the names of these views.
6 . They are owned by the SYSTEM user.
- A. 1 and 3
- B. 2, 3, 4, and 5
- C. 2, 5, and 6
- D. 1, 2, and 3
Answer: A
Explanation:
References:https://docs.oracle.com/cd/E11882_01/server.112/e40540/datadict.htm#CNCP
T002
NEW QUESTION 35
Examine the parameters for a database instance:
Your database has three undo tablespaces and the default undo tablespace is not autoextensible.
Resumable space allocation is not enabled for any sessions in the database instance.
What is the effect on new transactions when all undo space in the default undo tablespace is in use by active transactions?
- A. Transactions write their undo in a temporary tablespace.
- B. Transactions fail.
- C. Transactions write their undo in the SYSTEM undo segment.
- D. Transactions wait until space becomes available in UNDOTBS1.
Answer: B
Explanation:
Explanation/Reference:
References https://docs.oracle.com/cd/B19306_01/server.102/b14231/undo.htm (undo retention)
NEW QUESTION 36
You performed an incremental level 0 backup of a database:
RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE;
To enable block change tracking after the incremental level 0 backup, you issued this command:
SQL > ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE
'/mydir/rman_change_track.f';
To perform an incremental level 1 cumulative backup, you issued this command:
RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;
Which three statements are true?
- A. Block change tracking will always reduce I/O performed during cumulative incrementalbackups.
- B. The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.
- C. Backup change trackingwill sometimes reduce I/O performed during cumulative incremental backups.
- D. More than one database block may be read by an incremental backup for a change made to a single block.
- E. The change tracking file must always be backed up when you perform a full database backup.
Answer: A,B,D
Explanation:
Oracle Block Change Tracking
Once enabled; this new 10g feature records the modified since last backup and stores the log of it in a block change tracking file using the CTW (Change Tracking Writer) process.
During backups RMAN uses the log file to identify the specific blocks that must be backed up. This improves RMAN's performance as it does not have to scan whole datafiles to detect changed blocks. Logging of changed blocks is performed by the CTRW process which is also responsible for writing data to the block change tracking file.
Note:
* An incremental level 0 backup backs up all blocks that have ever been in use in this database.
NEW QUESTION 37
In your database instance, the UNDO_RETENTIONparameter is set to 1000and undo retention is not guaranteed for the fixed size undo tablespace.
Which statement is true about undo retention?
- A. Undo is retained in the UNDO tablespace for 1000 seconds, and then moved to the SYSTEM tablespace to provide read consistency.
- B. Inactive undo is retained for 1000 seconds even if new transactions fall due to lack of space in the undo tablespace.
- C. Inactive undo is retained for at least 1000 seconds if free undo space is available.
- D. Undo becomes expired obsolete after 1000 seconds.
Answer: C
NEW QUESTION 38
Which two statements are true about the logical storage structure of an Oracle database?
- A. An extent can span multiple segments.
- B. A data block is the smallest unit of I/O in data files.
- C. It is possible to have tablespaces of different block sizes.
- D. Each data block always corresponds to one operating system block.
- E. An extent contains data blocks that are always physically contiguous on disk.
Answer: A,C
Explanation:
Explanation/Reference:
References:
NEW QUESTION 39
Examine these two statements:
Which three are true about the MRKT tablespace?
- A. The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.
- B. Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.
- C. The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.
- D. No more data files can be added to the tablespace.
- E. The MRKT tablespace may be dropped if it has no contents.
Answer: B,D,E
Explanation:
Explanation/Reference:
Explanation:
NEW QUESTION 40
You determine that database performance is sub-optimal due to hard parsing statements. Automatic Shared Memory Management (ASMM) is disabled for your database instance.
Which tool would you use to get advice on how to improve performance?
- A. Memory Advisor for the PGA
- B. SQL Access Advisor
- C. Memory Advisor for the shared pool
- D. SQL Tuning Advisor
Answer: C
Explanation:
References: http://docs.oracle.com/cd/E25178_01/server.1111/e10897/montune.htm#CHDGFCFJ
NEW QUESTION 41
Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.
Which two RMAN commands may be; used to back up only the PDB1 pluggable database? (Choose two.)
- A. BACKUP DATABASE while connected to the PDB1 container
- B. BACKUP PLUGGABLE DATABASE PDB1 while connected to the root container
- C. BACKUP DATABASE while connected to the boot container
- D. BACKUP PLUGGABLE database PDB1 while connected to PDB2
- E. BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 container
Answer: A,B
Explanation:
Explanation
To perform operations on a single PDB, you can connect as target either to the root or directly to the PDB.
* (A) If you connect to the root, you must use the PLUGGABLE DATABASE syntax in your RMAN commands. For example, to back up a PDB, you use the BACKUP PLUGGABLE DATABASE command.
* (C)If instead you connect directly to a PDB, you can use the same commands that you would use when connecting to a non-CDB. For example, to back up a PDB, you would use the BACKUP DATABASE command.
References:
NEW QUESTION 42
You are connected to a pluggable database (PDB) as a common user with DBA privileges.
The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following:
SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = '*' SCOPE = SPFILE;
Which is true about the result of this command?
- A. The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.
- B. Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.
- C. The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.
- D. The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.
Answer: A
NEW QUESTION 43
Which three statements are true about the working of system privileges in a multitenant control database
(CDB) that has pluggable databases (PDBs)? (Choose three.)
- A. System privileges with the with grant option container all clause must be granted to a common user
before the common user can grant privileges to other users. - B. Local users cannot use local system privileges on the schema of a common user.
- C. The granter of system privileges must possess the set container privilege.
- D. Common users connected to a PDB can exercise privileges across other PDBs.
- E. System privileges apply only to the PDB in which they are used.
Answer: A,C,E
Explanation:
Explanation/Reference:
Explanation:
A, Not D: In a CDB, PUBLIC is a common role. In a PDB, privileges granted locally to PUBLIC enable all
local and common users to exercise these privileges in this PDB only.
C: A user can only perform common operations on a common role, for example, granting privileges
commonly to the role, when the following criteria are met:
The user is a common user whose current container is root.
The user has the SET CONTAINER privilege granted commonly, which means that the privilege applies in
all containers.
The user has privilege controlling the ability to perform the specified operation, and this privilege has been
granted commonly
Incorrect:
Note:
* Every privilege and role granted to Oracle-supplied users and roles is granted commonly except for
system privileges granted to PUBLIC, which are granted locally.
NEW QUESTION 44
......
Authentic Best resources for 1z0-062 Online Practice Exam: https://www.examsreviews.com/1z0-062-pass4sure-exam-review.html