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

Explain, why is rdbms better than dbms?

1 1065

What do you mean by cardinality and its types?

1 992

What do you mean by e-r model & object-oriented model?

1 983

Explain the difference between primary and foreign key?

1 1148

Explain the different types of languages that are available in the dbms?

1 965

What is database management system(dbms)?

1 1039

What do you mean by starvation in dbms?

1 1284

What do you mean by deadlock dbms?

1 1172

Explain the components of rdbms?

1 1033

What are alternatives to mongodb?

1 12

Is mongodb better than mysql? Explain

1 14

What is sharding in mongodb? Explain

1 14

What is the difference between mysql and mongodb? Explain

1 13

How we can create an index in mongodb?

1 17

Is mongodb support acid transactions?

1 13

Un-Answered Questions { Databases }

Is it possible to have clustered index on separate drive from original table location?

1026

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1055

Do we need to rebuild index after truncate?

1114

Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:

2297

What is subquery? Explain the properties of a subquery?

1046

What are the steps in creating a database?

985

How do I create a trace in sql server?

1102

what is dbms? : Sql dba

1048

If a cursor is open, how can we find in a pl/sql block?

1226

How many concurrent programs you have customized, can you name some of them?

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1200

Disadvantages of the indexes?

1207

When should you use an instead of trigger?

1033

What are the different SQL Server Versions you have worked on?

1071

What is a coalesce function?

1261

For More Un-Answered { Databases } Questions Click Here