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

RBS,

2915

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

RBS,

1 5487

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

RBS,

3 7702

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

1 6431

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 9445

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

1 4751

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

2801

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

NIIT,

5 9501

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 6032

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

2249

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

IBM,

21 27262

How to select nth record from a table?

DELL, Microsoft, Ramco,

13 40926

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

1954

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

1 3562

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,

2507

Un-Answered Questions { Databases }

what are the two integrity rules used in DBMS?

1130

What is named query? : sql server analysis services, ssas

976

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1105

how to extract a unit value from a date and time? : Sql dba

1003

How to drop an existing user defined function in ms sql server?

1039

How to connect to sybase database from linux?

1004

What is a covered index?

949

Explain the difference between HTTP and HTTPS in database?

1047

How to call shell script from pl sql procedure?

1292

Why do we use preparedstatement?

948

What are the main differences between the two?

904

How much does mysql enterprise cost?

934

Explain what is scheduled job and how to create it?

971

What is 1nf in database?

1006

How do you remove a foreign key constraint?

816

For More Un-Answered { Databases } Questions Click Here