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

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

1z0-497 Exam Dumps - Oracle Database 12c Essentials

Go to page:
Question # 17

Which two statements about ADDM are true?

A.

Real-Time ADDM uses AWR snapshots of the last 10 minutes.

B.

Real-Time ADDM uses ASH recent activity from SGA data.

C.

Real-Time ADDM analyzes performance in a completely different fashion than regular ADDM.

D.

Regular ADDM uses AWR snapshots that are not yet purged.

Full Access
Question # 18

Examine the statements:

SQL> CREATE TABLESPACE MYTBS DATAFILE '/disk1/mytbs_l.dbf ' SIZE 10M;

SQL> CREATE TABLE mytab (id NUMBER, descr VARCHAR2 (100) )

PARTITION BY RANGE(id) (

partition pi values loss than (100000) tablespacemytbs storage (initial lm),

partition p2 values less than (MAXVALUE) tablespacemytbs storage (initial 1m)

);

When inserting data, you get the error:

ORA-01688: unable to extend table SYS.MYTAB partition P2 by 128 in tablespace MYTBS

Which three operations would allow you to insert data without getting the error message?

A.

Extend the logical volume by 10 MB where the data files are stored;

# lvextend -L+10M /diskl

B.

Add a data file:

SQL>ALTER TABLESPACE MYTBS ADD DATAFILE ' /disk1/mytbs_2 .dbf SIZE 10M;

C.

Move a partition to another tablespace:

SQL> CREATE TABLESPACE ADDITIONAL_TBS DATAFILE '/disk1/additional_tbs_1 .dbf' SIZE 10M;

SQL> ALTER TABLE MYTAB MOVE PARTITION P2 TABLESPACE ADDlTIONAL_TBS;

D.

Resize the existing data file:

SQL> ALTER DATABASE DATAFILE '/diskl/mytbs_l .dbf' RESIZE 20M;

E) Remove a data file:

SQL> ALTER TABLESPACE MYTBS DROP DATAFILE '/diskl/mytbs_l - dbf';

Full Access
Question # 19

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 # 20

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 # 21

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

Full Access
Question # 22

Which statement about the Oracle Advanced Security Data Redaction feature is true?

A.

It transparently encrypts data at rest in Oracle databases.

B.

It securely manages encryption keys.

C.

It protects against theft or loss of disks and backups.

D.

It prevents OS users from inspecting tablespace files.

E.

It limits the exposure of sensitive data in applications.

F.

It alters data in caches, buffers, and persistent storage.

G.

It impacts operational activities such as backup & restore, upgrade & patch, and replication.

Full Access
Go to page:

Hot Exams

ADM-201 Dumps
Platform-App-Builder Dumps
AZ-500 Dumps
350-701 Dumps
SY0-601 Dumps
NCSE-Core Dumps
PDP9 Dumps
DP-203 Dumps
AZ-700 Dumps
NSE7_EFW-7.0 Dumps
Integration-Architect Dumps
CS0-003 Dumps