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 a Garbage Collection? and what is full recursive Garbage collection?

RBS,

1 2982

What is the difference between Sleep and Wait? (Java)

RBS,

1 5575

What is the difference between a vector and an Array? (Java)

RBS,

3 7897

How to retrieve data from log files in SQL SERVER ?????

1 6530

How To Change Column Ordinal Position in SQL Server 2005 using Query i.e I Want To Add Column at Particular Ordinal Position in SQL Server 2005

2 9550

How can I give discount condition in a sales table in MS Access?

1 4868

How can I give auto reorder mean when my stock will go below the reorder level at that time automaticaly replace order to supplier?

1 2901

Whether the updations made to the views reflect the original records in the table

NIIT,

5 9739

How can i give the restrictions for the data entry, if i wish to enter only I ,II, III, IV in the grade actegory of student table?

3 6177

By using Macromedia Director How to fetch the data from Microsoft Excel?

1 2316

how to select 5 to 7 rows from a table, which contains 10 rows?

IBM,

21 28022

How to select nth record from a table?

DELL, Microsoft, Ramco,

13 41571

role of sql sever 2005 in database rather than any other database

1 2013

Does aggregate and fact tables gets populated from transactional data with only diffrence in there granularity? Please clarify?

1 3651

1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do

CSC, IBM,

1 2555

Un-Answered Questions { Databases }

Is inner join faster than left join?

1273

How do I find the sql server version?

1099

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

1064

What are the steps in creating a database?

1004

What is an indexed view?

1018

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1021

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1292

What is the primary use of the model database?

1144

List the ways in which dynamic sql can be executed?

1083

Any work done in oracle workflow builder. Did you customize or build a new workflow?

What are the source of constraints?

1006

What is self contained sub query?

1138

Design database draw er diagram for a certain scenario ?

4647

Disadvantages of the indexes?

1218

What versions of clipper does netlib support?

1086

For More Un-Answered { Databases } Questions Click Here