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


Databases Interview Questions
Questions Answers Views Company eMail

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

 4 7916

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

TCS,

6 11831

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

 1 3316

What is index? How many types of indexes?

HCL,

2 10692

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

Infosys, Sierra Atlantica,

2 11700

what is difference between view and Dip.

IBM, L&T,

1995

what is curser.

 9 10689

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

TCS,

5 12745

wht is normalization?can u explain me in detail?

TCS,

9 15716

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 41019

what are the new features of sql server 2005?

HP, Keane India Ltd,

8 10872

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 4459

what is the bond code in materialized view?

 2489

what is the boundary line in varrays?

HCL,

1 7314

what is explain plan?

 4 19085

Un-Answered Questions { Databases }

How many columns are in access?

421

How do you copy a table in sql?

559

Which is faster union or join?

489

Discuss row chaining, how does it happen? How do you correct it?

281

What is varray?

585




How to access postgresql database from another machine?

399

What is a join in sql? What are the types of joins?

519

What are different types of data models available? Explain with example?

661

What is the use of prepared statement?

536

What is mongoose used for?

1

State some properties of relational databases?

580

How to modify existing triggers using "alter trigger"?

524

What are the functions of commit and rollback statements?

554

How would you identify the shared_pool_size parameter that needs to be adjusted?

1

How to write a query with a right outer join in oracle?

611

For More Un-Answered { Databases } Questions Click Here