Free Oracle 1z1-497 Exam Dumps Questions & Answers


Exam Code/Number:	1z1-497Join the discussion
Exam Name:	Oracle Database 12c Essentials
Certification:	Oracle
Free Question Number:	150
Publish Date:	Aug 10, 2026
# of views:	2191
Rating 100%

Page: 1 / 30
Total 150 questions

Question 1

Which three operations can the PUBLIC user with the SYSOPER privilege perform?

A.STARTUP
B.ALTER DATABASE RECOVER
C.SHUTDOWN
D.CREATE DATABASE
E.DROP DATABASE

Question 2

Which parameter can be changed by explicitly re-creating the control file or by using the DBNEWID utility?

A.control_files
B.instance_name
C.maxdatafiles
D.db_name

Question 3

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

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

Question 4

Which three options best describe Patch Set Updates (PSUs) in Oracle Database 12c?

A.stabilizing
B.non-cumulative
C.cumulative
D.multi-version
E.proactive

Question 5

You are installing OracleDatabase 12c on a machine. When you run the installer; Oracle Universal installer (OUI) shows a message that says one of the product-specific prerequisite checks has failed:
Checking available swap space requirements...
Expected result: 1512MB
Actual Result: 1018MB
Check complete. The overall result of this check is: failed <<
Problem: The system does not have the required swap space.
What happens to the installation in this situation?

A.It can be continued, but the instance cannot be started without increasing swap space.
B.It shows a message saying one or more prerequisite checks have failed and the installation aborts.
C.It can be continued.
D.It resizes the swap space automatically when you proceed further.