Oracle Database 12c Essentials Set 1

Question - 15 Maximum mark : - 28

Home
All Exams
Oracle Database 12c Essentials Online Mock Tests
Oracle Database 12c Essentials Set 1

Which two statements represent where Oracle Net must reside?

Only on the client for traditional client/server applications Only on the database server for web-based applications On both the web server and database server for web-based applications On both the client and database server for traditional client/server applications.

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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, b, c, d, e, f ✘ b, c, a, d, e, f ✘ c, b, a, d, f, e ✘ a, b, c, d ✔ b, c, a, d ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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 & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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 salesprdOPEN 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 developmentCDB, 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 salesprd@prd; Connected as the salesprd local DBA, you create an XML using:SQL> ALTER PLUGGABLE DATABASE salespdb UNPLUG INTO ' /tmp/salesprd-xml' ;Copythe 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';

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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 & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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.

b, c, d ✘ a, c, d, b ✘ a, d, b, c ✘ c, d, b ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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 & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Your customer wants all email addresses from the database displayed as [hidden]@company.com. What method of data redaction must you use?

full redaction ✘ partial redaction ✘ regular expressions ✘ random redaction ✔ no redaction ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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?

Uni-directional for 1Peer-to-peer for 2Bi-directional for 3Consolidation for 4 ✘ Peer-to-peer for 1Broadcast for 2Bi-directional for 3Consolidation for 4 ✘ Uni-directional for 1Broadcast for 2Bi-directional for 3Consolidation for 4 ✘ Peer-to-peer for 1Consolidation for 2Broadcast for 3Cascading for 4 ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

You execute some DMLcommands, followed by a COMMIT Statement.
Which option correctly describes how the logwriter (LGWR) process takes part in the transaction commit?

1. LGWR writes the commit record to disk.2. LGWR writes all redo entries from Redo Log Buffer to disk. ✘ 1. GWR writes only the transaction's redo entries from Redo Log Buffer to disk.2. LGWR writes the commit record to disk. ✘ 1. LGWR puts the commit record to Redo Log Buffer.2. IGWR writes all redo entries from Redo Log Buffer to disk. ✘ 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 allredo log entries from Redo Log Buffer to disk. ✔ 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 redoentries from Redo Log Buffer to disk. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Prev Next

Congratulations

you have successfully completed the test

Back to Question View Result

Detail Form

We will send your result on your email id and phone no. please fill detail

Name

Email ID Note: Report will be send to the above Email ID

Phone No

Oracle Database 12c Essentials Set 1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner