Create Next App

Exam contains 149 questions

Page 1 of 25

Question 1 🔥

As part of your Oracle Database 12c post-installation tasks, you run these commands:Cd $ORACLE_HOME/bin -srvctl stop database -d myDbchopt enable dmsrvctl start database -d myDbWhat does this do?

Which database solution meets these requirements?

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

Highly voted

B. It creates the Fast Recovery Area disk group.

Highly voted

C. It generates Client Static Library.

Highly voted

D. It configures one of the Oracle user accounts.

Highly voted

E. It configures Oracle Net Services.

Highly voted

F. It configures Oracle Messaging Gateway.

Highly voted

Discussion of the question

Question 2 🔥

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

Which database solution meets these requirements?

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

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

Discussion of the question

Question 3 🔥

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

Which database solution meets these requirements?

A. Hosts and databases

Highly voted

B. Hosts, databases, and application servers

Highly voted

C. Application servers and web applications

Highly voted

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

Highly voted

E. Databases, application servers, and web applications

Highly voted

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

Highly voted

Discussion of the question

Question 4 🔥

Which two statements are true regarding SQL*Plus?

Which database solution meets these requirements?

A. It has commands for performing database administration operations.

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

Discussion of the question

Question 5 🔥

Which two statements about the Process Monitor (PMON) process are true?

Which database solution meets these requirements?

A. PMON performs process recovery when a client process fails.

Highly voted

B. During instance startup, PMON takes care of instance recovery.

Highly voted

C. PMON performs listener registration.

Highly voted

D. PMON restarts background and dispatcher processes when they fail.

Highly voted

E. PMON resolves failures of distributed transactions.

Highly voted

Discussion of the question

Question 6 🔥

Which statement about CDB architecture is true?

Which database solution meets these requirements?

A. Oracle-supplied metadata resides only in the root container.

Highly voted

B. A seed PDB can sometimes be opened for particular operations.

Highly voted

C. Multiple PDBs with the same name can reside in the same CDB.

Highly voted

E. You can create common users in PDBs.

Highly voted

D. A CDB can have an infinite number of PDBs.

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_497

Exam contains 149 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us