[Aug-2021] Oracle 1z0-062 Dumps – Reduce Your Chance of Failure in 1z0-062 Exam
To help you achieve your ultimate goal, we suggest the actual Oracle 1z0-062 dumps for your Oracle Database 12c: Installation and Administration exam preparation to use as your guideline.
NEW QUESTION 192
The HR schema exists in databases, BOSTON and DENVER, with the same password, HR.
You have CREATE DATABASE LINK and CREATE SESSION privileges in both databases.
DENVER is defined as a service name in the tnsnames.ora of both databases.
You plan to use this command:
CREATE DATABASE LNK hr_link CONNECT TO hr IDENTIFIED BY hr USING 'DENVER'; What must be done to ensure that all users in BOSTON can access the HR schema in DENVER?
- A. Execute the command as SYS in BOSTON.
- B. Execute the command as HR in BOSTON and SYS in DENVER.
- C. Change the command to create a public database link in BOSTON.
- D. Execute the command as SYS in DENVER.
- E. Execute the command as SYS in both databases.
- F. Change the command to create a public database link in DENVER.
Answer: B
NEW QUESTION 193
You run a script that completes successfully using SQL*Plus that performs these actions:
1. Creates a multitenant container database (CDB)
2. Plugs in three pluggable databases (PDBs)
3. Shuts down the CDB instance
4. Starts up the CDB instance using STARTUP OPEN READ WRITE
Which two statements are true about the outcome after running the script? (Choose two.)
- A. The other PDBs will be in mount state.
- B. The seed will be opened read/write.
- C. The seed will be in mount state.
- D. The PDBs will be opened read/write.
- E. The seed will be opened read-only.
- F. The other PDBs will be opened read-only.
Answer: A,E
Explanation:
B: The seed is always read-only.
D: Pluggable databases can be started and stopped using SQL*Plus commands or the ALTER PLUGGABLE DATABASE command.
NEW QUESTION 194
You want to create a table, DAILY_ORDERS, for an OLTP application, where data should be compressed during both direct-path INSERT and conventional DML. The table will also be used for queries.
Which compression option should be used?
- A. COLUMN STORE COMPRESS FOR ARCHIVE LOW
- B. ROW STORE COMPRESS
- C. COLUMN STORE COMPRESS FOR QUERY
- D. ROW STORE COMPRESS ADVANCED
Answer: D
NEW QUESTION 195
You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.
You issue the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;
For which database users is the audit policy now active?
- A. All users except SYS
- B. All users except SCOTT
- C. All users except sys and SCOTT
- D. All users except sys, system, and SCOTT
Answer: B
Explanation:
Explanation/Reference:
Explanation:
If you run multiple AUDIT statements on the same unified audit policy but specify different EXCEPT users, then Oracle Database uses the last exception user list, not any of the users from the preceding lists. This means the effect of the earlier AUDIT POLICY ... EXCEPT statements are overridden by the latest AUDIT POLICY ... EXCEPT statement.
Note:
* The ORA_DATABASE_PARAMETER policy audits commonly used Oracle Database parameter settings.
By default, this policy is not enabled.
* You can use the keyword ALL to audit all actions. The following example shows how to audit all actions on the HR.EMPLOYEES table, except actions by user pmulligan.
Example Auditing All Actions on a Table
CREATE AUDIT POLICY all_actions_on_hr_emp_pol
ACTIONS ALL ON HR.EMPLOYEES;
AUDIT POLICY all_actions_on_hr_emp_pol EXCEPT pmulligan;
References:
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?
- A. It identifies any workload change that caused a performance difference in both time periods.
- B. It detects the top wait events causing performance degradation.
- C. It shows the difference in the size of memory pools in both time periods.
- D. It detects any configuration change that caused a performance difference in both time periods.
- E. It shows the resource usage for CPU, memory, and I/O in both time periods.
- F. It gives information about statistics collection in both time periods.
Answer: A,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.
References:
NEW QUESTION 197
Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column?
- A. All the components may be moved from the SYSAUX tablespace.
- B. The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.
- C. All the components may be moved into SYSAUX tablespace.
- D. The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.
Answer: B,D
NEW QUESTION 198
You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB).
The characteristics of the non-CDB are as follows:
- Version:Oracle Database 12c Releases 1 64-bit
- Character set: WE8ISO8859P15
- National character set: AL16UTF16
- O/S: Oracle Linux6 64-bit
The characteristics of the CDB are as follows:
- Version: Oracle Database 12c Release 1 64-bit
- Character set: AL32UTF8
- O/S:OracleLinux 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. RMAN
- C. The DBMS_PDB package
- D. Transportable tablespace
- E. Transportable database
Answer: C
Explanation:
Note:
* Generating a Pluggable Database Manifest File for the Non-CDB Execute the dbms_pdb.describe procedure to generate the manifest file.
execdbms_pdb.describe(pdb_descr_file=>'/u01/app/oracle/oradata/noncdb/noncdb.xml');
Shut down the noncdb instance to prepare to copy the data files in the next section.
shutdown immediate
exit
NEW QUESTION 199
Examine the parameters for your database instance:
You execute the following command:
SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE;
Which statement is true in this scenario?
- A. Undo data is written to flashback logs after 1200 seconds.
- B. An attempt is made to keep inactive undo for 1200 seconds but transactions may overwrite the undo before that time has elapsed.
- C. You can perform a Flashback Database operation only within the duration of 1200 seconds.
- D. Inactive undo data is retained for 1200 seconds even if subsequent transactions fail due to lack of space in the undo tablespace.
Answer: B
NEW QUESTION 200
Which two files must you copy from the Oracle home of the database that is being upgraded to the new Oracle home for Oracle Database 12c? (Choose three.)
- A. thesqlnet.orafile
- B. thelistener.orafile
- C. the initialization parameter file
- D. thetnsnames.orafile
- E. the password file
Answer: A,B,D
Explanation:
Referenceshttps://docs.oracle.com/cd/E11882_01/server.112/e23633/afterup.htm#UPGRD
52747
NEW QUESTION 201
Your database has been running with a peak load for the past hour. You want to preserve the performance
statistics collected during this period for comparison when you analyze the performance of the database
later.
What must you do to achieve this?
- A. Increase the window size of the moving window baseline so that it equals the Automatic Workload
Repository (AWR) snapshot retention period. - B. Create a baseline on a pair of snapshots that span the peak load period.
- C. Set the snapshot retention period in AWR to 60to avoid automatic purging of snapshots for the past
hour. - D. Generate Active Session History reports for the peak load period.
Answer: B
NEW QUESTION 202
Which three statements are true concerning unplugging a pluggable database (PDB)?
- A. The PDB data files are automatically removed from disk.
- B. The PDB must be dosed.
- C. The unplugged PDB can be plugged into the same multitenant container database (CDB)
- D. The unplugged PDB becomes a non-CDB.
- E. The PDB must be open in read only mode.
- F. The unplugged PDB can be plugged into another CDB.
Answer: B,C,F
Explanation:
B, not A: The PDB must be closed before unplugging it.
D: An unplugged PDB contains data dictionary tables, and some of the columns in these encode information in an endianness-sensitive way. There is no supported way to handle the conversion of such columns automatically. This means, quite simply, that an unplugged PDB cannot be moved across an endianness difference.
E (not F): To exploit the new unplug/plug paradigm for patching the Oracle version most effectively, the source and destination CDBs should share a filesystem so that the PDB's datafiles can remain in place.
Reference: Oracle White Paper, Oracle Multitenant
NEW QUESTION 203
Examine the memory-related parameters set in the SPFILE of an Oracle database:
Which statement is true?
- A. The size of the PGA cannot grow automatically beyond 500 MB.
- B. Only SGA components are sized automatically.
- C. Memory is dynamically re-allocated between the SGA and PGA as needed.
- D. The value of the MEMORY_TARGET parameter cannot be changed dynamically.
Answer: C
NEW QUESTION 204
Which action takes place when a file checkpoint occurs?
- A. The Log Writer process (LGWR) writes all redo entries in the log buffer to online redo log files.
- B. The Database Writer process (DBWn) writes all dirty buffers in the buffer cache to data files.
- C. All buffers for a checkpointed file that were modified before a specific SCN are written to disk by DBWn and the SCN is stored in the control file.
- D. The checkpoint position is advanced in the checkpoint queue.
Answer: B
Explanation:
Explanation/Reference:
Explanation:
NEW QUESTION 205
Your database has the SRV1 service configured for an application that runs on middle-tier application server.
The application has multiple modules. You enable tracing at the service level by executing the following command:
SQL > exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE ('SRV1');
The possible outcome and actions to aggregate the trace files are as follows:
1. The command fails because a module name is not specified.
2. A trace file is created for each session that is running the SRV1 service.
3. An aggregated trace file is created for all the sessions that are running the SRV1 service.
4. The trace files may be aggregated by using the trcess utility.
5. The trace files be aggregated by using the tkprof utility.
Identify the correct outcome and the step to aggregate by using tkprof utility?
- A. 3 and 5
- B. 0
- C. 2 and 5
- D. 2 and 4
- E. 3 and 4
Answer: D
Explanation:
Explanation
Tracing information is present in multiple trace files and you must use the trcsess tool to collect it into a single file.
Incorrect:
Not 1: Parameter service_name
Name of the service for which tracing is enabled.
module_name
Name of the MODULE. An optional additional qualifier for the service.
Note:
* The procedure enables a trace for a given combination of Service, MODULE and ACTION name. The specification is strictly hierarchical: Service Name or Service Name/MODULE, or Service Name, MODULE, and ACTION name must be specified. Omitting a qualifier behaves like a wild-card, so that not specifying an ACTION means all ACTIONs. Using the ALL_ACTIONS constant achieves the same purpose.
* SERV_MOD_ACT_TRACE_ENABLE Procedure
This procedure will enable SQL tracing for a given combination of Service Name, MODULE and ACTION globally unless an instance_name is specified.
* DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE(
service_name IN VARCHAR2,
module_name IN VARCHAR2 DEFAULT ANY_MODULE,
action_name IN VARCHAR2 DEFAULT ANY_ACTION,
waits IN BOOLEAN DEFAULT TRUE,
binds IN BOOLEAN DEFAULT FALSE,
instance_name IN VARCHAR2 DEFAULT NULL);
NEW QUESTION 206
Examine the following query output:
You issue the following command to import tables into the hr schema:
$ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr
TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y
Which statement is true?
- A. Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.
- B. All database operations performed by the impdp command are logged.
- C. Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.
- D. None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.
Answer: A
Explanation:
Oracle Data Pump disable redo logging when loading data into tables and when creating indexes.
The new TRANSFORM option introduced in data pumps import provides the flexibility to turn off the redo generation for the objects during the course of import. The Master Table is used to track the detailed progress information of a Data Pump job.
The Master Table is created in the schema of the current user running the Pump Dump export or import, and it keeps tracks of lots of detailed information.
NEW QUESTION 207
In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container:
Which two statements are true? (Choose two.)
- A. The statement for granting a role to a user fails because the CONTAINER clause is not used.
- B. The C # # ROLE1 role is created only in the root database because the container clause is not used.
- C. Privileges are granted to the C##A_ADMIN user only in the root database.
- D. Privileges are granted to the C##A_ADMIN user in the root database and all PDBs.
- E. The C # # ROLE1 role is created in the root database and all the PDBs.
Answer: C,E
Explanation:
* You can include the CONTAINER clause in several SQL statements, such as the CREATE USER, ALTER USER, CREATE ROLE, GRANT, REVOKE, and ALTER SYSTEM statements.
* * CREATE ROLE with CONTAINER (optional) clause
/ CONTAINER = ALL
Creates a common role.
/ CONTAINER = CURRENT
Creates a local role in the current PDB.
NEW QUESTION 208
Which three statements are true about adaptive SQL plan management? (Choose three.)
- A. It adds new, bettor plans automatically as fixed plans to the baseline.
- B. It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.
- C. The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.
- D. The optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline.
- E. The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.
Answer: B,C,E
Explanation:
With adaptive SQL plan management, DBAs no longer have to manually run the verification or evolve process for non-accepted plans. When automatic SQL tuning is in COMPREHENSIVE mode, it runs a verification or evolve process for all SQL statements that have non-accepted plans during the nightly maintenance window. If the non-accepted plan performs better than the existing accepted plan (or plans) in the SQL plan baseline, then the plan is automatically accepted and becomes usable by the optimizer. After the verification is complete, a persistent report is generated detailing how the non-accepted plan performs compared to the accepted plan performance. Because the evolve process is now an AUTOTASK, DBAs can also schedule their own evolve job at end time.
Note:
* The optimizer is able to adapt plans on the fly by predetermining multiple subplans for portions of the plan.
* Adaptive plans, introduced in Oracle Database 12c, enable the optimizer to defer the final plan decision for a statement until execution time. The optimizer instruments its chosen plan (the default plan) with statistics collectors so that it can detect at runtime, if its cardinality estimates differ greatly from the actual number of rows seen by the operations in the plan. If there is a significant difference, then the plan or a portion of it will be automatically adapted to avoid suboptimal performance on the first execution of a SQL statement.
References:
NEW QUESTION 209
......
Accurate & Verified Answers As Seen in the Real Exam here: https://www.certkingdompdf.com/1z0-062-latest-certkingdom-dumps.html