adspace


  1. Categories >> Software >> Databases
  2. Suggest New Category


Databases Interview Questions
Questions Answers Views Company eMail

How to write query to select word java's from column employees and from emp table

CGI,

1 3723

What are the dis_advantages of stored procedures, triggers, indexes?

 1 2321

OPTIMIZATION OF SP,CURSOR,TRIGGERS

 1 2911

what is difference between pass by value and eference by value in oracle plsql

 1 6495

How can I sum column wise in Oracle excel report?

 1 5951

Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.

CGI,

5 8677

how to retrieve 1st and last row of table without using group functions??

 6 9066

is it possible to assign two primary key in a table

IBM,

8 12997

what's the difference between SQL & MY-SQl...? And what we learn from these ....?

Broadridge,

2 7996

hai if any one having any project sample table structure please froward to my mail id tauseefwst@yahoo.com

HP,

1 2501

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 5978

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

 2103

what is diffrent between store procedure and trigger

 2 5470

What is the main difference between DBMS and RDBMS?

 3 5863

select Nth highest salary by using rownum

Ford, TCS, Tech Mahindra,

4 22031

Un-Answered Questions { Databases }

what is the command syntax for inserting a document?

70

What versions of clipper does netlib support?

1109

what is dbms? : Sql dba

1073

Any work done in oracle workflow builder. Did you customize or build a new workflow?

60

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?

1925

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1967

What is clustered index

1101

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1225

what are aggregate and scalar functions? : Sql dba

1145

what is schema? : Sql dba

1167

How to convert character strings into numeric values?

1203

What are the types of database explain each of them briefly?

1074

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

1866

How to rebuild the master database?

1176

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1057

For More Un-Answered { Databases } Questions Click Here