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 are the differences between having and where clause.

1025

What are the options which must be set to allow the usage of optimistic models?

1030

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

1043

Mention the command used to rename the database.

1055

Mention the differences between sql server and mysql.

1091

What are trace flags and mention a few common trace flags used with sql server?

1145

What are subqueries in sql server? Explain its properties.

1076

What do you understand by mirroring?

1051

What are joins in sql and what are the different types of joins?

1064

How can you check the version of sql server?

1167

Write a query to find 5th highest amount paid from the customer table.

994

What do you understand by physical_only option in dbcc checkdb?

1027

What are the differences between substr and charindex in sql server.

1195

What are relationships and mention different types of relationships in the dbms

1021

What do you understand by integration services in sql server?

1004

Un-Answered Questions { Databases }

Is filemaker pro a relational database?

1114

What does it mean to manipulate data?

1057

What is a filestream?

1052

What it means to be triggered?

1084

What is clob in mysql

1013

What is the difference between upgrade and migration in sql server?

1156

How can you see all indexes defined for a table?

1165

What is an index associated with a constraint?

1095

Can you tell any two advantages of stored procedures?

1097

What is the use of prepared statement?

1082

What are sql server procedures?

1038

what are the features and advantages of object-oriented programming? : Sql dba

1077

How to list all user accounts in oracle?

1070

Explain the advantages of couchdb?

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

2610

For More Un-Answered { Databases } Questions Click Here