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 11727

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,

3003

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 4890

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 5910

what is the querry for all managers salary?

2 4429

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 14852

What is the difference between Datapump & export/import?

2 12189

Can we take incremental backups in datapump?

1 11678

Datapump backup steps?

1 5305

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

1 5338

What is checkpoint?

Accenture,

3 5923

Oracle 11g new features?

2 11991

Hot backup procedure?

2 5117

Un-Answered Questions { Databases }

What is clustered vs nonclustered index?

1005

What happens if null values are involved in arithmetic operations?

1050

What happens when a shard is down or slow when querying?

With DTS packaging I can store tables in Excel and convert them back to SQL. But once I copied tables to Excel I want to modify some info. How you do that without editing the Excel file?

2636

Enlist some commands of dml?

998

How to loop through returning rows?

1091

How except clause is differs from not in clause?

1013

How do I get sql certification?

1021

Can we use join in subquery?

1156

explain the difference between bool, tinyint and bit. : Sql dba

1063

How will you run ms_batch file in forms?

What structure can you implement for the database to speed up table reads?

1240

What degree do database administrators need?

601

Write a query to retrieve a hundred books starting from 20th.

1566

What is ASM (Automatic Storage Management) in Oracle?

1247

For More Un-Answered { Databases } Questions Click Here