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 5583

HCL,

2 5387

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

5 7867

how to join two table?

iNautix,

2 5072

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 4103

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 4233

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

4 6936

DBMS vs. RDBMS

TCS,

2 5523

Un-Answered Questions { Databases }

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1137

You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?

642

What is out parameter used for eventhough return statement can also be used in pl/sql?

1128

What is a table index in oracle?

1187

What are the advantages of sql azure?

140

What are the various levels of constraints?

1171

What kind of database is postgres?

852

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1128

What are page splits?

1056

What is the best database software for small businesses?

985

What is the maximum number of columns in sql table?

1232

Explain armstrong rules? How they are complete and/or sound?

953

What is full form of xampp?

1238

How do I create an extended event in sql server?

1005

Does unique index improve performance?

854

For More Un-Answered { Databases } Questions Click Here