1z1-497 by Oracle Actual Free Exam Questions And Answers

Question 1

You are about to apply a patch to a database. Which recommended action is incorrect?

A. You should stop all applications running from the software directory that is being patched.

B. You should check the patch conflict with installed patches before applying the patch.

C. You should check the fifth digit of the release information to confirm that the Patch Set Update (PSU) is applied successfully.

D. You should install the latest O patch before applying the patch.

E. You should make sure that you have a good backup of the software, database, and configuration files.

Discussion 0

Correct Answer: C Vote an answer

Question 2

Which type of file system is NOT valid for storing data files, online redo log files, and control files for a pluggable database?

A. OS file system

B. RAW

C. logical volume (LVM)

D. Automatic Storage Management (ASM)

E. clustered file system

Discussion 0

Correct Answer: B Vote an answer

Question 3

Which two statements about Data Recovery Advisor are true?

A. You can use the ADVISE FAILURE command to display repair options after running LIST FAILURE in an RMAN session.

B. Data Recovery Advisor cannot be used to diagnose and repair data corruptions in the root of a CD

C. Data Recovery Advisor can be used to diagnose and repair data corruptions in non-CDBs.

D. Data Recovery Advisor can be used to diagnose and repair data corruptions in PDBs.

Discussion 0

Correct Answer: A,C Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 4

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

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 the database instance to be registered with the listener is configured in shared server mode

D. when users need to connect the database instance by using the host naming method

Discussion 0

Correct Answer: B Vote an answer

Question 5

Which option represents the steps to add a multiplexed copy of the current control file or to rename a control file in Oracle Database 12c?
a - Shut down the database.
b - Restart the database.
c - Copy an existing control file to a new location by using operating system commands.
d - Edit the CONTROL_FILESparameter in the database initialization parameter file to add the new control file name, or to change the existingcontrol file name.

A. c, d, b

B. a, d, b, c

C. b, c, d

D. a, c, d, b

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 6

Exhibit below:

Which three statements are true about terminating a session?

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

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

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

D. 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.

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

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

Discussion 0

Correct Answer: A,D,E Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 7

Identify three types of important statistics collection that you can disable in Oracle Database 12c by setting the STATISTIS_LEVEL parameter to BASIC.

A. Automatic SGA Memory Management

B. Oracle Database alert.log file

C. all server-generated alerts

D. Oracle Database Trace files

E. object-level statistics

Discussion 0

Correct Answer: A,C,E Vote an answer

Question 8

When you start up a CDB, which operations are performed automatically and in what order?
a - The instance is started.
b - Control files are opened.
c - The root container is opened (redo logs and root data files).
d - Seed pluggable database is in READ ONLY mode.
e - Other PDBs are still in MOUNTED mode.
f - Triggers may fire if they exist to open other PDBs.

A. a, b, c, d, e, f

B. b, c, a, d, e, f

C. b, c, a, d

D. c, b, a, d, f, e

E. a, b, c, d

Discussion 0

Correct Answer: E Vote an answer

Oracle Database 12c Essentials - 1z1-497 Exam Practice Test

Contact Us

Useful Links

Latest Updated