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 5195

How to update salary of employees department wise?

6 14984

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

2 6512

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 10565

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

3 7237

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

2190

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

2224

Psudo colums

HP,

1 4493

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

IBM,

2 6461

how to call forms in parametar forms

2 5969

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 4774

How to get second highest salary from a table

3 7043

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 6762

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

CTS,

1 4758

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 5990

Un-Answered Questions { Databases }

what are the join types in tsql? : Transact sql

1000

What are local and global variables and their differences?

1059

Is mongodb scalable?

What is sequence in postgresql?

836

You see the following on a status report: redo log space requests 23 redo log space wait time 0 is this something to worry about? What if redo log space wait time is high? How can you fix this?

568

What are two statement types in sql?

1046

How do you use join?

897

Name some usages of database trigger?

976

How do I install mysql on windows 10 64 bit?

877

How to grant create session privilege to a user in oracle?

954

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

977

How to connect Silverlight application to database?

994

What is a postgresql schema?

789

What are the limitations of sql express?

1002

Can excel and access work together?

774

For More Un-Answered { Databases } Questions Click Here