Download Free Oracle 1z0-062 Real Exam Questions Download [Q139-Q154]

Rate this post

Download Free Oracle 1z0-062 Real Exam Questions Download

Latest Oracle 1z0-062 Real Exam Dumps PDF

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!

NO.139 You want to reduce fragmentation and reclaim unused space for the SALES table but not its dependent objects. During this operation, you want to ensure the following:
– Long-running queries are not affected.
– No extra space is used.
– Data manipulation language (DML) operations on the table succeed at all times throughout the process.
– Unused space is reclaimed both above and below the high water mark.
Which ALTER TABLE option would you recommend?

DEALLOCATE UNUSED

SHRINK SPACE CASCADE

SHRINK SPACE COMPACT

ROW STORE COMPRESS BASIC

NO.140 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

NO.141 You are administering a database and you receive a requirement to apply the following restrictions:
1. A connection must be terminated after four unsuccessful login attempts by user.
2. A user should not be able to create more than four simultaneous sessions.
3. User session must be terminated after 15 minutes of inactivity.
4. Users must be prompted to change their passwords every 15 days.
How would you accomplish these requirements?

by granting a secure application role to the users

by creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENT parameter to FALSE

By creating and assigning a profile to the users and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter to 4

By Implementing Fine-Grained Auditing (FGA) and setting the REMOTE_LOGIN_PASSWORD_FILE parameter to NONE.

By implementing the database resource Manager plan and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameters to 4.

NO.142 The persistent configuration settings for RMAN have default for all parameters.
Identify four RMAN commands that produce a multi-section backup.

BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;

BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;

BACKUP ARCHIVELOG ALL SECTION SIZE 25M;

BACKUP TABLESPACE “TEMP” SECTION SIZE 10M;

BACKUP TABLESPACE “UNDO” INCLUDE CURRENTCONTROLFILE SECTION SIZE
100M;

BACKUP SPFILE SECTION SIZE 1M;

BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;

NO.143 In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs.
You execute the following command from the root container:
SQL > REVOKE create table FROM C # # A_ADMIN;
What is the result?

It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.

It fails and reports an error because the CONTAINER=ALL clause is not used.

It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.

It fails and reports an error because the CONTAINER=CURRENT clause is not used.

It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.

NO.144 Examine the following steps:
A DBA grants the CREATE TABLE system privilege with ADMIN OPTION to the user SIDNEY.
SIDNEY grants the CREATE TABLE system privilege to the HR user.
Which statement is true?

SIDNEY can revoke the CREATE TABLE system privilege only from HR, to whom he granted it.

HR can grant the CREATE TABLE system privilege to other users.

Neither SIDNEY nor HR can create new tables if the DBA revokes the CREATE TABLE privilege from SIDNEY.

HR still retains the CREATE TABLE system privilege if the DBA revokes the CREATE TABLE privilege from SIDNEY.

NO.145 Which two statements are true about Oracle Managed Files (OMF)? (Choose two.)

OMF cannot be used in a database that already has data files created with user-specified directions.

The file system directions that are specified by OMF parameters are created automatically.

OMF can be used with ASM disk groups, as well as with raw devices, for better file management.

OMF automatically creates unique file names for table spaces and control files.

OMF may affect the location of the redo log files and archived log files.

NO.146 You administer an online transaction processing (OLTP) system whose database is stored in Automatic
Storage Management (ASM) and whose disk group use normal redundancy.
One of the ASM disks goes offline, and is then dropped because it was not brought online before
DISK_REPAIR_TIME elapsed.
When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow.
Which two recommendations should you make to speed up the rebalance operation if this type of failure
happens again? (Choose two.)

Increase the value of the ASM_POWER_LIMIT parameter.

Set the DISK_REPAIR_TIME disk attribute to a lower value.

Specify the statement that adds the disk back to the disk group.

Increase the number of ASMB processes.

Increase the number of DBWR_IO_SLAVES in the ASM instance.

NO.147 Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report:

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

NO.148 Which three statements are true about Automatic Workload Repository (AWR)? (Choose three.)

All AWR tables belong to the SYSTEM schema.

The AWR data is stored in memory and in the database.

The snapshots collected by AWR are used by the self-tuning components in the database

AWR computes time model statistics based on time usage for activities, which are displayed in the
v$SYS time model and V$SESS_TIME_MODEL views.

AWR contains system wide tracing and logging information.

NO.149 Which two statements are true about the RMAN validate database command? (Choose two.)

It checks the database for intrablock corruptions.

It can detect corrupt pfiles.

It can detect corrupt spfiles.

It checks the database for interblock corruptions.

It can detect corrupt block change tracking files.

NO.150 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.

NO.151 In your Oracle 12c database, you invoke SQL *Loader Express Mode command to load data:
$> sqlldr hr/hr table=employees
Which two statements are true about this command? (Choose two.)

It succeeds and creates the EMPLOYEEStable in the HRschema if the table does not exist.

It fails because the SQL *Loader control file location is not specified.

It fails because the SQL *Loader data file location is not specified.

It succeeds with default settings if the EMPLOYEEStable belonging to the HRschema is already defined
in the database.

It succeeds even if the HR user does not have the CREATE DIRECTORYprivilege.

NO.152 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.

NO.153 Which statement is true regarding the startup of a database instance?

The instance does not start up normally and requires manual media recovery after a shutdown using the abort option.

Uncommitted transactions are rolled back during the startup of the database instance after a shutdown using the immediate option.

There is no difference in the underlying mechanics of the startup whether the database is shut down by using the immediate option or the abort option.

Media recovery is required when the database is shut down by using either the immediate option or the abort option.

Instance recovery is not required if the database instance was shut down by using SHUTDOWN IMMEDIATE.

NO.154 Which two statements are true about extents?

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.