28 August, 2022

Simulation Oracle 1Z0-062 Testing Material Online

Testking 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!

Oracle 1Z0-062 Free Dumps Questions Online, Read and Test Now.

Page: 1 / 30

Total 362 questions Full Exam Access

Question 1

Which two statements are true about standard database auditing? (Choose two.)

DDL statements can be audited.

Statements that refer to standalone procedure can be audited.

Operations by the users logged on as SYSDBA cannot be audited.

Only one audit record is ever created for a session per audited statement even though it is executed more than onc

Question 2

Which four statements are true about database instance behavior? (Choose four.)

An idle instance is created when a STARTUP NOMOUNT is successful

All dynamic performance views (v$ views) return data when queried from a session connected to an instance in NOMOUNT state

The consistency of redo logs and data files is checked when mounting the database

Redo log files can be renamed in MOUNT state

An SPFILE can be updated when connected to an idle instance

Datafiles can be renamed in MOUNT state

Question 3

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? (Choose two.)

Increasing the priority of the job class to which the job belongs

Increasing the job's relative priority within the Job class to which it belongs

Increasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler window

Moving the job to an existing higher priority scheduler window with the same schedule and duration

Increasing the value of the JOB_QUEUE_PROCESSES parameter

Increasing the priority of the scheduler window to which the job belongs

Question 4

SMD is a smallfile locally managed tablespace with manual segment space management. The SH user receives the following error while inserting data into the sales table:
1Z0-062 dumps exhibit

Which three actions can be taken to enable the user to insert data? (Choose three.)

altering the data file associated with the SMD tablespace to grow automatically

adding a data file to the SMD tablespace, provided the tablespace has not reached its maximum number of file

changing segment space management for the SMD tablespace to automatic

resizing the data file associated with the SMD tablespace to make it larger, provided all data files have not yet reached their maximum size

increasing the space quota on the SMD tablespace for the SH user, provided the files have not yet reached their maximum size

Question 5

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?

Database replay

SQL Tuning Advisor

SQL Access Advisor

SQL Performance Analyzer

Automatic Workload Repository compare reports

Question 6

Unified auditing is enabled in your database. The HR_ADMIN and OE_ADMIN roles exist and are granted system privileges.
You execute the command:
SQL>CREATE AUDIT POLICY tab1e_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE ROLES
hr_admin, oe_admin; Which statement is true?

It succeeds and needs to be enabled to capture all SQL statements that require either the specified privileges or any privilege granted to the HR_ADMIN and OE_ADMIN role.

It fails because system privileges cannot be granted with roles in the same audit policy.

It succeeds and starts capturing only successful SQL statements for all users who have either the specified privileges or roles granted to them.

It fails because the command does not specify when the unified audit policy should be enforce

Question 7

You want execution of large database operations to suspend, and then resume, in the event of space allocation failures. You set the value of the initialization parameter RESUMABLE_TIMEOUT to 3600. Which two statements are true? (Choose two.)

Before a statement executes in resumable mode, the ALTER SESSION ENABLE RESUMABLE statement must be issued in its session.

Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.

A resumable statement can be suspended and resumed only once during execution.

A suspended statement will report an error if no corrective action has taken place during a timeout period.

Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.

Question 8

Identify two situations in which the alert log file is updated.

Running a query on a table returns ORA-600: Internal Error.

Inserting a value into a table returns ORA-01722: invalid number.

Creating a table returns ORA-00955: name us already in used by an existing objects.

Inserting a value into a table returns ORA-00001: unique constraint (SYS.OK_TECHP) violated.

