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

1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]

2 11734

what is the main difference between myisam and innodb

Wipro,

2 6770

logshipping is Any difference 2000 and 2005?

2 4854

a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution

TCS,

2275

how to send multiple records which matches all the condition in the lookup transformation ? (if lookup matches the codition for duplicate values)

2069

how to get the values if source table & target table having duplicate values that matches the lookup condition ?(i want all duplicate match)

1 3550

how to make an oracle object

2372

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

2034

Un-Answered Questions { Databases }

What is full outer join in sql server joins?

1080

How do rank () and dense_rank () differ?

1059

What are the benefits of triggers?

1183

List and explain the different types of join clauses supported in ansi-standard sql?

1365

What is the difference between database and server?

1039

Does mongodb support primary-key, foreign-key relationship?

How can we find out the duplicate values in an oracle table?

1064

What is design view in ms access?

858

How do I become a dba?

589

What is foreign key sql?

997

Where is dbms used?

1092

What is using in sql?

1105

What is mysql_pconnect?

922

What is default schema in mysql?

940

What is regex in mysql?

1098

For More Un-Answered { Databases } Questions Click Here