PDF -Get eBook \\ Oracle Database 12c New Features for - Ideate - 1z0-060.v2015-03-01.by.EMMIE.150q
Wait Loading...


PDF :1 PDF :2 PDF :3 PDF :4 PDF :5 PDF :6 PDF :7 PDF :8 PDF :9 PDF :10


Like and share and download

1z0-060.v2015-03-01.by.EMMIE.150q

Get eBook \\ Oracle Database 12c New Features for - Ideate

PDF Actualtests 1z0 060 150q VCEplus ! vceplus 1z0 060 oracle actualtests 1z0 060 v2015 03 28 by lucile 150q pdf PDF Oracle Passit4sure 1z0 060 v2015 03 09 by Scott VCEplus !

Related PDF

Actualtests 1z0-060 150q - VCEpluscom!

[PDF] Actualtests 1z0 060 150q VCEplus ! vceplus 1z0 060 oracle actualtests 1z0 060 v2015 03 28 by lucile 150q pdf
PDF

OraclePassit4sure1z0-060v2015-03-09byScott - VCEpluscom!

[PDF] Oracle Passit4sure 1z0 060 v2015 03 09 by Scott VCEplus ! vceplus 1z0 060 oracle passit4sure 1z0 060 v2015 03 09 by scott pdf
PDF

Read Study Guide For 1z0 060: Upgrade To Oracle Database 12c

[PDF] Read Study Guide For 1z0 060 Upgrade To Oracle Database 12c 500mexicocity Study 20Guide 20for 201Z0 060 20Upgrade 20to 20Oracle 20Database 2012c
PDF

Ocp Upgrade To Oracle Database 12c Exam Guide

[PDF] Ocp Upgrade To Oracle Database 12c Exam Guide v2 cervejafacil ocp upgrade to oracle database 12c exam guide pdf
PDF

Actualtests CISM 631q - Gioielleria Caselli

[PDF] Actualtests CISM 631q Gioielleria Caselli gioielleriacaselli ?vce=exams 3298 cism v2015 03
PDF

Ocp Oracle Database 12c Advanced Administration Exam Exam 1z0

[PDF] Ocp Oracle Database 12c Advanced Administration Exam Exam 1z0 theme investinblockchain ocp oracle database 12c advanced administration exam exam 1z0 063 oracle press pdf
PDF

1z0-060 Q&A DEMO Version

[PDF] 1z0 060 Q&A DEMO Version chinatag exams 1z0 060d pdf
PDF

Formations inter et intra entreprises R abat – C - Dyn IT Maroc

[PDF] Formations inter et intra entreprises R abat – C Dyn IT Marocdynit ma CatalogueDeFormations2013 DynIT pdf
PDF

Study For 1z0 061 Oracle Database 12c Sql - Best Seller

[PDF] Study For 1z0 061 Oracle Database 12c Sql Best Seller kampanje fsc no study for 1z0 061 oracle database 12c sql fundamentals oracle certification prep pdf
PDF

Get eBook \\ Oracle Database 12c New Features for - Ideate

Oracle Database 12c New Features for Administrators Exam 1Z0 060 ExamFOCUS Study Notes Paperback Pub Date 2013 08 01 Language Chinese Publisher Createspace Independent Publishing Platform, United States, 2015
PDF

1Z0-062_Oracle Database 12cInstallation and Administration

Oca Oracle Database 12c Installation And Administration Exam

PDF Oca Oracle Database 12c Installation And Administration Exam admin ifj oca oracle database 12c installation and administration exam guide exam 1z0 062 oracle press pdf PDF Oca Oracle Database 12c Installation And Administration Exam thelook almay oca oracle database 12c installation and

1Z0-330 Exam Training Material and Exam Dumps

oca oracle database sql certified expert exam guide exam 1z0 047

PDF Oracle 1Z0 330 Braindumps Jira – Atlassian jira atlassian secure attachment 323965 1Z0 330 pdf PDF Oracle 1Z0 330 PDF Questions | Valid Dumps 2019 Jira – Atlassian jira atlassian secure attachment 342460 1Z0 330

1Z0-434 - Oracle SOA Suite 12c Essentials.pdf

1z0 434 Oracle Soa Suite 12c Essentials Service - Book Library

PDF SOA Suite 12c Exam Study Guide PDF Oracle oracle soa suite 12c exam study guide 2398385 pdf PDF Oracle 1Z0 434 Dumps with Valid 1Z0 434 Exam Jira – Atlassian

1z0-481

1Z0-481 - CertBus

PDF Oracle 1Z0 481 Dumps with Valid 1Z0 481 Exam Questions PDF Jira jira atlassian secure 1Z0 481 Exam Dumps 2018 pdf PDF 1z0 481 Exam Questions Certleader pdf certleader 1z0 481 pdf PDF

1z0-497

1Z0-497 - Pass4Lead

PDF Oracle 1Z0 497 Dumps with Valid 1Z0 497 Exam Jira – Atlassian jira atlassian secure 1Z0 497 Exam Dumps 2018 pdf PDF 1Z0 497 Pass4Sure officialcerts pdf bycode 1Z0 497

1Z1 Scja Beta Exam Notes

Download Sun Java Certification Questions And Answers PDF

ytmfurniture sun java certification questions

bib irb hr datoteka 682263 Zbornik41 Badurina pdf LADA BADURINA VREMENSKI ODNOSI NA RAZINI SLOŽENE REČENICE I TEKSTA 77 II Vrijeme u rečenici Prikaz vremenskih odnosa na razini složene rečenice započet ćemo osvr tom na prototipni način njihova iskazivanja – vremenske zavisnosložene rečenice Odabir polazišne točke

