22 August, 2022

The Secret Of Oracle 1Z0-062 Latest Exam

Examcollection offers free demo for 1Z0-062 exam. "Oracle Database 12c: Installation and Administration", also known as 1Z0-062 exam, is a Oracle Certification. This set of posts, Passing the Oracle 1Z0-062 exam, will help you answer those questions. The 1Z0-062 Questions & Answers covers all the knowledge points of the real exam. 100% real Oracle 1Z0-062 exams and revised by experts!

Free 1Z0-062 Demo Online For Oracle Certifitcation:

Page: 1 / 30

Total 362 questions Full Exam Access

Question 1

After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows:
1Z0-062 dumps exhibit

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?

Re-enable redaction policies that use FULL data redaction.

Re-create redaction policies that use FULL data redaction.

Re-connect the sessions that access objects with redaction policies defined on them.

Flush the shared pool.

Restart the database instance.

My answer: -

Reference answer: E

Reference analysis:

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.

Question 2

Examine this command:
SQL > exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’);
Which three statements are true about the effect of this command? (Choose three.)

Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.

Statistics collection is not done for the CUSTOMERS table when database stats are gathered.

Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.

Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.

Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.

Question 3

A redaction policy was added to the SAL column of the SCOTT.EMP table:
1Z0-062 dumps exhibit

All users have their default set of system privileges.
For which three situations will data not be redacted? (Choose three.)

SYS sessions, regardless of the roles that are set in the session

SYSTEM sessions, regardless of the roles that are set in the session

SCOTT sessions, only if the MGR role is set in the session

SCOTT sessions, only if the MGR role is granted to SCOTT

SCOTT sessions, because he is the owner of the table

SYSTEM session, only if the MGR role is set in the session

Question 4

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?

Transportable database

Transportable tablespace

Data Pump full export/import

The DBMS_PDB package

RMAN

Question 5

Which users are created and can be used for database and host management of your DBaaS database servers?

opc and oracle users

root, oracle and cloud users

root and oracle users

root, opc and oracle users

cloud and oracle users

Question 6

Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)

The ADDM requires at least four AWR snapshots for analysis

The ADDM runs after each AWR snapshot is collected automatically by MMON

The results of the ADDM analysis are stored in the Automatic Workload Repository (AWR)

The ADDM analysis provides only diagnostics information but does not provide recommendations

The ADDM calls other advisors if required, but does not provide recommendations about the advisors

Question 7

You are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace.
The table does not have a primary key and is used by an OLTP application.
Which technique will move the table and indexes while maintaining the highest level of availability to the application?

Oracle Data Pump.

An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.

An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.

Online Table Redefinition.

Edition-Based Table Redefinition.

My answer: -

Reference answer: D

Reference analysis:

* Oracle Database provides a mechanism to make table structure modifications without significantly affecting the availability of the table. The mechanism is called online table redefinition. Redefining tables online provides a substantial increase in availability compared to traditional methods of redefining tables.
* To redefine a table online:
Choose the redefinition method: by key or by rowid
* By key—Select a primary key or pseudo-primary key to use for the redefinition. Pseudo-primary keys are unique keys with all component columns having NOT NULL constraints. For this method, the versions of the tables before and after redefinition should have the same primary key columns. This is the preferred and default method of redefinition.
* By rowid—Use this method if no key is available. In this method, a hidden column named M_ROW$$ is added to the post-redefined version of the table. It is recommended that this column be dropped or marked as unused after the redefinition is complete. If COMPATIBLE is set to 10.2.0 or higher, the final phase of redefinition automatically sets this column unused. You can then use the ALTER TABLE ... DROP UNUSED COLUMNS statement to drop it.
You cannot use this method on index-organized tables. Note:
* When you rebuild an index, you use an existing index as the data source. Creating an index in this manner enables you to change storage characteristics or move to a new tablespace. Rebuilding an index based on an existing data source removes intra-block fragmentation. Compared to dropping the index and using the CREATE INDEX statement, re- creating an existing index offers better performance.
Incorrect:
Not E: Edition-based redefinition enables you to upgrade the database component of an application while it is in use, thereby minimizing or eliminating down time.

Question 8

Which two tasks must you perform before you begin the upgrade process to Oracle Database 12c? (Choose two.)

Put all readonly tablespaces in read write mode

Recompile all invalid objects

Set the compatible parameter to 12.1.0.1

Gather dictionary statistics

Empty all user recycle bins

Question 9

Your database has archive logging enabled and RMAN backups are taken at regular intervals. A data file in the USERS tablespace is damaged.
Which command must you execute before starting the recovery of this tablespace?

ALTER TABLESPACE users OFFLINE

STARTUP FORCE NOMOUNT

STARTUP FORCE

SWITCH DATAFILE ALL

Question 10

Your database instance has Automatic Memory Management enabled and supports shared server connections. Examine the following:
1. Parallel execution messages and control structures
2. Local variables for a process
3. Security and resource usage information
4. Runtime memory values, such as rows retrieved for a SQL statement using a serial execution plan
5. SQL execution work areas
Which option indicates what is allocated from the large pool in this instance?

