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?    1  29
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  19
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  29
The use of LAST_VALUE() AND FIRST_VALUE() with an example    1  86
What is the difference between Memory_target and Memory_max_target? Why its required to resize these parameter? sutherland   0  135
I'm need to prepare Month Over Month Sales Growth report. Is there any function available in OBIEE to perform this task.    0  179
determine the minimum salary of the employee and his details who join on the same date    3  702
select Nth highest salary by using rownum tcs   4  1673
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  615
Can anybody give me link for BOXI R3.1 Key please    0  464
what is the difference between inline query and corelated subquery    1  711
Explain the Normalized Relations?    0  625
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  271
Dept wise avrage salary tcs   2  621
dear sir please provide what question will be asked in CWE in bank it officer    0  297
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
 
1. Difference between Lookup and join? 2. Difference between funnel and join? 3. What type of load you have used in your project? 4. What type of data warehouse schema you have fallowed in you project? 5. How many fact tables and dimension tables is their in project? 6. How do you kill the job process using windows environment? 7. Difference between sequence file and dataset? 8. What is delta load and subsequent load? 9. By using which stages you have implemented the SCD 232
when All datafiles related to a Tablespace are removed ? 360
dear sir please provide what question will be asked in bank it officer interview 312
for what purpose we use MDM(master data management)tell me plz. 1013
How many number of columns can a RECORD GROUP have ? 373
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..... 330
With DTS packaging I can store tables in Excel and convert them back to SQL. But once I copied tables to Excel I want to modify some info. How you do that without editing the Excel file? 497
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? 29
How can we tune a oracle database if log file sync issue comes 334
what is normalization? types of normalization? example of each form? how do u implement normalization in ur project? 266
what do u mean by implementation? 428
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?? 271
Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com 277
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? 19
what is the index and synonym. i have the definitions ...can any one give me brief explanation.. with regards, 251
E-Mail New Answers        Answer Selected Questions