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,

1187

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,

1066

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

3i Infotech,

1230

How does non-cluster index functions?

Alcatel-Lucent,

1139

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,

1169

How concurrency problems effect the database?

BirlaSoft,

1160

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,

1093

What is the difference between primary and candidate key?

BirlaSoft,

1127

Un-Answered Questions { Databases }

What are the operating systems in which sybase could take its presence?

899

If no size is defined while creating the database, what size will the database have?

991

Explain the different levels at which oracle form services interact.

1054

Segregate database technology's development.

1554

How to define an oracle cursor variable?

1027

What is data modification?

974

Can we join two tables without primary key?

1054

What are the tables in sql?

1087

How many types of dimensions are there and what are they? : sql server analysis services, ssas

1068

How do I view a sql database?

1020

If you are working Microsoft excel, which type of file you used .excel or .csv?

643

How to use "begin ... End" statement structures in ms sql server?

1043

what is difference between delete and truncate commands? : Sql dba

1131

what is a crs resource?

1166

Explain what are the advantages of views?

1069

For More Un-Answered { Databases } Questions Click Here