Sreejobs Logo
   For Latest Job Updates  
sreenutech.com Online Exams
Home Govt Jobs IT Fresher Jobs IT Exp Jobs IT Walk-Ins MBA Jobs BPO Jobs Register FAQ’s Post Job Contact Us
Search:
SreeJob Fees   Feeds
Hot Jobs
Welcome Guest
Login | Register
Total No Of Questions: 100.
1) Which two statements are true about checkpointing? (Choose two.)


2) You execute the following command to audit database activities: SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL; What is the effect of this command?


3) Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undo tablespace? (Choose two.)


4) The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in your database instance. At a certain point of time, the maintenance window closes before the statistics are gathered for all objects. Which statement is true in this scenario?


5) Which two files in the database can be configured for automatic backups by using the autobackup feature in Recovery Manager (RMAN)? (Choose two.)


6) Which two statements are true about Shared SQL Area and Private SQL Area? (Choose two.)


7) Which two statements are true about alerts? (Choose two.)


8) Which two statements are true regarding the Oracle Data Pump export and import operations?(Choose two.)


9) The instance abnormally terminates because of a power outage. Which statement is true about redo log files during instance recovery?


10) Which two statements are true regarding the usage of the SQL*Loader utility? (Choose two.)
Page 1 of 10
Home | Register for Job Updates | Contact Us