Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk®
All Vendors
  2. Home
  3. Exams
  4. Oracle
  5. 1Z0-497

Free Oracle 1Z0-497 Exam Braindumps (page: 2)

Page 2 of 31
PDF with 150 Questions

Which statement about CDB architecture is true?

  1. Oracle-supplied metadata resides only in the root container.
  2. A seed PDB can sometimes be opened for particular operations.
  3. Multiple PDBs with the same name can reside in the same CDB.
  4. A CDB can have an infinite number of PDBs.
  5. You can create common users in PDBs.

Answer(s): A


Reference:

http://docs.oracle.com/cd/E16655_01/server.121/e17633/cdbovrvw.htm#CNCPT89235



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?

  1. It enables the Oracle Data Mining option in your Oracle binary files.
  2. It creates the Fast Recovery Area disk group.
  3. It generates Client Static Library.
  4. It configures one of the Oracle user accounts.
  5. It configures Oracle Net Services.
  6. It configures Oracle Messaging Gateway.

Answer(s): A


Reference:

http://docs.oracle.com/cd/E16655_01/install.121/e17889/postinst.htm#RILIN1049 (see 4.4)



Exhibit below:



Which three statements are true about terminating a session?

  1. Without any error, you can terminate the active session by executing:
    SQL> ALTER SYSTEM KILL SESSION '7, 15';
  2. 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
  3. You cannot terminate the active session. You have to wait until that session becomes inactive.
  4. Without any error, you can terminate the inactive session by executing:
    SQL> ALTER SYSTEM KILL SESSION '12, 63';
  5. 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.
  6. You cannot terminate the inactive session. You have to wait until that session becomes active again.

Answer(s): B,D,E

Explanation:

B (not A, Not C):
* You terminate a current session using the SQL statement ALTER SYSTEM KILL SESSION. The following statement terminates the session whose system identifier is 7 and serial number is 15:

* Terminating an Active Session
If a user session is processing a transaction (ACTIVE status) when you terminate the session, the transaction is rolled back and the user immediately receives the following message:
ORA-00028: your session has been killed
ALTER SYSTEM KILL SESSION '7,15';
E (not F): Terminating an Inactive Session
If the session is not making a SQL call to Oracle Database (is INACTIVE) when it is terminated, the ORA-00028 message is not returned immediately. The message is not returned until the user subsequently attempts to use the terminated session.
When an inactive session has been terminated, the STATUS of the session in the V$SESSION view is KILLED. The row for the terminated session is removed from V$SESSION after the user attempts to use the session again and receives the ORA-00028 message.


Reference:

Oracle Database Administrator's Guide, Terminating Sessions URL: http://docs.oracle.com/cd/B28359_01/server.111/b28310/manproc008.htm#ADMIN11192



Which two statements are true about shared server sessions?

  1. No Program Global Area (PGA) is allocated for shared server processes.
  2. User Global Area is stored in System Global Area (SGA).
  3. Shared SQL Area is allocated from Program Global Area (PGA).
  4. Private SQL Area is allocated from Library Cache.
  5. Large Pool is used for SQL work areas.

Answer(s): B,D


Reference:

Oracle Database Concepts, 12c, Memory Architecture



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

  1. Hosts and databases
  2. Hosts, databases, and application servers
  3. Application servers and web applications
  4. Databases, Oracle Management Server (OMS), and Oracle Management Repository (OMR)
  5. Databases, application servers, and web applications
  6. Hosts, databases, application servers, web applications, OMS, and OMR

Answer(s): F


Reference:

http://www.oracle.com/technetwork/oem/framework-infra/wp-em12c-security-best-practicesv2- 1493383.pdf (page 3, second bulleted point, last couple of sentences)



Viewing page 2 of 31
Viewing questions 6 - 10 out of 150 questions



Post your Comments and Discuss Oracle 1Z0-497 exam prep with other Community members:

1Z0-497 Exam Discussions & Posts