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

Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1411)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

why should required for Indexed by table in pl/sql

3 7874

create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

IBM,

8 11222

What is the difference between Outer join and Full outer join?

5 40458

how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...

ADP, Satyam, Tech Mahindra,

7 14243

which query u can write to sql server doesn't work inbetween 7.00PM to nextday 9.00AM

Wipro,

5 12166

Hello everybody, my self is Imtiyaz, i made a small database programm for challan in MS Access, but i am facing one problem in it... if u have seen any challan, it has few boxes like, crore, lacks, thousands, hundred, ten.....and when you put a figure like 20536, at that time in that boxis TWENTY will wrote in "thousand" box FIVE will be in "hundred" box and THIREE will be in "ten" box...... so, in sort i need to know that how can i do module for this that it appears automatically in perticular boxs...thanks

2 5533

what is vlook up in ms excel and how does it used???

CybAge,

1 5854

HI THIS IS SHEKAR MY QUTION IS IF I HAD 10 YEARS DATA IN MY SOURCE THEN I WANT TO LOAD ONLY LAST YEAR DATA HOW IT IS POSSIBLE BY USING DATASTAGE7.5.

1 3206

can you anybody tell me the how can you restore the master database. while migraion(one server to onther server)?

1 4645

can you any body tell me why are go for the rebuild the master database.what is the reason?

2 4491

what is package and it uses and how can u call a package

Satyam,

1 2091

What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning

TCS,

3 10130

how to delete duplicate rows from a specified table(only single table) how do you know which join is need to be used

UST,

11 19804

how to insert data into partitioned table partition done by Range partition

1 15628

What different of iner joint & outer joint with example

4 10317

Un-Answered Questions { Databases }

How to select all columns of all rows from a table in oracle?

1124

Suppose database is running slow, what will you do?

2590

Explain system functions or built-in functions? What are different types of system functions?

1060

Can one drop a column from a table?

1081

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2176

Do we need to rebuild index after truncate?

1130

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?

1907

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?

1207

How raid can influence database performance?

1114

do you know how to configure db2 side of the application? : Sql server database administration

1118

Why use identity in sql server?

1191

Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:

2308

How to provide default values to function parameters?

1250

what are all the common sql function? : Sql dba

1127

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2348

For More Un-Answered { Databases } Questions Click Here