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 are the diifferences between the ms sql server vs mysql?

1175

Which autogrowth database setting is good?

1059

What types of replication are supported in sql server?

1063

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

944

What is not null constraint?

1122

How to get nth highest salary from employee table.

1163

How would you add a section to a table?

1044

What do you mean by stored techniques? How would we use it?

1034

What does the argument [or replace] do?

1082

what are integrity rules?

1026

What are %type and %rowtype for?

1052

What is a sql profiler?

1025

How to select 10 records from a table?

1157

How many times can we commit in a loop?

1017

What is data manipulation language?

1187

Un-Answered Questions { Databases }

What is limit in dbms?

1048

What are the export options of ssrs?

173

Is it possible to have clustered index on separate drive from original table location?

967

How can you do replication?

Why are you getting errors when creating a new odbc dsn?

1223

How do I make my sql query run faster?

941

What are the functions of administration?

554

How can delete duplicate records in cte in sql server?

964

What is a transactions?

1041

Can I join the same table twice?

1043

In DBMS, what are the two integrity rules used?

944

What is the use of drop command and what are the differences between drop, truncate and delete commands?

1101

How to get help information from the server?

1053

What does <> symbol mean?

974

What is raid, and how it can influence database performance?

1054

For More Un-Answered { Databases } Questions Click Here