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 5364

How to update salary of employees department wise?

6 15209

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

2 6640

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 10668

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

3 7365

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

2244

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

2265

Psudo colums

HP,

1 4569

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

IBM,

2 6609

how to call forms in parametar forms

2 6107

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 4888

How to get second highest salary from a table

3 7178

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 6835

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

CTS,

1 4832

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 6166

Un-Answered Questions { Databases }

Explain the main features of couchdb?

Why we use the openxml clause?

1017

Describe the difference between embedded and dynamic sql.

1090

What are the key configuration files for sql server reporting services ?

170

What is a concurrency problem in dbms?

979

How do I install microsoft access 2013?

817

What are different types of data sources?

1023

How to create a stored program unit?

1234

Who developed MongoDB and when?

What is a relation schema?

996

How to copy the tables, schema and views from one sql server to another?

1051

What does tinyint mean?

922

What is the purpose of mysql database?

921

What is Lock table in SQL?

1475

What is normalization? Explain its different types?

1100

For More Un-Answered { Databases } Questions Click Here