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

Activedumpsnet Logo
  1. Home
  2. Oracle
  3. Oracle Database 12c Certified Implementation Specialist
  4. 1z0-497
  5. 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

Question 1

Which new process was introduced as of Oracle Database 12c?

Options:

A.

Result Cache Background process (RCBG)

B.

AQ Coordinator process (QMNC)

C.

Change Tracking Writer process (CTWR)

D.

Listener Registration process (LREG)

Question 2

Which two are client-side components of Oracle Data Guard Broker?

Options:

A.

Oracle Enterprise Manager Cloud Control

B.

Oracle Data Guard monitor

C.

Oracle Data Guard command-line interface (DGMGRL)

D.

Oracle Data Guard Broker Manager

Question 3

Which four items exist in the root of a CDB, but not in the PDBs?

Options:

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

Question 4

Which statement about the Queryable Patch inventory feature is false?

Options:

A.

It is used to retrieve installed patch information from a SQL prompt.

B.

It uses the PREPROCESSOR feature, which allows users to preprocess input data before it is sent to the access drivers.

C.

DBMS_QOPATCH provides a PL/SQL or SQL interface to view the database patches installed.

D.

It works in an Oracle database instance that is mounted. Therefore, it works in ASM instances and DG instances.

Question 5

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?

Options:

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.

Question 6

You execute the following command:

SQL> ALTER USER skd ACCOUNT LOCK;

Which two statements are correct?

Options:

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.

Question 7

You have two database servers EMP and EXP. A user of the database from the EXP server wants to extract some information from the database in the EMP server for cross-verification. Which schema object enables the user to access the information from the remote database?

Options:

A.

cluster

B.

database link

C.

mapping table

D.

materialized view

Question 8

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 9

Which statement about Online Move Data file is true?

Options:

A.

Moving a data file online prevents DML operations on segments stored in the data file.

B.

Flashing back a database to a point in time before a data file had been renamed online retains the new name.

C.

Moving a data file online can be performed if the data file is in OFFLINE mode.

D.

Moving a data file online cannot be performed if the data file is under BEGIN BACKUP.

Question 10

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 11

Which two statements about multi section backup are true?

Options:

A.

It is available only for full backups.

B.

It supports incremental backups and image copies.

C.

Backup for each data file is divided into sections and is backed up in parallel. However, for image copies, sections are backed up sequentially.

D.

For image copies, sections are backed up in parallel and recomposed at the end.

Question 12

Which two statements about multitenant architecture are true?

Options:

A.

It ensures full backward compatibility with non-CDBs.

B.

It fully operates with RAC.

C.

It is integrated with Enterprise Manager, but not with the Resource Manager.

D.

It allows central management and administration of single databases.

Question 13

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 14

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;

Options:

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.

Question 15

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

Options:

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

Question 16

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.

Options:

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

Question 17

Identify the correct order of consolidation density.

Options:

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

Question 18

You connect to a database instance and execute a DML command that changes one data block. The block is read from the buffer cache, modified, and modified, and marked as dirty. You commit the transaction. What must take place before the block can be written to disk?

Options:

A.

The buffer must be written to flash cache.

B.

A log writer (LGWR) must write all redo entries that have been copied into the buffer since the last time it wrote.

C.

The modified data block must be moved from the LRU list to the write queue.

D.

The database must advance the checkpoint.

Question 19

Which normalization level is adopted in real-world database systems?

Options:

A.

1NF

B.

2NF

C.

3NF

D.

BCNF

Question 20

Which three events signal a database writer (DWR) to write buffers to disk?

Options:

A.

The database advances a checkpoint.

B.

A client process commits a transaction.

C.

The redo log buffer becomes full.

D.

A server process cannot find non-dirty blocks after scanning a threshold number of buffers.

E.

A tablespace is changed to read-only status.

F.

The database is shut down in immediate mode.

Question 21

Which tool is recommended for moving a PDB to a non-CDB?

Options:

A.

RMAN

B.

Cold Backup

C.

Traditional Export / Import

D.

Data Pump

E.

SQL*Plus

Question 22

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

Options:

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

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