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 store procedure call by user define function in SQL server?

HCL,

10 18881

hi sql gurus, here is my question 4 u. i wanna use triggers for sending reminder mail to all users who are registered to the site. if any one knws the code plz send me ans here : chayabs3@gmail.com thnx advance

1 5485

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

EDS,

2104

We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.

5337

How i call Reports from Forms10g.

4 16754

What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?

4627

A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?

Infosys,

8 12776

How can I know what query is executing by by a particural user? (using sp id or any othe way.)

2 5283

what is the main difference between after trigger and instead trigger.

2 19844

I have to display ten columns values from diffrent ten tables. how many joins are require?

CarrizalSoft Technologies, HCL,

10 14522

what is difference between paging and fragmentation?

Cognizant, IOS,

1 7709

what is difference between clustering and mirroring?

Religare,

2 12063

please send me oracle pl/sql exp resume. and also faqs...

2501

What is the difference between compression level 0 1nd 9

2 7644

what is directio?

2 6979

Un-Answered Questions { Databases }

Define database system.

976

Find first and last day of current month in sql server

1038

What mysql means?

951

What is informix sql?

987

What is cold backup (in case of oracle)?

959

What is the use of Markers?

608

Explain in brief about Microsoft SQL server?

1107

How to display the records between two range in Oracle SQL Plus?

1158

What query language does mongodb use?

Mention a query to calculate the even and odd records from a table

970

How to insert new line characters into strings?

1003

How can a user-defined datatype be created?

996

Explain the the update statement in sql?

1053

What are the uses of Database Trigger ?

1731

what is isam? : Sql dba

1023

For More Un-Answered { Databases } Questions Click Here