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


Databases Interview Questions
Questions Answers Views Company eMail

What is the difference between oracle CPU and PSU?

 2 19488

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

Microsoft,

1451

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

Microsoft,

1512

which backup strategy you are following at ur company

 1728

your distribution database is full what will u do

 1676

Differences between logshipping and mirroring

Microsoft, Syntel,

1 4507

tell me the disaster recovery plan

Microsoft,

2021

application server is slow what may be the problem

Microsoft,

1781

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 2272

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 5267

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 3048

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 4027

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 4734

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 11661

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 6659

Un-Answered Questions { Databases }

What are the four objects in a database?

502

Differentiate between a having clause and a where clause.

518

How many sql core licenses do I need?

507

Explain indexed views and partitioned view with their syntax.

682

Which function is used to create an index?

5




You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?

110

Does postgres support json?

435

How to create a scrollable cursor with the scroll option?

494

Will mysql remain free?

504

State the criteria which a trusted publisher should meet before adding him?

481

Explain the types of database normalization?

480

What is create database?

441

Can primary key be null postgres?

436

what is a self join? Explain it with an example? : Sql server database administration

495

Can sql function call stored procedure?

556

For More Un-Answered { Databases } Questions Click Here