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

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 11551

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,

2956

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.

1849

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 4815

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

Ness Technologies,

3 8342

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

Ness Technologies,

1 5839

what is the querry for all managers salary?

2 4326

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 14766

What is the difference between Datapump & export/import?

2 12081

Can we take incremental backups in datapump?

1 11574

Datapump backup steps?

1 5247

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

1 5249

What is checkpoint?

Accenture,

3 5818

Oracle 11g new features?

2 11875

Hot backup procedure?

2 5002

Un-Answered Questions { Databases }

What is the Repository and how many types of repository?

579

What are variables in pl sql?

1171

How do I open a mongodb file on a mac?

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

984

How to rename an index in oracle?

1118

What is a join in the sql?

999

How do you create an access file?

977

What is the best database software for small businesses?

924

How to create trigger in mysql workbench?

1001

Give the different types of rollback segments.

1031

How are the exceptions handled in sql server programming?

1068

What happens to a statement batch if there is a compilation error?

971

What is the difference between indexing and hashing?

1175

How to create a store procedure with encryption?

1010

What are the advantages of manual database?

970

For More Un-Answered { Databases } Questions Click Here