CertsTopics Logo

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

Oracle Database 12c 1z0-060 Passing Score

Page: 3 / 8
Total 208 questions
Get 1z0-060 Full Access Download 1z0-060 PDF

Upgrade to Oracle Database 12c Questions and Answers

Question 9

Examine the following parameters for a database instance:

Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)? (Choose three.)

Options:

A.

LOG_BUFFER

B.

SORT_AREA_SIZE

C.

JAVA_POOL_SIZE

D.

STREAMS_POOL_SIZE

E.

DB_16K_CACHE_SIZE

F.

DB_KEEP_CACHE_SIZE

Question 10

You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.

You issue the following statements:

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;

For which database users is the audit policy now active?

Options:

A.

All users except SYS

B.

All users except SCOTT

C.

All users except SYS and SCOTT

D.

All users except SYS, SYSTEM, and SCOTT

Question 11

You use the segment advisor to help determine objects for which space may be reclaimed.

Which three statements are true about the advice given by the segment advisor? (Choose three.)

Options:

A.

It may advise the use of online table redefinition for tables in dictionary-managed tablespaces.

B.

It may advise the use of segment shrink for tables in dictionary-managed tablespaces if there are no chained rows.

C.

It may advise the use of online table redefinition for tables in locally managed tablespaces.

D.

It will detect and advise about chained rows.

E.

It may advise the use of segment shrink for freelist managed tables.

Question 12

You execute the following commands to audit database activities:

Which statement is true about the audit record that is generated when auditing starts after the instance restarts?

Options:

A.

One audit record is created for every successful execution of a SELECT, INSERT, or DELETE command on a table, and contains the SQL text for the SQL Statements.

B.

One audit record is created for every successful execution of a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.

C.

One audit record is created for the whole session if JOHN successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.

D.

One audit record is created for the whole session if JOHN successfully executes a SELECT, INSERT, or DELETE command, and contains the SQL text and bind variables used.

E.

One audit record is created for the whole session if JOHN successfully executes a SELECT, INSERT, or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.

Page: 3 / 8
Total 208 questions
Get 1z0-060 Full Access Download 1z0-060 PDF