Real 1z0-062 are Uploaded by Exam4Labs provide 2022 Latest 1z0-062 Practice Tests Dumps.
All 1z0-062 Dumps and Oracle Database 12c: Installation and Administration Training Courses Help candidates to study and pass the Oracle Database 12c: Installation and Administration Exams hassle-free!
NEW QUESTION 188
You want to create a test database as a replica of your production database with minimum intervention
from a DBA.
Which method would you use?
- A. Use DBCA to create a template from the existing database to contain the database structure and then
manually copy the data by using Oracle Data Pump. - B. Use Database Configuration Assistant (DBCA) to create a template from the existing database to
contain the database structure. - C. Create the database by using the CREATE DATABASE. . .command and manually import data by
using Data Pump. - D. Use DBCA to create a template from the existing database to contain the database structure with data
files and then use the same template to create the database in the new location.
Answer: A
NEW QUESTION 189
You notice that the elapsed time for an important database scheduler Job is unacceptably long.
The job belongs to a scheduler job class and window.
Which two actions would reduce the job's elapsed time?
- A. Moving the job to an existing higher priority scheduler window with the same schedule and duration
- B. Increasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler window
- C. Increasing the priority of the scheduler window to which the job belongs
- D. Increasing the priority of the job class to which the job belongs
- E. Increasing the value of the JOB_QUEUE_PROCESSES parameter
- F. Increasing the job's relative priority within the Job class to which it belongs
Answer: B,F
Explanation:
Explanation/Reference:
Explanation:
B: Job priorities are used only to prioritize among jobs in the same class.
Note: Group jobs for prioritization
Within the same job class, you can assign priority values of 1-5 to individual jobs so that if two jobs in the class are scheduled to start at the same time, the one with the higher priority takes precedence. This ensures that you do not have a less important job preventing the timely completion of a more important one.
C: Set resource allocation for member jobs
Job classes provide the link between the Database Resource Manager and the Scheduler, because each job class can specify a resource consumer group as an attribute. Member jobs then belong to the specified consumer group and are assigned resources according to settings in the current resource plan.
NEW QUESTION 190
Which two statements are true about Automatic Storage Management (ASM)? (Choose two.)
- A. It mirrors data at the allocation unit (AU) level across failure groups within a normal or high redundancy diskgroup.
- B. It mounts databases and diskgroups to make ASM files available to database instances.
- C. It automatically places each disk from an external redundancy diskgroup in its own failure group.
- D. It divides files into extents and allows an extent to span disks.
- E. It spreads files proportionally across all disks in a diskgroup, aiming to ensure that all the disks in a diskgroup have the same I/O load.
Answer: C,E
NEW QUESTION 191
Examine the following steps:
A DBA grants the CREATE TABLE system privilege with ADMIN OPTION to the user
SIDNEY.
SIDNEY grants the CREATE TABLE system privilege to the HR user.
Which statement is true?
- A. NeitherSIDNEYnorHRcan create new tables if the DBA revokes
theCREATETABLEprivilege fromSIDNEY. - B. HRstill retains the CREATE TABLE system privilege if the DBA revokes theCREATETABLEprivilegefromSIDNEY.
- C. SIDNEYcan revoke theCREATETABLEsystem privilege only fromHR, to whom he granted it.
- D. HRcan grant theCREATETABLEsystem privilege to other users.
Answer: A
Explanation:
References:http://www.dba-oracle.com/t_with_grant_admin_privileges.htm
NEW QUESTION 192
You create an Oracle 12c database and then import schemas that are required by an application which has not yet
been developed.
You want to get advice on creation of or modifications to indexes, materialized views and partitioning in these
schemas.
What must you run to achieve this?
- A. SQL Performance Analyzer
- B. SQL Access Advisor with a SQL tuning set
- C. SQL Access Advisor with a hypothetical workload
- D. SQL Tuning Advisor
- E. Automatic Database Diagnostic Monitor (ADDM) report
Answer: C
NEW QUESTION 193
You enabled block change tracking for faster incremental backups in your database. Which background process writes to the change tracking file?
- A. DBWR
- B. SMON
- C. CKPT
- D. MMON
- E. PMON
- F. RBAL
- G. CTWR
Answer: G
NEW QUESTION 194
Identify the access that is initially available to connect to your Database as a Service (DBaaS)
environment.
- A. Cloud Control on port 7799
- B. Enterprise Manager on port 1158
- C. telnet on port 23
- D. SSH on port 22
- E. SSL/TLS on port 443
Answer: D
NEW QUESTION 195
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 view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.
- B. 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.
- C. A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows
- D. A TOP-N query is created to limit the rows to 20 percent of the total rows
Answer: A
NEW QUESTION 196
You notice a performance change in your production Oracle database and you want to know which change has made this performance difference.
You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation.
Which three findings would you get from the report? (Choose three.)
- A. It gives information about statistics collection in both time periods.
- B. It detects the top wait events causing performance degradation.
- C. It identifies any workload change that caused a performance difference in both time periods.
- D. It shows the resource usage for CPU, memory, and I/O in both time periods.
- E. It detects any configuration change that caused a performance difference in both time periods.
- F. It shows the difference in the size of memory pools in both time periods.
Answer: C,D,E
Explanation:
Explanation/Reference:
Explanation:
Keyword: shows the difference.
* Full ADDM analysis across two AWR snapshot periods
Detects causes, measure effects, then correlates them
Causes: workload changes, configuration changes
Effects: regressed SQL, reach resource limits (CPU, I/O, memory, interconnect) Makes actionable recommendations along with quantified impact
* Identify what changed
/Configuration changes, workload changes
* Performance degradation of the database occurs when your database was performing optimally in the past, such as 6 months ago, but has gradually degraded to a point where it becomes noticeable to the users. The Automatic Workload Repository (AWR) Compare Periods report enables you to compare database performance between two periods of time.
While an AWR report shows AWR data between two snapshots (or two points in time), the AWR Compare Periods report shows the difference (ABE) between two periods (or two AWR reports with a total of four snapshots). Using the AWR Compare Periods report helps you to identify detailed performance attributes and configuration settings that differ between two time periods.
NEW QUESTION 197
The HR user receives the following error while inserting data into the sales table:
On investigation, you find that the users tablespace uses Automatic Segment Space Management (ASSM). It is the default tablespace for the HR user with an unlimited quota on it.
Which two methods would you use to resolve this error?
- A. Changing segment space management for the USERS tablespace to manual
- B. Adding a data file to the USERS tablespace
- C. Enabling resumable space allocation by setting the RESUMABLE_TIMEOUT parameter to a nonzero value
- D. Creating a new tablespace with autoextend enabled and changing the default tablespace of the HR user to the new tablespace
- E. Altering the data file associated with the USERS tablespace to ex automatically
Answer: D,E
Explanation:
Explanation/Reference:
Explanation:
NEW QUESTION 198
Which statement is true about a database in ARCHIVELOG mode?
- A. Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.
- B. All backups taken prior to switching to ARCHIVELOG mode can be used to perform complete recovery.
- C. Full database backups can be performed when the database is opened.
- D. A Fast Recovery Area (FRA) must be configured for the database.
Answer: C
NEW QUESTION 199
Identify three benefits of Unified Auditing.
- A. Decreased use of storage to store audit trail rows in the database.
- B. It improves overall auditing performance.
- C. It guarantees zero-loss auditing.
- D. The audit trail cannot be easily modified because it is read-only.
- E. It automatically audits Recovery Manager (RMAN) events.
Answer: A,B,E
Explanation:
A: Starting with 12c, Oracle has unified all of the auditing types into one single unit called Unified auditing. You don't have to turn on or off all of the different auidting types individually and as a matter of fact auditing is enabled by default right out of the box. The AUD$ and FGA$ tables have been replaced with one single audit trail table. All of the audit data is now stored in Secure Files table thus improving the overall management aspects of audit data itself.
B: Further the audit data can also be buffered solving most of the common performance related problems seen on busy environments.
E: Unified Auditing is able to collect audit data for Fine Grained Audit, RMAN, Data Pump, Label Security, Database Vault and Real Application Security operations.
Note:
* Benefits of the Unified Audit Trail
The benefits of a unified audit trail are many:
/ (B) Overall auditing performance is greatly improved. The default mode that unified audit works is Queued Write mode. In this mode, the audit records are batched in SGA queue and is persisted in a periodic way. Because the audit records are written to SGA queue, there is a significant performance improvement.
/ The unified auditing functionality is always enabled and does not depend on the initialization parameters that were used in previous releases
/ (A) The audit records, including records from the SYS audit trail, for all the audited components of your Oracle Database installation are placed in one location and in one format, rather than your having to look in different places to find audit trails in varying formats. This consolidated view enables auditors to co-relate audit information from different components. For example, if an error occurred during an INSERT statement, standard auditing can indicate the error number and the SQL that was executed. Oracle Database Vault-specific information can indicate whether this error happened because of a command rule violation or realm violation. Note that there will be two audit records with a distinct AUDIT_TYPE. With this unification in place, SYS audit records appear with AUDIT_TYPE set to Standard Audit.
/ The management and security of the audit trail is also improved by having it in single audit trail.
/ You can create named audit policies that enable you to audit the supported components listed at the beginning of this section, as well as SYS administrative users. Furthermore, you can build conditions and exclusions into your policies.
* Oracle Database 12c Unified Auditing enables selective and effective auditing inside the Oracle database using policies and conditions. The new policy based syntax simplifies management of auditing within the database and provides the ability to accelerate auditing based on conditions.
* The new architecture unifies the existing audit trails into a single audit trail, enabling simplified management and increasing the security of audit data generated by the database.
NEW QUESTION 200
You set the following parameters in the parameter file and restart the database instance:
Which two statements are true?
- A. The value oftheMEMORY_MAX_TARGETparameter remains zero for the database instance.
- B. TheMEMORY_MAX_TARGETparameter is automatically set to 500 MB.
- C. The instance does not start up because Automatic Memory Management (AMM) is enabled butPGA_AGGREGATE_TARGETandSGA_TARGETparameters are set to nonzero values.
- D. ThePGA_AGGREGATE_TARGETandSGA_TARGETparameters are automatically set to zero.
- E. The lower limits of thePGA_AGGREGATE_TARGETandSGA_TARGETparameters are set to 90 MB and 270 MB respectively.
Answer: A,E
NEW QUESTION 201
A redaction policy was added to the SAL column of the SCOTT.EMP table:
All users have their default set of system privileges.
For which three situations will data not be redacted?
- A. SCOTT sessions, only if the MGR role is granted to SCOTT
- B. SYSTEM session, only if the MGR role is set in the session
- C. SYSTEM sessions, regardless of the roles that are set in the session
- D. SCOTT sessions, only if the MGR role is set in the session
- E. SCOTT sessions, because he is the owner of the table
- F. SYS sessions, regardless of the roles that are set in the session
Answer: A,B,F
Explanation:
* SYS_CONTEXT
This is a twist on the SYS_CONTEXT function as it does not use USERENV. With this usage SYS_CONTEXT queries the
list of the user's current default roles and returns TRUE if the role is granted.
Example:
SYS_CONTEXT('SYS_SESSION_ROLES', 'SUPERVISOR')
conn scott/tiger@pdborcl
SELECT sys_context('SYS_SESSION_ROLES', 'RESOURCE')
FROM dual;
SYS_CONTEXT('SYS_SESSION_ROLES','SUPERVISOR')
---------------------------------------------
FALSE
conn sys@pdborcl as sysdba
GRANT resource TO scott;
conn scott/tiger@pdborcl
SELECT sys_context('SYS_SESSION_ROLES', 'RESOURCE')
FROM dual;
SYS_CONTEXT('SYS_SESSION_ROLES','SUPERVISOR')
---------------------------------------------
TRUE
NEW QUESTION 202
Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB and ACCOUNTS_PDB, both of which use the CDB tablespace. The temp file is called temp01.tmp.
A user issues a query on a table on one of the PDBs and receives the following error:
ERROR at line 1:
ORA-01565: error in identifying file '/u01/app/oracle/oradata/CDB1/temp01.tmp' ORA-27037: unable to obtain file status Identify two ways to rectify the error. (Choose two.)
- A. Add a new temp file to the temporary tablespace and drop the temp file that that produced the error.
- B. Shut down the database instance and then restart the CDB and PDBs.
- C. Take the temporary tablespace offline, recover the missing temp file by applying redo logs, and then bring the temporary tablespace online.
- D. Shutdown the database instance, restore and recover the temp file from the backup, and then open the database with RESETLOGS.
- E. Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.
Answer: A,B
Explanation:
* Because temp files cannot be backed up and because no redo is ever generated for them, RMAN never restores or recovers temp files. RMAN does track the names of temp files, but only so that it can automatically re-create them when needed.
* If you use RMAN in a Data Guard environment, then RMAN transparently converts primary control files to standby control files and vice versa. RMAN automatically updates file names for data files, online redo logs, standby redo logs, and temp files when you issue RESTORE and RECOVER.
NEW QUESTION 203
Which two statements are true about extents? (Choose two.)
- A. Data blocks in an extent are logically contiguous but can be non-contiguous on disk.
- B. Blocks belonging to an extent can be spread across multiple data files.
- C. The blocks of a newly allocated extent, although free, may have been used before.
- D. Data blocks in an extent are automatically reclaimed for use by other objects in a tablespace when all the rows in a table are deleted.
Answer: A,C
Explanation:
Explanation/Reference:
Explanation:
NEW QUESTION 204
Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?
- A. You can perform basic administrative tasks for pluggable databases by using the EM express interface.
- B. By default, EM express is available for a database after database creation.
- C. You cannot start up or shut down a database Instance by using EM express.
- D. You can use EM express to manage multiple databases running on the same server.
- E. You can create and configure pluggable databases by using EM express.
Answer: B
Explanation:
EM Express is built inside the database.
Note:
Oracle Enterprise Manager Database Express (EM Express) is a web-based database management tool that is built
inside the Oracle Database. It supports key performance management and basic database administration functions.
From an architectural perspective, EM Express has no mid-tier or middleware components, ensuring that its overhead
on the database server is negligible.
NEW QUESTION 205
You configure your database Instance to support shared server connections.
Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?
- A. Location of the runtime area for DML and DDL Statements
- B. Stack space
- C. User session data
- D. Private SQL area
- E. Location of a part of the runtime area for SELECT statements
Answer: C,D
Explanation:
A: PGA itself is subdivided. The UGA (User Global Area) contains session state information, including stuff like package-level variables, cursor state, etc. Note that, with shared server, the UGA is in the SGA. It has to be, because shared server means that the session state needs to be accessible to all server processes, as any one of them could be assigned a particular session. However, with dedicated server (which likely what you're using), the UGA is allocated in the PGA.
C: The Location of a private SQL area depends on the type of connection established for a session. If a session is connected through a dedicated server, private SQL areas are located in the server process' PGA. However, if a session is connected through a shared server, part of the private SQL area is kept in the SGA.
Note:
*System global area (SGA) The SGA is a group of shared memory structures, known as SGA components, that contain data and control information for one Oracle Database instance. The SGA is shared by all server and background processes. Examples of data stored in the SGA include cached data blocks and shared SQL areas.
*Program global area (PGA)
A PGA is a memory region that contains data and control information for a server process. It is nonshared memory created by Oracle Database when a server process is started. Access to the PGA is exclusive to the server process. There is one PGA for each server process. Background processes also allocate their own PGAs. The total memory used by all individual PGAs is known as the total instance PGA memory, and the collection of individual PGAs is referred to as the total instance PGA, or just instance PGA. You use database initialization parameters to set the size of the instance PGA, not individual PGAs.
Reference: Oracle Database Concepts 12c
NEW QUESTION 206
......
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:
- 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.
- ‘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.
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.
Valid Way To Pass Oracle's 1z0-062 Exam with : https://www.exam4labs.com/1z0-062-practice-torrent.html