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

Oracle (3259)
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

Can unique keys be null?

908

Does truncate need commit?

942

How do you create a unique index?

1046

How do I create an index in word?

1031

Do we need commit after truncate?

1078

How many unique keys can a table have?

1013

Does indexing improve query performance?

1 1257

Does normalization improve performance?

1034

How can you tell the difference between an index and a view?

937

Do we need to create index on primary key?

929

How many columns should be in an index?

963

How is indexing done in search engines?

982

How many subqueries can be nested in a statement?

982

How many clustered indexes can you have?

973

How do you explain an index?

1282

Un-Answered Questions { Databases }

Is nosql relational?

943

What is the query to display top 20 rows?

1017

what are the limitations of identity column? : Transact sql

1108

Name three of the features managed by the surface area configuration tool? : sql server security

990

What types of locking use in mongodb?

What are commonly used odbc functions in php?

1014

What are constraints?

1009

What is the minimum client footprint required to connect c# to an oracle database?

1092

How to present flrehird.log file from filling up the disk partition?

if the source have total 15 records with 2 records are updated and 3 records are newly inserted at the target side we have to load the newly changed and inserted records

549

How do I find the port number for sql server?

971

What is the newest version of microsoft access?

804

What are the advantages of using microsoft access?

1021

You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?

961

How to count groups returned with the group by clause in oracle?

1075

For More Un-Answered { Databases } Questions Click Here