Download Oracle Database 12c Essentials.1z0-497.Pass4Success.2026-04-01.112q.tqb

Vendor: Oracle
Exam Code: 1z0-497
Exam Name: Oracle Database 12c Essentials
Date: Apr 01, 2026
File Size: 492 KB
Download Exam

How to open TQB files?

Files with TQB (Taurus Question Bank) extension can be opened by Taurus Exam Studio.

Download
Taurus Exam Studio

Purchase
Coupon: TAURUSSIM_20OFF

Discount: 20%

Taurus Exam Simulator Taurus Exam Simulator Taurus Exam Simulator Taurus Exam Simulator Taurus Exam Simulator

Demo Questions

Question 1
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.
Correct answer: 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 SessionIf 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 killedALTER SYSTEM KILL SESSION '7,15';E (not F): Terminating an Inactive SessionIf 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.Oracle Database Administrator's Guide, Terminating SessionsURL: http://docs.oracle.com/cd/B28359_01/server.111/b28310/manproc008.htm#ADMIN11192
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.
Oracle Database Administrator's Guide, Terminating Sessions
URL: http://docs.oracle.com/cd/B28359_01/server.111/b28310/manproc008.htm#ADMIN11192
Question 2
What is the most appropriate architecture for handling 50,000 concurrent users in an e-commerce application?
  1. These administrative privileges allow a user to view DBA_xxx, GV$, VS, and SELECT on application tables.
  2. all sessions for which database users have access privileges to the PERSONS table
  3. System administrators and users with the CREATE SESSION system privilege may connect to the instance.
  4. when users need to connect the database instance by using the host naming method
  5. Authentication Service
Correct answer: E
Explanation:
https://docs.oracle.com/database/121/UPGRD/deprecated.htm#UPGRD60120
https://docs.oracle.com/database/121/UPGRD/deprecated.htm#UPGRD60120
Question 3
Consider an application in which memory required for each session is 400 KB and memory required for each server process is 4 MB. The pool size is 100 and the number of shared servers used is 100. If there are 5000 client connections, what is the amount of memory used by a dedicated server?
  1. 615 MB
  2. 2.5 GB
  3. 4 GB
  4. 12 GB
  5. 22 GB
Correct answer: E
Explanation:
http://docs.oracle.com/cd/E11882_01/server.112/e25494/manproc.htm#ADMIN12483
http://docs.oracle.com/cd/E11882_01/server.112/e25494/manproc.htm#ADMIN12483
Question 4
Which two statements about multitenant architecture are true?
  1. Multiple PDBs on a single server need multiple database instances and multiple sets of database files.
  2. Although consolidated into a single physical database, PDBs mimic the behavior of non-CDBs.
  3. A PDB administrator can use Oracle Flashback or point-in-time recovery to retrieve lost data from a PDB, only by shutting down all the PDBs from the CDB.
  4. It is easier to collect performance metrics for many databases in a CDB than individual non-CDB databases.
  5. It takes more time to apply a patch to one CDB that holds hundreds of PDBs than to hundreds of non-CDB databases.
Correct answer: B, D
Explanation:
B: A PDB is a portable collection of schemas, schema objects, and nonschema objects that appears to an Oracle Net client as a non-CDB. All Oracle databases before Oracle Database 12c were non-CDBs.D: Ease of performance tuningIt is easier to collect performance metrics for a single database than for multiple databases. It is easier to size one SGA than 100 SGAs.Benefits of the Multitenant Architecture for Database ConsolidationURL: http://docs.oracle.com/cd/E16655_01/server.121/e17633/cdbovrvw.htm#CNCPT89239
B: A PDB is a portable collection of schemas, schema objects, and nonschema objects that appears to an Oracle Net client as a non-CDB. All Oracle databases before Oracle Database 12c were non-CDBs.
D: Ease of performance tuning
It is easier to collect performance metrics for a single database than for multiple databases. It is easier to size one SGA than 100 SGAs.
Benefits of the Multitenant Architecture for Database Consolidation
URL: http://docs.oracle.com/cd/E16655_01/server.121/e17633/cdbovrvw.htm#CNCPT89239
Question 5
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.
Correct answer: B, D
Explanation:
Oracle Database Concepts, 12c, Memory Architecture
Oracle Database Concepts, 12c, Memory Architecture
Question 6
Your customer is looking for a solution to address these downtime needs:
  • Online addition and removal of disks should automatically rebalance data across new storage configurations while storage, database, and applications remain online.
  • Dynamically add or remove clustered nodes without disrupting the database or applications.
  • Automate the sizing and distribution of shared memory.
  • Add a column with a default value without disrupting the database or applications.
  • Perform rolling patch upgrades.
Which four would you recommend to address those needs?
  1. Automatic Storage Management (ASM)
  2. Online Data and Application change
  3. Global Data Services (GDS)
  4. Real Application Clusters (RAC)
  5. Oracle Streams
  6. Online Table Redefinition
  7. Oracle Database Vault
Correct answer: A, B, D, F
Question 7
Which two statements about PDBs and CDBs are true?
  1. There is only one SYSTEM tablespace per CDB .
  2. There is only one instance per PDB.
  3. There is a set of redo log files per PDB.
  4. There is only one UNDO tablespace per CDB.
  5. There is one SYSAUXtablespace per PDB.
Correct answer: D, E
Question 8
Which tool is recommended for moving a PDB to a non-CDB?
  1. RMAN
  2. Cold Backup
  3. Traditional Export / Import
  4. Data Pump
  5. SQL*Plus
Correct answer: D
Explanation:
https://docs.oracle.com/database/121/SUTIL/dp_overview.htm#SUTIL4334
https://docs.oracle.com/database/121/SUTIL/dp_overview.htm#SUTIL4334
Question 9
Which is the default isolation level in Oracle Database 12c?
  1. serializable
  2. read-only
  3. read committed
  4. read uncommitted
Correct answer: C
Explanation:
http://docs.oracle.com/cd/B28359_01/server.111/b28318/consist.htm#CNCPT1312 (see the sentence that comes right after table 13-1)
http://docs.oracle.com/cd/B28359_01/server.111/b28318/consist.htm#CNCPT1312 (see the sentence that comes right after table 13-1)
Question 10
Your customer is planning for a maximum-availability architecture at their data center to address their planned downtime, unplanned downtime, and replication needs.
Consider these options:
  • Instance, site recovery, and heterogeneous setup
  • Inter-region and intra-region load balancing across replicated databases
  • Fine-grained error investigation of incorrect results
  • Integrated client and application failover
  • Fastest and simplest database replication
Which four options would you recommend?
  1. Oracle GoldenGate
  2. Global Data Services
  3. Oracle Data Guard
  4. Data Recovery Advisor
  5. Oracle Flashback technology
  6. Oracle Advanced Queuing
Correct answer: A, B, C, E
Explanation:
http://docs.oracle.com/cd/E16655_01/server.121/e17601/unplanned.htm#HAOVW11824
http://docs.oracle.com/cd/E16655_01/server.121/e17601/unplanned.htm#HAOVW11824
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX FILES

Use ProfExam Simulator to open VCEX files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!