Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.

247Customer,

3 6591

Differences between functions and stored procedures?

247Customer, Accenture,

8 16118

Can we have more than one NULL in a column having unique constraint?

247Customer,

12 17194

1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records

1 5098

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

1 3416

In workflow how can we send a notification to the Supplier giving the Corresponding report Details.

1 1982

what is null value?

9 10943

How to recompile a already made trigger?

2 11983

What is the difference between SQL Constraint and PL/SQL constraint.Pls give all the constraint name.

TCS,

3 8833

how to get enames with comma seperated values by deptwise on emp table?

8 12193

what is transaction state, buffer management, shadow paging

1 3531

Un-Answered Questions { Databases }

Does group by remove duplicates?

1112

What is acid mean in sql server?

1237

What is the current mysql version?

1093

Why should you use or avoid select * statements?

1106

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

2088

What is standby servers? Explain types of standby servers.

1072

Can we do dml on views?

1032

How to convert character strings into numeric values?

1186

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? IBM 1. What is virtual dataset? 2. How do you handle reject link to a peek stage? 3. What is transaction table? 4. Which one is the efficient from the following? a. ODBC enterprise b. Oracle enterprise 5. How can you extract data from excel sheet? Do you know how to parameterize, this option? 6. Six pages of complex query I have, how do you simplify this query? 7. Difference between dataset and lookup file set?

1981

How to define array in mongoose schema?

What is the best sql course?

1046

Equi join and non equi join is possible with sql server?

1126

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2209

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8225

what is the difference between openrowset and openquery?

1186

For More Un-Answered { Databases } Questions Click Here