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,

1186

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

3i Infotech,

1165

What is a super key?

3i Infotech,

1039

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

3i Infotech,

1116

Which three commands cause a transaction to end?

3i Infotech,

1065

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

3i Infotech,

1229

How does non-cluster index functions?

Alcatel-Lucent,

1137

What are the tools used for backup and ticketing?

Alcatel-Lucent,

998

What is the difference between oracle and MS Access?

Alcatel-Lucent,

1071

What is the function of cluster index?

Alcatel-Lucent,

1167

How concurrency problems effect the database?

BirlaSoft,

1159

What does specialization in DBMS mean?

BirlaSoft,

1158

What is a sequence? Explain it with one example?

BirlaSoft,

1190

What is the candidate key used for?

BirlaSoft,

1091

What is the difference between primary and candidate key?

BirlaSoft,

1126

Un-Answered Questions { Databases }

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

1034

What does a dba do all day?

553

How to optimize stored procedure optimization?

892

What is the purpose of sql?

944

What is primary key and foreign key?

960

What is the difference between having clause and where clause in sql server?

1099

How do you exit a database?

897

What are the types of queries?

944

Explain the steps to create and execute a user-defined function in the sql server?

967

How do I clear the command in mysql?

944

What do you understand by aggregation and atomicity?

918

How can I create a new template for import ? : sql server management studio

1071

What is multilevel indexing?

927

How to execute a stored procedure in ms sql server?

1175

Is natural join and inner join same?

926

For More Un-Answered { Databases } Questions Click Here