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

can we use transformer in datastage without any input link?

Cognizant, CTS,

1698

Oracle

ABC, Genpact, HUI, Oracle,

2321

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1595

In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1790

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??

1670

which will default fire first statement level trigger or row level trigger

Cap Gemini, Data Vision,

2 8747

Maximum how many triggers can we use in trigger and How to find out how many records it fetched.

TCS,

1 3343

How did you export data from database to excel file.

TCS,

1 5526

Difference between global and parameter variables?

TCS,

1910

What is extent clause in table space?

TCS,

1 3509

What is the use of time stamp in select statement?

TCS,

1 3749

Which data type doesn't allow null data type?

TCS,

6 9193

What is window clause?

TCS,

1 4170

Can you alter start with clause?

TCS,

1 4480

Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.

JPMorgan Chase,

3 10371

Un-Answered Questions { Databases }

What are replica sets in mongodb?

What is the data source name for mysql?

889

Is microsoft access a sql database?

810

what is rollback? : Sql dba

1024

What is sequelize?

739

How do I start pgadmin 4 on windows?

816

How do I free up space in mysql?

856

What is a cursor and what are the steps need to be taken?

1123

Mention the differences between union and union all

860

What are subqueries in sql server?

1066

Why is databases important in healthcare?

909

What are filegroups in sql server?

1014

What is match command?

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

1091

PostgreSql Disadvantages

1858

For More Un-Answered { Databases } Questions Click Here