Sreejobs Logo
   For Latest Job Updates 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
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) What can you achieve by implementing reverse key index?

3) Your database instance is started using the server parameter file (SPFILE). You executed a command to change the value of the LOG_BUFFER initialization parameter: ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH; What would be the outcome of this command?

4) Which two statements are true regarding Oracle Data Pump? (Choose two.)

5) Identify the memory component from which memory may be allocated for: 1. Session memory for the shared server 2. Buffers for I/O slaves 3. Oracle Database Recovery Manager (RMAN) backup and restore operations

6) Examine the following output: SQL> SELECT index_name,status FROM dba_indexes WHERE status='UNUSABLE'; INDEX_NAME STATUS ------------------------------ ----------- EIND UNUSABLE Which two statements about the above index are true? (Choose two.)

7) You have a large amount of historical data in a flat file. Some analysts in your organization need to query this data in the file. The file is too large to load the data in it into your current database.Which is the most effective method to access this data in your database?

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

9) 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.)

10) You executed this command to create a temporary table : SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (startdate DATE, enddate DATE,class CHAR(20)) ON COMMIT PRESERVE ROWS;Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction?
Page 1 of 10
Home | Register for Job Updates | Contact Us