Greetings,

Every time i submit a question, i get a sense of confidence that i will surely get a valid and updated answer from the world's most interactive and supportive forum.

The group is a ORACLE DICTIONARY for me. I thank you from bottom of my heart. Thank You 'ask tom' and group.

I am up for oracle 12cR1 examination. For preparation i am using various dumps and forums discussions to solve as well.

But below are some 22 questions, on which i am confused. I have my own answers but forums have their varying answers. So i dont want to take chances in my examination.

I kindly request, if you could suggest valid answers to the below questions.


-----------------------------------------------------------------------------------


12. What are three purposes of the RMAN “FROM” clause?
A.
to support PUSH-based active database duplication
B.
to support synchronization of a standby database with the primary database in a Data
environment
C.
To support PULL-based active database duplication
D.
To support file restores over the network in a Data Guard environment
E.
To support file recovery over the network in a Data Guard environment

CDE

---------------
--------------


31. Which two are true concerning a multitenant container database with three pluggable
databases?
A.
All administration tasks must be done to a specific pluggable database.
B.
The pluggable databases increase patching time.
C.
The pluggable databases reduce administration effort.
D.
The pluggable databases are patched together.
E.
Pluggable databases are only used for database consolidation.

CD

---------------------
---------------------

32. Examine the current value for the following parameters in your database instance:
SGA_MAX_SIZE = 1024M
SGA_TARGET = 700M
DB_8K_CACHE_SIZE = 124M
LOG_BUFFER = 200M
You issue the following command to increase the value of DB_8K_CACHE_SIZE:
SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;
Which statement is true?
A.
It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically.
B.
It succeeds only if memory is available from the autotuned components if SGA.
C.
It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within
SGA_TARGET.
D.
It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within
SGA_MAX_SIZE.

B

-------------
-------------

33. Which three statements are true concerning unplugging a pluggable database (PDB)?
A.
The PDB must be open in read only mode.
B.
The PDB must be closed.
C.
The unplugged PDB becomes a non-CDB.
D.
The unplugged PDB can be plugged into the same multitenant container database (CDB)
E.
The unplugged PDB can be plugged into another CDB.
F.
The PDB data files are automatically removed from disk.

BDE

------
------

41. What are two benefits of installing Grid Infrastructure software for a stand-alone server before
installing and creating an Oracle database?
A.
Effectively implements role separation
B.
Enables you to take advantage of Oracle Managed Files.
C.
Automatically registers the database with Oracle Restart.
D.
Helps you to easily upgrade the database from a prior release.E.
Enables the Installation of Grid Infrastructure files on block or raw devices.

AC

---------
---------

44. Which statement is true concerning dropping a pluggable database (PDB)?
A.
The PDB must be open in read-only mode.
B.
The PDB must be in mount state.
C.
The PDB must be unplugged.
D.
The PDB data files are always removed from disk.
E.
A dropped PDB can never be plugged back into a multitenant container database (CDB).

B

---------
---------


47. You notice a performance change in your production Oracle 12c database. You want to know
which change caused this performance difference.
Which method or feature should you use?
A.
Compare Period ADDM report
B.
AWR Compare Period report
C.
Active Session History (ASH) reportb
D.
Taking a new snapshot and comparing it with a preserved snapshot

A

---------
---------

49. Which three statements are true about Automatic Workload Repository (AWR)?
A.
All AWR tables belong to the SYSTEM schema.
B.
The AWR data is stored in memory and in the database.
C.
The snapshots collected by AWR are used by the self-tuning components in the database
D.
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.
E.
AWR contains system wide tracing and logging information.

BCD

-----------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------

53. You are planning the creation of a new multitenant container database (CDB) and want
to store the ROOT and SEED container data files in separate directories.
——–You plan to create the database using SQL statements.
Which three techniques can you use to achieve this?
A.
Use Oracle Managed Files (OMF).
B.
Specify the SEED FILE_NAME_CONVERT clause.
C.
Specify the PDB_FILE_NAME_CONVERT initialization parameter.
D.
Specify the DB_FILE_NAMECONVERT initialization parameter.
E.
Specify all files in the CREATE DATABASE statement without using Oracle managed Files
(OMF).

BCE

-------------
-------------

