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,

1706

Oracle

ABC, Genpact, HUI, Oracle,

2332

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

1607

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

1811

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

1688

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

Cap Gemini, Data Vision,

2 8770

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

TCS,

1 3368

How did you export data from database to excel file.

TCS,

1 5541

Difference between global and parameter variables?

TCS,

1925

What is extent clause in table space?

TCS,

1 3540

What is the use of time stamp in select statement?

TCS,

1 3779

Which data type doesn't allow null data type?

TCS,

6 9233

What is window clause?

TCS,

1 4182

Can you alter start with clause?

TCS,

1 4501

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 10401

Un-Answered Questions { Databases }

What are page splits?

970

What is the difference between resultset and resultsetmetadata?

907

how many columns can be used for creating index? : Sql dba

913

What is max rowid in oracle?

985

What is scalar data type in pl sql?

1035

What is blocking and how would you troubleshoot it? : sql server database administration

1004

What are the different types of languages that are available in the dbms?

987

List different types of locks in sybase?

928

Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

1063

What is the definition for sql server 2000?

1057

Is mysql free for enterprise?

862

What is function of master database?

114

What is a behavioral trigger?

939

What is an alias command?

1022

What is flashback in Oracle?

983

For More Un-Answered { Databases } Questions Click Here