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

2 8566

Explain MySQL optimization?

1 6198

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 9987

What are the differences between Database Trigger and Integrity constraints ?

Synergy,

2 7770

About types of indexes in SQL server ?

Cognizant,

2 7977

Difference between writing SQL query and stored procedure ?

Cognizant, Infosys, TCS, Veritas,

15 77784

About DTS usage ?

Cognizant, Wipro,

2 8247

How do you optimize Sql queries ?

Cognizant,

2493

Rate yourself in .NET and SQL ?

Cognizant, HCL, SunGard,

1 9090

What are the blocks in stored procedure?

Microsoft,

6 15657

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

BCL, Microsoft,

1 8409

What is normalization and types of normalization?

Etisbew, F-TEC, Microsoft, TechProcess,

22 130290

When would you denormalize?

MBT, Microsoft, MMU,

8 17928

Difference between a query and strored procedure?

Microsoft,

4 10493

What is clustered and non-clustered indexes?

Microsoft,

4 14294

Un-Answered Questions { Databases }

What is the difference between for xml raw and for xml auto?

1108

Can you index views?

951

Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:

2308

List the ways in which dynamic sql can be executed?

1079

How to put more than 1000 values into an oracle in clause?

1106

Explain system functions or built-in functions? What are different types of system functions?

1057

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1207

Is primary key always clustered index?

1090

What is the difference between case version and decode version?

1102

Explain “row_number()” in sql server with an example?

1071

What are the two main functions of queries in databases?

1522

How do I create a trace in sql server?

1110

What is the current version of postgresql?

1163

Which statement is used in a select query for partial matching?

1239

What are the kinds of subquery?

1099

For More Un-Answered { Databases } Questions Click Here