Summer Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exc65

examout.co

Which two statements about Global Data Services (GDS) are correct?

A.

GDS allows scaling replication-aware application workloads beyond the cluster (that is, across replicated clusters).

B.

GDS helps in performing data replication.

C.

GDS works seamlessly with any combination of Oracle RAC databases, single-instance databases, Oracle Data Guard, Oracle Active Data Guard, and Oracle Golden Gate.

D.

GDS helps to perform database failovers, and does not require Data Guard Broker.

E.

The GDSMGRL utility is a command-line interface for configuring and managing the Global Data Services framework.

Which two statements are true about transactions in Oracle Database 12c?

A.

Multiple transactions can use the same undo segment.

B.

A transaction is assigned an undo segment when it is started.

C.

Multiple transactions cannot share the same extent in an undo tablespace.

D.

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

Identify three outcomes of using the Oracle Multitenant option in Oracle Database 12c.

A.

less instance overhead

B.

increased storage cost

C.

minor application changes

D.

fast and easy provisioning

E.

same time needed for patching and upgrade as in the previous release

F.

isolation

Which statement about the Oracle Advanced Security Data Redaction feature is true?

A.

It transparently encrypts data at rest in Oracle databases.

B.

It securely manages encryption keys.

C.

It protects against theft or loss of disks and backups.

D.

It prevents OS users from inspecting tablespace files.

E.

It limits the exposure of sensitive data in applications.

F.

It alters data in caches, buffers, and persistent storage.

G.

It impacts operational activities such as backup & restore, upgrade & patch, and replication.

All database users are currently connected to the database instance and are working. The HR user opens three database sessions and executes this command in one of the sessions:

SQL> UPDATE persons SET ccode='U031' WHERE ccode='U029';

123 rows updated.

SQL> DELETE FROM persons WHERE exp='Y';

3 rows deleted.

The SYS user opens a new session after HR executes the preceding commands. Which option represents the sessions that can see the effect of the UPDATE and DELETE commands?

A.

all sessions of the HR user

B.

all sessions of the HR user and the SYS user

C.

the session of the HR user that executed the commands

D.

all sessions for which database users have access privileges to the PERSONS table

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?

A.

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

B.

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

C.

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

D.

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

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.

Which four statements about users in Oracle Database 12c are correct?

A.

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

B.

A common user can be created only in the root container.

C.

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

D.

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

E.

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

F.

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

Which parameter can be changed by explicitly re-creating the control file or by using the DBNEWID utility?

A.

db_name

B.

maxdatafiles

C.

control_files

D.

instance_name

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,

B.

You can use the new SEED FILE_NAME_CONVERTclause in the CREATE DATABASE statement.

C.

The seed pluggable database is not required.

D.

The seed pluggable database does not require data files.

E.

The seed pluggable database is always kept in READ ONLY mode.

F.

The seed pluggable database is not a container.

G.

The seed pluggable database can be dropped.