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

Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this

HCL,

3 5575

HCL,

2 5380

select * from emp what happened internally when we write this query in the sql prompt?

5 7860

how to join two table?

iNautix,

2 5069

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

1 4099

can you explain performance tunning in oracle(sql,PL/SQL)

2 4795

Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.

1 4230

Can we get the deleted Record again if the delete transaction has been committed.

4 6924

DBMS vs. RDBMS

TCS,

2 5523

Un-Answered Questions { Databases }

Why do we use procedures in pl sql?

1076

How to create a store procedure with encryption?

1057

Â How to use an oracle sequence generator in a mapping?

1132

Which are the new data types introduced in sql server 2008?

931

How to change system global area (sga) in oracle?

1067

How to load a large xml file?

1108

Which is the best option used to move database from one server to another serve on same network and why?

581

What is write ahead logging in DBMS?

1142

How do you select a table?

1011

When we should use and scope of @@identity?

1047

as a technical developer in oracle applications which type errors feced in your experience sofar

2236

What is computer end?

969

What do you mean by sql server 2005 express management tools?

1358

Mention how oracle flex asm works?

Mention how can you determine what protocol is being used for interconnect traffic?

For More Un-Answered { Databases } Questions Click Here