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 new changes are being made in SQL Server?

Blue Star,

1275

Under which circumstance should you create an index on a table?

3i Infotech,

1235

What is a super key?

3i Infotech,

1084

Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?

3i Infotech,

1170

Which three commands cause a transaction to end?

3i Infotech,

1122

You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?

3i Infotech,

1269

How does non-cluster index functions?

Alcatel-Lucent,

1183

What are the tools used for backup and ticketing?

Alcatel-Lucent,

1037

What is the difference between oracle and MS Access?

Alcatel-Lucent,

1110

What is the function of cluster index?

Alcatel-Lucent,

1222

How concurrency problems effect the database?

BirlaSoft,

1212

What does specialization in DBMS mean?

BirlaSoft,

1204

What is a sequence? Explain it with one example?

BirlaSoft,

1281

What is the candidate key used for?

BirlaSoft,

1133

What is the difference between primary and candidate key?

BirlaSoft,

1193

Un-Answered Questions { Databases }

Discuss row chaining, how does it happen? How do you correct it?

601

How to create a Master database in SQL server ?

1145

Can there be 2 primary keys in a table?

1047

What are the differences between hash join, merge join and nested loops?

1069

Which function is used to return remainder in a division operator in sql?

1207

What is difference between inner join and join?

1096

What are the steps you must follow to hide sql server instances?

1033

How to display Row Number with Records in Oracle SQL Plus?

1096

What are the rules to be applied to nulls whilst doing comparisons?

1373

List the different types of normalization?

994

what is a view? : Sql dba

1137

Is there any restriction on the use of union in embedded sql?

1205

What is the benefit of database?

934

Which is better varchar or nvarchar?

1053

How to dump one database for backup.

990

For More Un-Answered { Databases } Questions Click Here