Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

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 5163

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 5462

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 13828

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 7982

Un-Answered Questions { Databases }

Write the command to remove all players named sachin from the players table.

1236

What found sql?

995

What are the basic functions for master, msdb, model, tempdb databases?

1098

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

1126

What is schema in mysql?

943

How does index help in query performance?

1089

Is primary key indexed by default in postgres?

851

In case you have filters in your report, when filters will be applied in cached report instance?

120

How to remove duplicate rows from table except one?

1070

What are the steps you will take to improve the performance of a poor performing query?

1026

Can a unique key be a foreign key?

883

What do you do in data exploration

1055

What are the various types of snapshots ?

1089

Where not exists in sql?

1038

Disadvantages of the indexes?

1197

For More Un-Answered { Databases } Questions Click Here