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

Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1411)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

One table how may column and Primary key

3 5353

How to update salary of employees department wise?

6 15195

what are the methods using performance tunning in sql and pl/sql

2 6629

i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.

IBM, Loginworks, OFSS,

2 10660

How do you display "13th of November, 17 days left for month end" without hardcoding the date.

3 7359

How do you use collections in procedure to return the resultset?

2238

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2265

Psudo colums

HP,

1 4560

how will you see when the database was started using sql prompt?

IBM,

2 6603

how to call forms in parametar forms

2 6097

how to create parameterised form in oracle 10g? and create another form from the value of the form? AND how to assign value to a parameter? sincerly your mamun

2 4883

How to get second highest salary from a table

3 7168

How can i retrieve the pseudoColumn values of a table in sybase? In oracle, we can get the same as 'ROWID'. Likewise in sybase which one is pseudo column?

1 6831

In TeraData We have 5 SQL queries, without using BTEQ how can we execute those queries?

CTS,

1 4825

If we execute an query in MLOAD it's ran successfully, my questions is after successfully ran MLOAD. In error tables we can see anything there! is it possible than what are they?

CTS,

3 6158

Un-Answered Questions { Databases }

Can you tell how many values can set the function of mysql to consider?

988

What are the properties and different types of sub-queries?

1011

What is dialect in database?

977

Which type of cursor is used to execute the dml statement?

958

Describe how to use linked server?

1020

What is sql partition function?

1212

The in operator may be used if you know the exact value you want to return for at least one of the columns.

1133

What are character functions in sql?

939

Find first and last day of current month in sql server

1028

Can we connect to postgresql using sql developer?

1009

How many rows can an access table hold?

890

Is mysql is a programming language?

994

What are sql triggers used for?

995

What is the sql case statement?

1008

Explain the dbcc pintable command when would you use it?

921

For More Un-Answered { Databases } Questions Click Here