Oracle 1z0-062 Exam Practice Questions Answers

Oracle Database 12c: Installation and Administration Questions and Answers

Question 1

You performed an incremental level 0 backup of a database:

RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE;

To enable block change tracking after the incremental level 0 backup, you issued this command:

SQL > ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE

‘ /mydir/rman_change_track.f’;

To perform an incremental level 1 cumulative backup, you issued this command:

RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;

Which three statements are true? (Choose three.)

Options:

Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.

The change tracking file must always be backed up when you perform a full database backup.

Block change tracking will always reduce I/O performed during cumulative incremental backups.

More than one database block may be read by an incremental backup for a change made to a single block.

The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.

Question 2

You find this query being used in your Oracle 12c database:

Which method a used by the optimizer to limit the rows being returned?

Options:

A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows

All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application.

A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.

A TOP-N query is created to limit the rows to 20 percent of the total rows

Question 3

You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index.

Which two are possible if table updates are performed which affect the invisible index columns? (Choose two.)

Options:

The index remains invisible.

The index is not updated by the DML statements on the indexed table.

The index automatically becomes visible in order to have it updated by DML on the table.

The index becomes unusable but the table is updated by the DML.

The index is updated by the DML on the table.

Question 4

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?

Options:

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.

Question 5

Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.

Which two RMAN commands may be; used to back up only the PDB1 pluggable database? (Choose two.)

Options:

BACKUP PLUGGABLE DATABASE PDB1 while connected to the root container

BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 container

BACKUP DATABASE while connected to the PDB1 container

BACKUP DATABASE while connected to the boot container

BACKUP PLUGGABLE database PDB1 while connected to PDB2

Question 6

You have just completed a manual upgrade of an Oracle 11g Database to Oracle Database 12c.

The Post-Upgrade Status Tool reports an INVALID status for some of the components after the upgrade.

What must you do first in this situation to attempt to fix this problem?

Options:

Run catuppst.sql to perform revalidation actions

Run utluiobj.sql to filter out objects that were invalidated by the upgrade process.

Run preupgrd.sql and then execute the generated “fix-up” scripts to resolve status issues.

Run utlrp.sql to recompile stored PL/SQL and Java code and check the DBA_REGISTRY view.

Question 7

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?

Options:

Create an event-based job.

Create a lightweight job.

Specify the job as a member of a job class.

Use a job array.

Question 8

You execute this command:

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

Options:

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

Question 9

Which two statements are true about the (PMON) background process in Oracle Database 12c? (Choose two.)

Options:

It records checkpoint information in the control file.

It frees unused temporary segments.

It kills sessions that exceed idle time.

It registers database services with all local and remote listeners known to the database instance.

It frees resources held by abnormally terminated processes.

Question 10

You set the following parameters in the parameter file and restart the database instance:

Which two statements are true? (Choose two.)

Options:

The MEMORY_MAX_TARGET parameter is automatically set to 500 MB.

The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero.

The value of the MEMORY_MAX_TARGET parameter remains zero for the database instance.

The lower limits of the PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB respectively.

The instance does not start up because Automatic Memory Management (AMM) is enabled but PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to nonzero values.

Question 11

You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privileges and execute the following sequence statements:

What is the result of the last SET CONTAINER statement and why is it so?

Options:

It succeeds because the PDB_ADMIN user has the required privileges.

It fails because common users are unable to use the SET CONTAINER statement.

It fails because local users are unable to use the SET CONTAINER statement.

If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).

Question 12

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

Options:

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 13

Which three operations can be performed as multipartition operations in Oracle? (Choose three.)

Options:

Merge partitions of a list partitioned table

Drop partitions of a list partitioned table

Coalesce partitions of a hash-partitioned global index.

Move partitions of a range-partitioned table

Rename partitions of a range partitioned table

Merge partitions of a reference partitioned index

Question 14

Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled? (Choose three.)

Options:

Reduced logical I/O

Reduced virtual memory utilization

Improved parallel Execution performance

Improved Serial Execution performance

Reduced physical I/O

Reduced CPU utilization

Question 15

You plan to implement the distributed database system in your company. You invoke Database Configuration Assistant (DBCA) to create a database on the server. During the installation, DBCA prompts you to specify the Global Database Name.

What must this name be made up of?

Options:

It must be made up of a database name and a domain name.

It must be made up of the value in ORACLE_SID and HOSTNAME.

It must be made up of the value that you plan to assign for INSTANCE_NAME and HOSTNAME.

It must be made up of the value that you plan to assign for ORACLE_SID and SERVICE_NAMES.

Question 16

Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)

Options:

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

Question 17

Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the HR_PDB. You execute the following command:

SQL > CREATE UNDO TABLESPACE undotb01

