Which three statements are true about Oracle checkpoint processing? (Choose three.) A. Frequent thread checkpoints can degrade database performance B. Database Writer (DBWn) processes write checkpoint information to datafile headers and the control file C. It reduces the recovery time…

Your database is configured in ARCHIVELOG mode. Examine the RMAN configuration parameters: Examine the command: RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT; Which two are true? (Choose two.) A. It fails because the DELETE INPUT option can be used only…

One of your databases has archive logging enabled and RMAN backups are taken at regular intervals. The data file for the USERS tablespace is corrupt. Which command must you execute before starting the recovery of this tablespace? A. STARTUP FORCE…

Examine this command executed on a client that is remote from the database server. SQL> CONNECT hr/hr@orcl Which two are required for this command to connect the SQL*PLUS client to a database instance? (Choose two.) A. An orcl TNS entry…

One of your databases supports an OLTP workload. The default UNDO tablespace is fixed size with: 1. RETENTION NOGUARANTEE 2. UNDO_RETENTION is 12 minutes User SCOTT gets this error after a query on the SALES table has run for more…

Which three file types are stored in the Fast Recovery Area by default in a traditional nonOMF file system? (Choose three.) A. online redo log files B. parameter file C. multiplexed copies of the current control file D. archived log…

Which two tools can be used to configure static service information in the listener.ora file? (Choose two.) A. Oracle Net Manager B. Oracle Enterprise Manager Cloud Control C. Oracle Net Configuration Assistant D. Listener Control Utility (LSNRCTL) E. Oracle Enterprise…

You install Oracle Grid Infrastructure standalone server and issue the following command: crsctl start has Which two existing components get automatically added to the Oracle Restart configuration? (Choose two.) A. Oracle CSSD services B. the database whose instance is running…

Which two tasks must you perform before you begin the upgrade process to Oracle Database 12c? (Choose two.) A. Put all readonly tablespaces in read write mode B. Recompile all invalid objects C. Set the compatible parameter to 12.1.0.1 D.…

Which three statements are true about windows? (Choose three.) A. Only one window can be open at any given time B. Consumer groups are associated with windows C. Windows work with job classes to control resource allocation D. The database…