1

Please wait - USCIS

irs gov pub irs pdf fw9 pdf Form W 9 (Rev 10 2018) Page 2 By signing the filled out form, you 1 Certify that the TIN you are giving is correct (or you are waiting for a irs gov

1

Cls Nº Entrant Nat Driver Nat Cat Cls Chassis Team Laps Total Time

PDF Scoring Guidelines for 2018 AP Physics 1 College Board secure media collegeboard ap pdf ap18 sg physics 1 pdf PDF AP Physics 1 2018 Free Response Questions The College Board secure media collegeboard

Home back Next

Description

Testking

1z0-060

QA Number: 1z0-060 Passing Score: 800 Time Limit: 120 min File Version: 11

Enjoy the real success with nicely written Questions with many corrections inside

You can get highest score with this dump, which are prepared by top certified professionals

Super valid, Hurry up guys study and pass this one

Exam A QUESTION 1 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

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

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

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

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

Use the MD_RESTORE command to restore both the metadata and data for the failed disk group

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

Correct Answer: CDF Section: (none) Explanation Explanation/Reference: QUESTION 2 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

Correct Answer: D'Section: (none) Explanation Explanation/Reference: * You can take an online tablespace offline so that it is temporarily unavailable for general use

The rest of the database remains open and available for users to access data

Conversely, you can bring an offline tablespace online to make the schema objects within the tablespace available to database users

The database must be open to alter the availability of a tablespace

QUESTION 3 Which three are true about the large pool for an Oracle database instance that supports shared server connections

Allocates memory for RMAN backup and restore operations Allocates memory for shared and private SQL areas Contains a cursor area for storing runtime information about cursors Contains stack space Contains a hash area performing hash joins of tables

Correct Answer: ABC Section: (none) Explanation Explanation/Reference: The large pool can provide large memory allocations for the following: / (B)UGA (User Global Area) for the shared server and the Oracle XA interface (used where transactions interact with multiple databases) /Message buffers used in the parallel execution of statements / (A) Buffers for Recovery Manager (RMAN) I/O slaves Note: * large pool Optional area in the SGA that provides large memory allocations for backup and restore operations, I/O server processes, and session memory for the shared server and Oracle XA

Session memory that stores session variables, such as logon information, and can also contain the OLAP pool

Unlike the shared pool, the large pool does not have an LRU list (not D)

Oracle Database does not attempt to age objects out of the large pool

Consider configuring a large pool if the database instance uses any of the following Oracle Database features: * Shared server In a shared server architecture, the session memory for each client process is included in the shared pool

For I/O server processes, backup, and restore operations, Oracle Database allocates buffers that are a few hundred kilobytes in size

QUESTION 4 What are three purposes of the RMAN FROM clause

to support PUSH-based active database duplication to support synchronization of a standby database with the primary database in a Data environment To support PULL-based active database duplication To support file restores over the network in a Data Guard environment To support file recovery over the network in a Data Guard environment

Correct Answer: BDE Section: (none) Explanation Explanation/Reference: DE: * With a control file autobackup, RMAN can recover the database even if the current control file, recovery catalog, and server parameter file are inaccessible

A recovery catalog is a database schema used by RMAN to store metadata about one or more Oracle databases

The catalog also records where the online redo logs, standby redo logs, tempfiles, archived redo logs, backup

sets, and image copies are created

QUESTION 5 You notice that the performance of your production 24/7 Oracle database significantly degraded

Sometimes you are not able to connect to the instance because it hangs

You do not want to restart the database instance

How can you detect the cause of the degraded performance

Enable Memory Access Mode, which reads performance data from SGA

Use emergency monitoring to fetch data directly from SGA analysis

Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots

Use Active Session History (ASH) data and hang analysis in regular performance monitoring

Run ADDM in diagnostic mode

Correct Answer: B Section: (none) Explanation Explanation/Reference: QUESTION 6 You are administering a database stored in Automatic Storage management (ASM)

The files are stored in the DATA disk group

You execute the following command: SQL > ALTER DISKGROUP data ADD ALIAS +data/prod/myfile

The file +data

The file +data

dbf`, and copied to +data/prod`

The file `+data

The file myfile

dbf` is created in +data/prod` and the reference to +data

Correct Answer: C Section: (none) Explanation Explanation/Reference:

ADD ALIAS Use this clause to create an alias name for an Oracle ASM filename

The alias_name consists of the full directory path and the alias itself

QUESTION 7 Which three functions are performed by the SQL Tuning Advisor

Building and implementing SQL profiles Recommending the optimization of materialized views Checking query objects for missing and stale statistics Recommending bitmap, function-based, and B-tree indexes Recommending the restructuring of SQL queries that are using bad plans

Correct Answer: ACE Section: (none) Explanation Explanation/Reference: The SQL Tuning Advisor takes one or more SQL statements as an input and invokes the Automatic Tuning Optimizer to perform SQL tuning on the statements

The output of the SQL Tuning Advisor is in the form of an advice or recommendations, along with a rationale for each recommendation and its expected benefit

The recommendation relates to collection of statistics on objects (C), creation of new indexes, restructuring of the SQL statement (E), or creation of a SQL profile (A)

You can choose to accept the recommendation to complete the tuning of the SQL statements

QUESTION 8 Examine the following command: ALTER SYSTEM SET enable_ddl_logging=FALSE

Which statement is true

None of the data definition language (DDL) statements are logged in the trace file

Only DDL commands that resulted in errors are logged in the alert log file

A new log

xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file

Only DDL commands that resulted in the creation of new database files are logged

Correct Answer: A Section: (none) Explanation Explanation/Reference:

ENABLE_DDL_LOGGING enables or disables the writing of a subset of data definition language (DDL) statements to a DDL alert log

The DDL log is a file that has the same format and basic behavior as the alert log, but it only contains the DDL statements issued by the database

The DDL log is created only for the RDBMS component and only if the ENABLE_DDL_LOGGING initialization parameter is set to true

When this parameter is set to false, DDL statements are not included in any log

QUESTION 9 Your multitenant container database (CDB) contains three pluggable database (PDBs)

You find that the control file is damaged

You plan to use RMAN to recover the control file

There are no startup triggers associated with the PDBs

Which three steps should you perform to recover the control file and make the database fully operational

Mount the container database (CDB) and restore the control file from the control file auto backup

Recover and open the CDB in NORMAL mode

Mount the CDB and then recover and open the database, with the RESETLOGS option

Open all the pluggable databases

Recover each pluggable database

Start the database instance in the nomount stage and restore the control file from control file auto backup

Correct Answer: CDF Section: (none) Explanation Explanation/Reference: Step 1: F Step 2: D'Step 3: C: If all copies of the current control file are lost or damaged, then you must restore and mount a backup control file

You must then run the RECOVERcommand, even if no data files have been restored, and open the database with the RESETLOGS option

Note: * RMAN and Oracle Enterprise Manager Cloud Control (Cloud Control) provide full support for backup and recovery in a multitenant environment

You can back up and recover a whole multitenant container database (CDB), root only, or one or more pluggable databases (PDBs)

QUESTION 10 A new report process containing a complex query is written, with high impact on the database

You want to collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests

For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and the CONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING

What should you do to accomplish this task

Execute the query and view Active Session History (ASH) for information about the query

Enable SQL trace for the query

Create a database operation, execute the query, and use the DBMS_SQL_MONITOR

REPORT_SQL_MONITOR function to view the report

Use the DBMS_APPLICATION_INFO

SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view

Correct Answer: C Section: (none) Explanation Explanation/Reference: The REPORT_SQL_MONITOR function is used to return a SQL monitoring report for a specific SQL statement

Incorrect: Not A: Not interested in session statistics, only in statistics for the particular SQL query

Not B: We are interested in statistics, not tracing

Not D: SET_SESSION_LONGOPS Procedure This procedure sets a row in the V$SESSION_LONGOPS view

This is a view that is used to indicate the on-going progress of a long running operation

Some Oracle functions, such as parallel execution and Server Managed Recovery, use rows in this view to indicate the status of, for example, a database backup

Applications may use the SET_SESSION_LONGOPS procedure to advertise information on the progress of application specific long running tasks so that the progress can be monitored by way of the V$SESSION_LONGOPS view

QUESTION 11 Identify two valid options for adding a pluggable database (PDB) to an existing multitenant container database (CDB)

Use the CREATE PLUGGABLE DATABASE statement to create a PDB using the files from the SEED

Use the CREATE DATABASE

ENABLE PLUGGABLE DATABASE statement to provision a PDB by copying file from the SEED

Use the DBMS_PDB package to clone an existing PDB

Use the DBMS_PDB package to plug an Oracle 12c non-CDB database into an existing CDB

Use the DBMS_PDB package to plug an Oracle 11 g Release 2 (11

Correct Answer: AD Section: (none) Explanation Explanation/Reference: QUESTION 12 Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis

You want to analyze some of the queries for an application that are cached in the library cache

What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance

Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS

Run the Automatic Workload Repository Monitor (ADDM)

Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS

Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS

Correct Answer: D'Section: (none) Explanation Explanation/Reference: * SQL Access Advisor is primarily responsible for making schema modification recommendations, such as adding or dropping indexes and materialized views

SQL Tuning Advisor makes other types of recommendations, such as creating SQL profiles and restructuring SQL statements

By using SQL Tuning Advisor and SQL Access Advisor, you can invoke the query optimizer in advisory mode to examine a SQL statement or set of statements and determine how to improve their efficiency

SQL Tuning Advisor and SQL Access Advisor can make various recommendations, such as creating SQL profiles, restructuring SQL statements, creating additional indexes or materialized views, and refreshing optimizer statistics

Note: * Decision support system (DSS) workload * The library cache is a shared pool memory structure that stores executable SQL and PL/SQL code

This cache contains the shared SQL and PL/SQL areas and control structures such as locks and library cache handles

Reference: Tuning SQL Statements

QUESTION 13 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

Create the evolve task by using the DBMS_SPM

CREATE_EVOLVE_TASK function

Implement the recommendations in the task by using the DBMS_SPM

IMPLEMENT_EVOLVE_TASK function

Execute the evolve task by using the DBMS_SPM

EXECUTE_EVOLVE_TASK function

Report the task outcome by using the DBMS_SPM

REPORT_EVOLVE_TASK function

Identify the correct sequence of steps: A

Correct Answer: B Section: (none) Explanation Explanation/Reference: * Evolving SQL Plan Baselines

Create the evolve task by using the DBMS_SPM

CREATE_EVOLVE_TASK function

This function creates an advisor task to prepare the plan evolution of one or more plans for a specified SQL statement

The input parameters can be a SQL handle, plan name or a list of plan names, time limit, task name, and description

Set the evolve task parameters

SET_EVOLVE_TASK_PARAMETER This function updates the value of an evolve task parameter

In this release, the only valid parameter is TIME_LIMIT

Execute the evolve task by using the DBMS_SPM

EXECUTE_EVOLVE_TASK function

This function executes an evolution task

The input parameters can be the task name, execution name, and execution description

If not specified, the advisor generates the name, which is returned by the function

Essentially, this function is equivalent to using ACCEPT_SQL_PLAN_BASELINE for all recommended plans

Input parameters include task name, plan name, owner name, and execution name

Report the task outcome by using the DBMS_SPM_EVOLVE_TASK function

This function displays the results of an evolve task as a CLOB

Input parameters include the task name and section of the report to include

Reference: Oracle Database SQL Tuning Guide 12c, Managing SQL Plan Baselines QUESTION 14 In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits

The database consists of locally managed tablespaces with free list managed segments

On further investigation, you find that buffer busy waits is caused by contention on data blocks

Which option would you consider first to decrease the wait event immediately

Decreasing PCTUSED Decreasing PCTFREE Increasing the number of DBWN process Using Automatic Segment Space Management (ASSM) Increasing db_buffer_cache based on the V$DB_CACHE_ADVICE recommendation

Correct Answer: D'Section: (none) Explanation Explanation/Reference: Automatic segment space management (ASSM) is a simpler and more efficient way * of managing space within a segment

It completely eliminates any need to specify and tune the pctused,freelists, and freelist groups storage parameters for schema objects created in the tablespace

If any of these attributes are specified, they are ignored

Oracle introduced Automatic Segment Storage Management (ASSM) as a * replacement for traditional freelists management which used one-way linked-lists to manage free blocks with tables and indexes

ASSM is commonly called "bitmap freelists" because that is how Oracle implement the internal data structures for free block management

Note: * Buffer busy waits are most commonly associated with segment header contention onside the data buffer pool (db_cache_size, etc

QUESTION 15 Examine this command: SQL > exec DBMS_STATS

SET_TABLE_PREFS (SH`, CUSTOMERS`, PUBLISH`, false`)

Which three statements are true about the effect of this command

Statistics collection is not done for the CUSTOMERS table when schema stats are gathered

Statistics collection is not done for the CUSTOMERS table when database stats are gathered

Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time

Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics

Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics

Correct Answer: CDE Section: (none) Explanation

Explanation/Reference: * SET_TABLE_PREFS Procedure This procedure is used to set the statistics preferences of the specified table in the specified schema

To ensure that the cost-based optimizer is still picking the best plan, statistics should be gathered once again

however, the user is concerned that new statistics will cause the optimizer to choose bad plans when the current ones are acceptable

The user can do the following: EXEC DBMS_STATS

SET_TABLE_PREFS('hr', 'employees', 'PUBLISH', 'false')

By setting the employees tables publish preference to FALSE, any statistics gather from now on will not be automatically published

The newly gathered statistics will be marked as pending

QUESTION 16 Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):

Which three are prerequisites for successful execution of the command

The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXD_FULL_DATABASE role

All the user-defined tablespaces must be in read-only mode on the source database

The export dump file must be created before starting the import on the target database

The source and target database must be running on the same platform with the same endianness

The path of data files on the target database must be the same as that on the source database

The impdp operation must be performed by the same user that performed the expdp operation

Correct Answer: ABD Section: (none) Explanation http://www

Explanation/Reference: In this case we have run the impdp without performing any conversion if endian format is differ- ent then we have to first perform conversion

QUESTION 17 Which two are true concerning a multitenant container database with three pluggable database

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

Correct Answer: CE Section: (none) Explanation Explanation/Reference: The benefits of Oracle Multitenant are brought by implementing a pure deployment choice

The following list calls out the most compelling examples

(E) The many pluggable databases in a single multitenant container database share its memory and background processes, letting you operate many more pluggable databases on a particular platform than you can single databases that use the old architecture

This is the same benefit that schema-based consolidation brings

(D, not B) The investment of time and effort to patch one multitenant container database results in patching all of its many pluggable databases

To patch a single pluggable database, you simply unplug/plug to a multitenant container database at a different Oracle Database software version

By consolidating existing databases as pluggable databases, administrators can manage many databases as one

For example, tasks like backup and disaster recovery are performed at the multitenant container database level

In Oracle Database 12c, Resource Manager is extended with specific functionality to control the competition for resources between the pluggable databases within a multitenant container database

Note: * Oracle Multitenant is a new option for Oracle Database 12c Enterprise Edition that helps customers reduce IT costs by simplifying consolidation, provisioning, upgrades, and more

It is supported by a new architecture that allows a multitenant container database to hold many pluggable databases

And it fully complements other options, including Oracle Real Application Clusters and Oracle Active Data Guard

An existing database can be simply adopted, with no change, as a pluggable database

and no changes are needed in the other tiers of the application

Reference: 12c Oracle Multitenant QUESTION 18 Examine the current value for the following parameters in your database instance: http://www

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

It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically

It succeeds only if memory is available from the autotuned components if SGA

It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET

It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE

Correct Answer: B Section: (none) Explanation Explanation/Reference: QUESTION 19 Which three statements are true concerning unplugging a pluggable database (PDB)

The PDB must be open in read only mode

The PDB must be closed

The unplugged PDB becomes a non-CDB

The unplugged PDB can be plugged into the same multitenant container database (CDB) The unplugged PDB can be plugged into another CDB

The PDB data files are automatically removed from disk

Correct Answer: BDE Section: (none) Explanation Explanation/Reference: D: An unplugged PDB contains data dictionary tables, and some of the columns in these encode information in an endianness-sensitive way

There is no supported

way to handle the conversion of such columns automatically

This means, quite simply, that an unplugged PDB cannot be moved across an endianness difference

E (not F): To exploit the new unplug/plug paradigm for patching the Oracle version most effectively, the source and destination CDBs should share a filesystem so that the PDB`s datafiles can remain in place

The PDB must be closed before it can be unplugged

When you unplug a PDB from a CDB, the unplugged PDB is in mounted mode

The unplug operation makes some changes in the PDB's data files to record, for example, that the PDB was successfully unplugged

Because it is still part of the CDB, the unplugged PDB is included in an RMAN backup of the entire CDB

Such a backup provides a convenient way to archive the unplugged PDB in case it is needed in the future

Reference: Oracle White Paper, Oracle Multitenant QUESTION 20 Examine the following command: CREATE TABLE (prod_id number(4), Prod_name varchar2 (20), Category_id number(30), Quantity_on_hand number (3) INVISIBLE)

Which three statements are true about using an invisible column in the PRODUCTS table

The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output

The DESCRIBE commands in SQL *Plus will not display the invisible column in the output

Referential integrity constraint cannot be set on the invisible column

The invisible column cannot be made visible and can only be marked as unused

A primary key constraint can be added on the invisible column

Correct Answer: ABE Section: (none) Explanation Explanation/Reference: AB: You can make individual table columns invisible

Any generic access of a table does not show the invisible columns in the table

For example, the following operations do not display invisible columns in the output: * SELECT * FROM statements in SQL * DESCRIBE commands in SQL*Plus * %ROWTYPE attribute declarations in PL/SQL * Describes in Oracle Call Interface (OCI) Incorrect: Not D: You can make invisible columns visible

You can make a column invisible during table creation or when you add a column to a table, and you can later alter the table to make the same column visible

Reference: Understand Invisible Columns QUESTION 21 You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT

You issue the following statements: SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT

For which database users is the audit policy now active

All users except SYS All users except SCOTT All users except sys and SCOTT All users except sys, system, and SCOTT

Correct Answer: B Section: (none) Explanation Explanation/Reference: If you run multiple AUDIT statements on the same unified audit policy but specify different EXCEPT users, then Oracle Database uses the last exception user list, not any of the users from the preceding lists

This means the effect of the earlier AUDIT POLICY

EXCEPT statements are overridden by the latest AUDIT POLICY

EXCEPT statement

Note: * The ORA_DATABASE_PARAMETER policy audits commonly used Oracle Database parameter settings

By default, this policy is not enabled

The following example shows how to audit all actions on the HR

EMPLOYEES table, except actions by user pmulligan

Example Auditing All Actions on a Table CREATE AUDIT POLICY all_actions_on_hr_emp_pol ACTIONS ALL ON HR

EMPLOYEES

AUDIT POLICY all_actions_on_hr_emp_pol EXCEPT pmulligan

Reference: Oracle Database Security Guide 12c, About Enabling Unified Audit Policies

QUESTION 22 On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command: $> sqlldr hr/[email protected] table=employees

com/ Which two statements are true regarding the command

It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database

It fails because no SQL *Loader data file location is specified

It fails if the HR user does not have the CREATE ANY DIRECTORY privilege

It fails because no SQL *Loader control file location is specified

Correct Answer: AC Section: (none) Explanation Explanation/Reference: Note: * SQL*Loader is invoked when you specify the sqlldr command and, optionally, parameters that establish session characteristics

QUESTION 23 After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows:

After changing the value, you notice that FULL redaction continues to redact numeric data with zero

What must you do to activate the new default value for numeric full redaction

Re-enable redaction policies that use FULL data redaction

Re-create redaction policies that use FULL data redaction

Re-connect the sessions that access objects with redaction policies defined on them

Flush the shared pool

Restart the database instance

Correct Answer: E Section: (none) Explanation Explanation/Reference: About Altering the Default Full Data Redaction Value You can alter the default displayed values for full Data Redaction polices

By default, 0 is the redacted value when Oracle Database performs full redaction (DBMS_REDACT

FULL) on a column of the NUMBER data type

If you want to change it to another value (for example, 7), then you can run the DBMS_REDACT

UPDATE_FULL_REDACTION_VALUES procedure to modify this value

The modification applies to all of the Data Redaction policies in the current database instance

After you modify a value, you must restart the database for it to take effect

Note: * The DBMS_REDACT package provides an interface to Oracle Data Redaction, which enables you to mask (redact) data that is returned from queries issued by low-privileged users or an application

You can redact column data by using one of the following methods: / Full redaction

Reference: Oracle Database Advanced Security Guide 12c, About Altering the Default Full Data Redaction Value QUESTION 24 You must track all transactions that modify certain tables in the sales schema for at least three years

Automatic undo management is enabled for the database with a retention of one day

Which two must you do to track the transactions

Enable supplemental logging for the database

Specify undo retention guarantee for the database

Create a Flashback Data Archive in the tablespace where the tables are stored

Create a Flashback Data Archive in any suitable tablespace

Enable Flashback Data Archiving for the tables that require tracking

Correct Answer: DE Section: (none) Explanation Explanation/Reference: E: By default, flashback archiving is disabled for any table

You can enable flashback archiving for a table if you have the FLASHBACK ARCHIVE object privilege on the Flashback Data Archive that you want to use for that table

D: Creating a Flashback Data Archive

/ Create a Flashback Data Archive with the CREATE FLASHBACK ARCHIVE statement, specifying the following: Name of the Flashback Data Archive Name of the first tablespace of the Flashback Data Archive (Optional) Maximum amount of space that the Flashback Data Archive can use in the first tablespace / Create a Flashback Data Archive named fla2 that uses tablespace tbs2, whose data will be retained for two years: CREATE FLASHBACK ARCHIVE fla2 TABLESPACE tbs2 RETENTION 2 YEAR

QUESTION 25 Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table`s indexes, to another tablespace

The table does not have a primary key and is used by an OLTP application

Which technique will move the table and indexes while maintaining the highest level of availability to the application

Oracle Data Pump

An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes

An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes

Online Table Redefinition

Edition-Based Table Redefinition

Correct Answer: D'Section: (none) Explanation Explanation/Reference: * Oracle Database provides a mechanism to make table structure modifications without significantly affecting the availability of the table

The mechanism is called online table redefinition

Redefining tables online provides a substantial increase in availability compared to traditional methods of redefining tables

Pseudo- primary keys are unique keys with all component columns having NOT NULL constraints

For this method, the versions of the tables before and after redefinition should have the same primary key columns

This is the preferred and

default method of redefinition

In this method, a hidden column named M_ROW$$ is added to the post-redefined version of the table

It is recommended that this column be dropped or marked as unused after the redefinition is complete

If COMPATIBLE is set to 10

You can then use the ALTER TABLE

DROP UNUSED COLUMNS statement to drop it

You cannot use this method on index-organized tables

Note: * When you rebuild an index, you use an existing index as the data source

Creating an index in this manner enables you to change storage characteristics or move to a new tablespace

Rebuilding an index based on an existing data source removes intra-block fragmentation

Compared to dropping the index and using the CREATE INDEX statement, re-creating an existing index offers better performance

Incorrect: Not E: Edition-based redefinition enables you to upgrade the database component of an application while it is in use, thereby minimizing or eliminating down time

QUESTION 26 To implement Automatic Management (AMM), you set the following parameters:

When you try to start the database instance with these parameter settings, you receive the following error message: SQL > startup ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information

Identify the reason the instance failed to start

The PGA_AGGREGATE_TARGET parameter is set to zero

The STATISTICS_LEVEL parameter is set to BASIC

Both the SGA_TARGET and MEMORY_TARGET parameters are set

The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal

Correct Answer: B Section: (none) Explanation Explanation/Reference: Example: SQL> startup force ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings ORA-00848: STATISTICS_LEVEL cannot be set to BASIC with SGA_TARGET or MEMORY_TARGET QUESTION 27 What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database

Effectively implements role separation Enables you to take advantage of Oracle Managed Files

Automatically registers the database with Oracle Restart

Helps you to easily upgrade the database from a prior release

Enables the Installation of Grid Infrastructure files on block or raw devices

Correct Answer: CE Section: (none) Explanation Explanation/Reference: Oracle Grid Infrastructure for a standalone server includes Oracle Restart and Oracle Automatic Storage Management

Oracle combined the two infrastructure products into a single set of bina- ries that is installed into an Oracle Restart home

htm#NTDBI999 QUESTION 28 Identify two correct statements about multitenant architectures

Multitenant architecture can be deployed only in a Real Application Clusters (RAC) configuration

Multiple pluggable databases (PDBs) share certain multitenant container database (CDB) resources

Multiple CDBs share certain PDB resources

Multiple non-RAC CDB instances can mount the same PDB as long as they are on the same server

Patches are always applied at the CDB level

A PDB can have a private undo tablespace

Correct Answer: BE Section: (none) Explanation Explanation/Reference: B: Using 12c Resource manager you will be able control CPU, Exadata I/O, sessions and parallel servers

A new 12c CDB Resource Manager Plan will use socalled Shares (resource allocations) to specify how CPU is distributed between PDBs

A CDB Resource Manager Plan also can use utilization limits to limit the CPU usage for a PDB

With a default directive, you do not need to modify the resource plan for each PDB plug and unplug

E: New paradigms for rapid patching and upgrades

The investment of time and effort to patch one multitenant container database results in patching all of its many pluggable databases

To patch a single pluggable database, you simply unplug/plug to a multitenant container database at a different Oracle Database software version

Incorrect: Not A: * The Oracle RAC documentation describes special considerations for a CDB in an Oracle RAC environment

It is supported by a new architecture that allows a container database to hold many pluggable databases

And it fully complements other options, including Oracle Real Application Clusters and Oracle Active Data Guard

An existing database can be simply adopted, with no change, as a pluggable database

and no changes are needed in the other tiers of the application

Not D: You can unplug a PDB from one CDB and plug it into a different CDB without altering your schemas or applications

A PDB can be plugged into only one CDB at a time

not F: * UNDO tablespace can NOT be local and stays on the CDB level

QUESTION 29 You upgrade your Oracle database in a multiprocessor environment

As a recommended you execute the following script: SQL > @utlrp

sql Which two actions does the script perform

Parallel compilation of only the stored PL/SQL code Sequential recompilation of only the stored PL/SQL code Parallel recompilation of any stored PL/SQL code Sequential recompilation of any stored PL/SQL code Parallel recompilation of Java code Sequential recompilation of Java code

Correct Answer: CE Section: (none) Explanation Explanation/Reference: utlrp

sql scripts are provided by Oracle to recompile all invalid objects in the database

They are typically run after major database changes such as upgrades or patches

They are located in the $ORACLE_HOME/rdbms/admin directory and provide a wrapper on the UTL_RECOMP package

The utlrp

sql script simply calls the utlprp

sql script with a command line parameter of "0"

The utlprp

sql accepts a single integer parameter that indicates the level of parallelism as follows

Both scripts must be run as the SYS user, or another user with SYSDBA, to work correctly

Reference: Recompiling Invalid Schema Objects QUESTION 30 Which statement is true concerning dropping a pluggable database (PDB)

The PDB must be open in read-only mode

The PDB must be in mount state

The PDB must be unplugged

The PDB data files are always removed from disk

A dropped PDB can never be plugged back into a multitenant container database (CDB)

Correct Answer: B Section: (none) Explanation Explanation/Reference: http://docs

com/database/121/ADMIN/cdb_plug

htm#ADMIN13658 QUESTION 31 You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report

After further investigation, you find that queries are performing too many full table scans and indexes are not being used even though the filter columns are indexed

Identify three possible reasons for this

Missing or stale histogram statistics Undersized shared pool High clustering factor for the indexes High value for the DB_FILE_MULTIBLOCK_READ_COUNT parameter Oversized buffer cache

Correct Answer: ACD Section: (none) Explanation Explanation/Reference: D: DB_FILE_MULTIBLOCK_READ_COUNT is one of the parameters you can use to minimize I/O during table scans

It specifies the maximum number of blocks read in one I/O operation during a sequential scan

The total number of I/Os needed to perform a full table scan depends on such factors as the size of the table, the multiblock read count, and whether parallel execution is being utilized for the operation

QUESTION 32 Which three features work together, to allow a SQL statement to have different cursors for the same statement based on different selectivity ranges

Bind Variable Peeking SQL Plan Baselines Adaptive Cursor Sharing Bind variable used in a SQL statement Literals in a SQL statement

Correct Answer: ACE Section: (none) Explanation Explanation/Reference: * In bind variable peeking (also known as bind peeking), the optimizer looks at the value in a bind variable when the database performs a hard parse of a statement

When a query uses literals, the optimizer can use the literal values to find the best plan

However, when a query uses bind variables, the optimizer must select the best plan without the presence of literals in the SQL text

This task can be extremely difficult

By peeking at bind values the optimizer can determine the selectivity of a WHERE clause condition as if literals had been used, thereby improving the plan

C: Oracle 11g/12g uses Adaptive Cursor Sharing to solve this problem by allowing the server to compare the effectiveness of execution plans between executions with different bind variable values

If it notices suboptimal plans, it allows certain bind variable values, or ranges of values, to use alternate execution plans for the same statement

This functionality requires no additional configuration

QUESTION 33 You notice a performance change in your production Oracle 12c database

You want to know which change caused this performance difference

com/ Which method or feature should you use

Compare Period ADDM report AWR Compare Period report Active Session History (ASH) report Taking a new snapshot and comparing it with a preserved snapshot

Correct Answer: A Section: (none) Explanation Explanation/Reference: QUESTION 34 You want to capture column group usage and gather extended statistics for better cardinality estimates for the CUSTOMERS table in the SH schema

Examine the following steps: 1

Issue the SELECT DBMS_STATS

CREATE_EXTENDED_STATS (SH`, CUSTOMERS`) FROM dual statement

Execute the DBMS_STATS

SEED_COL_USAGE (null, SH`, 500) procedure