DATAFILE ‘u01/oracle/rddb1/undotbs01.dbf’ SIZE 60M AUTOEXTEND ON;

What is the result?

Options:

It executes successfully and creates an UNDO tablespace in HR_PDB.

It falls and reports an error because there can be only one undo tablespace in a CDB.

It fails and reports an error because the CONTAINER=ALL clause is not specified in the command.

It fails and reports an error because the CONTAINER=CURRENT clause is not specified in the command.

It executes successfully but neither tablespace nor the data file is created.

Question 18

A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions

The table has a local prefixed, range partitioned index.

Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still perform a full scan for all accessed partitions.

This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month.

You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a segment, while still allowing full scans for segments where many rows are returned.

Which three methods could transparently help to achieve this result? (Choose three.)

Options:

Using a partial local Index on the warehouse fact table month column with indexing disabled to the table partitions that return most of their rows to the queries.

Using a partial local Index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.

Using a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column.

Converting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned column.

Using a partial global index on the warehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries.

Using a partial global index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.

Question 19

Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart.

Examine the following command and its output:

$ crsctl config has

CRS-4622: Oracle High Availability Services auto start is enabled.

What does this imply?

Options:

When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.

When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.

When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.

When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.

Question 20

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:

Options:

2, 4, 5

2, 1, 4, 3, 5

1, 2, 3, 4, 5

1, 2, 4, 5

Question 21

A database is open READ WRITE and the instance has multiple sessions some of which have active

transactions.

You execute this command:

SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;

Which three are true about the active transactions? (Choose three.)

Options:

They may issue COMMIT OR ROLLBACK statements

They are suspended and unable to issue any statements

They may continue to issue DML statements

They are rolled back automatically

They may continue to issue queries

They are terminated immediately

Question 22

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

Options:

RMAN CONVERT command

Data Pump Export and import

Conventional Export and Import

The BACKUP AS COPY DATABASE . . . command of RMAN

DBMS_FILE_TRANSFER with transportable tablespace

Question 23

In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer.

Which statement is true?

Options:

The CDB must be open.

The CDB must be in the mount stage.

The CDB must be in the nomount stage.

Alt existing PDBs must be closed.

Question 24

You use a recovery catalog for maintaining your database backups.

You execute the following command:

$rman TARGET / CATALOG rman / cat@catdb

RMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL;

Which two statements are true? (Choose two.)

Options:

Corrupted blocks, if any, are repaired.

Checks are performed for physical corruptions.

Checks are performed for logical corruptions.

Checks are performed to confirm whether all database files exist in correct locations

Backup sets containing both data files and archive logs are created.

Question 25

Which two must be installed or configured either manually or by DBCA in order to use Enterprise Manager

Database Express (EM Express)? (Choose two.)

Options:

A port number for Oracle HTTP Server must be configured

The APEX_PUBLIC_USER role must be granted to SYSMAN

A SYSMAN user with SYSDBA privilege must be created

At least one TCP/IP dispatcher must be configured

The Oracle HTTP Server must be installed

Question 26

You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs).

Examine the query and its output:

Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file? (Choose two.)

Options:

Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.

Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.

Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.

Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.

Re-create the password file in the Oracle Database 12c format.

Question 27

Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER by issuing the following command:

1snrctl > STOP

What happens to the sessions that are presently connected to the database Instance?

Options:

They are able to perform only queries.

They are not affected and continue to function normally.

They are terminated and the active transactions are rolled back.

They are not allowed to perform any operations until the listener LISTENER is started.

Question 28

Which two statements are true about the logical storage structure of an Oracle database? (Choose two.)

Options:

An extent contains data blocks that are always physically contiguous on disk.

An extent can span multiple segments.

Each data block always corresponds to one operating system block.

It is possible to have tablespaces of different block sizes.

A data block is the smallest unit of I/O in data files.

Question 29

Which three statements are true about a job chain? (Choose three.)

Options:

It can contain a nested chain of jobs.

It can be used to implement dependency-based scheduling.

It cannot invoke the same program or nested chain in multiple steps in the chain.

It cannot have more than one dependency.

It can be executed using event-based or time-based schedules.

Question 30

Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN.

You want to issue the following RMAN command:

RMAN > BACKUP TABLESPACE hr_pdb:userdata;

Which task should you perform before issuing the command?

Options:

Place the root container in ARHCHIVELOG mode.

Take the user data tablespace offline.

Place the root container in the nomount stage.

Ensure that HR_PDB is open.

Question 31

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

Options:

Tracking the most recent read time for a table segment in a user tablespace

Tracking the most recent write time for a table segment in a user tablespace

Tracking insert time by row for table rows

Tracking the most recent write time for a table block

Tracking the most recent read time for a table segment in the SYSAUX tablespace

Tracking the most recent write time for a table segment in the SYSAUX tablespace

