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

What is blocking and how would you troubleshoot it?

2 5638

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

3 11790

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

1 4585

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

3 6745

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 4318

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

TCS,

3 9651

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

1 4685

How to call Report from other Report ?

1 8736

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

InteQ,

4 12062

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

Bank Of America,

4 14988

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

Wipro,

10 18672

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

HCL,

1 10346

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

HCL,

1 7958

What is blocking and how would you troubleshoot it?

HCL,

3 8203

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

HCL,

3 11386

Un-Answered Questions { Databases }

what type of index will get created after executing the above statement? : Sql server database administration

1028

Explain some features of neo4j.

If you have an example table, what is the best way to get sizing data for the production table implementation?

601

Explain different backup plans?

1007

What are the two modes of authentication in sql server?

1139

How do I create a database in access 2007?

925

How to transfer data from a cursor to variables with a "fetch" statement?

1148

What is sap sql anywhere?

1171

What is mvcc in postgresql?

892

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2095

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

2195

How do you login to MySql using Unix shell?

1238

What is dense_rank?

990

explain pdq priority?

What is a left join mysql?

949

For More Un-Answered { Databases } Questions Click Here