Oracle Database Administration II178 questions across 18 pages are complete and free, with no account or card.
178 questions in this bank
Free access · progress saved on this device
HR_ROOT is an application container with the HR_APP application installed. No application PDBs and no application seed have yet been created in HR_ROOT. An application PDB, PDB1, must be created so that the HR_APP application's common objects are accessible to it. Which two methods can be used? (Choose two.)
Answer: CD
Which three are true about Rapid Home Provisioning of Oracle software? (Choose three.)
Answer: BDE
Not F Support for single-instance databases: You can use Oracle Fleet Patching and Provisioning to provision, patch, and upgrade single-instance databases running on clusters or Oracle Restart, or on single, standalone nodes
Source: Adapted from community discussion — nobody347
In performance management, which two factors might reduce the ability of an application to scale to a large number of users? (Choose two.)
Answer: AC
A,C no doubt! About Concurrency and Scalability The better your application handles concurrency, the more scalable it is. Concurrency is the simultaneous execution of multiple transactions. Statements within concurrent transactions can update the same data. Concurrent transactions must produce meaningful and consistent results. Therefore, a multiuser database must provide the following: Data concurrency , which ensures that users can access data at the same time. Data consistency, which ensures that each user sees a consistent view of the data, including visible changes from his or her own transactions and committed transactions of other users
Source: Adapted from community discussion — Amaora
Which three are true about monitoring waits for sessions and services? (Choose three.)
Answer: BCF
Answer: B, D, F Explanation : A, E - False : V$SESSION_EVENT displays information on waits for an event by a session. V$SESSION_WAIT_HISTORY displays the last 10 wait events for each active session. B - V$SERVICE_EVENT displays aggregated wait counts and wait times for each wait statistic. C - False : V$SESSION_WAIT_CLASS displays the time spent in various wait event operations on a per-session basis. D, F - True : V$SESSION_WAIT displays the current or last wait for each session. V$SESSION.EVENT If the session is currently waiting, then the resource or event for which the session is waiting. If the session is not in a wait, then the resource or event for which the session most recently waited. Resource : https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/V-SESSION_EVENT.html#GUID-5723D404-83F7-4C8D-8BF2-031B3FFEAAA8
Source: Adapted from community discussion — brolem
You issued this command: RMAN> BACKUP RECOVERY AREA FORCE; Which three are true? (Choose three.)
Answer: BCD
The key is a term "recovery files". BACKUP RECOVERY AREA ... per 19c RMAN reference: Backs up recovery files created in the current and all previous fast recovery area destinations. Backups can go to SBT and disk. To backup to disk, you must use the TO DESTINATION syntax. Recovery files are full and incremental backup sets, control file autobackups, data file copies, and archived redo log files. Flashback logs, the current control file, and online redo log files are not backed up. By default, backup optimization is enabled for this command even if the CONFIGURE BACKUP OPTIMIZATION setting is OFF. You can disable backup optimization for BACKUP RECOVERY AREA by specifying FORCE. Note: If the fast recovery area is not enabled but was enabled previously, then files created in the previous fast recovery area location are backed up.
Source: Adapted from community discussion — Franta1
Which three are true about recovery operations done without using Recovery Manager (RMAN)? (Choose three.)
Answer: ADF
Why F? you can drop datafiles of tablespace where are INDEXes only, then restart DB. It will fail as datafiles cannot be found so make them offline drop and open DB. From dictionary view extract DDLs to create indexes and save it in your notepad. Drop tablespace including contents. Create tablespace with the same name. Use DDLs to re-create indexes from your notepad. Done. Tested in practice minutes ago.
Source: Adapted from community discussion — ObserverPL
Examine this configuration: 1. CDB1 is a container database. 2. APP_ROOT is an application root in CDB1. 3. APP_PDB1 is an application PDB in APP_ROOT. 4. FLASHBACK DATABASE is ON. You execute these commands:
Which table or set of tables will exist after the Flashback operation has completed?
Answer: B
B Performing a flashback operation on the application root reverts only the application root to the specified point in time.
Source: Adapted from community discussion — mporislav
Which two are true about RMAN backups when using a media manager? (Choose two.)
Answer: BC
BC are correct answer. Tested in lab for B. https://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta007.htm#RCMRF107 A is incorrect - zdlra backups are sbt backups but not written to tape always E is incorrect - Not all are supported
Source: Adapted from community discussion — ABAJ
Which three are true about interpreting Recovery Manager (RMAN) error stacks returned to standard output? (Choose three.)
Answer: ACF
ACF C: RMAN-03009 provides channel ID. F: The main information of interest returned by SBT 1.1 media managers is the error code in the "Additional information" line: https://docs.oracle.com/cd/E15586_01/backup.1111/e10642/rcmtroub.htm
Source: Adapted from community discussion — Aldrid
Which three are true about block media recovery? (Choose three.)
Answer: ABC
A, C, F By default , RMAN searches the flashback logs for good copies of the blocks, and then searches for the blocks in full or level 0 incremental backups. You could use the EXCLUDE FLASHBACK LOG option to restrict RMAN from searching the flashback logs. (Not B). A, C main features You can perform block recovery only on blocks that are marked corrupt or fail a corruption check (Not D) The target database must run in ARCHIVELOG mode and be open or mounted with a current control file (Not E).
Source: Adapted from community discussion — mporislav
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
1Z0-083 practice, question 21. 178 questions available.
Version 1.0.0. How we source questions