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 5175

How to update salary of employees department wise?

6 14931

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

2 6476

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 10539

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

3 7211

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

2180

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

2216

Psudo colums

HP,

1 4475

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

IBM,

2 6441

how to call forms in parametar forms

2 5940

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 4760

How to get second highest salary from a table

3 7004

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 6739

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

CTS,

1 4739

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 5940

Un-Answered Questions { Databases }

What methods is used to commit the changes made in DataSet object?

978

Are subqueries faster than joins?

949

How would you import data from another ms access database?

801

What is a DBMS, query, SQL?

995

How do I connect to a database in mysql workbench?

968

Define phantom deadlock.

934

How do I open sybase control center?

889

How to convert the oracle reports to excel sheet from oracle?

How would you lock a table in sybase?

889

What is a sub query and what are the different types of subqueries?

1072

How many segment are present in Oracle Manufacturing

2259

How does db indexing work?

891

How do I start mongodb locally?

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

892

How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?

1874

For More Un-Answered { Databases } Questions Click Here