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) You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct path load method to perform this task. The table in which you plan to load data is an important table having various integrity constraints defined on it. Which constraints will remain enabled by default during this operation? (Choose all that apply.)


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


3) Which two statements correctly describe the relation between a data file and the logical database structures? (Choose two.)


4) Which statements are true regarding the creation of an incident package file by using the EM Workbench Support? (Choose all that apply.)


5) You are in the middle of a transaction updating a very important table. The machine on which a database was running reboots because of power outage. This caused a database instance failure. Which statement is true in this situation?


6) Which two statements about the background process of the database writer are true? (Choose two.)


7) The TRANS_SUMMARY table contains product-wise transaction details that get updated with every transaction in the system. Each row has cumulative transaction details of a single product and every product is identified by a product code, which is the primary key. As part of the archival process, the company wants to transfer the rows in the TRANS_SUMMARY table to the TRANS_SUMMARY_DUP table at the end of every quarter of the year. Along with existing products, the company deals with many new products during every quarter.Which method is best suited for this quarterly data transfer?


8) You are working on a database that must be functioning 24 hours a day, 7 days a week. The database is configured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups? (Choose two.)


9) Why does performance degrade when many UPDATE, INSERT, or DELETE statements are issued on a table that has an associated Bitmap index?


10) Which two statements are true about alerts? (Choose two.)
Page 1 of 10
Home | Register for Job Updates | Contact Us