25 August, 2022

How Many Questions Of 1Z0-062 Exam Dumps

we provide Realistic Oracle 1Z0-062 pdf exam 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!

Free demo questions for Oracle 1Z0-062 Exam Dumps Below:

Page: 1 / 30

Total 362 questions Full Exam Access

Question 1

You want to flash back a test database by five hours. You issue this command:
SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);
Which two statements are true about this flashback scenario? (Choose two.)

The database must have multiplexed redo logs for the flashback to succeed.

The database must be MOUNTED for the flashback to succeed.

The database must use block change tracking for the flashback to succeed.

The database must be opened in restricted mode for the flashback to succeed.

The database must be opened with the RESETLOGS option after the flashback is complete.

The database must be opened in read-only mode to check if the database has been flashed back to the correct SC

Question 2

Which statement is true regarding the DEFAULT profile?

The values assigned to the resource limits and password parameters in the default profile can be altered.

A different DEFAULT profile can be created before each user in a database.

It can be dropped and recreated.

it must be explicitly assigned to the use

Question 3

Examine the parameters:
1Z0-062 dumps exhibit

Users complain that their sessions for certain transactions hang. You investigate and discover that some users fail to complete their transactions, causing other transactions to wait on row-level locks.
Which two actions would you take to prevent this problem? (Choose two.)

Increase the maximum number of ITL slots for segments on which a blocking user performs a transaction.

Decrease the SESSIONS_PER_USER limit in the profiles assigned to blocking users.

Set a limit in the proles of blocking users to control the number of data blocks that can be accessed in a session.

Use Database Resource Manager to automatically kill the sessions that are idle and are blocking other sessions.

Decrease the IDLE_TIME resource limit in the profiles assigned to blocking user

Question 4

Which statement is true about using the Database Upgrade Assistant (DBUA) to upgrade your database from Oracle Database 11g to Oracle Database 12c?

It terminates if the SYSTEM tablespace in the source database is not autoextensible.

It automatically makes necessary changes to Oracle environment variables.

It automatically enables unified auditing in the upgraded database.

It automatically adds new data files if there is not enough disk space to grow.

Question 5

Which three statements are true about user account administration? (Choose three.)

A user's current session is not affected when the user's profile is changed.

Only users with the SYSDBA privilege can change the tablespace quota for other users.

A new user account can be created only by SYS or SYSTEM users.

A user's quota can be set for any permanent tablespace but not for the default temporary tablespace.

A user requires only the CREATE SESSION privilege to change his or her own passwor

Question 6

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.

My answer: -

Reference answer: A

Reference analysis:

You can design your applications to automatically grant a role to the user who is trying to log in, provided the user meets criteria that you specify. To do so, you create a secure application role, which is a role that is associated with a PL/SQL procedure (or PL/SQL package that contains multiple procedures). The procedure validates the user: if the user fails the validation, then the user cannot log in. If the user passes the validation, then the procedure grants the user a role so that he or she can use the application. The user has this role only as long as he or she is logged in to the application. When the user logs out, the role is revoked.
Incorrect:
Not B: REMOTE_OS_AUTHENT specifies whether remote clients will be authenticated with the value of the OS_AUTHENT_PREFIX parameter.
Not C, not E: SEC_MAX_FAILED_LOGIN_ATTEMPTS specifies the number of authentication attempts that can be made by a client on a connection to the server process. After the specified number of failure attempts, the connection will be automatically dropped by the server process.
Not D: REMOTE_LOGIN_PASSWORDFILE specifies whether Oracle checks for a password file. Values:
shared
One or more databases can use the password file. The password file can contain SYS as well as non-SYS users. exclusive
The password file can be used by only one database. The password file can contain SYS as well as non-SYS users. none
Oracle ignores any password file. Therefore, privileged users must be authenticated by the operating system. Note:
The REMOTE_OS_AUTHENT parameter is deprecated. It is retained for backward compatibility only.

Question 7

Which two services may you see on the My Service Dashboard page? (Choose two.)

Network Cloud Service

User Cloud Service

Compute Cloud Service

Database Cloud Service

Question 8

Which three statements are true about server-generated alerts? (Choose three.)

Server-generated alerts notify administrators of problems that cannot be resolved automatically.

Alerts are not issued for locally managed read-only tablespaces.

Response actions cannot be specified for server-generated alerts.

Stateful alerts can be queried only from the DBA_ALERT_HISTORY view.

When an alert is cleared, it is moved to the DBA_ALERT_HISTORY view.

Question 9

Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0 MEMORY_TARGET=0 SGA_TARGET=0 PGA_AGGREGATE_TARGET=500m
Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)? (Choose three.)

LOG_BUFFER

SORT_AREA_SIZE

JAVA_POOL_SIZE

STREAMS_POOL_SIZE

DB_16K_CACHE_SZIE

DB_KEEP_CACHE_SIZE

Question 10

Which three statements are true about Flashback Database? (Choose three.)

Flashback logs are written sequentially, and are archived.

Flashback Database uses a restored control file to recover a database.

The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.

Flashback Database can recover a database to the state that it was in before a reset logs operation.

Flashback Database can recover a data file that was dropped during the span of time of the flashback.

Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.

Question 11

In your database, USERS is the default permanent tablespace. Examine the commands and their outcome:
1Z0-062 dumps exhibit

You plan to execute the commands:
1Z0-062 dumps exhibit

Which two statements are true? (Choose two.)

The MYTAB table is created in the SYSTEM tablespace but no rows can be inserted into the table by USER02.

The MYTAB table is created in the SYSTEM tablespace and rows can be inserted into the table by USER02.

The MYTAB table is created in the USERS tablespace but no rows can be inserted into the table by USER02.

