Weekend Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

examout.co

Which two statements about Database Express are true?

A.

It uses internal infrastructure components, such as XDB and SQL*Net.

B.

It can perform actions outside the database.

C.

It has background tasks and processes that periodically collect information via FTP.

D.

It has two new features: Performance Hub and Composite Active Reports.

E.

It is not supported on Standard Edition (SE) and Express Edition (XE).

Which tablespace contains the data dictionary, being automatically created at database creation?

A.

USERS

B.

TEMP

C.

SYSAUX

D.

SYSTEM

E.

EXAMPLE

For which use case would you use a rolling upgrade with the Oracle Active Data Guard feature?

A.

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

What must you do to an application for it to take advantage of partitioning?

A.

recompile it

B.

rewrite its SQL queries

C.

relink

D.

rework the applications schema

E.

nothing; it is transparent

Which three tasks can you perform in Database Express?

A.

View performance and status information about the database instance.

B.

Start up the database.

C.

Shut down the database.

D.

Create database structures.

E.

Manage users and security.

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?

A.

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

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?

A.

Active Data Guard

B.

Oracle GoldenGate

C.

Oracle Real Application Clusters

D.

Oracle Transportable Tablespaces

E.

Oracle Cloud Platform as a Service

Which is the default isolation level in Oracle Database 12c?

A.

serializable

B.

read-only

C.

read committed

D.

read uncommitted

Which type of information is included in dynamic performance views?

1 - System and session parameters

2 - Memory usage and allocation

3 - File states (including RMAN backup files)

4 - Progress of jobs and tasks

5 - SQL execution

6 - Statistics and metrics

A.

3, 4, and 5

B.

1, 2, 5, and 6

C.

1, 2, 3, and 4

D.

2, 3, 5, and 6

E.

2, 3, 4, 5, and 6

F.

1, 2, 3, 4, 5, and 6

Which three operations can the PUBLIC user with the SYSOPER privilege perform?

A.

STARTUP

B.

SHUTDOWN

C.

CREATE DATABASE

D.

DROP DATABASE

E.

ALTER DATABASE RECOVER