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

Blue Star,

1125

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

3i Infotech,

1119

What is a super key?

3i Infotech,

993

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

3i Infotech,

1082

Which three commands cause a transaction to end?

3i Infotech,

1022

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

3i Infotech,

1191

How does non-cluster index functions?

Alcatel-Lucent,

1100

What are the tools used for backup and ticketing?

Alcatel-Lucent,

975

What is the difference between oracle and MS Access?

Alcatel-Lucent,

1042

What is the function of cluster index?

Alcatel-Lucent,

1117

How concurrency problems effect the database?

BirlaSoft,

1112

What does specialization in DBMS mean?

BirlaSoft,

1115

What is a sequence? Explain it with one example?

BirlaSoft,

1122

What is the candidate key used for?

BirlaSoft,

1053

What is the difference between primary and candidate key?

BirlaSoft,

1085

Un-Answered Questions { Databases }

Is sqlite faster than mysql?

895

What do you mean by oracle dba and what is its role?

546

Mention in rac what files should be created on shared storage?

Why join is faster than subquery?

1065

What are the limitations of check constraint?

978

how Data is stored in a file so that Direct Searching can be performed

981

WHAT IS CARDINALITIES OF JOIN?

2328

What is table value parameters (tvp)?

1053

How view is related to data independence?

920

What are the two different parts of the pl/sql packages?

1045

What is resource db in sql server?

975

Explain trigger and trigger types?

925

What is sqlservr exe?

955

Is join same as left join?

993

How do I make a pgadmin server?

845

For More Un-Answered { Databases } Questions Click Here