Execute the required queries on the CUSTOMERS table

Issue the SELECT DBMS_STATS

REPORT_COL_USAGE (SH`, CUSTOMERS`) FROM dual statement

Identify the correct sequence of steps

Correct Answer: B Section: (none) Explanation Explanation/Reference: Step 1 (2)

Seed column usage Oracle must observe a representative workload, in order to determine the appropriate column groups

Using the new procedure DBMS_STATS

SEED_COL_USAGE, you tell Oracle how long it should observe the workload

Step 2: (3) You don't need to execute all of the queries in your work during this window

You can simply run explain plan for some of your longer running queries to ensure column group information is recorded for these queries

(1) Create the column groups At this point you can get Oracle to automatically create the column groups for each of the tables based on the usage information captured during the monitoring window

You simply have to call the DBMS_STATS

CREATE_EXTENDED_STATS function for each table

This function requires just two arguments, the schema name and the table name

From then on, statistics will be maintained for each column group whenever statistics are gathered on the table

Note: * DBMS_STATS

REPORT_COL_USAGE reports column usage information and records all the SQL operations the database has processed for a given object

While the optimizer has traditionally analyzed the distribution of values within a column, he does not collect value-based relationships between columns

create_extended_stats to relate the columns together

Unlike a traditional procedure that is invoked via an execute (exec) statement, Oracle extended statistics are created via a select statement

