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 4729

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

3 6236

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

1 3787

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 3893

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 8970

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 7413

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

3 6952

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

2 5987

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

2121

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

2289

Un-Answered Questions { Databases }

What happens if you delete a table that is used by a view?

1064

what is a mixed extent? : Sql server administration

1177

What are the types of index?

997

How to get data from mongodb in flask?

How does sql store data?

960

What do you understand by mirroring?

1046

What is sql in mysql?

1089

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

1062

Is postgres a mpp?

963

What are the applications of database management system?

957

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

1057

What is the latest version of microsoft sql server?

1117

How many threads can mysql handle?

1039

What are the various editions of sql server 2017 that are available in the market?

941

What is difference between truncate and delete?

1100

For More Un-Answered { Databases } Questions Click Here