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 are the differences between MySQL_fetch_array(), MySQL_fetch_object(), MySQL_fetch_row()?

2 8414

Explain MySQL optimization?

1 6073

The table tbl_sites contains the following data: ----------------------------------------------------- Userid sitename country ------------------------------------------------------ 1 sureshbabu indian 2 PHPprogrammer andhra 3 PHP.net usa 4 PHPtalk.com germany 5 MySQL.com usa 6 sureshbabu canada 7 PHPbuddy.com pakistan 8. PHPtalk.com austria 9. PHPfreaks.com sourthafrica 10. PHPsupport.net russia 11. sureshbabu australia 12. sureshbabu nepal 13. PHPtalk.com italy Write a select query that will displayed the duplicated site name and how many times it is duplicated?

Afixi, GE,

4 9771

What are the differences between Database Trigger and Integrity constraints ?

Synergy,

2 7598

About types of indexes in SQL server ?

Cognizant,

2 7821

Difference between writing SQL query and stored procedure ?

Cognizant, Infosys, TCS, Veritas,

15 76979

About DTS usage ?

Cognizant, Wipro,

2 8115

How do you optimize Sql queries ?

Cognizant,

2430

Rate yourself in .NET and SQL ?

Cognizant, HCL, SunGard,

1 8975

What are the blocks in stored procedure?

Microsoft,

6 15320

How do you handle exceptions. Give the syntax for it?

BCL, Microsoft,

1 8321

What is normalization and types of normalization?

Etisbew, F-TEC, Microsoft, TechProcess,

22 129338

When would you denormalize?

MBT, Microsoft, MMU,

8 17574

Difference between a query and strored procedure?

Microsoft,

4 10269

What is clustered and non-clustered indexes?

Microsoft,

4 14090

Un-Answered Questions { Databases }

What is maintaining database?

903

What happens if you delete a table that is used by a view?

990

How to run queries with sql server management studio express?

1095

What is merge?

1021

How can we identify the resources for which the sessions are waiting?

What is view in sql?

911

Is sql is a dbms?

914

Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

2525

What are the features of database language?

1038

Why place tempdb and log on low numbered devices?

835

Can a commit statement be executed as part of a trigger?

1055

What is raw datatype in oracle?

1137

Can group functions be mixed with non-group selection fields?

1020

What is dao recordset in access?

909

Tell me about normalization in DBMS.

998

For More Un-Answered { Databases } Questions Click Here