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 11837

what is the main difference between myisam and innodb

Wipro,

2 6923

logshipping is Any difference 2000 and 2005?

2 4989

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,

1 2340

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

1 2128

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

1 3662

how to make an oracle object

1 2424

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

1 2092

Un-Answered Questions { Databases }

What are the kinds of subquery?

1101

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8225

What are the properties of the transaction?

1069

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2348

What is subquery? Explain the properties of a subquery?

1056

How do I create a trace in sql server?

1112

What is the difference between upgrade and migration in sql server?

1179

Where can you add custom error messages to sql server?

1203

What is sql server query analyzer?

1123

What is acid mean in sql server?

1237

What is the current version of sql?

1091

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1293

Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com

1895

How to remove duplicate rows from table except one?

1081

in oracle BPM composer in part BA model on design model in enterprise model i cannot connection with value chain model work not links in part properties do you can me help me?

1605

For More Un-Answered { Databases } Questions Click Here