Oracle 1Z0-497 Certification Material Provider,High Pass Rate Oracle 1Z0-497 Exam Questions With Low Price

Now,Flydumps has publised the new version of Oracle 1Z0-497 exam dumps with new added exam questions.Also the latest Oracle 1Z0-497 PDF and VCE dumps with VCE test engine for free download,and the new Oracle 1Z0-497 practice tests ensure your exam 100% pass.Visit www.Flydumps.com to get more exam dumps!

QUESTION 35

Which two statements about this policy are true?
A. It replaces the first four digits of the value from the SALARY column with the number 9.
B. It replaces the first digit of the value from the SALARY column with the number 4.
C. It replaces the first digit of the value from the COMMISSION_PCTcolumn with 9.
D. It replaces the first nine digits of the value from the COMMISSION_PCTcolumn with 1.
E. It uses the full data redaction method.
F. It uses the random redaction method.

Correct Answer: DF Explanation
Explanation/Reference:
QUESTION 36
Which option represents a function of Global Data Services (GDS)?
A. performs data replication
B. performs database failovers
C. replaces the functionality of Oracle Clusterware and Oracle RAC
D. coordinates site failovers
E. works seamlessly with Oracle Site Guard

Correct Answer: AB Explanation
Explanation/Reference:
QUESTION 37
Which two statements represent where Oracle Net must reside?
A. 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.

Correct Answer: BD Explanation
Explanation/Reference:
QUESTION 38
When you start up a CDB, which operations are performed automatically and in what order?

a – The instance is started.
b – Control files are opened.
c – The root container is opened (redo logs and root data files).
d – Seed pluggable database is in READ ONLY mode.
e – Other PDBs are still in MOUNTED mode.
f – Triggers may fire if they exist to open other PDBs.

A. a, b, c, d, e, f
B. b, c, a, d, e, f
C. c, b, a, d, f, e
D. a, b, c, d
E. b, c, a, d

Correct Answer: D Explanation
Explanation/Reference:
QUESTION 39
Which new process was introduced as of Oracle Database 12c?
A. Result Cache Background process (RCBG)
B. AQ Coordinator process (QMNC)
C. Change Tracking Writer process (CTWR)
D. Listener Registration process (LREG)
Correct Answer: D Explanation

Explanation/Reference:
Reference: http://musingdba.wordpress.com/2013/07/05/new-in-oracle-database-12c-a/
QUESTION 40

Which two statements are true about this common user?
A. SQL> conn c##usr/[email protected] You are connected to PDB1 successfully.
B. SQL> conn c##usr/[email protected] You are connected to PDB2 successfully.
C. 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;
D. 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.

Correct Answer: AD Explanation
Explanation/Reference:
QUESTION 41
Which two statements are true regarding undo data records?
A. They are required to support Flashback features.
B. They are not required if Flashback features are enabled.
C. They are retained until the session making the changes ends.
D. Undo records contain copies of data as it appears after a change is made.
E. Undo records contain copies of data as it appears before a change is made.
Correct Answer: AE Explanation

Explanation/Reference:
Reference: http://docs.oracle.com/cd/E11882_01/server.112/e25494/undo.htm#ADMIN11463
QUESTION 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?
A. 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;
B. 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;
C. 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];
D. 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.xml’;

Correct Answer: AD Explanation
Explanation/Reference:
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 XML file that describes the PDB must exist in a location that is accessible to the CDB.
The USING clause must specify the XML file.
Etc

QUESTION 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?
A. Nothing else happens.
B. The database is mounted but not opened.
C. The database is mounted and finally opened.
D. The database is opened and finally mounted.

Correct Answer: C Explanation
Explanation/Reference:
Reference: http://docs.oracle.com/cd/E17781_01/server.112/e18804/startup.htm
QUESTION 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?

a – Shut down the database.
b – Restart the database.
c – Copy an existing control file to a new location by using operating system commands. d – Edit the
CONTROL_FILESparameter in the database initialization parameter file to add the new control file name,
or to change the existingcontrol file name.

A. b, c, d
B. a, c, d, b
C. a, d, b, c
D. c, d, b

Correct Answer: B Explanation
Explanation/Reference:
Reference: http://docs.oracle.com/cd/E16655_01/server.121/e17636/control.htm#ADMIN11287
QUESTION 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?
A. They can perform only queries.
B. They are not affected and continue to function normally.
C. They are terminated and the active transactions are rolled back.
D. They are not allowed to perform any operations till the listener is started.

Correct Answer: D Explanation
Explanation/Reference:
Note: 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.
QUESTION 46
Your customer wants all email addresses from the database displayed as [hidden]@company.com. What method of data redaction must you use?
A. full redaction
B. partial redaction
C. regular expressions
D. random redaction
E. no redaction

Correct Answer: B Explanation
Explanation/Reference:
QUESTION 47
Your customer is looking for a solution that meets these four needs:
1 – Replicate data from source to target for reporting purposes. 2 -Replicate data from one source to multiple targets. 3 – Replicate data between two databases for instant failover. 4 – Replicate data from multiple sources to a single target for a data warehouse.
Which GoldenGate-supported topology would you recommended?
A. 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

Correct Answer: C Explanation
Explanation/Reference:
QUESTION 48
You execute some DMLcommands, followed by a COMMIT Statement. Which option correctly describes how the logwriter (LGWR) process takes part in the transaction commit?
A. 1. LGWR writes the commit record to disk.
2. LGWR writes all redo entries from Redo Log Buffer to disk.
B. 1. GWR writes only the transaction’s redo entries from Redo Log Buffer to disk.
2. LGWR writes the commit record to disk.
C. 1. LGWR puts the commit record to Redo Log Buffer.
2. IGWR writes all redo entries from Redo Log Buffer to disk.
D. 1. LGWR puts the commit record to Redo Log Buffer.
2.
If the activity is high, LGWR waits three seconds for other transactions to commit.

3.
LGWR writes all redo log entries from Redo Log Buffer to disk.
E. 1. LGWR puts the commit record to Redo Log Buffer.
2.
LGWR signals the database writer (DBW) process to write dirty blocks to disk.

3.
LGWR writes all redo entries from Redo Log Buffer to disk.

Correct Answer: C Explanation
Explanation/Reference:
QUESTION 49
Which two statements about PDBs and CDBs are true?
A. There is only one SYSTEM tablespace per CDB.
B. There is only one instance per PDB.
C. There is a set of redo log files per PDB.
D. There is only one UNDO tablespace per CDB.
E. There is one SYSAUXtablespace per PDB.
Correct Answer: DE Explanation

Explanation/Reference:
QUESTION 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?
A. You have to copy the seed data files yourself,

The Oracle 1Z0-497 training is a vital way of becoming the best.This Oracle 1Z0-497 certification has helped the candidates to enhance their capabilities by providing a great learning platform to them so that they can polish their skills.