New Year Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70special

Examstrust Logo
examstrust mcafee
  1. Home
  2. Oracle
  3. Oracle Database 12c Certified Implementation Specialist
  4. 1z0-497 - Oracle Database 12c Essentials

Oracle 1z0-497 Oracle Database 12c Essentials Exam Practice Test

Page: 1 / 15
Total 150 questions
Get 1z0-497 Full Access Download 1z0-497 PDF

Oracle Database 12c Essentials Questions and Answers

Testing Engine

  • Product Type: Testing Engine
$37.5  $124.99
Add to Cart

PDF + Testing Engine

  • Product Type: PDF + Testing Engine
$52.5  $174.99
Add to Cart

PDF Study Guide

  • Product Type: PDF Study Guide
$33  $109.99
Add to Cart
Question 1

Identify two solutions that Oracle provides for patch conflict.

Options:

A.

merge patch

B.

combine patch

C.

overlay patch

D.

dual patch

E.

super patch

Question 2

Identify three types of important statistics collection that you can disable in Oracle Database 12c by setting the STATISTIS_LEVEL parameter to BASIC.

Options:

A.

Oracle Database alert.log file

B.

object-level statistics

C.

Automatic SGA Memory Management

D.

Oracle Database Trace files

E.

all server-generated alerts

Question 3

Which database feature can be used for organizing data when there is a very large amount of data?

Options:

A.

Index

B.

Partitioning

C.

Triggers

D.

Row-level security

E.

Database vault

Question 4

Which two statements are true about listeners?

Options:

A.

Listeners use only the TCP/IP protocol.

B.

Multiple listener processes can run simultaneously on a host.

C.

Multiple database instances can be registered with a single listener,

D.

Listener-related errors can be traced only at the administrative level.

E.

Only one database instance can be registered with a single listener at any time.

Question 5

What new role in Oracle Database 12c encompasses the administrative privileges required for backup and recovery?

Options:

A.

SYSBKP

B.

SYSBKPRMAN

C.

SYSRMAN

D.

SYSBACKUP

Question 6

Which statement is true regarding this connect string?

(DESCRIPTION

(FAILOVER=on)

(ADDRESS_LIST=

(LOAD_BALANCE=ON)

(ADDRESS=(host=sales-east1) (port=1522) )

(ADDRESS=(host=sales-east2)(port=1522))

(ADDRESS=(host=sales-east3) (port=1522) ))

(ADDRESS_LIST=

(LOAD_BALANCE=ON)

(ADDRESS=(host=sales-west1) (port=1522) )

(ADDRESS=(host=sales-west2) (port=JS22))

(ADDRESS=(host=sales-west3) (port=lS22) ) )

(CONNECT_DATA=

(SERVICE_NAME=sales)

(REGION=east)))

Options:

A.

It contains three global service managers in the client's local region (east).

B.

Client-side load balancing has been enabled only for the global service managers within the client's buddy (west).

C.

Connect-time failover between regions has not been enabled.

D.

The REGION parameter is optional.

Question 7

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?

Options:

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.

Question 8

YOU want to move all objects of the CONSULTANT user from the test database to theDB-USER schema of the production database. Which option of IMPDP would you use to accomplish this task?

Options:

A.

FULL

B.

SCHEMAS

C.

TRANSFORM

D.

REMAP_SCHEMA

E.

REMAP_TABLESPACE

Question 9

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

Options:

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

Question 10

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?

Options:

A.

Oracle Data Guard

B.

Oracle Streams

C.

Oracle Real Application Clusters

D.

Oracle GoldenGate

Question 11

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

Options:

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.

Question 12

Examine the command:

SQL> CREATE TABLE orders(oid NUMBER (6) PRIMARY KEY, odato DATE, ccode NUMBER (6), oamt NUMBER (10, 2)) TABLESPACE users ;

Which two statements are true about the execution of the command?

Options:

