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

can we use transformer in datastage without any input link?

Cognizant, CTS,

1781

Oracle

ABC, Genpact, HUI, Oracle,

2423

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

1709

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??

1909

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??

1789

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

Cap Gemini, Data Vision,

2 8963

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

TCS,

1 3483

How did you export data from database to excel file.

TCS,

1 5704

Difference between global and parameter variables?

TCS,

2015

What is extent clause in table space?

TCS,

1 3732

What is the use of time stamp in select statement?

TCS,

1 3926

Which data type doesn't allow null data type?

TCS,

6 9606

What is window clause?

TCS,

1 4324

Can you alter start with clause?

TCS,

1 4642

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 10661

Un-Answered Questions { Databases }

What is the use of the drop option in the alter table command?

630

Where is dbms used?

1126

How does triggers work in mysql?

1026

Is number a datatype in mysql?

995

What is pl sql package?

1072

Which table is left in left join?

1063

What is an oracle?

1066

Do you know what is difference between stored procedure and user defined function?

1156

When should you not use firebase?

1107

How does the on-delete-cascade statement work?

1163

What is alternate key?

994

what kind of lan types do you know? : Sql server database administration

1022

What are a scheduled jobs?

991

What are the different types of partitions in oracle?

1032

What is SDL (Storage Definition Language)?

845

For More Un-Answered { Databases } Questions Click Here