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

I need to write a simple query,which one is better select statement or stored procedure?and why?

iGate,

2 7122

how can we write a column values horizontal by using sql stmt; ex: select name from table_name;(actual output) a b c d require output is a b c d

Honeywell, Interact,

5 13773

How can we join three tables in SQL server 2000

Intelligroup,

2 4728

how will you find out the last three records in a table with n no of records and delete them

3 6232

if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 as it is,how?

1 3786

if 3 duplicate records in table,i want to delete 2 alternating duplicate records by keeping 1 duplicate and 1 original as it is,how?

2 3892

if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 duplicate and 1 original as it is,how?

5 8969

can we pass two out parameters at a time in function?please answer to my question

Wipro,

3 6241

please tell me the informatica telecom projects interview question? like if they ask about project explanation and the difficulties and the solutions taken to solve the issues for telecom projects,e.g i am workin for a vodafone project handlin postpaid section,pls tell me wat wud be the process if i work in this ? thanks

8565

How to delete the duplicate rows from a table in SQL Server ??

3 7412

i have a word ***********hello********world******. I require a o/p **********hello world**********, Need to delete the middle stars.

3 6951

If we have n no of columns in a table, can we add new column in that table with not null constraint?

2 5986

types of receipts and detail desription about recipts and tables effected by receipts?

2120

dear sir please provide what question will be asked in bank it officer interview

2178

dear sir please provide what question will be asked in CWE in bank it officer

2288

Un-Answered Questions { Databases }

What is a view? How it is related to data independence?

972

How do I change the order of columns in postgresql?

932

Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

2266

Why do we use set serveroutput on?

1015

What is optimistic concurrency control? : Transact sql

1031

What is application trigger?

1056

How do you change a value in sql?

1068

What is data sparsity and how it effect on aggregation?

997

explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

2550

Is sql a case sensitive language?

1010

Who is the founder of database?

1214

What are foreign keys in database?

1045

Explain the difference between primary keys and foreign keys?

1103

What is difference between procedure and trigger?

1022

What are data modelling tools?

976

For More Un-Answered { Databases } Questions Click Here