only 1

1, 2, and 5

1, 2, 3, and 5

1, 2, and 4

Question 11

Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report:
1Z0-062 dumps exhibit

What are three possible causes for the latch-related wait events?

The size of the shared pool is too small.

Cursors are not being shared.

A large number COMMITS are being performed.

There are frequent logons and logoffs.

The buffers are being read into the buffer cache, but some other session is changing the buffer

Question 12

Which two statements are true about Automatic Storage Management (ASM)? (Choose two.)

It mounts databases and diskgroups to make ASM files available to database instances.

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.

It automatically places each disk from an external redundancy diskgroup in its own failure group.

It divides files into extents and allows an extent to span disks.

It mirrors data at the allocation unit (AU) level across failure groups within a normal or high redundancy diskgrou

Question 13

In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time.
How would you accomplish this?

Setting a metric threshold

Implementing Database Resource Manager

Enabling resumable timeout for user sessions

Decreasing the value of the IDLE_TIME resource limit in the default profile

Question 14

Examine this command:
SQL> ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE;
Which two statements are true? (Choose two.)

All data definition language (DDL) statements are written to the control file

Some DDL statements are written to an XML file in the ADR home

All DDL statements are logged in to a text file in Automatic Diagnostic Repository (ADR) home

Some data definition language (DDL) statements are written to the control file

Some DDL statements are written to a text file in the ADR home

The Alert Log still contains some DDL statements

Question 15

Examine the following command;
ALTER SYSTEM SET enable_ddl_logging = TRUE; Which statement is true?

Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.

All DDL commands are logged in the alert log file.

All DDL commands are logged in a different log file that contains DDL statements and their execution dates.

Only DDL commands that resulted in the creation of new segments are logged.

All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.

Question 16

Examine the query and its output executed In an RDBMS Instance:
1Z0-062 dumps exhibit

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

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

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

The C # # A_ADMIN user can perform wallet operations.

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

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

Question 17

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.)

Increase the size of the temporary tablespace.

Enable Automatic Memory Management (AMM).

Enable undo retention guarantee.

Enable temporary undo for the database.

Increase the size of the redo log buffe

Question 18

The HR schema exists in two databases, BOSTON and DENVER, and has the same password, HR. You have the CREATE DATABASE LINK and CREATE SESSION privileges on both the database. BOSTON is defined as a service name in the tnsnames.ora of both the databases.
You plan to use the command:
CREATE DATABASE LINK hr_link CONNECT to hr IDENTIFIED BY hr USING 'denver';
What must be done to ensure only the HR user in the BOSTON database can access the HR schema in the DENVER database?

Execute this command as HR user in the BOSTON database and SYS user in the DENVER database.

Execute this command as SYS user in both the databases.

Execute this command as HR user in the DENVER database.

Execute this command as HR user in the BOSTON databas

Question 19

The HR user executes the following query on the EMPLOYEES table but does not issue COMMIT, ROLLBACK, or any data definition language (DDL) command after that:
1Z0-062 dumps exhibit

HR then opens a second session.
Which two operations wait when executed in HR’s second session? (Choose two.)

LOCK TABLE employees IN EXCLUSIVE MODE;

INSERT INTO employees(empno,ename) VALUES (1289, ‘Dick’);

SELECT job FROM employees WHERE job=’CLERK’ FOR UPDATE OF empno;

SELECT empno,ename FROM employees WHERE job=’CLERK’;

INSERT INTO employees(empno,ename,job) VALUES (2001,’Harry’,’CLERK);

Question 20

Which three file types are stored in the Fast Recovery Area by default in a traditional nonOMF file system? (Choose three.)

online redo log files

parameter file

multiplexed copies of the current control file

archived log files

Flashback Data Archive files

Flashback logs

Question 21

You created an encrypted tablespace:
1Z0-062 dumps exhibit

You then closed the encryption wallet because you were advised that this is secure.
Later in the day, you attempt to create the EMPLOYEES table in the SECURESPACE tablespace with the SALT option on the EMPLOYEE column.
Which is true about the result?

It creates the table successfully but does not encrypt any inserted data in the EMPNAME column because the wallet must be opened to encrypt columns with SALT.

It generates an error when creating the table because the wallet is closed.

It creates the table successfully, and encrypts any inserted data in the EMPNAME column because the wallet needs to be open only for tablespace creation.

It generates error when creating the table, because the salt option cannot be used with encrypted tablespaces.

Question 22

You install Oracle Grid Infrastructure for a standalone server.
Which two components are automatically included in the Oracle Restart configuration? (Choose two.)

A pre-existing Oracle Net Listener

Oracle Notification services

A pre-existing database

A pre-existing Oracle management agent

Oracle CSSD service

Question 23

Which three features work together, to allow a SQL statement to have different cursors for the same statement based on different selectivity ranges? (Choose three.)

Bind Variable Peeking

SQL Plan Baselines

Adaptive Cursor Sharing

Bind variable used in a SQL statement

Literals in a SQL statement

Page: 1 / 30

Total 362 questions Full Exam Access