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

What is the difference between indexing and hashing?

1 1242

What is difference between rownum and rowid?

1 962

What is a document index?

1 1081

What is difference between joins and subqueries?

1 1177

What is a rownum?

1 1074

What is the difference between count () and rowcount ()?

1 1085

What is the difference between clustered index and primary key?

1 976

What is a non clustered primary key?

1 978

What is the process of indexing?

1 1068

What is the difference between row_number and dense_rank?

1 941

What is the difference between count and distinct count?

1 939

What is the datatype of rowid?

1 977

What is a natural primary key?

1 1124

What is an inner join?

1 1050

What is an example of a primary key?

1 1044

Un-Answered Questions { Databases }

How do I find query history in sql server?

1000

What is a coalesce function?

1261

List the ways in which dynamic sql can be executed?

1071

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?

1200

Do we need to rebuild index after truncate?

1112

How to rebuild the master database?

1148

Can we rollback truncate?

1057

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1118

what is the difference between openrowset and openquery?

1174

what is the last version,the release date of that version and fix pack of ibm db2 udb?

2035

Disadvantages of the indexes?

1205

Is microsoft getting rid of access?

877

What are the two main functions of queries in databases?

1509

If a cursor is open, how can we find in a pl/sql block?

1225

What is the current mysql version?

1082

For More Un-Answered { Databases } Questions Click Here