QUESTION 35 Which three statements are true about Automatic Workload Repository (AWR)

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

Correct Answer: BCD

Section: (none) Explanation Explanation/Reference: (http://docs

This data is both in memory and stored in the database

The gathered data can be displayed in both reports and views

The statistics collected and processed by AWR include: Object statistics that determine both access and usage statistics of database segments Time model statistics based on time usage for activities, displayed in the V$SYS_TIME_MODEL and V$SESS_TIME_MODEL views QUESTION 36 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

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

Correct Answer: BD Section: (none) Explanation

Explanation/Reference: * orapwd / You can create a database password file using the password file creation utility, ORAPWD

The syntax of the ORAPWD command is as follows: orapwd FILE=filename [ENTRIES=numusers] [FORCE={y|n}] [ASM={y|n}] [DBUNIQUENAME=dbname] [FORMAT={12|legacy}] [SYSBACKUP={y|n}] [SYSDG={y|n}] [SYSKM={y|n}] [DELETE={y|n}] [INPUT_FILE=input-fname] force

/ 10c: sts users who have been granted SYSDBA and SYSOPER privileges as derived from the password file

Column Datatype Description USERNAME VARCHAR2(30) The name of the user that is contained in the password file SYSDBA VARCHAR2(5) If TRUE, the user can connect with SYSDBA privileges SYSOPER VARCHAR2(5) If TRUE, the user can connect with SYSOPER privileges Incorrect: not E: The format of the v$PWFILE_users file is already in 12c format

QUESTION 37 An application accesses a small lookup table frequently

You notice that the required data blocks are getting aged out of the default buffer cache

How would you guarantee that the blocks for the table never age out

Configure the KEEP buffer pool and alter the table with the corresponding storage clause

Increase the database buffer cache size

Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause

Configure Automata Shared Memory Management

Configure Automatic Memory Management-

Correct Answer: A Section: (none) Explanation Explanation/Reference: Schema objects are referenced with varying usage patterns

therefore, their cache behavior may be quite different

Multiple buffer pools enable you to address

You can use a KEEP buffer pool to maintain objects in the buffer cache and a RECYCLE buffer pool to prevent objects from consuming unnecessary space in the cache

When an object is allocated to a cache, all blocks from that object are placed in that cache

Oracle maintains a DEFAULT buffer pool for objects that have not been assigned to one of the buffer pools

QUESTION 38 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

The shutdown proceeds immediately

The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolled hack

The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back

The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back

The statement results in an error because there are open PDBs

Correct Answer: B Section: (none) Explanation Explanation/Reference: * 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

QUESTION 39 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

Use Oracle Managed Files (OMF)

Specify the SEED FILE_NAME_CONVERT clause

Specify the PDB_FILE_NAME_CONVERT initialization parameter

Specify the DB_FILE_NAMECONVERT initialization parameter

Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF)

