Free Oracle 1z0-497 Exam Dumps Questions & Answers

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

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

What happens when you execute these SQL statements?
ALTER SYSTEM SET SGA_TARGET = 992M;
ALTER SYSTEM SET SHARED_POOL_SIZE = 0;
ALTER SYSTEM SET LARGE_POOL_SIZE = 0; ALTER SYSTEM SET JAVA_POOL_SIZE = 0;
ALTER SYSTEM SET DB_CACHE_SIZE = 0;
ALTER SYSTEM SET STREAMS POOL SIZE = 0;

• A.The database stops (shutdown abort).
• B.B) The database Stops (shutdown immediate).
• C.You get an error message.
• D.You activate Automatic Shared Memory Management.

Identify three key properties of a transaction in Oracle Database 12c.

• A.consistency
• B.isolation
• C.concurrency
• D.manageability
• E.scalability
• F.durability

An Oracle instance is a combination of______.

• A.database files and parameter file (initialization parameter file or server parameter file)
• B.database files, System Global Area (SGA), and background processes
• C.System Global Area (SGA), server processes, and background processes
• D.a listener process, server processes, and background processes
• E.System Global Area (SGA) and background processes

Consider 10 scenarios that result in database downtime. Which five of them are considered as planned downtime?

• A.dropped database object
• B.table definition changes
• C.database or application deadlocks
• D.runaway processes that consume system resources
• E.operating system or storage device / driver failure
• F.changing configuration parameters, upgrading, or patching Oracle software
• G.migrating to cluster architecture
• H.addition or removal of nodes, memory, or disks
• I.file deletion
• J.adding table partitioning