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

Oracle 1z0-497 - Oracle Database 12c Essentials

Oracle 1z0-497 Premium Access     Download Demo    
Page: 2 / 5
Total 150 questions

In Oracle Database 12c, when does a transaction begin?

A.

when a transaction ID is allocated for it.

B.

when a user explicitly issues a "begin" statement

C.

when a transaction is assigned to an available undo data segment to record undo entries for the new transaction

D.

when the first executable SQL statement is encountered

Consider 10 scenarios that result in database downtime. Which five of them are considered as planned downtime?

A.

addition or removal of nodes, memory, or disks

B.

changing configuration parameters, upgrading, or patching Oracle software

C.

file deletion

D.

migrating to cluster architecture

E.

dropped database object

F.

table definition changes

G.

runaway processes that consume system resources

What happens when you execute these SQL statements?

ALTER SYSTEM SET SGA_TARGET = 992M;

ALTER SYSTEM SET SHARED_POOL_SIZE = 0;

ALTER SYSTEM SET LARGE_POOL_SIZE = 0;

ALTER SYSTEM SET JAVA_POOL_SIZE = 0;

ALTER SYSTEM SET DB_CACHE_SIZE = 0;

ALTER SYSTEM SET STREAMS POOL SIZE = 0;

A.

The database stops (shutdown abort).

B.

B) The database Stops (shutdown immediate).

C.

You activate Automatic Shared Memory Management.

D.

You get an error message.

Which three DBA operations can be performed by using Oracle SQL Developer?

A.

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

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

For which database operation do you need the database to be in MOUNT state?

A.

renaming the control files

B.

re-creating the control files

C.

dropping a user in your database

D.

dropping a tablespace in your database

E.

configuring the database instance to operate in ARCHIVELOG or NOARCHIVELOG mode

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 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).

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?

A.

Oracle Data Guard

B.

Oracle Streams

C.

Oracle Real Application Clusters

D.

Oracle GoldenGate

Which two statements are true regarding SQL*Plus?

A.

It has commands for performing database administration operations.

B.

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

C.

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

D.

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