1. Categories >> Software >> Databases
  2. Suggest New Category


Databases Interview Questions
Questions Answers Views Company eMail

What are the differences between MySQL_fetch_array(), MySQL_fetch_object(), MySQL_fetch_row()?

 2 7350

Explain MySQL optimization?

 1 5318

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 8331

What are the differences between Database Trigger and Integrity constraints ?

Synergy,

2 6161

About types of indexes in SQL server ?

Cognizant,

2 6707

Difference between writing SQL query and stored procedure ?

Cognizant, Infosys, TCS, Veritas,

15 71679

About DTS usage ?

Cognizant, Wipro,

2 7059

How do you optimize Sql queries ?

Cognizant,

1884

Rate yourself in .NET and SQL ?

Cognizant, HCL, SunGard,

1 7926

What are the blocks in stored procedure?

Microsoft,

6 13122

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

BCL, Microsoft,

1 7461

What is normalization and types of normalization?

Etisbew, F-TEC, Microsoft, TechProcess,

22 122593

When would you denormalize?

MBT, Microsoft, MMU,

8 15174

Difference between a query and strored procedure?

Microsoft,

4 8741

What is clustered and non-clustered indexes?

Microsoft,

4 12552

Un-Answered Questions { Databases }

How do I make sql search faster?

547

What is a database table in oracle?

561

What are the types of schemas?

269

what is the difference between union and union all? : Sql dba

537

How do I restore a mysql database dump file in linux?

479




Differentiate between clustered and non-clustered index.

463

How to change server name in sql server?

554

How do I start mongodb on windows?

1

Does mongodb need lots of ram?

1

how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.

1098

Is microsoft access a sql database?

444

change column name and make a unique column so we get no dupes.

490

How does mysql clustering work?

475

What is a database instance?

277

How to use subqueries with the exists operators in ms sql server?

578

For More Un-Answered { Databases } Questions Click Here