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 single-user mode?

941

What are the differences between ms sql server & oracle?

1063

What part does database design plays a role in performance of an sql server-based application?

986

What do you understand by replication in sql server? Mention the different types of replication in sql server.

947

What is the command dbcc checkdb used for?

1010

Can you name a few encryption mechanisms in sql server?

942

What are subqueries in sql server?

1123

What is the purpose of update statistics and scope_identity() function?

1100

what do you understand by change data capture?

1025

Mention the different types of triggers?

1118

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1164

Explain the properties of subqueries in sql server?

1082

How do you start single user mode in clustered installations?

942

What are the differences between sql server and mysql.

1099

Mention the different types of replication in sql server.

1026

Un-Answered Questions { Databases }

How different is ms access and oracle?

1040

Can two different columns be merged into single column? Show practically?

1066

What does set rowcount do?

910

How to count duplicated values in a column in oracle?

1044

Describe the four types of indexes.

1105

Are sql database names case sensitive?

1006

How do I send sql query results to excel?

1067

What are the differences between clustered and non-clustered index?

1033

What are the applications of database?

886

What is DDL Interpreter?

946

Explain ttitle and btitle.

1120

how do u compile a form i.e .fmb file in Unix or in dos

4573

What is cursor and why it is required?

1183

What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?

621

What are the different oracle database objects?

1092

For More Un-Answered { Databases } Questions Click Here