Question 32

DAILY_ORDS_LST is created in locally managed tablespace ORDERS_TBS which uses automatic segment space management.

Which two are true? (Choose two.)

Options:

80% of every data block in daily_ords_list is reserved for row inserts

20% of each data block in the table is reserved for row updates

PCTFREE can help to minimize row chaining during inserts

PCTFREE can help reduce row migration during updates

PCTFREE eliminates row chaining during inserts

Question 33

You want a job that performs a bulk insert as soon as the loader file arrives on the local file system.

Which two would you do to accomplish this? (Choose two.)

Options:

Create a file watcher

Create a bulk loader watcher

Create a light weight job for bulk insert

Create an event-based job for bulk insert

Create a job chain with a step for bulk insert

Question 34

Which two are true concerning a multitenant container database with three pluggable database? (Choose two.)

Options:

All administration tasks must be done to a specific pluggable database.

The pluggable databases increase patching time.

The pluggable databases reduce administration effort.

The pluggable databases are patched together.

Pluggable databases are only used for database consolidation.

Question 35

Your database is configured in ARCHIVELOG mode.

Examine the RMAN configuration parameters:

Examine the command:

RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;

Which two are true? (Choose two.)

Options:

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

It creates image copies of the archivelogs

It creates a backupset of archive log files

It creates image copies of the database files

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

Question 36

You plan to create a database by using the Database Configuration Assistant (DBCA), with the following specifications:

– Applications will connect to the database via a middle tier.

– The number of concurrent user connections will be high.

– The database will have mixed workload, with the execution of complex BI queries scheduled at night.

Which DBCA option must you choose to create the database?

Options:

a General Purpose database template with default memory allocation

a Data Warehouse database template, with the dedicated server mode option and AMM enabled

a General Purpose database template, with the shared server mode option and Automatic Memory Management (AMM) enabled

a default database configuration

Question 37

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

Options:

It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.

The optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline.

It adds new, bettor plans automatically as fixed plans to the baseline.

The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.

The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.

Question 38

A senior DBA asked you to execute the following command to improve performance:

SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle);

You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows.

What could be a reason for this recommendation?

Options:

The keep pool is not configured.

Automatic Workarea Management is not configured.

Automatic Shared Memory Management is not enabled.

The data blocks in the SUBSCRIBE_LOG table are rarely accessed.

All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view.

Question 39

Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. Currently, the database is running with peak workload. You want to analyze some of the most resource-intensive statements cached in the library cache.

What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance?

Options:

Automatic Database Diagnostic Monitor (ADDM)

SQL Tuning Advisor

SQL Access Advisor

SQL Performance Analyzer

Automatic Workload Repository (AWR) report

Question 40

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

Options:

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 41

Examine the command:

SQL> CREATE TABLESPACE test1

DATAFILE '/u01/app/oracle/oradata/orc1/test01.dbf' SIZE 5M

AUTOEXTEND ON UNIFORM;

Which statement is true?

Options:

The data file, TEST01.DBF, can be auto extended to a maximum size of 5M.

The tablespace, TEST1, can contain a maximum of one data file.

Allocated and free extents are tracked using bitmaps.

Segment free space is tracked in the data dictionary.

Question 42

Examine the details of the uncompressed, non-partitioned heap table CITIES.

Examine the command:

SQL> ALTER TABLE cities SHRINK SPACE COMPACT;

What must you do before executing it?

Options:

Ensure free space that is approximately equal to the space used by the table should be available.

Ensure there are no pending transactions on the table.

Enable row movement is enabled.

Disable all indexes on the table.

Question 43

Which two tasks must you perform before you begin the upgrade process to Oracle Database 12c? (Choose two.)

Options:

Put all readonly tablespaces in read write mode

Recompile all invalid objects

Set the compatible parameter to 12.1.0.1

Gather dictionary statistics

Empty all user recycle bins

Question 44

You want to create a database and you have the following:

- Oracle Grid Infrastructure is installed and configured.

- Oracle Database Vault is installed in ORACLE_HOME to be used for this database.

- Oracle Enterprise Manager Cloud Control is available and an agent is deployed on the database server.

Examine the requirements:

1. configuring the database instance to support shared server mode

2. using Automatic Storage Management (ASM) for storing database files.

3. configuring a naming method to help a remote user connect to a database instance

4. configuring the Fast Recovery Area

5. configuring Database Vault

6. configuring Enterprise Manager (EM) Database Express

7. registering with EM Cloud Control

8. configuring remote log archive destinations

9. enabling daily incremental backups

10. configuring a nondefault block size for nondefault block size tablespaces

Which of these requirements can be met while creating a database by using the Database Configuration Assistant (DBCA)?

Options:

