Updated Sep-2022 100% Cover Real 1z0-062 Exam Questions - 100% Pass Guarantee [Q10-Q32]

Updated Sep-2022 100% Cover Real 1z0-062 Exam Questions - 100% Pass Guarantee

Use Real Oracle Dumps - 100% Free 1z0-062 Exam Dumps

NEW QUESTION 10
Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB and ACCOUNTS_PDB, both of which use the CDB tablespace. The temp file is called temp01.tmp.
A user issues a query on a table on one of the PDBs and receives the following error:
ERROR at line 1:
ORA-01565: error in identifying file '/u01/app/oracle/oradata/CDB1/temp01.tmp'
ORA-27037: unable to obtain file status
Identify two ways to rectify the error.

A. Shutdown the database instance, restore and recover the temp file from the backup, and then open the database with RESETLOGS.
B. Shut down the database instance and then restart the CDB and PDBs.
C. Add a new temp file to the temporary tablespace and drop the temp file that that produced the error.
D. Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.
E. Take the temporary tablespace offline, recover the missing temp file by applying redo logs, and then bring the temporary tablespace online.

Answer: B,C

Explanation:
* Because temp files cannot be backed up and because no redo is ever generated
for them, RMAN never restores or recovers temp files. RMAN does track the names of temp files,
but only so that it can automatically re-create them when needed.
* If you use RMAN in a Data Guard environment, then RMAN transparently converts primary control files to standby control files and vice versa. RMAN automatically updates file names for data files, online redo logs, standby redo logs, and temp files when you issue RESTORE and RECOVER.

NEW QUESTION 11
Your database is configured in ARCHIVELOGmode, 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.)

A. all the control flies
B. a data file belonging to the SYSAUXtablespace
C. server parameter ﬁle (SPFILE)
D. inactive online redo log file group
E. active online redo log ﬁle group
F. a data file belonging to the default temporary tablespace

Answer: A,D,E

NEW QUESTION 12
What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE" statement?

A. It will create a multitenant container database (CDB) with only the root opened.
B. It will create a CDB with root and seed opened and one PDB mounted.
C. It will create a CDB with root opened and seed mounted.
D. It will create a CDB that must be plugged into an existing CDB.
E. It will create a CDB with root opened and seed read only.

Answer: E

Explanation:
* The CREATE DATABASE ... ENABLE PLUGGABLE DATABASE SQL statement creates a new CDB. If you do not specify the ENABLE PLUGGABLE DATABASE clause, then the newly created database is a non-CDB and can never contain PDBs.
Along with the root (CDB$ROOT), Oracle Database automatically creates a seed PDB (PDB$SEED). The following graphic shows a newly created CDB:

* Creating a PDB
Rather than constructing the data dictionary tables that define an empty PDB from scratch, and then populating its Obj$ and Dependency$ tables, the empty PDB is created when the CDB is created. (Here, we use empty to mean containing no customer-created artifacts.) It is referred to as the seed PDB and has the name PDB$Seed. Every CDB non-negotiably contains a seed PDB; it is non-negotiably always open in read-only mode. This has no conceptual significance; rather, it is just an optimization device. The create PDB operation is implemented as a special case of the clone PDB operation.

NEW QUESTION 13
Examine the parameters for your database instance:

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

A. An attempt is made to keep inactive undo for 1200 seconds but transactions may overwrite the undo before that time has elapsed.
B. Inactive undo data is retained for 1200 seconds even if subsequent transactions fail due to lack of space in the undo tablespace.
C. Undo data is written to flashback logs after 1200 seconds.
D. You can perform a Flashback Database operation only within the duration of 1200 seconds.

Answer: A

Explanation:
Explanation/Reference:

NEW QUESTION 14
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? (Choose three.)

A. A large number COMMITS are being performed.
B. Cursors are not being shared.
C. There are frequent logons and logoffs.
D. The buffers are being read into the buffer cache, but some other session is changing the buffers.
E. The size of the shared pool is too small.

Answer: B,C,E

NEW QUESTION 15
You plan to migrate your database from a File system to Automata Storage Management (ASM) on same platform.
Which two methods or commands would you use to accomplish this task? (Choose two.)

A. DBMS_FILE_TRANSFER with transportable tablespace
B. RMAN CONVERT command
C. The BACKUP AS COPY DATABASE . . . command of RMAN
D. Data Pump Export and import
E. Conventional Export and Import

Answer: B,C

Explanation:
Explanation/Reference:
Explanation:
A:
1. Get the list of all datafiles.
Note: RMAN Backup of ASM Storage
There is often a need to move the files from the file system to the ASM storage and vice versa. This may come in handy when one of the file systems is corrupted by some means and then the file may need to be moved to the other file system.
D: Migrating a Database into ASM
* To take advantage of Automatic Storage Management with an existing database you must migrate that database into ASM. This migration is performed using Recovery Manager (RMAN) even if you are not using RMAN for your primary backup and recovery strategy.
* Example:
Back up your database files as copies to the ASM disk group.
BACKUP AS COPY INCREMENTAL LEVEL 0 DATABASE
FORMAT '+DISK' TAG 'ORA_ASM_MIGRATION';
References:

