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 7358

Explain MySQL optimization?

 1 5320

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 8351

What are the differences between Database Trigger and Integrity constraints ?

Synergy,

2 6174

About types of indexes in SQL server ?

Cognizant,

2 6718

Difference between writing SQL query and stored procedure ?

Cognizant, Infosys, TCS, Veritas,

15 71739

About DTS usage ?

Cognizant, Wipro,

2 7074

How do you optimize Sql queries ?

Cognizant,

1890

Rate yourself in .NET and SQL ?

Cognizant, HCL, SunGard,

1 7940

What are the blocks in stored procedure?

Microsoft,

6 13155

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

BCL, Microsoft,

1 7478

What is normalization and types of normalization?

Etisbew, F-TEC, Microsoft, TechProcess,

22 122703

When would you denormalize?

MBT, Microsoft, MMU,

8 15196

Difference between a query and strored procedure?

Microsoft,

4 8755

What is clustered and non-clustered indexes?

Microsoft,

4 12578

Un-Answered Questions { Databases }

what is the link between suppliers and banks in ap module in oracle apps? And also query?

2013

What are the main functions of a database management system?

477

Explain having clause and where clause?

576

Explain the role of metadata for the three-layer architecture.

510

What does psql command do?

453




Determine if oracle date is on a weekend?

555

How do you modify a trigger?

524

Can an automatic recovery be initiated by a user?

556

What is the role of database management system?

480

What is the sid in oracle?

534

Can there be more than one function with a similar name in a pl/sql block?

543

How to grant create session privilege to a user in oracle?

567

Can a table contain multiple foreign key’s?

571

List some of the products of sybase.

485

What are fact tables and dimension tables ? What is dimensional modeling and star schema design

443

For More Un-Answered { Databases } Questions Click Here