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 many primary keys are possible in a table?

966

What are the parts of a function?

995

Is a primary key unique?

1041

Can primary key be a foreign key?

1122

What are key constraints?

1024

How do I make an action query?

1002

How do I rename a procedure?

935

How do stored procedures work?

1128

How do you create a primary key?

1064

How do you create a schema?

1013

How do you flush privileges?

1022

How do you insert a table?

973

How do you name a table?

942

How do you rename a table?

1050

How do you select a table?

1016

Un-Answered Questions { Databases }

How to calculate the difference between two time values?

1073

What is user and end user?

966

HOW TO SPOT AHIERARCHY?

2353

What happens when my integer identity runs out of scope?

1086

How to update muliple row in single query?

1126

How to call a javascript function from pl sql?

1198

List the important features of mongodb.

What is a sql schema used for?

1169

What is the command used to fetch first 5 characters of the string?

1469

How to create median function?

172

Explain about Microsoft access?

916

Can the “if update (colname)” statement be used in a delete trigger?

1045

You look at the dba_rollback_segs view and see that there is a large number of shrinks and they are of relatively small size, is this a problem? How can it be fixed if it is a problem?

848

Explain steps of normalization?

1075

Do you know what is blocking?

1001

For More Un-Answered { Databases } Questions Click Here