19 August, 2022

What Accurate 1Z0-062 Testing Material Is

we provide High value Oracle 1Z0-062 test questions which are the best for clearing 1Z0-062 test, and to get certified by Oracle Oracle Database 12c: Installation and Administration. The 1Z0-062 Questions & Answers covers all the knowledge points of the real 1Z0-062 exam. Crack your Oracle 1Z0-062 Exam with latest dumps, guaranteed!

Check 1Z0-062 free dumps before getting the full version:

Page: 1 / 30

Total 362 questions Full Exam Access

Question 1

Which three statements are true about SQL plan directives? (Choose three.)

They are tied to a specific statement or SQL ID.

They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan.

They are used to gather only missing statistics.

They are created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect.

They instruct the optimizer to create only column group statistics.

Improve plan accuracy by persisting both compilation and execution statistics in the SYSAUX tablespac

Question 2

Which two statements are true about extents? (Choose two.)

Blocks belonging to an extent can be spread across multiple data files.

Data blocks in an extent are logically contiguous but can be non-contiguous on disk.

The blocks of a newly allocated extent, although free, may have been used before.

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.

Question 3

Which two statements are true about availability audit features after migration to unified auditing? (Choose two.)

The ability of users to audit their own schema objects is not available in the post-migrated database.

Operating system audit trail is available in the post-migrated database.

Network auditing is available in the post-migrated database.

Mandatory auditing of audit administrative actions is available in the post-migrated database.

Question 4

What should you do to ensure that a job stores minimal job metadata and runtime data on disk, and uses only existing PL/SQL programs?

Create an event-based job.

Create a lightweight job.

Specify the job as a member of a job class.

Use a job array.

Question 5

You use multiple temporary tables frequently in your database. Which two are benefits of configuring temporary undo? (Choose two.)

Performance improves because less redo is written to the redo log.

Temporary undo reduces the amount of undo stored in undo tablespaces.

Performance improves because data manipulation language (DML) operations performed on temporary tables do not use the buffer cache.

Performance improves because no redo and undo are generated for the temporary table

Question 6

You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further investigation, you find that queries are performing too many full table scans and indexes are not being used even though the filter columns are indexed. Identify three possible reasons for this.

Missing or stale histogram statistics

Undersized shared pool

High clustering factor for the indexes

High value for the DB_FILE_MULTIBLOCK_READ_COUNT parameter

Oversized buffer cache

Question 7

Which two statements are true about initialization parameter files? (Choose two.)

A lost or damaged SPFILE can be re-created by using the parameter values listed in the alert log.

A PFILE must exist for an SPFILE to be created.

The ALTER SYSTEM command cannot be used to change the value of any parameter if a database instance has started using a PFILE.

Both the SPFILE and PFILE must always reside on a file system accessible from the database host server.

On startup, by default a database instance always first searches for an SPFILE, and if it does not find any, searches for a PFILE.

Question 8

Which two statements are true about Oracle network connections? (Choose two.)

A listener may listen on behalf of only one database instance at a time.

A server process checks a user’s authentication credentials and creates a session if the credentials are valid.

The listener continuously monitors a connection after the user process connects to a service handler.

The listener always spawns a new server process to deal with each new connection.

A connection request from a client is always first received by a listener running on the port that is used for the connection request for the database server.

Question 9

Examine the commands executed to monitor database operations:
$> conn sys oracle/oracle@prod as sysdba SQL > VAR eid NUMBER
SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING => ‘Y’);
Which two statements are true? (Choose two.)

Database operations will be monitored only when they consume a significant amount of resource.

Database operations for all sessions will be monitored.

Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.

Only DML and DDL statements will be monitored for the session.

All subsequent statements in the session will be treated as one database operation and will be monitored.

Question 10

Which four statements are true about the components of the Oracle Scheduler? (Choose four.)

A schedule can be specified to a single job only.

A scheduler job can point to a chain instead of pointing to a single program object.

A job may get started automatically when a window opens.

A program and job can be specified as part of a schedule definition.

A job is specified as part of a program specification.

A program can be used in the definition of multiple jobs.

A program and schedule can be specified as part of a job definition.

Question 11

Which three statements are true about checkpointing? (Choose three.)

It prompts the Checkpoint (CKPT) process to write data to the data files and redo information to the online redo log files.

It ensures that all dirty buffers are written to data files during consistent shutdown.

It reduces the time required for recovery in case of an instance failure.

Frequent thread checkpoints can degrade database performance.

It prompts the Database Writer (DBWn) process to write checkpoint information into data file headers and the control file.

Question 12

You want to create a locally managed tablespace called NEWTBS to store segments with different extent sizes. Which set of tablespace attributes can be specified for a tablespace that satisfies the requirements?

EXTENT MANAGEMENT LOCAL STORAGE (INITIAL 5M MAXSIZE 10M)

REUSE AUTOEXTEND ON MAXSIZE UNLIMITED

EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT UNIFORM

EXTENT MANAGEMENT LOCAL AUTOALLOCATE

Question 13

You execute this command:
1Z0-062 dumps exhibit

Which two statements are true about segment space management for segments in this tablespace? (Choose two.)

Space utilization inside segments is mapped by bitmaps.

Segments are automatically shrunk and compressed when rows are deleted.

The PCTFREE storage parameter has no effect on segments created in this tablespace.

The PCTUSED storage parameter has no effect on segments created in this tablespac

Question 14

You want to create a file watcher and an event-based job for detecting the arrival of files on the local server from various locations. To achieve this, you enable the raising of file arrival events from remote systems.
Which two conditions must be satisfied to receive file arrival events from a remote system? (Choose two.)

