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

Write a query to genarate target column.Please answer me. Advance Thanks. Src Tgt Q10 Quarter to 2010 Q90 Quarter to 1990 Q80 Quarter to 1980 Q74 Quarter to 1974

Infosys,

5 11741

hi ..i am working as a sql dba.....now i want to learn more about t-sql..... is it possible to learn online.... plz refer any site ..thankq

IBM,

3006

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1900

If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?

Ness Technologies,

1 4893

What are the benefits of using stored procedures over sql statements?

Ness Technologies,

3 8459

What is the default isolation level of the sql server database?

Ness Technologies,

1 5922

what is the querry for all managers salary?

2 4434

how to implement dense rank in rank transformation in Informatica? so that output should be like 1,1,2,3 and not like 1,2,3,4

1 14863

What is the difference between Datapump & export/import?

2 12200

Can we take incremental backups in datapump?

1 11683

Datapump backup steps?

1 5308

How will u copy the objects of one schema to another schema in datapump & export/import?

1 5340

What is checkpoint?

Accenture,

3 5924

Oracle 11g new features?

2 11995

Hot backup procedure?

2 5126

Un-Answered Questions { Databases }

What do you mean by redo log file mirroring?

1075

Is mysqli deprecated?

1019

Is mysql good for big data?

1000

What is sqlcommand?

1074

how node connect with cpu?

2172

How delete all data from table in sql?

1079

Can a rule be bound to any column of any data type?

1031

How to replace the Query Result 'Null Value' with a text ?

1101

When should I use nosql database?

1066

Explain the difference between rename and alias?

1073

Can binary strings be converted into numeric or float data types?

1108

Can we save images in a database and if yes, how?

1116

What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

1212

Tell me what is difference between clustered and non clustered index?

986

Is mysql a free database?

996

For More Un-Answered { Databases } Questions Click Here