[Jan 16, 2022] 1z0-062 Test Engine files, 1z0-062 Dumps PDF
Latest Oracle 1z0-062 PDF and Dumps (2022) Free Exam Questions Answers
NEW QUESTION 193
Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the HR_PDB. You execute the following command:
SQL > CREATE UNDO TABLESPACE undotb01
DATAFILE 'u01/oracle/rddb1/undotbs01.dbf' SIZE 60M AUTOEXTEND ON;
What is the result?
- A. It executes successfully but neither tablespace nor the data file is created.
- B. It executes successfully and creates an UNDO tablespace in HR_PDB.
- C. It falls and reports an error because there can be only one undo tablespace in a CD
- D. It fails and reports an error because the CONTAINER=ALL clause is not specified in the command.
- E. It fails and reports an error because the CONTAINER=CURRENT clause is not specified in the command.
Answer: A
Explanation:
Interesting behavior in 12.1.0.1 DB of creating an undo tablespace in a PDB. With the new Multitenant architecture the undo tablespace resides at the CDB level and PDBs all share the same UNDO tablespace.
When the current container is a PDB, an attempt to create an undo tablespace fails without returning an error.
NEW QUESTION 194
As a user of the ORCL database, you establish a database link to the remote HQ database such that all users in the ORCL database may access tables only from the SCOTT schema in the HQ database.
SCOTT's password is TIGER. The service mane "HQ" is used to connect to the remote HQ database.
Which command would you execute to create the database link?
- A. CREATE PUBLIC DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING 'HQ';
- B. CREATE DATABASE LINK HQ CONNECT TO CURRENT_USER USING 'HQ';
- C. CREATE DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING 'HQ';
- D. CREATE DATABASE LINK HQ USING 'HQ';
Answer: A
Explanation:
Explanation/Reference:
Explanation:
NEW QUESTION 195
In your Oracle 12c database, you plan to execute the command:
SQL> CREATE TABLESPACE tbs1 DATAFILE '/u02/oracle/data/tbs01.dbf' SIZE 50M;
The u02 file system has 1 GB of free space available.
What is the outcome?
- A. It creates a locally managed tablespace with manual segment space management enabled.
- B. It creates a locally managed tablespace with automatic segment space management enabled.
- C. It creates a dictionary-managed tablespace with manual segment space management enabled.
- D. It raises an error because extent management is not specified.
Answer: B
Explanation:
References:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces002.htm#ADMIN11359
NEW QUESTION 196
You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute the following script:
SQL > @utlrp.sql
Which two actions does the script perform?
- A. Sequential recompilation of any stored PL/SQL code
- B. Parallel recompilation of Java code
- C. Sequential recompilation of only the stored PL/SQL code
- D. Parallel recompilation of any stored PL/SQL code
- E. Sequential recompilation of Java code
- F. Parallel compilation of only the stored PL/SQL code
Answer: B,D
Explanation:
Explanation/Reference:
Explanation:
utlrp.sql and utlprp.sql
The utlrp.sql and utlprp.sql scripts are provided by Oracle to recompile all invalid objects in the database.
They are typically run after major database changes such as upgrades or patches. They are located in the
$ORACLE_HOME/rdbms/admin directory and provide a wrapper on the UTL_RECOMP package. The utlrp.sql script simply calls the utlprp.sql script with a command line parameter of "0". The utlprp.sql accepts a single integer parameter that indicates the level of parallelism as follows.
0 - The level of parallelism is derived based on the CPU_COUNT parameter.
1 - The recompilation is run serially, one object at a time.
N - The recompilation is run in parallel with "N" number of threads.
Both scripts must be run as the SYS user, or another user with SYSDBA, to work correctly.
References:
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 three operations can be performed as multipartition operations in Oracle? (Choose three.)
- A. Merge partitions of a list partitioned table
- B. Merge partitions of a reference partitioned index
- C. Move partitions of a range-partitioned table
- D. Coalesce partitions of a hash-partitioned global index.
- E. Drop partitions of a list partitioned table
- F. Rename partitions of a range partitioned table
Answer: A,B,E
Explanation:
Explanation/Reference:
Explanation:
Multipartition maintenance enables adding, dropping, truncate, merge, split operations on multiple partitions.
A: Merge Multiple Partitions:
The new "ALTER TABLE ... MERGE PARTITIONS " help merge multiple partitions or subpartitions with a single statement. When merging multiple partitions, local and global index operations and semantics for inheritance of unspecified physical attributes are the same for merging two partitions.
B: Drop Multiple Partitions:
The new "ALTER TABLE ... DROP PARTITIONS " help drop multiple partitions or subpartitions with a single statement.
Example:
view plaincopy to clipboardprint?
SQL> ALTER TABLE Tab_tst1 DROP PARTITIONS
Tab_tst1_PART5, Tab_tst1_PART6, Tab_tst1_PART7;
Table altered
SQL>
Restrictions :
- You can't drop all partitions of the table.
- If the table has a single partition, you will get the error: ORA-14083: cannot drop the only partition of a partitioned.
NEW QUESTION 199
Automatic Shared Memory Management is enabled for your database instance. You notice that there are SQL statements performing poorly because of repeated parsing activity.
Which action generates recommendations to overcome the performance issues?
- A. running the Memory Advisor for the library cache
- B. running the Memory Advisor for the SGA
- C. running the Memory Advisor for the buffer cache
- D. running the Memory Advisor for the PGA
Answer: A
NEW QUESTION 200
Which three statements are true about adaptive SQL plan management?
- A. It adds new, bettor plans automatically as fixed plans to the baseline.
- B. The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.
- C. It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than 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:
Explanation/Reference:
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 201
Examine the query and its output:
What might have caused three of the alerts to disappear?
- A. An Automatic Workload Repository (AWR) snapshot was taken before the execution of the second query.
- B. The database instance was restarted before the execution of the second query.
- C. An Automatic Database Diagnostic Monitor (ADOM) report was generated before the execution of the second query.
- D. The threshold alerts were cleared and transferred to DBA_ALERT_HISTORY.
Answer: B
Explanation:
Explanation/Reference:
Explanation:
NEW QUESTION 202
Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it.
This consumes a lot of undo tablespace and generates lots of redo.
Which two actions would you take to solve this problem? (Choose two.)
- A. Enable temporary undo for the database.
- B. Enable undo retention guarantee.
- C. Increase the size of the redo log buffer.
- D. Increase the size of the temporary tablespace.
- E. Enable Automatic Memory Management (AMM).
Answer: A,D
NEW QUESTION 203
Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the HR_PDB. You execute the following command:
SQL > CREATE UNDO TABLESPACE undotb01
DATAFILE 'u01/oracle/rddb1/undotbs01.dbf' SIZE 60M AUTOEXTEND ON;
What is the result?
- A. It executes successfully but neither tablespace nor the data file is created.
- B. It executes successfully and creates an UNDO tablespace in HR_PDB.
- C. It falls and reports an error because there can be only one undo tablespace in a CD
- D. It fails and reports an error because the CONTAINER=ALL clause is not specified in the command.
- E. It fails and reports an error because the CONTAINER=CURRENT clause is not specified in the command.
Answer: A
Explanation:
Interesting behavior in 12.1.0.1 DB of creating an undo tablespace in a PDB.With the new
Multitenant architecture the undo tablespace resides at the CDB level and PDBs all share the same UNDO tablespace.
When the current container is a PDB, an attempt to create an undo tablespace fails without returning an error.
NEW QUESTION 204
Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache.
What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?
- A. Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.
- B. Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.
- C. Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.
- D. Run the Automatic Workload Repository Monitor (ADDM).
Answer: B
Explanation:
Explanation/Reference:
Explanation:
* SQL Access Advisor is primarily responsible for making schema modification recommendations, such as adding or dropping indexes and materialized views. SQL Tuning Advisor makes other types of recommendations, such as creating SQL profiles and restructuring SQL statements.
* The query optimizer can also help you tune SQL statements. By using SQL Tuning Advisor and SQL Access Advisor, you can invoke the query optimizer in advisory mode to examine a SQL statement or set of statements and determine how to improve their efficiency. SQL Tuning Advisor and SQL Access Advisor can make various recommendations, such as creating SQL profiles, restructuring SQL statements, creating additional indexes or materialized views, and refreshing optimizer statistics.
Note:
* Decision support system (DSS) workload
* The library cache is a shared pool memory structure that stores executable SQL and PL/SQL code. This cache contains the shared SQL and PL/SQL areas and control structures such as locks and library cache handles.
References:
NEW QUESTION 205
After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows:
After changing the value, you notice that FULL redaction continues to redact numeric data with zero.
What must you do to activate the new default value for numeric full redaction?
- A. Re-create redaction policies that use FULL data redaction.
- B. Flush the shared pool.
- C. Re-enable redaction policies that use FULL data redaction.
- D. Restart the database instance.
- E. Re-connect the sessions that access objects with redaction policies defined on them.
Answer: D
Explanation:
About Altering the Default Full Data Redaction Value You can alter the default displayed values for full Data Redaction polices. By default, 0 is the redacted value when Oracle Database performs full redaction (DBMS_REDACT.FULL) on a column of the NUMBER data type. If you want to change it to another value (for example, 7), then you can run the DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES procedure to modify this value. The modification applies to all of the Data Redaction policies in the current database instance. After you modify a value, you must restart the database for it to take effect.
Note:
*The DBMS_REDACT package provides an interface to Oracle Data Redaction, which enables you to mask (redact) data that is returned from queries issued by low-privileged users or an application.
*UPDATE_FULL_REDACTION_VALUES Procedure
This procedure modifies the default displayed values for a Data Redaction policy for full redaction.
*After you create the Data Redaction policy, it is automatically enabled and ready to redact data.
*Oracle Data Redaction enables you to mask (redact) data that is returned from queries issued by low-privileged users or applications. You can redact column data by using one of the following methods:
/ Full redaction. / Partial redaction. / Regular expressions. / Random redaction. / No redaction.
Reference: Oracle Database Advanced Security Guide 12c, About Altering the Default Full Data Redaction Value
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. All database operations performed by the impdp command are logged.
- B. Only CREATE TABLE and ALTER TABLE statements generated by the import 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: B
Explanation:
Explanation/Reference:
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
Your database is running in NOARCHIVLOG mode.
Examine the following parameters:
You execute the following command after performing a STARTUP MOUNT:
SQL> ALTER DATABASE ARCHIVELOG;
Which statement is true about the execution of the command?
- A. It executes successfully and sets the Fast Recovery Area as the local archive destination.
- B. It executes successfully and sets $ORACLE_HOME/dbs as the default archive destination.
- C. It executes successfully and issues a warning to set LOG_ARCHIVE_DEST while opening the database.
- D. It fails and returns an error about LOG_ARCHIVE_DEST not being set.
Answer: A
NEW QUESTION 208
Which two statements are true?
- A. The predefined connect role is always automatically granted to all new users at the time of their creation.
- B. The predefined resource role includes the unlimited_tablespace privilege.
- C. A role can contain both system and object privileges.
- D. All roles are owned by the sys user.
- E. A role cannot be assigned external authentication.
- F. A role can be granted to other roles.
Answer: C,F
NEW QUESTION 209
Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN.
You want to issue the following RMAN command:
RMAN > BACKUP TABLESPACE hr_pdb:userdata;
Which task should you perform before issuing the command?
- A. Ensure that HR_PDB is open.
- B. Take the user data tablespace offline.
- C. Place the root container in ARHCHIVELOG mode.
- D. Place the root container in the nomount stage.
Answer: C
Explanation:
Explanation/Reference:
Explanation:
NEW QUESTION 210
Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance.
What should you use to achieve this?
- A. SQL Performance Analyzer
- B. Database replay
- C. SQL Access Advisor
- D. Automatic Workload Repository compare reports
- E. SQL Tuning Advisor
Answer: A
Explanation:
Explanation
You can use the SQL Performance Analyzer to analyze the SQL performance impact of any type of system change. Examples of common system changes include:
* Database upgrades
* Configuration changes to the operating system, hardware, or database
* Database initialization parameter changes
* Schema changes, such as adding new indexes or materialized views
* Gathering optimizer statistics
* SQL tuning actions, such as creating SQL profiles
References:
http://docs.oracle.com/cd/B28359_01/server.111/b28318/intro.htm#CNCPT961
NEW QUESTION 211
......
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!
Pass Your Oracle Database 1z0-062 Exam on Jan 16, 2022 with 380 Questions: https://www.exam4docs.com/1z0-062-study-questions.html
