Labour Day Special - 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: c4sdisc65

1z0-497 PDF

$38.5

$109.99

3 Months Free Update

Add to Cart
  • Printable Format
  • Value of Money
  • 100% Pass Assurance
  • Verified Answers
  • Researched by Industry Experts
  • Based on Real Exams Scenarios
  • 100% Real Questions

1z0-497 PDF + Testing Engine

$61.6

$175.99

3 Months Free Update

Add to Cart
  • Exam Name: Oracle Database 12c Essentials
  • Last Update: Apr 28, 2024
  • Questions and Answers: 150
  • Free Real Questions Demo
  • Recommended by Industry Experts
  • Best Economical Package
  • Immediate Access

1z0-497 Engine

$46.2

$131.99

3 Months Free Update

Add to Cart
  • Best Testing Engine
  • One Click installation
  • Recommended by Teachers
  • Easy to use
  • 3 Modes of Learning
  • State of Art Technology
  • 100% Real Questions included

1z0-497 Practice Exam Questions with Answers Oracle Database 12c Essentials Certification

Question # 6

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

Full Access
Question # 7

Which two statements about switchover and failover are true?

A.

A snapshot standby can be the target of a switchover or fast-start failover operation.

B.

Neither a switchover nor a failover is possible to a far sync instance.

C.

For fast-start failover, you must preselect the target standby database that will be used.

D.

You can activate a standby database to test whether it is being updated correctly.

Full Access
Question # 8

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

Full Access
Question # 9

Your database instance is down because there was a user-initiated shutdown. Which option represents the actions performed, in the correct order, if you start up the instance?

a - The control file is read.

b - Memory is allocated.

c - Background processes pre started.

d -The initialization parameter file is read,

e- Redo log files and data files are opened.

A.

b, c, a

B.

d, a, e

C.

a, e, d, b

D.

d, b, c, a, e

E.

c, b, d, a, e

Full Access
Question # 10

Examine the command:

sqlplus /nolog

In which scenario would this command execute successfully?

A.

only from the server, if the database instance is not up

B.

from either a client or server, even if the database instance is not up

C.

from either a client or server, only if the database instance is up, and the command connects the session to the instance

D.

from either a client or server, only if the database instance is up, but the command does not connect the session to the instance

Full Access
Question # 11

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

Full Access
Question # 12

Which statement regarding Oracle Active Data Guard 12c is false?

A.

Any application compatible with a read-only database can run on an Oracle Active Data Guard standby.

B.

It provides new support for DML to global temporary tables and the use of sequences in the standby database.

C.

It repairs block corruptions detected in the primary or standby database.

D.

It supports different software patch levels between a primary database and its physical standby database for the purpose of applying and validating Oracle patches in a rolling fashion.

E.

It supports multi master and bidirectional replication architectures where there are multiple databases that all contain the same data, even if they are not synchronized.

Full Access
Question # 13

You want to start a global service on your database. Which three conditions must be met?

A.

The database is open and registered with a global service manager.

B.

The service has been disabled on that database.

C.

The database role is different from the role attribute of the service.

D.

The replication lag on the database does not exceed the maximum value specified for the service.

E.

The service has reached its cardinality defined by the number of preferred databases.

F.

No other database in the pool is a better candidate for starting the service.

Full Access
Question # 14

In which situation would you use static database registration for a listener?

A.

when multiple databases are to be registered with the listener

B.

when DBAs need to connect remotely to start up the database instance

C.

when users need to connect the database instance by using the host naming method

D.

when the database instance to be registered with the listener is configured in shared server mode

Full Access
Question # 15

An Oracle instance is a combination of______.

A.

database files and parameter file (initialization parameter file or server parameter file)

B.

System Global Area (SGA) and background processes

C.

a listener process, server processes, and background processes

D.

System Global Area (SGA), server processes, and background processes

E.

database files, System Global Area (SGA), and background processes

Full Access
Question # 16

You are about to apply a patch to a database. Which recommended action is incorrect?

A.

You should check the patch conflict with installed patches before applying the patch.

B.

You should make sure that you have a good backup of the software, database, and configuration files.

C.

You should install the latest O patch before applying the patch.

D.

You should check the fifth digit of the release information to confirm that the Patch Set Update (PSU) is applied successfully.

E.

You should stop all applications running from the software directory that is being patched.

Full Access
Question # 17

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

Full Access
Question # 18

You execute the following command:

SQL> ALTER USER skd ACCOUNT LOCK;

Which two statements are correct?

A.

The SKD user cannot log in to the database instance.

B.

The objects owned by the SKD user are not accessible to any user.

C.

Other users can access objects owned by the SKD user, to which they have access.

D.

The SKD user's password expires and the user is forced to change the password at the next login.

Full Access
Question # 19

You create a CDB with four containers: the loot, the seed, and two pluggable databases PDB1 and PDB2. Which four items can reside In PDB1, but not in the root?

A.

shared UNDO and default database temporary tablespace

B.

Oracle-supplied metadata

C.

shared Oracle-supplied data

D.

CDB views providing information across PDBs

E.

application tablespaces

F.

local temporary tablespaces

G.

local users and local roles

Full Access
Question # 20

Identify the correct order of consolidation density.

A.

multitenant< schema consolidation< dedicated database< VMs

B.

schema consolidation< VMs< dedicated databases< multitenant

C.

dedicated databases< VMs< schema consolidation< multitenant

D.

VMs< dedicated databases< schema consolidation< multitenant

Full Access
Question # 21

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.

Full Access
Question # 22

Examine the error:

GSM-45054: GSM error or NET-40006: unable to start GSH

What is the cause of this error, and what troubleshooting steps should you perform?

A.

The GDS catalog database of its listener may be down. Verify that the GDS catalog database and its local listener are running.

B.

The GDS pool database may be down. Make sure that the GDS pool databases are up and the service is enabled and started.

C.

The GDS pool database's local listener may be down. Make sure that it is running.

D.

The global service may be down. Verify that the pool databases are up and the service is started.

E.

The global service may be disabled. Make sure that the pool databases are up and the service is enabled and started.

Full Access