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

How can you stop stored procedures from recompiling?

1 970

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

1 1059

What is a livelock?

1 1044

What are alternate keys?

1 1047

What does it mean to normalize a database and why would you do it?

1 1045

‘Order by’ is not allowed in a view how can you sort information from a view?

1 1131

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

1 1008

How do you use a subquery to find records that exist in one table and do not exist in another?

1 1113

Can a cursor be updated? If yes, how you can protect which columns are updated?

1 1210

What is xdr?

1 1062

How can you set the threshold at which sql server will generate keysets asynchronously?

1 1077

Which table keeps information about stored procedures?

1 1013

How is a full-text index updated?

1 1024

Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

1 1017

How can you find out how many rows returned in a cursor?

1 1112

Un-Answered Questions { Databases }

What is self contained sub query?

1138

Have you written applications to retrieve stored images in a table?

1083

How to use values from other tables in update statements using oracle?

1147

How do I remove duplicates in two columns?

1177

what are the advantages of sql ? : Sql dba

1136

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1021

How to put more than 1000 values into an oracle in clause?

1106

how many tables will create when we create table, what are they? : Sql dba

1140

How do I create a trace in sql server?

1110

How to select all columns of all rows from a table in oracle?

1120

How efficient you are in oracle and SQL server?

1251

how to start mysql server? : Sql dba

1258

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

1175

Why should you use or avoid select * statements?

1105

Can you index views?

951

For More Un-Answered { Databases } Questions Click Here