NEW QUESTION 16
You run a script that completes successfully using SQL*Plus that performs these actions:
1. Creates a multitenant container database (CDB)
2. Plugs in three pluggable databases (PDBs)
3. Shuts down the CDB instance
4. Starts up the CDB instance using STARTUP OPEN READ WRITE
Which two statements are true about the outcome after running the script? (Choose two.)

A. The seed will be opened read-only.
B. The seed will be in mount state.
C. The other PDBs will be in mount state.
D. The PDBs will be opened read/write.
E. The seed will be opened read/write.
F. The other PDBs will be opened read-only.

Answer: A,C

Explanation:
Explanation
B: The seed is always read-only.
D: Pluggable databases can be started and stopped using SQL*Plus commands or the ALTER PLUGGABLE DATABASE command.

NEW QUESTION 17
Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN. (Choose all that apply.)

A. Default backup device type
B. Default section size for backups
C. Backup retention policy
D. Default destinations for backups
E. Multiple backup device types for single backup

Answer: A,C,D

Explanation:
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmconfb.htm#BRADV89399

NEW QUESTION 18
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.)

A. all the control flies
B. server parameter file (SPFILE)
C. inactive online redo log file group
D. active online redo log file group
E. a data file belonging to the default temporary tablespace
F. a data file belonging to the SYSAUX tablespace

Answer: A,C,D

NEW QUESTION 19
Examine the parameters for a database instance:

Which two statements are true? (Choose two.)

A. Undo records for temporary tables are stored in the undo tablespace and logged in the redo.
B. No redo and undo records are generated for temporary tables.
C. No redo is generated for the undo records belonging to temporary tables.
D. Undo records for temporary tables are stored in a temporary tablespace.
E. Undo records for temporary tables are stored in the undo tablespace and logged in the redo only for those sessions where temporary undo is enabled.

Answer: B,D

NEW QUESTION 20
Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)? (Choose three.)

A. Tracking insert time by row for table rows
B. Tracking the most recent read time for a table segment in a user tablespace
C. Tracking the most recent write time for a table segment in the SYSAUX tablespace
D. Tracking the most recent read time for a table segment in the SYSAUX tablespace
E. Tracking the most recent write time for a table segment in a user tablespace
F. Tracking the most recent write time for a table block

Answer: B,E,F

Explanation:
Incorrect:
Not E, Not F When Heat Map is enabled, all accesses are tracked by the in-memory activity tracking module. Objects in the SYSTEM and SYSAUX tablespaces are not tracked.
* To implement your ILM strategy, you can use Heat Map in Oracle Database to track data access and modification.
Heat Map provides data access tracking at the segment-level and data modification tracking at the segment and row level.
* To implement your ILM strategy, you can use Heat Map in Oracle Database to track data access and modification. You can also use Automatic Data Optimization (ADO) to automate the compression and movement of data between different tiers of storage within the database.
References:

NEW QUESTION 21
You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure.
In which three ways can you re-create the lost disk group and restore the data?

A. Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.
B. Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.
C. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.
D. Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.
E. Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.
F. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data.

Answer: B,D,E

Explanation:
Explanation/Reference:
Explanation:
AC (not E):
The md_restore command allows you to restore a disk group from the metadata created by the md_backup command.
md_restore can't restore data, only metadata.

NEW QUESTION 22
Your database is running in NOARCHIVLOG mode.
Examine the following parameters:

You execute the following command after performing a STARTUP MOUNT:
SQL> ALTER DATABASE ARCHIVELOG;
Which statement is true about the execution of the command?

A. It executes successfully and issues a warning to set LOG_ARCHIVE_DEST while opening the database.
B. It fails and returns an error about LOG_ARCHIVE_DEST not being set.
C. It executes successfully and sets the Fast Recovery Area as the local archive destination.
D. It executes successfully and sets $ORACLE_HOME/dbs as the default archive destination.

Answer: C

NEW QUESTION 23
Examine the resources consumed by a database instance whose current Resource
Manager plan is displayed.

Which two statements are true?

A. An attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.
B. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management.
C. A user belonging to the DSS__QUERIES resource consumer group can create a new session but the session will be queued.
D. An attempt to start a new session by a user belonging to OTHER_GROUPS fails with an error.
E. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to I/O waits and latch or enqueue contention.

Answer: B,C

NEW QUESTION 24
What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a
"CREATE DATABASE" statement?

A. It will create a multitenant container database (CDB) with only the root opened.
B. It will create a CDB with root and seed opened and one PDB mounted.
C. It will create a CDB with root opened and seed mounted.
D. It will create a CDB that must be plugged into an existing CDB.
E. It will create a CDB with root opened and seed read only.

