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 is blocking and how would you troubleshoot it?

2 5535

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

3 11650

What are the different ways of moving data/databases between servers and databases in SQL Server?

1 4518

What is database replicaion? What are the different types of replication you can set up in SQL Server?

3 6651

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 4241

What is the system function to get the current user's user id?

TCS,

3 9544

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

1 4605

How to call Report from other Report ?

1 8675

what is a sub query?how will you calculate working days in a month using sub query?

InteQ,

4 11927

what is difference between cartesian join & cross join even they give same result?

Bank Of America,

4 14835

What's the difference between a primary key and a unique key?

Wipro,

10 18402

What are the steps you will take to improve performance of a poor performing query?

HCL,

1 10256

What are the steps you will take, if you are tasked with securing an SQL Server?

HCL,

1 7876

What is blocking and how would you troubleshoot it?

HCL,

3 8082

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

HCL,

3 11254

Un-Answered Questions { Databases }

all the queries used in sql

2664

Can we update data in a view?

1040

Why should I use mongodb?

How many rows can be inserted in mysql at a time?

1018

How do I open the query tool in pgadmin?

818

what are the differences between binary and varbinary? : Sql dba

1049

What is mysql connector used for?

951

How to convert numbers to characters in oracle?

1036

Is oracle faster than sql server?

959

What is the difference between mongodb and elasticsearch?

What is clob in mysql

954

What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

4449

How to recreate the index on a firebird table?

914

What is the difference between truncate and delete?

1201

How is data stored in a relational database?

951

For More Un-Answered { Databases } Questions Click Here