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

What is normalization of database?

1126

Where do we use trace frag?

1032

Describe in brief authentication modes in sql server.

1042

What is indexed view? How to create it?

1034

What is difference between view and materialized view?

947

Can you explain about buffer cash and log cache in sql server?

967

What are partitioned views?

1019

How to create indexed view?

1062

What are the types of subquery?

1054

Difference between report and query parameter.

1109

Explain the dirty pages?

1020

What are magic tables in sql server?

1150

List few advantages of stored procedure.

993

What is the difference between locking and multi-versioning?

1003

Differentiate between a local and a global temporary table?

972

Un-Answered Questions { Databases }

How to define an anonymous block?

1179

Explain intellisense for query editing

1041

Explain the difference between mysql_fetch_array(), mysql_fetch_object()?

959

Explain index in sql server?

1032

Can we use redis as database?

1000

What is the maximum length of an extended property?

999

explain different types of joins? : Sql server database administration

1000

What are commit and rollback in sql?

1142

How can we check whether A S M instance is up or down?

2436

Is sybase a database? Explain.

976

How to backup encryption key ?

185

What is the maximum size per database for sql server express?

1067

What is the maximum size of table in mysql?

1042

Where is mongodb headquarters?

Explain view?

1058

For More Un-Answered { Databases } Questions Click Here