59. 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 used a dynamic plan for the query.
B.
The optimizer chose different plans because automatic dynamic sampling was enabled.
C.
The optimizer used re-optimization cardinality feedback for the query.
D.
The optimizer chose different plan because extended statistics were created for the
columns used.

C

-----------
-----------

69. Examine the contents of SQL loader control file:
Which three statements are true regarding the SQL* Loader operation performed using the
control file?
A.
An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended
with the loaded data.
B.
The SQL* Loader data file myfile1.dat has the column names for the EMP table.
C.
The SQL* Loader operation fails because no record terminators are specified.
D.
Field names should be the first line in the both the SQL* Loader data files.
E.
The SQL* Loader operation assumes that the file must be a stream record format file with
the normal carriage return string as the record terminator.

BDE

------------
------------

70. 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?
A.
It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN
in root only.
B.
It fails and reports an error because the CONTAINER=ALL clause is not used.
C.
It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN
in root and all PDBs.
D.
It fails and reports an error because the CONTAINER=CURRENT clause is not used.
E.
It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN
in all PDBs.

B

---------
---------

74. 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?
A.
Increasing the priority of the job class to which the job belongs
B.
Increasing the job’s relative priority within the Job class to which it belongs
C.
Increasing the resource allocation for the consumer group mapped to the scheduler job’s
job class within the plan mapped to the scheduler windowD.
Moving the job to an existing higher priority scheduler window with the same schedule and
duration
E.
Increasing the value of the JOB_QUEUE_PROCESSES parameter
F.
Increasing the priority of the scheduler window to which the job belongs

BC

------
------

79. Which three statements are true about using flashback database in a multitenant
container database (CDB)?
A.
The root container can be flashed back without flashing back the pluggable databases
(PDBs).
B.
To enable flashback database, the CDB must be mounted.
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.
A CDB can be flashed back specifying the desired target point in time or an SCN, but not a
restore point.

BCD

---------
---------

81. You execute the following commands to audit database activities:
SQL > ALTER SYSTEM SET AUDIT_TRAIL=DB, EXTENDED SCOPE=SPFILE;
SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION
WHENEVER SUCCESSFUL;
Which statement is true about the audit record that generated when auditing after instance
restarts?
A.
One audit record is created for every successful execution of a SELECT, INSERT OR
DELETE command on a table, and contains the SQL text for the SQL Statements.
B.
One audit record is created for every successful execution of a SELECT, INSERT OR
DELETE command, and contains the execution plan for the SQL statements.C.
One audit record is created for the whole session if john successfully executes a SELECT,
INSERT, or DELETE command, and contains the execution plan for the SQL statements.
D.
One audit record is created for the whole session if JOHN successfully executes a select
command, and contains the SQL text and bind variables used.
E.
One audit record is created for the whole session if john successfully executes a SELECT,
INSERT, or DELETE command on a table, and contains the execution plan, SQL text, and
bind variables used.

A

---------
---------

You are required to migrate your 11.2.0.3 database as a pluggable database (PDB) to a
multitenant container database (CDB).
The following are the possible steps to accomplish this task:
1. Place all the user-defined tablespace in read-only mode on the source database.
2. Upgrade the source database to a 12c version.
3. Create a new PDB in the target container database.
4. Perform a full transportable export on the source database with the VERSION parameter
set to 12 using the expdp utility.
Question No : 102
Oracle 1z0-060 : Practice Test
Pass Your Certification With Marks4sure Guarantee 895. Copy the associated data files and export the dump file to the desired location in the
target database.
6. Invoke the Data Pump import utility on the new PDB database as a user with the
DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.
7. Synchronize the PDB on the target container database by using the
DBMS_PDS.SYNC_ODB function.
Identify the correct order of the required steps.
A. 2, 1, 3, 4, 5, 6
B. 1, 3, 4, 5, 6, 7
C. 1, 4, 3, 5, 6, 7
D. 2, 1, 3, 4, 5, 6, 7
E. 1, 5, 6, 4, 3, 2

Answer: C

--------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------

101. Examine the parameters for your database instance:
Which three statements are true about the process of automatic optimization by using cardinality
feedback?
A.
The optimizer automatically changes a plan during subsequent execution of a SQL statement if
there is a huge difference in optimizer estimates and execution statistics.B.
The optimizer can re optimize a query only once using cardinality feedback.
C.
The optimizer enables monitoring for cardinality feedback after the first execution of a query.
D.
The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn
statistics are enabled.
E.
After the optimizer identifies a query as a re-optimization candidate, statistics collected by the
collectors are submitted to the optimizer.