A.

A CHECK constraint is created on the OID column.

B.

A NOT NULL constraint is created on the OID column.

C.

The ORDERS table is the only object created in the USERS tablespace.

D.

The ORDERS table and a unique index are created in the USERS tablespace.

E.

The ORDERS table is created in the USERS tablespace and a unique index is created on the OID column in the SYSTEM tablespace.

Question 13

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?

Options:

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

Question 14

Examine the command:

sqlplus /nolog

In which scenario would this command execute successfully?

Options:

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

Question 15

Which statement about Oracle patches is false?

Options:

A.

Interim patches, also known as "one-off" patches, are created to provide a specific fix between the releases of patch sets.

B.

Security Patch Update (SPU) is the primary means of releasing security fixes for Oracle products. SPUs are cumulative with respect to prior SPUs and generally contain only security fixes.

C.

Patch Set Update (PSU) is a collection of proactive, stabilizing, cumulative patches for a particular product version (base release or patch set). PSUs are cumulative and include all the security fixes from CPU patches, plus additional fixes.

D.

Patch Set is the main way in which Oracle provides bug fixes in between releases. Oracle bundles a number of fixes, tests them thoroughly together, and packages, then together for easy download and installation.

E.

Terminal Patch Set is an unsupported patch set by Oracle Lifetime Support policies.

Question 16

Which two statements about multitenant architecture are true?

Options:

A.

Multiple PDBs on a single server need multiple database instances and multiple sets of database files.

B.

Although consolidated into a single physical database, PDBs mimic the behavior of non-CDBs.

C.

A PDB administrator can use Oracle Flashback or point-in-time recovery to retrieve lost data from a PDB, only by shutting down all the PDBs from the CDB.

D.

It is easier to collect performance metrics for many databases in a CDB than individual non-CDB databases.

E.

It takes more time to apply a patch to one CDB that holds hundreds of PDBs than to hundreds of non-CDB databases.

Question 17

Your customer is looking for zero-data-loss failover with maximum data protection and high availability for their primary database. Which two solutions would you recommend to the customer if the distance between the primary and the standby location is more than 300 miles?

Options:

A.

Asynchronous redo transport with Data Guard

B.

Synchronous redo transport with Data Guard

C.

Active Data Guard Far Sync

D.

Data Guard SQL Apply

Question 18

Which two statements represent where Oracle Net must reside?

Options:

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.

Question 19

An Oracle instance is a combination of______.

Options:

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

Question 20

Which two statements about Automatic Data Optimization (ADO) are true?

Options:

A.

ADO policies can automatically compress data when it qualifies.

B.

ADO policies can automatically move segments when necessary.

C.

ADO is not dependent on Heat Map, and works even if Heat Map is disabled.

D.

You cannot compress at block level, but you can compress at segment level.

E.

You can compress at row level only for QUERY LOW.

Question 21

Which three tasks can you perform in Database Express?

Options:

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.

Question 22

Exhibit below:

Which three statements are true about terminating a session?

Options:

A.

Without any error, you can terminate the active session by executing:

SQL> ALTER SYSTEM KILL SESSION '7, 15';

B.

You can terminate the active session by executing:

SQL> ALTER SYSTEM KILL SESSION "7, 15';

But you also get the error message:

ORA-00028: your session has been killed

C.

You cannot terminate the active session. You have to wait until that session becomes inactive.

D.

Without any error, you can terminate the inactive session by executing:

SQL> ALTER SYSTEM KILL SESSION '12, 63';

E.

When an inactive session is killed, the status of that session remains visible in VSSESSION with status KILLED. The rowf the terminated session is removed from VSSESSION after the user attempts to use the session again.

F.

You cannot terminate the inactive session. You have to wait until that session becomes active again.

Load More 1z0-497 Questions
Page: 1 / 15
Total 150 questions
Get 1z0-497 Full Access Download 1z0-497 PDF