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 we delete a table in sql server?

1 1046

Can sql server be linked with other servers like oracle?

1 1049

What are the hotfixes and patches in sql server?

1 1083

What is the recursive stored procedure in sql server?

1 1103

What is the difference between the application object and session object?

1 1146

Describe the types of keys?

1 1224

What is the difference between a shared lock and exclusive lock?

1 1242

How many types of database languages are?

1 1003

What do you mean by extension and intension?

1 1129

When does checkpoint occur in dbms?

1 1104

What do you mean by durability in dbms?

1 1128

Explain the functionality of dml compiler.

1 1071

What do you mean by transparent dbms?

1 1496

Define a relation schema and a relation.

1 1197

What are the integrity rules in dbms?

1 1194

Un-Answered Questions { Databases }

What is a coalesce function?

1276

how to start mysql server? : Sql dba

1263

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

1110

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

1124

Disadvantages of the indexes?

1220

What is a concurrency problem in dbms?

1050

What are the source of constraints?

1006

Explain “row_number()” in sql server with an example?

1073

What is oracle latest version?

1171

How do I start sql server 2017?

1012

What are wait types?

1245

How efficient you are in oracle and SQL server?

1254

Can you index views?

953

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

1021

How do I remove duplicates in two columns?

1179

For More Un-Answered { Databases } Questions Click Here