ACE

------------------------
------------------------



110. You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity
feature of Oracle Database 12c.
Examine the table definition:
Which three statements are true concerning the use of the Valid Time Temporal feature for the
EMPLOYEES table?
A.
The valid time columns employee_time_start and employee_time_end are automatically
created.
B.
The same statement may filter on both transaction time and valid temporal time by using the AS
OF TIMESTAMP and PERIOD FOR clauses.
C.
The valid time columns are not populated by the Oracle Server automatically.
D.
The valid time columns are visible by default when the table is described.
E.
Setting the session valid time using
DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data
manipulation language (DML), data definition language (DDL), and queries performed by the
session.

ABC

-------------
-------------

121. You use the segment advisor to help determine objects for which space may be reclaimed.
Which three statements are true about the advisor given by the segment advisor?
A.
It may advise the use of online table redefinition for tables in dictionary managed tablespace.
B.
It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no
chained rows.
C.
It may advise the use of online table redefinition for tables in locally managed tablespaces
D.
It will detect and advise about chained rows.
E.
It may advise the use of segment shrink for free list managed tables.

ACD

---------
---------

128. You are about to plug a multi-terabyte non-CDB into an existing multitenant container database
(CDB) as a pluggable database (PDB).
——-The characteristics of the non-CDB are as follows:
Version: Oracle Database 12c Releases 1 64-bit
Character set: WE8ISO8859P15
National character set: AL16UTF16
O/S: Oracle Linux 6 64-bit
The characteristics of the CDB are as follows:
Version: Oracle Database 12c Release 1 64-bit
Character set: AL32UTF8
O/S: Oracle Linux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the
CDB?
A.
Transportable database
B.
Transportable tablespace
C.
Data Pump full export / import
D.
The DBMS_PDB package
E.
RMAN

C

----------
----------

134. 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.
Setting a metric threshold
B.
Implementing Database Resource Manager
C.
Enabling resumable timeout for user sessions
D.
Decreasing the value of the IDLE_TIME resource limit in the default profile

B

------
------

146. A database is stored in an Automatic Storage Management (ASM) disk group, disk group,
DGROUP1 with SQL:
There is enough free space in the disk group for mirroring to be done.
What happens if the CONTROLLER1 failure group becomes unavailable due to error of for
maintenance?
A.
Transactions and queries accessing database objects contained in any tablespace stored in
DGROUP1 will fall.
B.
Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until
the CONTROLLER1 for failure group is brought back online.
C.
The data in the CONTROLLER1 failure group is copied to the controller2 failure group and
rebalancing is initiated.
D.
ASM does not mirror any data until the controller failure group is brought back online, and
newly allocated primary allocation units (AU) are stored in the controller2 failure group, without
mirroring.
E.
Transactions accessing database objects contained in any tablespace stored in DGROUP1 will
fail but queries will succeed.

D

----------
-----------------------------

Yours' Sincerely,
Sanjiv Ranjit

SQL> startup pfile=c:\temp\init.ora
ORA-00380: cannot specify db_8k_cache_size since 8K is the standard block size

SQL> startup nomount pfile=c:\temp\init.ora
ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size                  3053880 bytes
Variable Size             641730248 bytes
Database Buffers          209715200 bytes
Redo Buffers              219242496 bytes

SQL> select name, block_size, set_msize from V$BUFFER_POOL_statistics;

NAME                 BLOCK_SIZE  SET_MSIZE
-------------------- ---------- ----------
DEFAULT                    4096      17974
DEFAULT                    8192      15190

SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;

System altered.

SQL> show sga

Total System Global Area 1073741824 bytes
Fixed Size                  3053880 bytes
Variable Size             641730248 bytes
Database Buffers          209715200 bytes
Redo Buffers              219242496 bytes

SQL> select name, block_size, set_msize from V$BUFFER_POOL_statistics;

NAME                 BLOCK_SIZE  SET_MSIZE
-------------------- ---------- ----------
DEFAULT                    4096      14190
DEFAULT                    8192      17150