Free Oracle 1z0-497 Exam Dumps Questions & Answers


Exam Code/Number:	1z0-497Join the discussion
Exam Name:	Oracle Database 12c Essentials
Certification:	Oracle
Question Number:	150
Publish Date:	May 20, 2026
Rating 100%

Real-Time ADDM detects a high-load performance issue within the database. Which condition triggered it?

A. The average active sessions were more than three times the number of CPU cores.
B. Hung sessions were more than 10% of total sessions.
C. The session limit was close to 100%.
D. Active sessions were more than 10% of total load and CPU utilization was more than 50%.
E. A deadlock was detected.
F. Memory allocations were more than 95% of physical memory.

Which two statements represent where Oracle Net must reside?

A. Only on the client for traditional client/server applications
B. Only on the database server for web-based applications
C. On both the web server and database server for web-based applications
D. On both the client and database server for traditional client/server applications.

Which three DBA operations can be performed by using Oracle SQL Developer?

A. storage configuration for archive logs and control files
B. performance tuning operations such as generation of AWR, ADDM, and ASH reports
C. database backup and recovery using RMAN
D. database status view and Data Pump export and import jobs
E. storage configuration for data files and redo log groups

You need to recover a database running In NOARCHIVELOG mode. Which two statements are true in this scenario?

A. You can perform complete recovery by using the command:
RESTORE DATABASE
FROM TAG"consistent_whole_backup";
RECOVER DATABASE;
B. Media recovery is possible in most cases.
C. Only consistent backups can be used for restoring a database in NOARCHIVELOG mode.
D. You can perform incomplete recovery by using the command:
RESTORE DATABASE;
FROM TAG "consistent_whole_backup";
RECOVER DATABASE NOREDO;

You are about to install Oracle Database 12c Enterprise Edition. Which statement is true?

A. Oracle recommends that you back up the root. sh script after you complete the installation.
B. You can stop existing Oracle processes, including the listener and the database running in the Oracle home, before the database software installation.
C. A multitenant container database (CDB) can have several pluggable databases (PDBs) with different character sets.
D. You should not install the Oracle Database software into an existing Oracle home from a different release.
E. Cloning an Oracle home is useful if you are performing multiple Oracle Database Installations.

Add Comments