ALLInterview.com :: Home Page      
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   Errors
   Testimonials Refer this Site  Refer This Site to Your Friends  Site Map  Contact Us      
   
 
 Categories >> Software >> Databases >> Oracle >> Database Management
 
Suggest New Category 
 


 

Question Asked @ Answers Views     Select
You loss one datafile and DB is running in ARCHIVELOG mode. You have full database backup of 1 week old and partial backup of this datafile which is just 1 day old. From which backup should you restore this file?    0  16
There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?    0  14
I have 2 tables with 1 million rows each. I have updated 1 row in first and 1 million update on second table. Now I commit both the updates. Which one will commit fast and Why?    0  16
The use of LAST_VALUE() AND FIRST_VALUE() with an example    1  58
What is the difference between Memory_target and Memory_max_target? Why its required to resize these parameter? sutherland   0  108
I'm need to prepare Month Over Month Sales Growth report. Is there any function available in OBIEE to perform this task.    0  174
determine the minimum salary of the employee and his details who join on the same date    3  684
select Nth highest salary by using rownum tcs   4  1610
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name, price 101, LED Lights,200 102, 20 watt CFL Lights, 145 103, 30 watt CFL lights,155 Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence flat file product list has two column pro_name, price 20 watt tube light ,45 30 watt tube light ,60 tcs   1  583
Can anybody give me link for BOXI R3.1 Key please    0  460
what is the difference between inline query and corelated subquery    1  692
Explain the Normalized Relations?    0  618
dear all,Greetings of the day.. i have a small query plz rply if u knw.. i have done MBA Hr and B.sc microbiology. i am very much interested in it industry,so i am planing to go with oracle HRMS module,can it be work out??    0  266
Dept wise avrage salary tcs   2  599
dear sir please provide what question will be asked in CWE in bank it officer    0  289
E-Mail New Answers        Answer Selected Questions        Post New database-management Questions
 [1]    2  ... 3   ... 5   ... 7   ... 9   ... 11   ... 13   ... 15   ... 17   ... 19    Next
 
 
 
 
 
Un-Answered Questions
 
 Question Views   Select
 
There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how? 14
what is the difference between filters and conditions? 328
what are parameter, we can check after creating a database in terms of QC and for each tables what should be the parameters for QC and QA? 206
1. How many nodes you are using project? 2. What is configuration file? 3. What is modules partition? How it is work in project? 4. What is Environment Variable? How it is use? 5. What is sequence? 6. How do you execute parallel jobs in projects? 7. If you run a job in job sequencer individually without any comments? 8. How many jobs did in your project? 9. How to schedule the job in Data stage 7.5 X2? 10. If you have 10 jobs in PX2, shall you run all jobs at a time? 11. I have 5 jobs (1-5), I connect with each other, but I want to run from 3-5 only how? 12. What is same partition? 13. If you have 40GB hard disk in I have 30GB data how I configure the nodes for partition? 14. Did you write any code for Data stage project? 15. Did you write any code for parallel job execution in your project? 16. Will you schedule all jobs at a time? 177
1.If we have a Salary coloumn in Staff entity with this description the salary must be monetary and >=$35450.00, how we can write it in into schemain SQL? 2. If we have Weight and Marks in Assessment entity and the Weight has the description of this it must be Non-zero percentage. And also the Marks attribute stores the maximum possible raw mark for assessment (e.g., 30), while Weight stores of the weight of this assessment for the paper as a whole (e.g., 10%). If Marks is not specified, then Weight is used for both. How we can convert this into schema in SQL???? 250
i have a web page and in this page i create 3 textbax and a "summit" button do you have any html code for add text velue in my web page like link summation(form) sites. 272
Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ? 929
Single File Database: Develop a student record management program, which uses single file as its database. It is not supposed to create additional files at any part of the project and should never rewrite total content. It must be capable of storing 100000's of records. It should support variable length records to be added, deleted, modified, listed. 540
what do u mean by canvases and alerts? 241
dear sir please provide what question will be asked in bank it officer interview 306
What types of questions are asked in NIC(Natinal Informatics Centre)'s interview?If any one has any information about this,I would be very thankful to him/her..... 328
I'm need to prepare Month Over Month Sales Growth report. Is there any function available in OBIEE to perform this task. 174
What is built_in Subprogram ? 363
i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: summi4you@yahoo.co.in 236
Explain the Normalized Relations? 618
E-Mail New Answers        Answer Selected Questions