Answer: E

NEW QUESTION 25
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?

A. Implementing Database Resource Manager
B. Decreasing the value of the IDLE_TIME resource limit in the default profile
C. Enabling resumable timeout for user sessions
D. Setting a metric threshold

Answer: A

NEW QUESTION 26
Which three factors influence the optimizer's choice of an execution plan?

A. the optimizer_mode initialization parameter
B. fixed baselines
C. operating system (OS) statistics
D. cardinality estimates
E. object statistics in the data dictionary

Answer: A,C,E

NEW QUESTION 27
Which two options can be configured for an existing database by using the Database
Configuration Assistant (DBCA)?

A. Nondefault blocksize tablespaces
B. Database Resident Connection Pooling
C. Database Vault inORACLE_HOME
D. Configure Label Security
E. Oracle SuggestedBackup Strategy

Answer: B,C

NEW QUESTION 28
Which three statements are true about using flashback database in a multitenant container database
(CDB)? (Choose three.) (Choose three.)

A. To enable flashback database, the CDB must be mounted.
B. A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore
point.
C. Individual PDBs can be flashed back without flashing back the entire CDB.
D. The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB.
E. The root container can be flashed back without flashing back the pluggable databases (PDBs).

Answer: A,D,E

Explanation:
Explanation/Reference:
Explanation:

NEW QUESTION 29
Examine the parameter for your database instance:

You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan: Identify the reason why the optimizer chose different execution plans.

A. The optimizer chose different plan because extended statistics were created for the columns used.
B. The optimizer used a dynamic plan for the query.
C. The optimizer used re-optimization cardinality feedback for the query.
D. The optimizer chose different plans because automatic dynamic sampling was enabled.

Answer: D

Explanation:
* optimizer_dynamic_sampling OPTIMIZER_DYNAMIC_SAMPLING controls both when the database gathers dynamic statistics, and the size of the sample that the optimizer uses to gather the statistics. Range of values0 to 11

NEW QUESTION 30
Which three statements are true about Oracle Data Pump? (Choose three.)

A. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
B. EXPDP and IMPDP are the client components of Oracle Data Pump.
C. The DBMS_DATAPUMP PL/SQL package can be used independently of Data Pump clients to perform export and import operations.
D. IMPDP can be used to change target data file names, schemas, and tablespaces during import.
E. IMPDP always use the conventional path insert method to import data.

Answer: B,C,D

Explanation:
Explanation
References: https://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_overview.htm#SUTIL2880

NEW QUESTION 31
You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege.
The CDB has several pluggable databases (PDBs) open in the read/write mode.
There are ongoing transactions in both the CDB and PDBs.
What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?

A. The statement results in an error because there are open PDBs.
B. The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back.
C. The shutdown proceeds immediately. The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolled hack.
D. The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.

Answer: D

Explanation:
* SHUTDOWN [ABORT | IMMEDIATE | NORMAL | TRANSACTIONAL [LOCAL]]
Shuts down a currently running Oracle Database instance, optionally closing and dismounting a database. If the current database is a pluggable database, only the pluggable database is closed. The consolidated instance continues to run.
Shutdown commands that wait for current calls to complete or users to disconnect such as SHUTDOWN NORMAL and SHUTDOWN TRANSACTIONAL have a time limit that the SHUTDOWN command will wait. If all events blocking the shutdown have not occurred within the time limit, the shutdown command cancels with the following message:
ORA-01013: user requested cancel of current operation
* If logged into a CDB, shutdown closes the CDB instance.
To shutdown a CDB or non CDB, you must be connected to the CDB or non CDB instance that you want to close, and then enter SHUTDOWN Database closed.
Database dismounted.
Oracle instance shut down.
To shutdown a PDB, you must log into the PDB to issue the SHUTDOWN command.
SHUTDOWN
Pluggable Database closed.
Note:
* Prerequisites for PDB Shutdown
When the current container is a pluggable database (PDB), the SHUTDOWN command can only be used if:
The current user has SYSDBA, SYSOPER, SYSBACKUP, or SYSDG system privilege.
The privilege is either commonly granted or locally granted in the PDB.
The current user exercises the privilege using AS SYSDBA, AS SYSOPER, AS SYSBACKUP, or AS SYSDG at connect time.
To close a PDB, the PDB must be open.

NEW QUESTION 32
......

1z0-062 Dumps PDF - 1z0-062 Real Exam Questions Answers: https://www.exams-boost.com/1z0-062-valid-materials.html

Realistic 1z0-062 Dumps Latest Practice Tests Dumps: https://drive.google.com/open?id=1Qqq7QiwOlEivc7r1eqP75I2hpI0NkkBn

Updated Sep-2022 100% Cover Real 1z0-062 Exam Questions - 100% Pass Guarantee [Q10-Q32]

Related Blogs