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

Oracle (3253)
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 5460

How to update salary of employees department wise?

6 15394

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

2 6726

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 10777

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

3 7479

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

2284

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

2305

Psudo colums

HP,

1 4637

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

IBM,

2 6697

how to call forms in parametar forms

2 6212

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 4971

How to get second highest salary from a table

3 7298

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 6914

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

CTS,

1 4911

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 6293

Un-Answered Questions { Databases }

How big is a blob mysql?

937

What is an indice?

1085

How can I get data from a database on another server?

1047

What are the variable types?

669

What is Difference Between Unique and Primary Key Constraints?

1153

What type of database is postgres?

838

What is the relation between database and instance?

691

What do you understand by the term 'normalization'?

710

What is clause?

1228

Explain datetime2 data type in sal server 2008?

951

What are some emotional triggers?

1033

Can we rollback truncate?

1049

Can we rename a column in the output of sql query?

1039

What is pivot and unpivot?

1065

What is a trigger what are the advantages of trigger?

1062

For More Un-Answered { Databases } Questions Click Here