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?

944

How do you create a unique index?

1046

How do I create an index in word?

1031

Do we need commit after truncate?

1079

How many unique keys can a table have?

1014

Does indexing improve query performance?

1 1257

Does normalization improve performance?

1038

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?

975

How do you explain an index?

1282

Un-Answered Questions { Databases }

Discuss row chaining, how does it happen? How can you reduce it?

542

What are views in mysql?

930

What is policy based management (pbm)? : sql server database administration

987

What is the best database software for small businesses?

920

What are transactions and its controls?

1061

What is primary key and example?

953

Which command is used to modify the rows?

850

What is the Lock Based Protocol used for?

1082

Write an sql query for deleting duplicate rows?

995

What is difference between views and stored procedures?

989

What is shared lock?

901

What is scope and visibility in PL/SQL?

1204

What are the disadvantages of stored procedures?

979

How to concatenate two binary strings together?

1125

How does sharding work with replication in mongodb?

For More Un-Answered { Databases } Questions Click Here