Correct Answer: ABC Section: (none) Explanation Explanation/Reference: You must specify the names and locations of the seed's files in one of the following ways:

The characteristics of the non-CDB are as follows: Version: Oracle Database 11g Release 2 (11

Transportable database Transportable tablespace Data Pump full export/import The DBMS_PDB package RMAN

Correct Answer: B Section: (none) Explanation Explanation/Reference: QUESTION 41 Your database supports an online transaction processing (OLTP) application

The application is undergoing some major schema changes, such as addition of new indexes and materialized views

You want to check the impact of these changes on workload performance

What should you use to achieve this

Database replay SQL Tuning Advisor SQL Access Advisor SQL Performance Analyzer Automatic Workload Repository compare reports

Correct Answer: D'Section: (none) Explanation Explanation/Reference: You can use the SQL Performance Analyzer to analyze the SQL performance impact of any type of system change

Examples of common system changes include: · Database upgrades · Configuration changes to the operating system, hardware, or database · Database initialization parameter changes · Schema changes, such as adding new indexes or materialized views · Gathering optimizer statistics · SQL tuning actions, such as creating SQL profiles http://docs

htm#CNCPT961 QUESTION 42 An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges

A multitenant container database (CDB) instant has the following parameter set: THREADED_EXECUTION = FALSE Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode

You can conned as a common user by using the connect statement

You can connect as a local user by using the connect statement

You can connect by using easy connect

You can connect by using OS authentication

You can connect by using a Net Service name

You can connect as a local user by using the SET CONTAINER statement

Correct Answer: ACDE Section: (none) Explanation

Explanation/Reference: http://docs

com/database/121/ADMIN/cdb_admin

htm QUESTION 43 Examine the following query output:

You issue the following command to import tables into the hr schema: $ > impdp hr/hr directory = dumpdir dumpfile = hr_new

dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y Which statement is true

All database operations performed by the impdp command are logged

Only CREATE INDEX and CREATE TABLE statements generated by the import are logged

Only CREATE TABLE and ALTER TABLE statements generated by the import are logged

None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged

Correct Answer: C Section: (none) Explanation Explanation/Reference: Note from Oracle Documentation: With redo logging disabled, the disk space required for redo logs during an Oracle Data Pump import will be smaller

However, to ensure recovery from media failure, the DBA should do an RMAN backup after the import completes

Even with this parameter specified, there is still redo logging for other operations of Oracle Data Pump

This includes all CREATE and ALTER statements, except CREATE INDEX, and all operations against the master table used by Oracle Data Pump during the import

QUESTION 44 You notice a performance change in your production Oracle database and you want to know which change has made this performance difference

You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation

Which three findings would you get from the report

It detects any configuration change that caused a performance difference in both time periods

It identifies any workload change that caused a performance difference in both time periods

It detects the top wait events causing performance degradation

It shows the resource usage for CPU, memory, and I/O in both time periods

It shows the difference in the size of memory pools in both time periods

It gives information about statistics collection in both time periods

Correct Answer: ABD Section: (none) Explanation Explanation/Reference: Keyword: shows the difference