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  7
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  6
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  8
The use of LAST_VALUE() AND FIRST_VALUE() with an example    1  33
What is the difference between Memory_target and Memory_max_target? Why its required to resize these parameter? sutherland   0  91
I'm need to prepare Month Over Month Sales Growth report. Is there any function available in OBIEE to perform this task.    0  166
determine the minimum salary of the employee and his details who join on the same date    3  668
select Nth highest salary by using rownum tcs   4  1568
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  567
Can anybody give me link for BOXI R3.1 Key please    0  457
what is the difference between inline query and corelated subquery    1  677
Explain the Normalized Relations?    0  613
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  255
Dept wise avrage salary tcs   2  582
dear sir please provide what question will be asked in CWE in bank it officer    0  282
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
 
what do u mean by canvases and alerts? 239
1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping? 222
what do u mean by implementation? 422
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???? 246
What will be the maximum size of an extent of a segment if the tablepac's default storage values are specified as (initial 8K next 16k minextent 4 pctincrease 100).Explain. 320
What are the Roles and responsibilities of database administrator? 841
How to handle data if f table are more than one and each table contain thousands of entries? 186
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 226
Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com 273
what is the index and synonym. i have the definitions ...can any one give me brief explanation.. with regards, 243
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? 6
Explain the classification of Database Management System? 1161
IF Statements BLOCK 1 . IF a >= b THEN do_this …..; ELSE do_that….; END IF BLOCK 2 . IF a < b THEN do_that …..; ELSE do_this….; END IF; • Given any pair of non-NULL values for “a” and”b”, will Block 1 and Block 2 do the same thing? • What if either “a” or”b” (or both) is NULL? 348
8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values? 185
how you will identify the mapping level bottleneck ? if there is a mapping level bottleneck then how will you try to improve the mapping 286
E-Mail New Answers        Answer Selected Questions