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

Where can you add custom error messages to sql server?

1138

What is the primary use of the model database?

1105

what is the difference between openrowset and openquery?

1102

Why and when do stored procedure recompile?

999

How can you append an identity column to a temporary table?

979

What is the difference between for xml raw and for xml auto?

1048

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?

1148

Why should you use or avoid select * statements?

1044

When should you use an instead of trigger?

983

What is an indexed view?

982

How can you know if the row fetched from cursor is still valid in underlying table?

1014

What is the difference between a primary key and a unique key? Are they the same?

1087

how you can list all the tables in a database?

1045

What is a mixed extent?

1043

After removing a table from database, what other related objects have to be dropped explicitly?

1076

Un-Answered Questions { Databases }

How do you use automatic pga memory management with oracle 9i and above?

602

Write the command to remove all players named sachin from the players table.

1193

How do you handle your own transaction?

1022

what protocol both networks use? : Sql server database administration

987

What is plpgsql language?

1078

Why is oracle used?

963

Where is the mysql database stored?

928

Can you rename a database in mysql?

1046

What is delete command in sql?

1129

How to connect mongodb with visual studio 2017?

When you use CKM?

593

What is the difference between writing data to mirrored drives versus raid5 drives

949

Is the After report trigger fired if the report execution fails ?

2928

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1049

How to find out what is the default collation in a database?

1139

For More Un-Answered { Databases } Questions Click Here