The CREATE TABLE statement generates an error because the SYSDBA privilege does not provide any space quota on the SYSTEM tablespace by default.

The MYTAB table is owned by the SYS use

Question 12

You executed the following command to create a password file in the database server:
$ orapwd file = orapworcl entries = 5 ignorecase=N
Which statement describes the purpose of the above password file?

It records usernames and passwords of users when granted the DBA role

It contains usernames and passwords of users for whom auditing is enabled

It is used by Oracle to authenticate users for remote database administrator

It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating groups

Question 13

A database uses Automatic Storage Management (ASM) as database storage, which has a diskgroup, DATA1, which is created as follows:
1Z0-062 dumps exhibit

What happens when the FAILGRP1 failure group is corrupted?

Mirroring of allocation units occurs within the FAILGRP2 failure group.

Transactions that are using the diskgroup fail.

ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the FAILGRP2 failure group.

Data in the FAILGRP1 failure group is moved to the FAILGRP2 failure group and rebalancing is starte

Question 14

Your database instance has started using an SPFILE. Examine the RMAN configuration settings:
1Z0-062 dumps exhibit

You execute the command:
RMAN> BACKUP AS COPY TABLESPACE TEST;
Which three types of files are backed up by using this command? (Choose three.)

online redo log files

control file

SPFILE

archived redo log files

data file(s)

PFILE

Question 15

Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for the database.
You issue the command to open ACCOUNTS_PDB and find that the USERDATA.DBF data file for the default permanent tablespace USERDATA belonging to ACCOUNTS_PDB is corrupted.
What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB?

Place CDB1 in the mount stage and then the USERDATA tablespace offline in ACCOUNTS_PDB.

Place CDB1 in the mount stage and issue the ALTER PLUGGABLE DATABASE accounts_pdb CLOSE IMMEDIATE command.

Issue the ALTER PLUGGABLE DATABASE accounts_pdb RESTRICTED command.

Take the USERDATA tablespace offline in ACCOUNTS_PDB.

Question 16

Which two statements are true about Oracle Data Pump export and import operations? (Choose two.)

You can detach from a data pump export job and reattach later.

Data pump uses parallel execution server processes to implement parallel import.

Data pump import requires the import file to be in a directory owned by the oracle owner.

The master table is the last object to be exported by the data pump.

You can detach from a data pump import job and reattach later.

Question 17

Examine the command to perform a data pump export operation on a source database:
$> expdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLE=emp_dept On the target database, you execute the data pump import command:
$> impdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLE=emp_dept Which three statements are true? (Choose three.)

The expdp operation exports data that satisfies the condition of the defining query used to create the EMP_DEPT view.

The impdp operation creates the view and dependent objects.

All rows from the dependent objects, along with the metadata required to create the EMP_DEPT view, are exported.

Objects dependent on the EMP_DEPT view are exported.

The impdp operation creates EMP_DEPT as table and populates it with the data from the export dump fil

Question 18

Which two would you recommend to an application developer for reducing locking conflicts on tables in an Oracle database? (Choose two.)

Create objects in locally managed tablespaces with Automatic Segment Space Management (ASSM) enabled.

Avoid coding long-running transactions.

Allow the database to handle locks ln default locking mode.

Create objects in locally managed tablespaces with manual segment space management enabled.

Enable undo retention guarantee.

Question 19

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 EMPLOYEES table in the HR schema 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 EMPLOYEES table belonging to the HR schema is already defined in the database.

It succeeds even if the HR user does not have the CREATE DIRECTORY privileg

Question 20

Your database is configured in ARCHIVELOG mode, and a daily full database backup is taken by using RMAN. Control file autobackup is configured.
Loss of which three database files can lead to an incomplete recovery? (Choose three.)

inactive online redo log file group

a data file belonging to the default temporary tablespace

a data file belonging to the SYSAUX tablespace

server parameter le (SPFILE)

active online redo log le group

all the control flies

Question 21

You are administering a database that supports an OLTP workload.
The default UNDO tablespace is a fixed size tablespace with the RETENTION NOGUARATNEE clause and undo retention set to 12 minutes.
The user SCOTT queries a large table during peak activity.
The query runs for more than 15 minutes and then SCOTT receives the following error: ORA-01555: snapshot too old
Which is possible reason for this?

The Oracle server is unable to generate a read-consistent image for a block containing updates.committed after the query began.

The query is unable to place data blocks in the UNDO tablespace.

The flashback data archive is not enabled for the table on which the query is issued.

There is not enough space in Fast Recovery Area.

The Oracle server is unable to generate a read-consistent image for a block containing uncommitted update

Question 22

Examine the parameters for a database instance:
1Z0-062 dumps exhibit

Your database has three undo tablespaces and the default undo tablespace is not autoextensible. Resumable space allocation is not enabled for any sessions in the database instance.
What is the effect on new transactions when all undo space in the default undo tablespace is in use by active transactions?

Transactions write their undo in the SYSTEM undo segment.

Transactions fail.

Transactions wait until space becomes available in UNDOTBS1.

Transactions write their undo in a temporary tablespace.

Question 23

Examine the parameters for your database instance:
1Z0-062 dumps exhibit

You execute the following command:
SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE;
Which statement is true in this scenario?

Undo data is written to flashback logs after 1200 seconds.

Inactive undo data is retained for 1200 seconds even if subsequent transactions fail due to lack of space in the undotablespace.

You can perform a Flashback Database operation only within the duration seconds.

An attempt is made to keep inactive undo for 1200 seconds but transactions may overwrite the undo before that time has elapsed.

Page: 1 / 30

Total 362 questions Full Exam Access