1, 2, 4, 5, 7, 8, 9 and 10

1, 2, 4, 5, 6 and 7

1, 2, 3, 8, 9 and 10

1, 2, 3, 4, 6, 8, 9 and 10

1, 2, 4, 5, 6, 7 and 8

Question 45

You configured the Fast Recovery Area (FRA) for your database. The database instance is in ARCHIVELOG mode. The default location for the archived redo log files is the FRA.

Which two files are removed automatically if space is required in the FRA as per the retention policy? (Choose two.)

Options:

Archived redo log files that have multiple copies in a different archive location

user-managed backups of data files and control files

RMAN backups that are obsolete

flashback logs

Question 46

Identify three uses of the CROSSCHECK command (Choose three.)

Options:

to validate the database backup

to synchronize logical backup records with physical files in backup storage

to check the obsolete backups that can be deleted from the file system

to update information about backups that are deleted, corrupted, or inaccessible in a recovery catalog or control file

to update the recovery catalog or control file if archived log files are deleted with operating system commands

Question 47

You have a production Oracle 12c database running on a host.

You want to install and create databases across multiple new machines that do not have any Oracle database software installed. You also want the new databases to have the same directory structure and components as your existing 12c database.

The steps in random order:

1. Create directory structures similar to the production database on all new machines.

2. Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production database.

3. Create a database clone template for the database.

4. Run the Database Configuration Assistant (DBCA) to create the database.

5. Run OUI in graphical mode on each machine.

6. Run OUI in silent mode using the OUI response file.

Identify the required steps in the correct sequence to achieve the requirement with minimal human intervention.

Options:

1, 5, and 4

3, 1, 5, and 6

2, 3, 6, and 4

2, 1, 6, and 4

2, 3, 1, and 6

Question 48

What is the effect of setting the STATISTICS_LEVEL initialization parameter to BASIC?

Options:

Optimizer statistics are collected automatically.

Only timed operating system (OS) statistics and plan execution statistics are collected.

Automatic Workload Repository (AWR) snapshots are not generated automatically.

The Oracle server dynamically generates the necessary object-level statistics on tables as part of query optimization.

Question 49

Which two statements are true about SQL *Loader Express Mode in an Oracle 12c database? (Choose two.)

Options:

The DEGREE_OF_PARALLELISM parameter is set to AUTO.

You cannot have multiple SQL *Loader data files.

If no data file is specified, it assumes the data file to be .dat in the current directory and uses it.

You can have multiple bad files created when loading in parallel.

You can selectively load rows into a table based on a filter.

Question 50

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

Options:

An AWR snapshot shows the SQL statements that are producing the highest load on the system, based on criteria such as elapsed time and CPU time.

AWR data is stored in memory and in a database.

All AWR tables belong to the SYSTEM schema.

The manageability monitor (MMON) process gathers statistics and creates an AWR snapshot that is used by the self-tuning components in a database.

An AWR snapshot contains system-wide tracing and logging information.

Question 51

To enable faster incremental backups, you enabled block change tracking for the database.

Which two statements are true about the block change tracking file? (Choose two.)

Options:

Multiple change tracking files can be created for a database.

The change tracking file must be created after the first level 0 backup.

RMAN does not support backup and recovery of the change tracking file.

The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

Question 52

Which two statements are true about using SQL*Loader? (Choose two.)

Options:

It can load data from external files by using the direct path only.

It can load data into multiple tables using the same load statement.

It can load data into only one table at a time.

It can generate unique sequential key values in specified columns.

It can load data from external files by using the conventional path only.

Question 53

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

Options:

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 54

A database uses Automatic Storage Management (ASM) as database storage, which has a diskgroup, DATA1, which is created as follows:

What happens when the FAILGRP1 failure group is corrupted?

Options:

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

Question 55

Your database is configured for ARCHIVELOG mode, and a daily full database backup is taken. RMAN is configured to perform control file autobackup.

In which three scenarios do you need media recovery? (Choose three.)

Options:

loss of all the copies of the control file

loss of all the inactive online redo log group members

loss of a data file that belongs to the active undo tablespace

loss of data files that belong to the SYSTEM tablespace

logical corruption of data that is caused by a wrong transaction

abnormal termination of the database instance

Question 56

Which statement is true about the Database as a Service (DBaaS) instances and Database instances in Oracle Public Cloud

Options:

An Oracle database instance can support only one DBaaS instance.

A DBaaS instance can support only one Oracle database instance.

An Oracle database instance can support multiple DBaaS instances.

A DBaaS instance can support multiple Oracle database instances.

A DBaaS instance runs in a pluggable database (PDB), which is contained in a multi-tenant container database (CDB).

Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Oracle 1z0-062 Dumps

Oracle Database 12c: Installation and Administration Questions and Answers

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation: