PDF -1Z0-497 - Pass4Lead - 1z0-497
Wait Loading...


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


Like and share and download

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

Related PDF

Oracle 1Z0-497 Dumps with Valid 1Z0-497 Exam - Jira – Atlassian

[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

[PDF] 1Z0 497 Pass4Sure officialcerts pdf bycode 1Z0 497 pdf
PDF

1Z0-497 Exam Questions - Certleader

[PDF] 1Z0 497 Exam Questions Certleader pdf certleader 1Z0 497 pdf
PDF

1z0 497 Dumps Pass Exam With Valid 1z0 497

[PDF] 1z0 497 Dumps Pass Exam With Valid 1z0 497 mmcuav 1z0 497 pdf dumps pass exam with valid 1z0 497 pdf
PDF

1Z0-497 - Killexamscom

[PDF] 1Z0 497 Killexams killexams demo download 1Z0 497 pdf
PDF

1Z0-497 - CertBus

[PDF] 1Z0 497 CertBus certbus online pdf 1Z0 497 pdf
PDF

Selecting the Best Oracle Database Certification for You – Where to

[PDF] Selecting the Best Oracle Database Certification for You – Where to oracle a dc ww database certification guide pdf
PDF

Study-guide-for-1z0-497-oracle-database-12c - Fine Ridge

[PDF] Study guide for 1z0 497 oracle database 12c Fine Ridgefineridge au study guide for 1z0 497 oracle database 12c essentials oracle 2019 printablefile pdf
PDF

1Z0-497 - Pass4Lead

Pass Oracle 1Z0 497 Exam with 100 Guarantee Free Download Real Questions & Answers PDF and VCE file from pass4lead 1Z0 497
PDF

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

1

SR 1, Report of Traffic Accident Occuring in California - DMV

PDF Scoring Guidelines for 2018 AP Physics 1 The 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

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

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

Sample papers - Cambridge English

PDF DOR Motor Vehicle Title Tag Application dor georgia gov MV Tag and or Title Application Form MV1 0 pdf PDF 2018 Schedule 1 (Form 1040) IRS gov irs gov pub irs pdf

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

Home back Next

Description

Oracle 1z0-497

Oracle Database 12c Essentials Version: 6

Oracle 1z0-497 Exam QUESTION NO: 1 Which statement about CDB architecture is true

Oracle-supplied metadata resides only in the root container

A seed PDB can sometimes be opened for particular operations

Multiple PDBs with the same name can reside in the same CDB

A CDB can have an infinite number of PDBs

You can create common users in PDBs

Answer: A Reference: http://docs

QUESTION NO: 2 As part of your Oracle Database 12c post-installation tasks, you run these commands: Cd $ORACLE_HOME/bin srvctl stop database

It enables the Oracle Data Mining option in your Oracle binary files

It creates the Fast Recovery Area disk group

It generates Client Static Library

It configures one of the Oracle user accounts

It configures Oracle Net Services

It configures Oracle Messaging Gateway

Answer: A Reference: http://docs

"Pass Any Exam

Any Time

Oracle 1z0-497 Exam QUESTION NO: 3 Exhibit below:

Which three statements are true about terminating a session

Without any error, you can terminate the active session by executing: SQL> ALTER SYSTEM KILL SESSION '7, 15'

You can terminate the active session by executing: SQL> ALTER SYSTEM KILL SESSION "7, 15'

But you also get the error message: ORA-00028: your session has been killed C

You cannot terminate the active session

You have to wait until that session becomes inactive

Without any error, you can terminate the inactive session by executing: SQL> ALTER SYSTEM KILL SESSION '12, 63'

When an inactive session is killed, the status of that session remains visible in VSSESSION with status KILLED

The rowf the terminated session is removed from VSSESSION after the user attempts to use the session again

You cannot terminate the inactive session

You have to wait until that session becomes active again

Answer: B,D,E Explanation: B (not A, Not C): * You terminate a current session using the SQL statement ALTER SYSTEM KILL SESSION

The following statement terminates the session whose system identifier is 7 and serial number is 15: * Terminating an Active Session If a user session is processing a transaction (ACTIVE status) when you terminate the session, the transaction is rolled back and the user immediately receives the following message: ORA-00028: your session has been killed ALTER SYSTEM KILL SESSION '7,15'

E (not F): Terminating an Inactive Session

"Pass Any Exam

Any Time

Oracle 1z0-497 Exam If the session is not making a SQL call to Oracle Database (is INACTIVE) when it is terminated, the ORA-00028 message is not returned immediately

The message is not returned until the user subsequently attempts to use the terminated session

When an inactive session has been terminated, the STATUS of the session in the V$SESSION view is KILLED

The row for the terminated session is removed from V$SESSION after the user attempts to use the session again and receives the ORA-00028 message

Reference: Oracle Database Administrator's Guide, Terminating Sessions URL: http://docs

QUESTION NO: 4 Which two statements are true about shared server sessions

No Program Global Area (PGA) is allocated for shared server processes

User Global Area is stored in System Global Area (SGA)

Shared SQL Area is allocated from Program Global Area (PGA)

Private SQL Area is allocated from Library Cache

Large Pool is used for SQL work areas

Answer: B,D Explanation: Reference: Oracle Database Concepts, 12c, Memory Architecture

QUESTION NO: 5 Which targets can be managed by using Enterprise Manager Cloud Control

Hosts and databases B

Hosts, databases, and application servers C

Application servers and web applications D

Databases, Oracle Management Server (OMS), and Oracle Management Repository (OMR) E

Databases, application servers, and web applications F

Hosts, databases, application servers, web applications, OMS, and OMR Answer: A "Pass Any Exam

Any Time

Oracle 1z0-497 Exam Reference: http://www

com/technetwork/oem/framework-infra/wp-em12c-security-bestpracticesv2-1493383

pdf (page 3, second bulleted point, last couple of sentences)

QUESTION NO: 6 Which two statements are true regarding SQL*Plus

It has commands for performing database administration operations

It can be used in interactive but not batch mode for SQL commands

It has to be installed separately after the Oracle Database 12c installation

Operating system commands can be executed from the SQL*Plus command prompt

Answer: A,D Explanation: Reference: http://docs

QUESTION NO: 7 Which two statements about the Process Monitor (PMON) process are true

PMON performs process recovery when a client process fails

During instance startup, PMON takes care of instance recovery

PMON performs listener registration

PMON restarts background and dispatcher processes when they fail

PMON resolves failures of distributed transactions

Answer: A,D Explanation:

QUESTION NO: 8 Which statement is true about loading data by using the conventional path of SQL*Loader

Redo is not generated while performing conventional path loads

Only PRIMARY KEY, UNIQUE KEY, and NOT NULL constraints are checked, "Pass Any Exam

Any Time

Oracle 1z0-497 Exam C

No exclusive locks are acquired when the conventional path loads are performed

Instead of performing transactions, SQL*Loader directly writes data blocks to the data files

INSERT triggers are disabled before the conventional path load and re-enabled at the end of the load

Answer: B Reference: http://docs

com/cd/A57673_01/DOC/server/doc/SUT73/ch8

htm#data%20paths (see direct loads, integrity constraints, and triggers)

QUESTION NO: 9 Identify three key properties of a transaction in Oracle Database 12c

manageability Answer: A,B,D Reference: http://docs

QUESTION NO: 10 Which type of file system is NOT valid for storing data files, online redo log files, and control files for a pluggable database

Automatic Storage Management (ASM) B

OS file system C

RAW Answer: E Explanation:

"Pass Any Exam

Any Time

Oracle 1z0-497 Exam QUESTION NO: 11 Which two statements about ADDM are true

Real-Time ADDM uses AWR snapshots of the last 10 minutes

Real-Time ADDM uses ASH recent activity from SGA data

Real-Time ADDM analyzes performance in a completely different fashion than regular ADDM

Regular ADDM uses AWR snapshots that are not yet purged

Answer: B,D Explanation:

QUESTION NO: 12 Which two items are key for maintaining data consistency in Oracle Database 12c

serializability Answer: B,C Reference: http://docs

htm#CNCPT88969 (overview of the oracle database locking mechanism)

QUESTION NO: 13 You are about to install Oracle Database 12c Enterprise Edition

Which statement is true

You should not install the Oracle Database software into an existing Oracle home from a different release

A multitenant container database (CDB) can have several pluggable databases (PDBs) with different character sets

Oracle recommends that you back up the root

sh script after you complete the installation

Cloning an Oracle home is useful if you are performing multiple Oracle Database Installations

You can stop existing Oracle processes, including the listener and the database running in the Oracle home, before the database software installation

Answer: B

"Pass Any Exam

Any Time

Oracle 1z0-497 Exam Explanation:

QUESTION NO: 14 Which logical storage relationship is correct

Tablespace< Segment < Extent < Oracle Datablock B

B) Segment < Extent < Oracle Datablock VALIDATE BACKUP C

RMAN> VALIDATE CORRUPT BLOCKS D

RMAN> VALIDATE DATABASE Answer: D'Explanation: since 11g the syntax got changed to RMAN> validate [check logical] database

Example: DGMGRL> validate database verbose d1 output include: Block Corruptions found NO NO

QUESTION NO: 33 Which tool is recommended for moving a PDB to a non-CDB

Cold Backup C

Traditional Export / Import "Pass Any Exam

Any Time

Oracle 1z0-497 Exam D

Data Pump E

SQL*Plus Answer: E Explanation: Creating a PDB by Plugging an Unplugged PDB into a CDB An unplugged PDB consists of an XML file that describes the PDB and the PDB's files (such as the data files and wallet file)

You can use the CREATE PLUGGABLE DATABASE statement to plug in an unplugged PDB

To do so, you must include a USING clause that specifies the XML file that describes the PDB

The source CDB is the CDB from which the PDB was unplugged

The target CDB is the CDB into which you are plugging the PDB

The source CDB and target CDB can be the same CDB or different CDBs

QUESTION NO: 34 Which two statements describe data dictionary views

They are stored in the SYSTEM tablespace

They are based on virtual tables

They are owned by the SYS user

They speed up query and data manipulation language (DML) operations

The VSFIXED_TABLEview can be queried to list the names of these views

Answer: A,C Explanation:

QUESTION NO: 35

"Pass Any Exam

Any Time

Oracle 1z0-497 Exam

Which two statements about this policy are true

It replaces the first four digits of the value from the SALARY column with the number 9

It replaces the first digit of the value from the SALARY column with the number 4

It replaces the first digit of the value from the COMMISSION_PCTcolumn with 9

It replaces the first nine digits of the value from the COMMISSION_PCTcolumn with 1

It uses the full data redaction method

It uses the random redaction method

Answer: D,F Explanation:

QUESTION NO: 36 Which option represents a function of Global Data Services (GDS)

replaces the functionality of Oracle Clusterware and Oracle RAC D

works seamlessly with Oracle Site Guard Answer: E Explanation:

"Pass Any Exam

Any Time

Oracle 1z0-497 Exam QUESTION NO: 37 Which two statements represent where Oracle Net must reside

Only on the client for traditional client/server applications B

Only on the database server for web-based applications C

On both the web server and database server for web-based applications D

On both the client and database server for traditional client/server applications

Answer: B,D Explanation:

QUESTION NO: 38 When you start up a CDB, which operations are performed automatically and in what order

b, c, a, d'Answer: D'Explanation:

QUESTION NO: 39 Which new process was introduced as of Oracle Database 12c

"Pass Any Exam

Any Time

Oracle 1z0-497 Exam A

Result Cache Background process (RCBG) B

AQ Coordinator process (QMNC) C

Change Tracking Writer process (CTWR) D

Listener Registration process (LREG) Answer: D'Reference: http://musingdba

com/2013/07/05/new-in-oracle-database-12c-a/

QUESTION NO: 40

Which two statements are true about this common user

SQL> conn c##usr/[email protected] You are connected to PDB1 successfully

SQL> conn c##usr/[email protected] You are connected to PDB2 successfully

SQL> conn c##usr/[email protected] You are unable to create a connection

You first need to sync PDB2 by executing: SQL> conn / as sysdba SQL>exec DBMS_PDB

SYNC_PDB

SQL> conn c##usr/[email protected] You are unable to create a connection

You need to create the common user c# #usr explicitly in PDB2 by executing: SQL>conn system/[email protected] SQL> CREATE USER c##usrIDENTIFIED BYpwd CONTAINER=CURRENT

Now you are able to connect as common user c##usr to PDB2

Answer: A,B

"Pass Any Exam

Any Time

Oracle 1z0-497 Exam Explanation:

QUESTION NO: 41 Which two statements are true regarding undo data records

They are required to support Flashback features

They are not required if Flashback features are enabled

They are retained until the session making the changes ends

Undo records contain copies of data as it appears after a change is made

Undo records contain copies of data as it appears before a change is made

Answer: A,E Reference: http://docs

QUESTION NO: 42 Your customer has two CDBs: one for Production and one for development

You are asked to create a new development PDB (salesdev) from an existing production PDB (salesprd)

Which two options would accomplish this

You copy all the PDBSSEEDdata files from the production CDB into the development CDB and execute this on the development CDB

SQL> CREATE PLUGGABLE DATABASE salesdev ADMIN USER salesdm IDENTIFIED by password

You alter the salesprd source database to open in read-only mode, and start cloning the source database: SQL> ALTER PLUGGABLE DATABASE salesprd OPEN READ ONLY

SQL> CREATE PLUGGABLE DATABASE salesdev FROM salesprd

You alter the salesprd source database to open in read-only mode: SQL> ALTER PLUGGABLE DATABASE salesprd OPEN READ ONLY

In the development CDB, you create a databaselink "PRD" that connects to the root of the source CDB, and start cloning the source PDB: SQL> CREATE PLUGGABLE DATABASE salesdevFROM [email protected]

Connected as the salesprd local DBA, you create an XML using: SQL> ALTER PLUGGABLE DATABASE salespdb UNPLUG INTO ' /tmp/salesprd-xml'

Copy the XML file and all salesprd-related files to the target CDB and start plugging the copy into the development CDB using: SQL> CREATE PLUGGABLE DATABASE salesdev USING' /tmp/salesprd

"Pass Any Exam

Any Time

Oracle 1z0-497 Exam Answer: C,D Explanation: A: Creating a PDB Using the Seed You can use the CREATE PLUGGABLE DATABASE statement to create a PDB in a CDB using the files of the seed

D: Plugging In an Unplugged PDB To plug in an unplugged PDB, the following prerequisites must be met: * Complete the prerequisites described in "Preparing for PDBs"

The USING clause must specify the XML file

QUESTION NO: 43 Your database is down

You log in as the SYS user and issue this command: SQL> STARTUP What happens after the instance is started

Nothing else happens

The database is mounted but not opened

The database is mounted and finally opened

The database is opened and finally mounted

Answer: C Reference: http://docs

QUESTION NO: 44 Which option represents the steps to add a multiplexed copy of the current control file or to rename a control file in Oracle Database 12c

"Pass Any Exam

Any Time

Oracle 1z0-497 Exam d

c, d, b Answer: B Reference: http://docs

QUESTION NO: 45 Your database is open and the listener is running

The DBA stops the listener by using the command: LSNRCTL> STOP What happens to the sessions that are currently connected to the database instance

They can 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 till the listener is started

Answer: B Explanation:

QUESTION NO: 46 Your customer wants all email addresses from the database displayed as [hidden]@company

What method of data redaction must you use

"Pass Any Exam

Any Time

Oracle 1z0-497 Exam E

no redaction Answer: A Explanation:

QUESTION NO: 47 Your customer is looking for a solution that meets these four needs: 1

Which GoldenGate-supported topology would you recommended

Uni-directional for 1 Peer-to-peer for 2 Bi-directional for 3 Consolidation for 4 B

Peer-to-peer for 1 Broadcast for 2 Bi-directional for 3 Consolidation for 4 C

Uni-directional for 1 Broadcast for 2 Bi-directional for 3 Consolidation for 4 D

Peer-to-peer for 1 Consolidation for 2 Broadcast for 3 Cascading for 4 Answer: C Explanation:

QUESTION NO: 48

"Pass Any Exam

Any Time

Oracle 1z0-497 Exam You execute some DMLcommands, followed by a COMMIT Statement

Which option correctly describes how the logwriter (LGWR) process takes part in the transaction commit

LGWR writes the commit record to disk

LGWR writes all redo entries from Redo Log Buffer to disk

GWR writes only the transaction's redo entries from Redo Log Buffer to disk

LGWR writes the commit record to disk

LGWR puts the commit record to Redo Log Buffer

IGWR writes all redo entries from Redo Log Buffer to disk

LGWR puts the commit record to Redo Log Buffer

If the activity is high, LGWR waits three seconds for other transactions to commit

LGWR writes all redo log entries from Redo Log Buffer to disk

LGWR puts the commit record to Redo Log Buffer

LGWR signals the database writer (DBW) process to write dirty blocks to disk

LGWR writes all redo entries from Redo Log Buffer to disk

Answer: C Explanation:

QUESTION NO: 49 Which two statements about PDBs and CDBs are true

There is only one SYSTEM tablespace per CDB

There is only one instance per PDB

There is a set of redo log files per PDB

There is only one UNDO tablespace per CDB

There is one SYSAUXtablespace per PDB

Answer: D,E Explanation:

QUESTION NO: 50 You went to create a new CDB foe your customer

Which two statements are true about the seed pluggable database that will reside in the new CDB

You have to copy the seed data files yourself, B

You can use the new SEED FILE_NAME_CONVERTclause in the CREATE DATABASE "Pass Any Exam

Any Time

Oracle 1z0-497 Exam statement

The seed pluggable database is not required

The seed pluggable database does not require data files

The seed pluggable database is always kept in READ ONLY mode

The seed pluggable database is not a container

The seed pluggable database can be dropped

Answer: B,E Explanation:

QUESTION NO: 51 You want to clone PDB1 and PDB2 into the same CDB

Which statement is correct

You cannot do this, because you can only clone PDBs into another CDB

You can clone only one PDB (either PDB1 or PDB2) into the same CDB

Cloning a PDB can use the source files copy method to the target PDB files

Cloning a PDB can use the NOCOPY clause if the target PDB files use the source files

Answer: C Explanation:

QUESTION NO: 52 Consider 10 scenarios that result in database downtime

Which five of them are considered as planned downtime

addition or removal of nodes, memory, or disks B

changing configuration parameters, upgrading, or patching Oracle software C

migrating to cluster architecture E

runaway processes that consume system resources H

operating system or storage device / driver failure J

database or application deadlocks Answer: A,B,D,F,H Explanation:

"Pass Any Exam

Any Time

Oracle 1z0-497 Exam

QUESTION NO: 53 What happens if you execute these SQL statements

A common user is created in the root container

A local user is created in the root container

A local user is created in all the PDBs

The second SQL statement fails because a local user cannot be created in the root container

Answer: D'Explanation:

QUESTION NO: 54 A standby database is in mounted state and you are required to perform a failover to the physical standby

Which solution is best suited forthis scenario

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE statement with the FINISH keyword B

ALTER DATABASE PREPARE TO SWITCHOVER and ALTER DATABASE COMMIT TO SWITCHOVER statements C

ALTER DATABASE RECOVER TO STANDBY DATABASE statement with the FINISH keyword D

D) ALTER DATABASE PREPARE SWITCHOVER and ALTER DATABASE COMMIT TO SWITCHOVER Statements Answer: A Explanation:

"Pass Any Exam

Any Time

Oracle 1z0-497 Exam QUESTION NO: 55 Which two statements are true about transactions in Oracle Database 12c

Multiple transactions can use the same undo segment

A transaction is assigned an undo segment when it is started

Multiple transactions cannot share the same extent in an undo tablespace

If all the segments in an undo tablespace are used, transactions use system undo segments to store undo data

Answer: A,B Explanation:

QUESTION NO: 56 Which two statements about Data Recovery Advisor are true

Data Recovery Advisor can be used to diagnose and repair data corruptions in non-CDBs

Data Recovery Advisor cannot be used to diagnose and repair data corruptions in the root of a CDB

Data Recovery Advisor can be used to diagnose and repair data corruptions in PDBs

You can use the ADVISE FAILURE command to display repair options after running LIST FAILURE in an RMAN session

Answer: A,D Explanation: A (not B): In the current release, Data Recovery Advisor can only be used to diagnose and repair data corruptions in non-CDBs and the root of a multitenant container database (CDB)

Not C: Data Recovery Advisor is not supported for pluggable databases (PDBs)

D: A failure is detected either automatically by the database or through a manual check such as the VALIDATE command

You can use the LIST FAILURE command to view problem statements for failures and the effect of these failures on database operations

Each failure is uniquely identified by a failure number

In the same RMAN session, you can then use the ADVISE FAILURE command to view repair options, which typically include both automated and manual options

Reference: Oracle Database Backup and Recovery User's Guide, 12c, Diagnosing and Repairing Failures with Data Recovery Advisor

"Pass Any Exam

Any Time

Oracle 1z0-497 Exam

QUESTION NO: 57 Which two statements about multitenant architecture are true

It ensures full backward compatibility with non-CDBs

It fully operates with RAC

It is integrated with Enterprise Manager, but not with the Resource Manager

It allows central management and administration of single databases

Answer: C,D Explanation:

QUESTION NO: 58 You are installing OracleDatabase 12c on a machine

When you run the installer

Oracle Universal installer (OUI) shows a message that says one of the product-specific prerequisite checks has failed: Checking available swap space requirements

Expected result: 1512MB Actual Result: 1018MB Check complete

The overall result of this check is: failed «« Problem: The system does not have the required swap space

What happens to the installation in this situation

It can be continued

It resizes the swap space automatically when you proceed further

It can be continued, but the instance cannot be started without increasing swap space

It shows a message saying one or more prerequisite checks have failed and the installation aborts

Answer: A Reference: https://bugs

"Pass Any Exam

Any Time

Oracle 1z0-497 Exam QUESTION NO: 59 Examine the command below: LSNRCTL> SERVICES LISTENER2 Connecting to (DESCRIPTION=(ADDRESS= (PROTOCOL=TCP) (HOST=estb

com) (PORT=1525))) Services Summary

Service "orcl

Instance "oracle", status UNKNOWN, has 1 handler(s) for this service

Handler(s): "DEDICATED" established:2 refused:0 LOCAL SERVER The command completed successfully Which two statements are true about LISTENER2

The ORCL instance is registered dynamically with the listener

The ORCL instance is registered statically in the listener

The number of current client connections handled by the service handler is two

The total number of client connections handled so far by the service handler is two

Answer: B,D Explanation:

QUESTION NO: 60 Which three statements are true about a database instance that has mounted a database but has not opened it

System administrators and users with the CREATE SESSION system privilege may connect to the instance

Data files are open in read-only mode

A control file is open

System Global Area (SGA) is allocated and background processes are started

An alert log and trace files are open

Instance recovery is performed for the database

Answer: C,D,E Explanation:

"Pass Any Exam

Any Time

Oracle 1z0-497 Exam

QUESTION NO: 61 View the current parameter settings shown in the output below

NAMETYPEVALUE db_file_multiblock_read_count integer 107 ddl_lock_timeout integer 60 Distributed_lock_timeout integer 60 dml_locks integer 748 lock_sga boolean FALSE enab1e_dd1_1ogging boolean FALSE resumable_timeout integer 0 A user logs in to the hrschema and issues the following commands: "Pass Any Exam

Any Time

Oracle 1z0-497 Exam SQL> CREATE TABLE emp (empno NUMBER(3), enamo VARCHAR2(20), sal NUMBER (8, 2))

SQL> INSERT INTO emp (empno, ename) VALUES(1, 'JAMES')

At this moment, a second user also logs in to the hrschema and issues the following command: SQL> ALTER TABLE emp MODIFY salNUMBER(10, 2)

What happens in this scenario

The second user's session immediately produces a "resource busy" error

The second user's command executes successfully

The second user's session waits for a time before producing a "resource busy" error

A deadlock is created

Answer: A Explanation:

QUESTION NO: 62 Your customer wants to migrate their production database from Oracle Database 10gon AIX to Oracle Database 12con Solaris, and is concerned about the downtime

Which Oracle solution would you recommend

Active Data Guard B

Oracle GoldenGate C

Oracle Real Application Clusters D

Oracle Transportable Tablespaces E

Oracle Cloud Platform as a Service Answer: B Explanation:

"Pass Any Exam

Any Time

Oracle 1z0-497 Exam QUESTION NO: 63 An Oracle instance is a combination of______

database files and parameter file (initialization parameter file or server parameter file) B

System Global Area (SGA) and background processes C

a listener process, server processes, and background processes D

System Global Area (SGA), server processes, and background processes E

database files, System Global Area (SGA), and background processes Answer: B Reference: http://docs

com/cd/A57673_01/DOC/server/doc/SCN73/ch9

QUESTION NO: 64 You have two database servers EMP and EXP

A user of the database from the EXP server wants to extract some information from the database in the EMP server for cross-verification

Which schema object enables the user to access the information from the remote database

materialized view Answer: B Reference: http://docs

QUESTION NO: 65 Which two are client-side components of Oracle Data Guard Broker

Oracle Enterprise Manager Cloud Control B

Oracle Data Guard monitor C

Oracle Data Guard command-line interface (DGMGRL) D

Oracle Data Guard Broker Manager Answer: A,C Reference: http://books

?id=qK-biQrYzAUC&pg=PA55&lpg=PA55&dq=clientside+components+of+Oracle+Data+Guard+Broker&source=bl&ots=hHTjqx70n7&sig=1SkypkiGuU "Pass Any Exam

Any Time

Oracle 1z0-497 Exam R1uPpy0QLGFPqy4mw&hl=en&sa=X&ei=qsT7Us7VDMWN7AavYCgCg&ved=0CEQQ6AEwAw#v=onepage&q=clientside%20components%20of%20Oracle%20Data%20Guard%20Broker&f=false

QUESTION NO: 66 Your customer needs server availability that provides uninterrupted access to database services, handling any unexpected failure of one or more machines hosting the database server, due to a hardware or software fault

Which product should your customer use

Oracle Data Guard B

Oracle Streams C

Oracle Real Application Clusters D

Oracle GoldenGate Answer: C Reference: http://www

com/technetwork/database/availability/maximum-availability-wp-12c1896116

pdf (page 5, Server HA: Oracle Real Application Clusters)

QUESTION NO: 67 Your customer has three data centers in three different locations, location A has their production database running on Oracle Database 12c

They want to replicate the data from location A to location B

which is 50 miles away and is used for disaster protection and database rolling upgrades

They also want to create a replica database at location C, which must be open in readwrite mode, while synchronizing with the primary database

Which two solutions would you recommend to your customer

Oracle GoldenGate B

Oracle Advanced Replication C

Oracle Active Data Guard D

Oracle Streams Answer: A,C Explanation:

"Pass Any Exam

Any Time

Oracle 1z0-497 Exam QUESTION NO: 68 Your database instance is running

You issue a connection request by using the command: SQL> CONNECT scott/[email protected] Which component receives the request and establishes the appropriate connection

server process Answer: A Reference: http://docs

QUESTION NO: 69 Which statement about Online Move Data file is true

Moving a data file online prevents DML operations on segments stored in the data file

Flashing back a database to a point in time before a data file had been renamed online retains the new name

Moving a data file online can be performed if the data file is in OFFLINE mode

Moving a data file online cannot be performed if the data file is under BEGIN BACKUP

Answer: B Explanation:

QUESTION NO: 70 You execute the following command: SQL> ALTER USER skd ACCOUNT LOCK

Which two statements are correct

"Pass Any Exam

Any Time

Oracle 1z0-497 Exam A

The SKD user cannot log in to the database instance

The objects owned by the SKD user are not accessible to any user

Other users can access objects owned by the SKD user, to which they have access

The SKD user's password expires and the user is forced to change the password at the next login

Answer: A,C Explanation:

QUESTION NO: 71 Examine the statements: SQL> CREATE TABLESPACE MYTBS DATAFILE '/disk1/mytbs_l

SQL> CREATE TABLE mytab (id NUMBER, descr VARCHAR2 (100) ) PARTITION BY RANGE(id) ( partition pi values loss than (100000) tablespacemytbs storage (initial lm), partition p2 values less than (MAXVALUE) tablespacemytbs storage (initial 1m) )

When inserting data, you get the error: ORA-01688: unable to extend table SYS

MYTAB partition P2 by 128 in tablespace MYTBS Which three operations would allow you to insert data without getting the error message

Extend the logical volume by 10 MB where the data files are stored

Add a data file: SQL>ALTER TABLESPACE MYTBS ADD DATAFILE ' /disk1/mytbs_2

Move a partition to another tablespace: SQL> CREATE TABLESPACE ADDITIONAL_TBS DATAFILE '/disk1/additional_tbs_1

SQL> ALTER TABLE MYTAB MOVE PARTITION P2 TABLESPACE ADDlTIONAL_TBS

Resize the existing data file: SQL> ALTER DATABASE DATAFILE '/diskl/mytbs_l

E) Remove a data file: SQL> ALTER TABLESPACE MYTBS DROP DATAFILE '/diskl/mytbs_l

"Pass Any Exam

Any Time

Oracle 1z0-497 Exam Answer: B,C,D Explanation:

QUESTION NO: 72 Which two statements about Automatic Data Optimization (ADO) are true

ADO policies can automatically compress data when it qualifies

ADO policies can automatically move segments when necessary

ADO is not dependent on Heat Map, and works even if Heat Map is disabled

You cannot compress at block level, but you can compress at segment level

You can compress at row level only for QUERY LOW

Answer: A,B Explanation:

QUESTION NO: 73 Which statement about Oracle patches is false

Interim patches, also known as "one-off" patches, are created to provide a specific fix between the releases of patch sets

Security Patch Update (SPU) is the primary means of releasing security fixes for Oracle products

SPUs are cumulative with respect to prior SPUs and generally contain only security fixes

Patch Set Update (PSU) is a collection of proactive, stabilizing, cumulative patches for a particular product version (base release or patch set)

PSUs are cumulative and include all the security fixes from CPU patches, plus additional fixes

Patch Set is the main way in which Oracle provides bug fixes in between releases

Oracle bundles a number of fixes, tests them thoroughly together, and packages, then together for easy download and installation

Terminal Patch Set is an unsupported patch set by Oracle Lifetime Support policies

Answer: E Explanation: Starting with Oracle Database version 12

Security Patch Updates (SPU) will no longer be available

"Pass Any Exam

Any Time

Oracle 1z0-497 Exam QUESTION NO: 74 Which three statements represent the difference between a container database (CDB)and a noncontainer database

A container database has exactly one seed PDB, and a non-container database has no seed PDB

In a newly created non-CDB that does not yet contain user data, the data dictionary contains only system metadata

When application users create their own objects, this metadata is mixed with the system metadata

In a CDB, the data dictionary metadata is split between the root and the PDBs

The data dictionary in the PDB contains pointers to the data dictionary in the root

New views are introduced

Next to DBA_views, AIL_-views, and USER_-views, there are CDB_-views

Both CDB and non-CDB databases can access this information

You are allowed to create only a single HR user in a non-CDB database

This restriction is identical for a CDB database

Every PDB in a CDB has its own control file

A non-CDB, which has no containers, needs only one control file

Answer: A,B,C Explanation:

QUESTION NO: 75 The session of user SCOTT receives the following error after executing an UPDATE command on the EMP table: ERROR at line 1: ORA-00060: deadlock detected while waiting for resource You find out that a session opened by user JIM has a transaction that caused the deadlock

Which two statements are true about SCOTT's session in this scenario

The session is terminated after receiving the error and JIM can continue with his transaction

SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction

The session is rolled back after receiving the error and JIM can continue with his transaction

SCOTT has to re-execute the last command in the transaction after he commits the transaction

Answer: B,D Explanation:

"Pass Any Exam

Any Time

Oracle 1z0-497 Exam QUESTION NO: 76 Examine the command: SQL> CREATE TABLE orders(oid NUMBER (6) PRIMARY KEY, odato DATE, ccode NUMBER (6), oamt NUMBER (10, 2)) TABLESPACE users

Which two statements are true about the execution of the command

A CHECK constraint is created on the OID column

A NOT NULL constraint is created on the OID column

The ORDERS table is the only object created in the USERS tablespace

The ORDERS table and a unique index are created in the USERS tablespace

The ORDERS table is created in the USERS tablespace and a unique index is created on the OID column in the SYSTEM tablespace

Answer: B,D Explanation: B: A NOT NULL constraint is put on the primary key

D: * To enable a unique or primary key constraint, you must have the privileges necessary to create an index on the table

You need these privileges because Oracle Database creates an index on the columns of the unique or primary key in the schema containing the table

If you omit TABLESPACE, then the database creates that item in the default tablespace of the owner of the schema containing the table

Reference: Oracle Database SQL Language Reference 12c , CREATE TABLE

QUESTION NO: 77 Which three options correctly match environment variables with their specific functionality

ORACLE_SID specifies the instance name

ORACLE_SID specifies the global database name

ORACLE_BASE specifies the root of the Oracle Database directory tree in all platforms

ORACLE_BASE specifies the root of the Oracle Database directory tree only in UNIX and Linux platforms

ORACLE_HOME specifies the directory containing the Oracle software executables and network files

ORACLE_HOME specifies the directory containing only the Oracle software executables, but "Pass Any Exam

Any Time

Oracle 1z0-497 Exam not the network files

Answer: A,C,E Explanation:

QUESTION NO: 78 Identify the correct order of consolidation density

multitenant< schema consolidation< dedicated database< VMs B

schema consolidation< VMs< dedicated databases< multitenant C

dedicated databases< VMs< schema consolidation< multitenant D

VMs< dedicated databases< schema consolidation< multitenant Answer: D'Explanation:

QUESTION NO: 79 Examine the commands: SQL> CONNECT [email protected] AS SYSDBA $QL>STARTUP MOUNT SQL> ALTER DATABASE cdbl MOUNT

Which four options represent what happens when these commands are executed

The instance is started

The CDB control files are opened for the instance

The root is mounted

The root is opened

The PDBs are mounted

The PDBs are mounted, and the seed is opened in READ ONLY mode

The PDBs are mounted, and opened in READ WRITE mode, while the seed is opened In READ ONLY mode

Answer: A,B,C,E Explanation:

"Pass Any Exam

Any Time

Oracle 1z0-497 Exam

QUESTION NO: 80 Which two statements about switchover and failover are true

A snapshot standby can be the target of a switchover or fast-start failover operation

Neither a switchover nor a failover is possible to a far sync instance

For fast-start failover, you must preselect the target standby database that will be used

You can activate a standby database to test whether it is being updated correctly

Answer: B,C Reference: http://docs

QUESTION NO: 81 Identify three types of important statistics collection that you can disable in Oracle Database 12c by setting the STATISTIS_LEVEL parameter to BASIC

Oracle Database alert

Automatic SGA Memory Management D

Oracle Database Trace files E

all server-generated alerts Answer: B,C,E Explanation:

QUESTION NO: 82 You need to recover a database running In NOARCHIVELOG mode

Which two statements are true in this scenario

You can perform complete recovery by using the command: RESTORE DATABASE FROM TAG“consistent_whole_backup”

RECOVER DATABASE

"Pass Any Exam

Any Time

Oracle 1z0-497 Exam B

You can perform incomplete recovery by using the command: RESTORE DATABASE

FROM TAG "consistent_whole_backup"

RECOVER DATABASE NOREDO

Only consistent backups can be used for restoring a database in NOARCHIVELOG mode

Media recovery is possible in most cases

Answer: B,C Reference: http://docs

QUESTION NO: 83 Which statement about a server parameter file (SPFILE) is false

An SPFILE is a binary file that cannot be edited by using a text editor

You can create an SPFILE from an existing text initialization parameter file or from memory

You can use the SHOW PARAMETERS command to display the values of initialization parameters in an SPFILE

The instance first searches for an SPFILE named spfileoRACLE_SID

It searches for spfile

Answer: D'Explanation: Not A, not B: SPFILE is a text file that can be created from a file or from scratch

Not C: This shows database was started by spfile SQL> show parameter spfile

NAME TYPE VALUE

ora No values returned means its started by pfile

QUESTION NO: 84 Which statement about the Queryable Patch inventory feature is false

It is used to retrieve installed patch information from a SQL prompt

It uses the PREPROCESSOR feature, which allows users to preprocess input data before it is "Pass Any Exam

Any Time

Oracle 1z0-497 Exam sent to the access drivers

DBMS_QOPATCH provides a PL/SQL or SQL interface to view the database patches installed

It works in an Oracle database instance that is mounted

Therefore, it works in ASM instances and DG instances

Answer: D'Explanation: * New in Oracle 12c is queryable Opatch

Oracle offers a set of tables and a PL/SQL packages to query the Oracle Inventory

Prior to Oracle 12c, it was not easy to List Oracle patches

Now from Oracle 12c and beyond, you can use the DBMS_QOPATCH package to list all patches

Write wrapper programs to create reports and do validation checks across multiple environments

Check patches installed on Oracle RAC nodes from a single location instead of having to log onto each one in turn

QUESTION NO: 85

Option A B

Option B C

Option C D

Option D'E

Option E Answer: A,C,E

"Pass Any Exam

Any Time

Oracle 1z0-497 Exam Explanation:

QUESTION NO: 86 Identify two types of solutions in which you would need to use Active Data Guard and Golden Gate together

a solution that provides zero-data-loss protection at any distance without impacting database performance B

a solution for disaster protection and database rolling upgrades for a mission-critical OLTP database, where you also want to extract data from a data guard primary database for ETL update o' an enterprise data warehouse C

a solution requiring minimal planned downtime and risk, using standby first patching, database rolling upgrades, and select platform migrations D

a solution that helps with integrated automatic database and client failover between source and target, where you also need to establish advanced replication (such as multi master and bidirectional replication and data transformations) Answer: B,C Reference: http://www

com/technetwork/database/availability/active-data-guard-wp-12c1896127

pdf (page 16, last two bulleted points)

QUESTION NO: 87 You create a CDB with four containers: the loot, the seed, and two pluggable databases PDB1 and PDB2

Which four items can reside In PDB1, but not in the root

shared UNDO and default database temporary tablespace B

Oracle-supplied metadata C

CDB views providing information across PDBs E

non-shared local metadata Answer: E,F,G,H Explanation:

"Pass Any Exam

Any Time

Oracle 1z0-497 Exam

QUESTION NO: 88 Which two statements are true when you execute an invoker's rights procedure

The owner must have the INHERIT PRIVILEGES object privilege on the invoking user, or the INHERIT ANY PRIVILEGES privilege

Invoking users can control who can access their privileges when they run an invoker's rights procedure

The calling user must be granted the INHERIT PRIVILEGES object privilege on the user owner of the procedure

The calling user must grant the INHERIT PRIVILEGES object privilege on the user owner of the procedure

Answer: A,B Reference: http://docs

QUESTION NO: 89 Which parameter can be changed by explicitly re-creating the control file or by using the DBNEWID utility

instance_name Answer: A Reference: http://docs

QUESTION NO: 90 Several tables are accidentally deleted from a PDB

Which database would you immediately connect to, and as which user, to recover these tables

the CDB as the CDBADMIN user "Pass Any Exam

Any Time

Oracle 1z0-497 Exam C

the PDB as the PDB Admin user Answer: D'Explanation:

QUESTION NO: 91 Identify two solutions that Oracle provides for patch conflict

super patch Answer: A,C Explanation:

QUESTION NO: 92 You are in the middle of transaction, updating a table

The machine on which the database is running reboots because of a power outage

This causes a database instance failure

Which statement is true in this situation

The online redo log files and archived redo log files are required to accomplish a recovery

The uncommitted transaction is committed at the next startup of the database instance

The uncommitted transaction is rolled back automatically at the next opening of the database

The DBA has to perform a recovery on the database to recover the uncommitted transaction

Answer: C Explanation:

QUESTION NO: 93 Which three options best describe Patch Set Updates (PSUs) in Oracle Database 12c

"Pass Any Exam

Any Time

Oracle 1z0-497 Exam A

cumulative Answer: C,D,E Explanation:

QUESTION NO: 94 For which use case would you use a rolling upgrade with the Oracle Active Data Guard feature

when upgrading from Oracle Database 12c to the first patch set of Oracle Database 12c B

when upgrading from Oracle Database 10g to Oracle Database 12c C

when upgrading from Oracle Database 11g to Oracle Database 12c D

when upgrading from any previous version of Oracle Database to Oracle Database 12c Answer: A Explanation: You will be able to use this feature to perform database version upgrades starting with the first patchset of Oracle Database 12c (that is, you cannot use it to upgrade from any version earlier than the first Oracle Database 12c patchset)

This means that the manual Transient Logical Standby upgrade procedure must still be used when upgrading from Oracle Database 11g to Oracle Database12c, or when upgrading from the initial Oracle Database 12c release to the first patchset of Oracle Database 12c

Reference: Oracle Data Guard Concepts and Administration, 12c, Using DBMS_ROLLING to Perform a Rolling Upgrade

QUESTION NO: 95 Which two statements about multi section backup are true

It is available only for full backups

It supports incremental backups and image copies

Backup for each data file is divided into sections and is backed up in parallel

However, for image copies, sections are backed up sequentially

For image copies, sections are backed up in parallel and recomposed at the end

Any Time

Oracle 1z0-497 Exam Answer: B,D Explanation: B (Not A): Starting with Oracle Database 12c Release 1 (12

While the image copy is being created, multiple channels are used to write files sections

However, the output of this operation is one copy for each data file

Reference: Specifying Multisection Incremental Backups Making Multisection Backups Using Image Copies

QUESTION NO: 96 Which tablespace contains the data dictionary, being automatically created at database creation

USERS B

SYSAUX D

SYSTEM E

EXAMPLE Answer: D'Reference: http://docs

QUESTION NO: 97 Which three tasks can you perform in Database Express

View performance and status information about the database instance

Start up the database

Shut down the database

Create database structures

Manage users and security

Answer: A,D,E Explanation:

"Pass Any Exam

Any Time

Oracle 1z0-497 Exam

QUESTION NO: 98 Which two statements are true about the B-tree Index

The leaf blocks in the index are doubly linked

The leaf node stores a bitmap for each key value

Rows with a NULL value in key columns also have entries in the Index

The deletion of a row from the table causes a logical deletion in the index leaf block and the space becomes available for a new leaf entry

Answer: A,B Reference: http://www

edu/~dbock/cmis565/module12-indexes

QUESTION NO: 99 Which two statements are true about listeners

Listeners use only the TCP/IP protocol

Multiple listener processes can run simultaneously on a host

Multiple database instances can be registered with a single listener, D

Listener-related errors can be traced only at the administrative level

Only one database instance can be registered with a single listener at any time

Answer: B,C Explanation: B: A network may contain multiple local and remote listeners

E: Oracle Net Listener is a separate process that runs on the database server

It receives incoming client connection requests and manages the traffic of these requests to the database server

Incorrect: Not A: Because the configuration parameters have default values, it is possible to start and use a listener with no configuration

This default listener has a name of LISTENER, supports no services on startup, and listens on the following TCP/IP protocol address: (ADDRESS=(PROTOCOL=tcp)(HOST=host_name)(PORT=1521))

"Pass Any Exam

Any Time

Oracle 1z0-497 Exam

QUESTION NO: 100 You want to start a global service on your database

Which three conditions must be met

The database is open and registered with a global service manager

The service has been disabled on that database

The database role is different from the role attribute of the service

The replication lag on the database does not exceed the maximum value specified for the service

The service has reached its cardinality defined by the number of preferred databases

No other database in the pool is a better candidate for starting the service

Answer: A,B,F Explanation: To provide global services, a database must be added to a Global Data Services pool

The valid node checking for registration (VNCR) feature provides the ability to configure and dynamically update a set of IP addresses, host names, or subnets from which registration requests are allowed by the global service manager

Database instance registration with a global service manager succeeds only when the request originates from a valid node

GDSCTL>start service

QUESTION NO: 101 What must you do to an application for it to take advantage of partitioning

Any Time

Oracle 1z0-497 Exam B

rework the applications schema E

it is transparent Answer: E Reference: http://docs

QUESTION NO: 102 Which three statements about common and local roles are true

When a role is granted to a user, the privileges in the role are limited to the context of the PDB

Local roles can be granted only to local users

Common roles can be granted to both local and common users

A user can create common roles if the user has the CREATE ROLE privilege, and SET CONTAINER for all PDBs E

Common roles can be created in the root and PDBs

Answer: A,C,D Explanation:

QUESTION NO: 103 Which statement regarding Oracle Active Data Guard 12c is false

Any application compatible with a read-only database can run on an Oracle Active Data Guard standby

It provides new support for DML to global temporary tables and the use of sequences in the standby database

It repairs block corruptions detected in the primary or standby database

It supports different software patch levels between a primary database and its physical standby database for the purpose of applying and validating Oracle patches in a rolling fashion

It supports multi master and bidirectional replication architectures where there are multiple databases that all contain the same data, even if they are not synchronized

Answer: E Explanation:

"Pass Any Exam

Any Time

Oracle 1z0-497 Exam QUESTION NO: 104 Examine the command: sqlplus /nolog In which scenario would this command execute successfully

only from the server, if the database instance is not up B

from either a client or server, even if the database instance is not up C

from either a client or server, only if the database instance is up, and the command connects the session to the instance D

from either a client or server, only if the database instance is up, but the command does not connect the session to the instance Answer: B Explanation:

QUESTION NO: 105 John is a CDB administrator, and Mike and Tim are PDB administrators of their respective databases- John takes a complete CDB backup by using RMAN>Backup Database

Mike and Tim may need point-in-time recovery of their PDBs

Which statement is true

Recovery of individual PDBs is not possible, because John did not back up by using RMAN>Backup Pluggable database pdb1 pdb2

However, complete CDB recovery is still possible

Mike and Tim need to individually take backups of their respective PDBs, because CDB-level backup does not include PDB data dictionary objects

Mike and Tim do not need to worry, because recovery of individual PDBs is possible

Recovery of individual PDBs is not possible at all

Answer: A Explanation:

QUESTION NO: 106 In this SQL statement, what is the partitioning criteria

? CREATE TABLE books_part PARTITION BY RANGE (cell_id) ( "Pass Any Exam

Any Time

Oracle 1z0-497 Exam PARTITION p0l VALUES LESS THAN (2), PARTITION p02 VALUES LESS THAN (3) ,

PARTITION pl4 VALUES LESS THAN (15), PARTITION pl5 VALUES LESS THAN (16), PARTITION pl6 VALUES LESS THAN (MAXVALUE) ) AS SELECT * FROM books

MAXVALUE D

There is no partitioning criteria

Answer: D'Explanation:

QUESTION NO: 107 Which four statements about users in Oracle Database 12c are correct

A common user cannot have the same name as any local user across all PDBs

A common user can be created only in the root container

A local user with the proper privileges can also create a common user

If a PDB is closed, the common and local users of the PDB are not visible

A common user with the proper privileges can create a common user by using the CONTAINER=CURRENT clause

A common user is one that has the same username and authentication credentials across multiple PDBs

Answer: A,B,D,F Explanation:

QUESTION NO: 108

"Pass Any Exam

Any Time

Oracle 1z0-497 Exam Which three DBA operations can be performed by using Oracle SQL Developer

database backup and recovery using RMAN B

performance tuning operations such as generation of AWR, ADDM, and ASH reports C

storage configuration for archive logs and control files D

storage configuration for data files and redo log groups E

database status view and Data Pump export and import jobs Answer: A,B,D Explanation: 1

Reference: Using DBA Features in SQL Developer URL: http://docs

QUESTION NO: 109 Consider an application in which memory required for each session is 400 KB and memory required for each server process is 4 MB

The pool size is 100 and the number of shared servers used is 100

If there are 5000 client connections, what is the amount of memory used by a dedicated server

615 MB B

12 GB E

QUESTION NO: 110 "Pass Any Exam

Any Time

Oracle 1z0-497 Exam When executing shutdown abort in a pluggable database (PDB), you ____________