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
All questions related to Control m monitoring tool    0  9
how to solve cardinality in dbms...many to many ralationships    0  159
user says the db performance is slow or yesterday the query runned 1min and today its taking 30 min. how to trouble shot or were to start with?    1  273
how to restore particular schema from rman full backup?    0  197
what is scan listener.    0  476
Suppose database is running slow, what will you do?    0  576
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?    2  1254
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  657
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  1016
The use of┬áLAST_VALUE() AND FIRST_VALUE() with an example    1  2433
What is the difference between Memory_target and Memory_max_target? Why its required to resize these parameter? sutherland   1  3531
I'm need to prepare Month Over Month Sales Growth report. Is there any function available in OBIEE to perform this task.    0  787
determine the minimum salary of the employee and his details who join on the same date    3  2318
select Nth highest salary by using rownum tcs   4  9244
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  2801
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
 
How can we tune a oracle database if log file sync issue comes 679
How to handle data if f table are more than one and each table contain thousands of entries? 471
I'm need to prepare Month Over Month Sales Growth report. Is there any function available in OBIEE to perform this task. 787
for what purpose we use MDM(master data management)tell me plz. 2392
what is the index and synonym. i have the definitions ...can any one give me brief explanation.. with regards, 674
What do you mean by Checkbox ? 918
Can anybody give me link for BOXI R3.1 Key please 1160
how to restore particular schema from rman full backup? 197
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? 1. What are environment variable, job parameters? 2. What is the relationship between the tables in oracle? 3. How can u create the sequence? 4. What are the client components? 5. Tell me about the Data stage administrator? 6. Tell me about the Data stage Manager? 7. What is joining? 8. What is difference between grep command and fgrep command? 9. What is run time column propagation? 10. How to open the file? 11. How do you cleanse the data in your project? 1. Using which stage raw binary converted into dataset? 2. Which stage is used to read the data into external application? 3. Can we convert dataset into raw binary 4. XML path? 5. When we use the hash partition in aggregator stage? 6. How many reject links in transformer stage? 7. Data stage debugger available in which jobs? 8. Tell me two parts of data set? 9. What is the function used for null handling in modify stage? 10. Default execution mode for exception handler? 11. Maximum exception handler allowed in sequence? 1792
what do u mean by canvases and alerts? 653
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..... 566
dear sir please provide what question will be asked in CWE in bank it officer 873
What is a Built_in subprogram ? 1967
1. Tell me about your self? 2. Latest Project Introduction? 3. Difference between server jobs and parallel jobs? 4. Seq-Seq Explain its behavior and execution mode and which parallelism technique is used? 5. What is padding characters? 6. Seq-Seq, Seq-Copy-Seq which one is the best and efficient? 7. How many reject links do we have to a transformer? 8. How many reject links to join stage? 9. Difference between join and lookup? 10. How to design PX routine? 11. How can we call job in another job? 12. Difference between batch and sequencer? 13. Which Database is used? 14. What is change capture? Give briefing of that? 15. What is change Code? Explain? 16. How you call UNIX in Ds? 17. How do you call JCL in UNIX? 18. How do you pass the job status of one job to another job? Have designed any job sequencer? 19. How do you find a file in existed directory? 20. How can you call parallel jobs in transformer? 21. Execution of jobs in command line? 22. Tuning of sql queries? 23. What is orchestrating metadata? 24. What are junk dimension? 25. What are the third party tools you are used? 26. What are the system variables you have used? 530
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. 869
E-Mail New Answers        Answer Selected Questions