The remote system must have a running Oracle Database instance and a scheduler agent installed.

The initialization parameter REMOTE_OS_AUTHENT must be set to TRUE on your database.

The local database must be set up to run remote external jobs.

The remote system's scheduler agent must be registered with your database.

Database links to remote databases must be created.

Question 15

Examine the parameter settings in your local ORCL database:
1Z0-062 dumps exhibit

Examine the parameter settings for the remote SALES database:
1Z0-062 dumps exhibit

As the SYS user, you issue the following command on ORCL:
CREATE PUBLICDATABASE LINK sales.us.example.com USING ‘sales1’; The sales1 tnsnames entry points to the sales database instance.
Which two are requirements to ensure that you can successfully connect by using this database link? (Choose two.)

The GLOBAL_NAMES initialization parameter should be set to FALSE in the ORCL database.

The SALES1 net service name should be known to both the local and remote databases.

Local database users who use this database link should have accounts and the required privileges in the remote database.

The REMOTE_OS_AUTHENT initialization parameter should be set to FALSE in the remote database.

Only the user creating the database link must have an account and the required privileges in the remote databas

Question 16

To implement Automatic Management (AMM), you set the following parameters:
1Z0-062 dumps exhibit

When you try to start the database instance with these parameter settings, you receive the following error message: SQL > startup
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information.
Identify the reason the instance failed to start.

The PGA_AGGREGATE_TARGET parameter is set to zero.

The STATISTICS_LEVEL parameter is set to BASIC.

Both the SGA_TARGET and MEMORY_TARGET parameters are set.

The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal.

Question 17

Which statement is true about the Log Writer process?

It writes when it receives a signal from the checkpoint process (CKPT).

It writes concurrently to all members of multiplexed redo log groups.

It writes after the Database Writer process writes dirty buffers to disk.

It writes when a user commits a transaction.

Question 18

You are using RMAN to back up your database. All the data files are in read/write mode. Examine the RMAN configuration parameters:
1Z0-062 dumps exhibit

Which two statements are true about a whole consistent backup of a database running in ARCHIVELOG mode? (Choose two.)

The backup can be used as an incremental level 0 backup.

The database instance must be shut down to take the backup.

The database must be in MOUNT state to take the backup.

The backup consists of blocks that have been formatted.

The system Change Number (SCN) is the same for all the data files in the backu

Question 19

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?

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.

Run the Automatic Workload Repository Monitor (ADDM).

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.

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.

Question 20

The schema SALES exists in two databases, ORCL1 and ORCL2, and has the same password, SALES123. User SALES has CREATE DATABASE LINK and CREATE SESSION privileges on both databases. Examine these commands: Conn SALES/SALES123
CREATE DATABASE LINK orcl2 USING 'orcl2';
What is the outcome of executing these commands in the ORCL1 database?

ORCL2 is created as a public database link to connect a single session to the SALES schema in the ORCL2 database.

ORCL2 is created as a shared database link to connect multiple sessions to the SALES schema in the ORCL2 database.

ORCL2 is created as a private database link to connect to only the SALES schema in the ORCL2 database.

ORCL2 database link creation fail

Question 21

In your database, the RESOURCE_LIMIT parameter is set to TRUE. You create the profile:
1Z0-062 dumps exhibit

Which two statements are true about users and their sessions that are subject to this profile? (Choose two.)

The CPU_PER_CALL is ignored in the user sessions because of the unlimited value of CPU_PER_CALL

These users can never reuse a password

The PASSWORD_LIFE_TIME value is ignored because of the unlimited value of PASSWORD_REUSE_MAX.

In each user session, the limit for LOGICAL_READS_PER_SESSION in the same as defined in the DEFAULT profile.

Question 22

Which statement is true about profiles?

Resource limits specified in a profile assigned to a user are always enabled.

A user can exist without any profile.

A profile can be assigned only to one user.

Password management using profiles is always enable

Question 23

The following parameter are set for your Oracle 12c database instance: OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE
You want to manage the SQL plan evolution task manually. Examine the following steps:
1. Set the evolve task parameters.
2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function.
3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.
4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.
5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function. Identify the correct sequence of steps:

2, 4, 5

2, 1, 4, 3, 5

1, 2, 3, 4, 5

1, 2, 4, 5

My answer: -

Reference answer: B

Reference analysis:

* Evolving SQL Plan Baselines
1Z0-062 dumps exhibit
*2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function.
This function creates an advisor task to prepare the plan evolution of one or more plans for a specified SQL statement. The input parameters can be a SQL handle, plan name or a list of plan names, time limit, task name, and description.
1. Set the evolve task parameters. SET_EVOLVE_TASK_PARAMETER
This function updates the value of an evolve task parameter. In this release, the only valid parameter is TIME_LIMIT.
4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.
This function executes an evolution task. The input parameters can be the task name, execution name, and execution description. If not specified, the advisor generates the name, which is returned by the function.
3: IMPLEMENT_EVOLVE_TASK
This function implements all recommendations for an evolve task. Essentially, this function is equivalent to using ACCEPT_SQL_PLAN_BASELINE for all recommended plans. Input parameters include task name, plan name, owner name, and execution name.
5. Report the task outcome by using the DBMS_SPM_EVOLVE_TASK function.
This function displays the results of an evolve task as a CLOB. Input parameters include the task name and section of the report to include.
References:

Page: 1 / 30

Total 362 questions Full Exam Access