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

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

iGate,

2 7022

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 13605

How can we join three tables in SQL server 2000

Intelligroup,

2 4631

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

3 6101

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

1 3707

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 3796

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 8786

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

Wipro,

3 6120

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

8497

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

3 7298

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

3 6815

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

2 5885

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

2075

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

2121

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

2240

Un-Answered Questions { Databases }

What is mysql database extension?

1029

What is bson in mongodb?

how to implement data validations?

590

how would you get the current date in mysql? : Sql dba

967

how to return query output in html format? : Sql dba

1073

What is the clause we need to add in function body to return variable?

1012

How do you configure to cache size for mmapv1 in mongodb?

What is importing utility?

986

How to execute a sql statement using odbc_exec()?

1140

What is the purpose of scan?

What is difference between clustered and non clustered index?

989

What is sql server used for?

1048

how you can create/delete databases in Neo4j?

What is default value database?

1005

What do you mean by Oracle MEDIA RECOVERY?

1226

For More Un-Answered { Databases } Questions Click Here