Databases Interview Questions
Questions Answers Views Company eMail

write a query to delete similar records in different tables with same structure

4 7949

write a query to delete similar records in particular fields(columns) in different tables

TCS,

6 11871

Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?

1 3324

What is index? How many types of indexes?

HCL,

2 10706

what are the optimization techniques for Query optimization performance issues and faster execution of queries

Infosys, Sierra Atlantica,

2 11717

what is difference between view and Dip.

IBM, L&T,

2003

what is curser.

9 10746

what is Data Transformation Services (DTS) ?can u explain me in detail?

TCS,

5 12779

wht is normalization?can u explain me in detail?

TCS,

9 15751

what are the main differences between MyISAM and InnoDB table storage structures ? what are the advantages and disadvantages in usage of these ?

E2 Solutions, Tesco,

10 41068

what are the new features of sql server 2005?

HP, Keane India Ltd,

8 10902

Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?

HP,

1 4473

what is the bond code in materialized view?

2490

what is the boundary line in varrays?

HCL,

1 7329

what is explain plan?

4 19124


Un-Answered Questions { Databases }

Is pdo faster than mysqli?

473


What is bind variable in pl sql?

532


How useful is microsoft access?

452


What is sql in java?

548


How do you use a while loop in pl sql?

539






How to create an identity column?

644


What is limit in mysql?

445


What is a trigger in sql?

642


State some criteria and their effects of a database?

518


What program is used to store the data source file?

505


How to replace given values with null using nullif()?

578


What is maintaining database?

505


What is prepared statement in mysql?

493


What mysql means?

493


What is the command that can be used to allocate memory in postgreSQL?

956