1Z0-497 Questions | Free Practice 1Z0-497 Dumps & Exam Prep

Question No 1

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?

Choose the Choices:

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.

Question No 2

Exhibit below Which three statements are true about terminating a session?

Choose the Choices:

Without any error, you can terminate the active session by executing SQL> ALTER SYSTEM KILL SESSIOU '7, 15';

You can terminate the active session by executing SQL> ALTER SYSTEM KILL SESSIOM "7, 15'; But you also get the error message ORA - 00028 your session has been killed

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

Without any error, you can terminate the inactive session by executing SQL> ALTER SYSTEM KILL SESSION '12, 63';

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.

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

Question No 3

Which two statements are true about shared server sessions?

Choose the Choices:

No Program Global Area (PGA) is allocated for shared server processes.

User Global Area is stored in System Global Area (SGA).

Shared SQL Area is allocated from Program Global Area (PGA).

Private SQL Area is allocated from Library Cache.

Large Pool is used for SQL work areas.

Question No 4

Which targets can be managed by using Enterprise Manager Cloud Control?

Choose the Choices:

Hosts and databases

Hosts, databases, and application servers

Application servers and web applications

Databases, Oracle Management Server (OMS), and Oracle Management Repository (OMR)

Databases, application servers, and web applications

Hosts, databases, application servers, web applications, OMS, and OMR

Question No 5

Which two statements are true regarding SQL*Plus?

Choose the Choices:

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.

Free Oracle 1Z0-497 Questions

Question No 1

Question No 2

Question No 3

Question No 4

Question No 5

1Z0-497 Exam Features

1Z0-497 PDF Dumps