Rebuilding an index using ALTER INDEX . . . REBUILD fails with an ORA-01578: ORACLE data block corrupted (file # 14, block # 50) error.

Question 9

Examine the query and its output:
1Z0-062 dumps exhibit

What might have caused three of the alerts to disappear?

The threshold alerts were cleared and transferred to DBA_ALERT_HISTORY.

An Automatic Workload Repository (AWR) snapshot was taken before the execution of the second query.

An Automatic Database Diagnostic Monitor (ADOM) report was generated before the execution of the second query.

The database instance was restarted before the execution of the second quer

Question 10

Which action takes place when a file checkpoint occurs?

The checkpoint position is advanced in the checkpoint queue.

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.

The Database Writer process (DBWn) writes all dirty buffers in the buffer cache to data files.

The Log Writer process (LGWR) writes all redo entries in the log buffer to online redo log file

Question 11

The user SCOTT owns the CUST table that is placed in the SALES tablespace. The user SCOTT opens a session and executes commands as follows:
SQL> INSERT INTO cust VALUES(101, 'JACK'); 1 row created. SQL> INSERT INTO cust VALUES(102, 'SMITH'); 1 row created.
As a DBA, you execute the following command from another session: ALTER TABLESPACE sales READ ONLY; Which statement is true regarding the effect of this command on the transaction in Scott's session?

The command fails as a transaction is still pending.

The transaction in Scott's session is rolled back and the tablespace becomes readonly.

The command waits and the user SCOTT can execute data manipulation language (DML) statements only as part of the current transaction.

The command hangs until all transactions on the objects in the tablespace commit or rollback, and then the tablespace is placed in readonly mode.

Question 12

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?

Increase the window size of the moving window baseline so that it equals the Automatic Workload Repository (AWR) snapshot retention period.

Create a baseline on a pair of snapshots that span the peak load period.

Generate Active Session History reports for the peak load period.

Set the snapshot retention period in AWR to 60 to avoid automatic purging of snapshots for the past hou

Question 13

You determine that database performance is sub-optimal due to hard parsing statements. Automatic Shared Memory Management (ASMM) is disabled for your database instance.
Which tool would you use to get advice on how to improve performance?

Memory Advisor for the PGA

SQL Access Advisor

Memory Advisor for the shared pool

SQL Tuning Advisor

Question 14

Which two tasks can be performed on an external table? (Choose two.)

partitioning the table

creating an invisible index

updating the table by using an UPDATE statement

creating a public synonym

creating a view

Question 15

Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyze impact on the performance of SQL statements.

Change in the Oracle Database version

Change in your network infrastructure

Change in the hardware configuration of the database server

Migration of database storage from non-ASM to ASM storage

Database and operating system upgrade

Question 16

Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)? (Choose three.)

ADBA can check specific tables with the DMU

The database to be migrated must be opened read-only.

The release of the database to be converted can be any release since 9.2.0.8.

The DMU can report columns that are too long in the converted characterset.

The DMU can report columns that are not represented in the converted characterset.

Question 17

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? (Choose two.)

User session data

Stack space

Private SQL area

Location of the runtime area for DML and DDL Statements

Location of a part of the runtime area for SELECT statements

My answer: -

Reference answer: AC

Reference analysis:

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.
References:

Question 18

Your database is configured in ARCHIVELOG mode. Examine the RMAN configuration parameters:
1Z0-062 dumps exhibit

Examine the command:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
What is the outcome?

It fails because the DELETE INPUT option can be used only with the BACKUP AS BACKUPSET command.

It executes successfully and creates a backup set of the database along with archived log files and then deletes the original archived log files.

It executes successfully and creates an image copy of the database along with archive log files and then deletes the original archived log files.

It fails because the DELETE INPUT option can be used only with the BACKUP AS COPY command.

Question 19

Which three statements are true about Oracle Restart? (Choose three.)

It can be configured to automatically attempt to restart various components after a hardware or software failure.

While starting any components, it automatically attempts to start all dependencies first and in proper order.

It can be configured to automatically restart a database in case of normal shutdown of the database instance.

It can be used to only start Oracle components.

It runs periodic check operations to monitor the health of Oracle component

Question 20

Which statement is true about the Oracle central inventory directory (oraInventory)?

oraInventory must not be shared by all Oracle software installations on a single system.

If ORACLE_BASE is set to /u01/app/oracle for the oracle user during an installation, OUI creates the Oracle Inventory directory in the /u01/app/oracle/ oraInventory path.

lf an OFA-compliant path is not created and the ORACLE_BASE environment variable is not set during an Oracle Database installation, the Oracle Inventory directory is placed in the home directory of the user that is performing the installation.

Oracle software owners must be members of the same central oraInventory group, but they need not have this group as their primary group.

Question 21

Which four operations performed after the Oracle Restart installation are automatically added to the Oracle Restart configuration? (Choose four.)

listener configured by using NETCA

database service created by using SRVCTL

database created by using a SQL statement

database created by using DBCA

ASM instance created by using ASMCA

database service created by using DBMS_SERVICE.CREATE_SERVICE

database service created by modifying the SERVICE_NAMES initialization parameter

Question 22

Which statement is true about using the Export/Import method for migrating data when upgrading to Oracle Database 12c?

It automatically restarts a Data Pump Export or Import job after a failure is connected and the job continues from the point of failure.

It can be used to migrate a database only if the source and target databases are hosted on the same endian format.

It can be used to migrate a database only if the source database does not have any tablespace in read-only mode.

It allows migration of a database directly over network link

Question 23

Examine these two statements:
1Z0-062 dumps exhibit

Which three are true about the MRKT tablespace? (Choose three.)

The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.

The MRKT tablespace may be dropped if it has no contents.

Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.

No more data files can be added to the tablespace.

The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.

Page: 1 / 30

Total 362 questions Full Exam Access