Oracle Database 12c Essentials (1z0-497) Practice Test

Questions # 41:

Which logical storage relationship is correct?

Options:

Tablespace< Segment < Extent < Oracle Datablock

B) Segment < Extent < Oracle Datablock

Tablespace< Extent < Segment < Oracle Datablock

Data File

Questions # 42:

As part of your Oracle Database 12c post-installation tasks, you run these commands:

Cd $ORACLE_HOME/bin

srvctl stop database -d myDb

chopt enable dm

srvctl start database -d myDb

What does this do?

Options:

It enables the Oracle Data Mining option in your Oracle binary files.

It creates the Fast Recovery Area disk group.

It generates Client Static Library.

It configures one of the Oracle user accounts.

It configures Oracle Net Services.

It configures Oracle Messaging Gateway.

Questions # 43:

Which type of information is included in dynamic performance views?

1 - System and session parameters

2 - Memory usage and allocation

3 - File states (including RMAN backup files)

4 - Progress of jobs and tasks

5 - SQL execution

6 - Statistics and metrics

Options:

3, 4, and 5

1, 2, 5, and 6

1, 2, 3, and 4

2, 3, 5, and 6

2, 3, 4, 5, and 6

1, 2, 3, 4, 5, and 6

Questions # 44:

Which two statements are true regarding SQL*Plus?

Options:

It has commands for performing database administration operations.

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

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

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

Questions # 45:

Examine the output:

SQL> SELECT index_name, status FROM dba_indexes WHEREstatus='UNUSABLE’;

INDEX_NAME STATUS

--------------------- -----------------

EIND UNUSABLE

Which two statements about this index are true?

Options:

It is ignored by the query optimizer.

It is not used while the index is being rebuilt.

The index cannot be rebuilt, and has to be re-created.

The index is automatically rebuilt when used the next time.

Viewing page 5 out of 5 pages

Viewing questions 41-50 out of questions

Summer Certification Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Pass the Oracle Database 12c Certified Implementation Specialist 1z0-497 Questions and answers with ExamsMirror

Exam 1z0-497 Premium Access

Options:

Options:

Options:

Options:

Options:

TOP CODES