You are about to apply a patch to a database. Which recommended action is incorrect? A. You should check the patch conflict with installed patches before applying the patch. B. You should make sure that you have a good backup…
Which type of information is included in dynamic performance views? 1 – System and session parameters 2 – Memory usage and allocation 3 – File states (including RMAN backup files) 4 – Progress of jobs and tasks 5 – SQL…
Which three statements are true about System Global Area (SGA)? A. SGA contains shared memory structures for all Oracle processes running on a single server. B. Each server process has its own SGA. C. SGA is allocated automatically when a…
Which two statements correctly distinguish between undo and redo data? A. Undo reverses a change, whereas redo re-creates a change. B. Redo reverses a change, whereas undo re-creates a change. C. Undo protects against inconsistent reads, whereas redo protects against…
After a ___________ statement is issued, a transaction ends. (select three) A. COMMIT B. ROLLBACK C. SAVEPOINT D. SELECT E. CREATE
Which statement about Storage Snapshot Optimization is correct? A. It enables you to use third-party technologies to take a storage snapshot of your database without putting the database in BACKUP mode. You can then use the snapshot to recover all…
There are two listeners, LISTENER1 arid LISTENER2, and one service name ORCL available for your database. The database is running and currently, only LISIENER1 is started. You issue the command: lsnrctl start listener2 What would be the outcome? A. It…
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…
When executing shutdown abort in a pluggable database (PDB), you ____________. A. shut down abort the CDB B. shut down abort the PDB C. shut down immediate the PDB D. shut down immediate the CDB
Which is the default isolation level in Oracle Database 12c? A. serializable B. read-only C. read committed D. read uncommitted