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,

1745

Oracle

ABC, Genpact, HUI, Oracle,

2375

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

1661

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

1840

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

1725

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

Cap Gemini, Data Vision,

2 8862

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

TCS,

1 3419

How did you export data from database to excel file.

TCS,

1 5627

Difference between global and parameter variables?

TCS,

1966

What is extent clause in table space?

TCS,

1 3635

What is the use of time stamp in select statement?

TCS,

1 3853

Which data type doesn't allow null data type?

TCS,

6 9433

What is window clause?

TCS,

1 4247

Can you alter start with clause?

TCS,

1 4562

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 10534

Un-Answered Questions { Databases }

Explain different types of Normalization.

1832

How to move objects from DEV to QA and QA to PROD Environments?

710

What is data block in Oracle?

1116

What is nosql db?

967

What is trigger in dbms?

921

Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

1276

What are the functions of a database?

989

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

1840

What is execute immediate?

1084

What is character functions?

1061

What are sql indexes?

999

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

1002

How do I import a csv file into postgres?

913

What are the characteristics of database?

894

How many databases should a dba manage?

654

For More Un-Answered { Databases } Questions Click Here