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

Which four data types cannot be used as a return type from a user-defined function?

1 1081

How can you log an error to the server event log from a stored procedure?

1 1194

If a column is an image value type, how you can compare column values? How can you use this column in join clause?

1 1063

You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?

1 1146

You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

1 1048

How can I detect whether a given connection is blocked?

1 1143

The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?

1 1065

Explain the rollup operator?

1 1166

How many types of stored procedures are there in sql server?

1 1085

What is the purpose of linked server configuration in sql server?

1 1120

In how many ways you can invoke ssrs reports?

1 223

Explain the advantages and disadvantages of stored procedure?

1 1222

What are stand-alone procedures?

1 1026

Mention how can you determine what protocol is being used for interconnect traffic?

1 64

Mention what are the benefits of oracle rac?

1 65

Un-Answered Questions { Databases }

How do I find query history in sql server?

1018

How did mongodb get its name?

i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: summi4you@yahoo.co.in

1856

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2088

Do we need to rebuild index after truncate?

1128

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2701

Does view occupy space?

1005

What are the different types of subquery?

1228

What are the advantages of database?

1009

How to select all columns of all rows from a table in oracle?

1123

what is collation? : Sql dba

1224

What is acid mean in sql server?

1237

what are the advantages of sql ? : Sql dba

1137

When should you use an instead of trigger?

1042

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1189

For More Un-Answered { Databases } Questions Click Here