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 11714

what is the main difference between myisam and innodb

Wipro,

2 6758

logshipping is Any difference 2000 and 2005?

2 4847

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,

2270

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

2058

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

1 3534

how to make an oracle object

2363

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

2022

Un-Answered Questions { Databases }

Is sql an operating system?

1021

What is unsigned in mysql?

942

How does limit work in mysql?

911

What is scalar and vector?

1008

Give the advantages and disadvantages of clusters.

1052

How do I view a sql database?

1023

What does truncate do?

943

What is snapshot parameter in ssrs?

151

Can I learn sql in a week?

1083

Explain the role of building blocks like Nodes, Relationships, Properties and Labels in Neo4j?

What does where 1/2 mean in sql?

1088

How can you ensure that the database and sql server based application perform well?

1085

How to connect to the server with user account: sys?

1024

What are the 'mysql' command line options?

998

What happens when unicode strings concatenate with non-unicode strings?

1102

For More Un-Answered { Databases } Questions Click Here