Databases Interview Questions
Questions Answers Views Company eMail

What is the difference between oracle CPU and PSU?

2 19500

how to use DTS package in 2000,2005,2008 in sql server

Microsoft,

1457

on line cluster can we make if yes tell me the procedure

Microsoft,

1517

which backup strategy you are following at ur company

1735

your distribution database is full what will u do

1683

Differences between logshipping and mirroring

Microsoft, Syntel,

1 4529

tell me the disaster recovery plan

Microsoft,

2028

application server is slow what may be the problem

Microsoft,

1785

I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.

IBM, Wipro,

1 2277

Whether Oracle satisfy more codd rules or db2 satisfy more codd rules? How meny of each can satisfy ? Please answer me. Advance thanks

IBM,

2 5283

I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.

IBM,

2 3064

Hi, I want table structure shown below. How can i create this ? Num Name Address Addr1 Addr2 I want Addr1 and Addr2 under Address column. How can i achive this ? Is it possible ?

IBM,

2 4042

write a query filter the null value data following source? name age john 30 smith null null 24 sharp 35 i want output name age john 30 sharp 35

TCS,

1 4755

wirte a query to remove null? following table are col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output like col1 col2 col3 dinesh suresh prkaesh

TCS,

6 11690

write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh

TCS,

3 6683


Un-Answered Questions { Databases }

How to change varchar(m) to varchar(n) in sybase?

468


what is collation? : Sql dba

620


What are the main differences between primary key and unique key?

503


What is app tier?

485


How to make a remote connection in a database?

535






How do you optimize a stored procedure query?

570


Suppose database is running slow, what will you do?

2089


Can you leave a union at any time?

546


How many indexes can be created on a table in sql?

498


Where is mysql used?

524


what is a control file ? : Sql dba

581


What is scalar function in sql?

536


What is field size access?

415


What is a cursor variable?

580


What do you know by pl/sql cursors?

574