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

How to enter Characters as HEX Numbers?

1 1076

What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?

1 1014

How can I insert images into a Mysql database?

1 1128

What type of Index will get created after executing the above statement?

1 1168

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 1108

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

1 1152

What do you think of this implementation? Can this be implemented better?

1 1015

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

1 1270

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

1 1244

What is the New in SQL server 2008?

1 1033

What are the types of indexes?

1 1165

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

1 1198

What is DML Compiler?

1 1069

What is Record-at-a-time?

1 912

What is an Entity?

1 941

Un-Answered Questions { Databases }

List the ways in which dynamic sql can be executed?

1079

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

1125

What is the difference between upgrade and migration in sql server?

1173

How do I create a trace in sql server?

1109

Is it possible to have clustered index on separate drive from original table location?

1034

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

8225

How to write a left outer join with the where clause in oracle?

1149

How to convert character strings into numeric values?

1186

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

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

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

1945

What are wait types?

1235

What are the different types of subquery?

1228

How to connect php with different port numbers?

1177

What is the latest version of postgresql?

949

For More Un-Answered { Databases } Questions Click Here