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 5447

HCL,

2 5269

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

5 7657

how to join two table?

iNautix,

2 4942

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 4025

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

2 4678

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 4141

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

4 6775

DBMS vs. RDBMS

TCS,

2 5436

Un-Answered Questions { Databases }

RDBMS file system can be defined as

1018

How to connect to oracle using service name instead of sid?

1027

Explain the types of record group.

Define Unique Key?

1021

what is difference between NULL and ISNULL in SQL Server 2008?

1020

If user is owning any SQL Objects, can we drop that user

2080

What is difference between data and database?

1098

What extended events?

1007

What are joins, explain all types of joins?

2299

What stored by the master?

953

What is the purpose of optimization?

998

What is the difference between layer and tier?

895

Define right outer join?

984

Why do we use cursors?

991

Does uninstalling mysql delete database?

1028

For More Un-Answered { Databases } Questions Click Here