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

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2139

What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?

Microsoft, TCS, Techastrum,

3 8482

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

Adsys, Cap Gemini,

15 21889

Dept wise avrage salary

HCL, IBM, TCS,

2 6187

I've looked but can't find a MySQL equivalent for MS SQL's xp_cmdshell. I have 7z files that I want to unzip and load into MySQL. I'm trying to write a sp to do the unzip, but I can't find a way to do that. Can anyone provide an example of a similar process in Windows? TIA.

4045

How do I apply a custom Ribbon after a user logs into the database? I want to use a different ribbon based upon the users level of security. I have 3 levels.

2443

in sql table follw columns r their vehicle_no|servicetype|date|location| 1234 |1FS |1-JAN|PUNE| 4561 |2FS |5-JAN|PUNE| 1234 |PS |7-JAN|PUNE| 1234 |PS |15-JAN|MUMB| i want o/p below vehicleno|1fs|1fsdate|1fslocation|1ps|1PSDATE|1PSLOC|2PS|2PS DATE|2PSLOCA e.g 1234|1FS|1JAN|PUNE|1PS|7JAN|PUNE|2PS|15JAN|MUMBAI PLS help me out to execute using sql query

1 3299

We have a CURSOR then we need BULK COLLECT?

1 3711

What is the Difference beween sql server 2005 and sql server 2008

CMC, Hitech,

3 7016

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

2365

Un-Answered Questions { Databases }

Explain procedure cache and data cache in sybase.

950

Define the one-to-one relationship while designing tables.

941

Mention what are different methods to trace the pl/sql code?

1296

What is ms sql server index?

1153

What are the differences between char and nchar in ms sql server?

1144

How to get help at the sql prompt?

1166

What are the two types of exceptions in pl/sql?

1093

How to connect the oracle server as sysdba?

1132

What is tns service name?

1180

How to clone the database using RMAN back

2316

How do you delete a document from a collection?

Explain how can you save or place your msg in a table?

1078

How to create an initialization parameter file?

1106

Does truncate release storage space?

1137

How do I create a sql database?

1055

For More Un-Answered { Databases } Questions Click Here