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 18854

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 5471

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,

2096

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.

5329

How i call Reports from Forms10g.

4 16732

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 ?

4622

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 12752

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

2 5266

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

2 19835

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

CarrizalSoft Technologies, HCL,

10 14491

what is difference between paging and fragmentation?

Cognizant, IOS,

1 7699

what is difference between clustering and mirroring?

Religare,

2 12054

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

2495

What is the difference between compression level 0 1nd 9

2 7633

what is directio?

2 6969

Un-Answered Questions { Databases }

Explain the informix instance.

Can you assign multiple query result rows to a variable?

992

What are the popular database management systems in the it industry?

1002

What are the qualities of 2nf?

1039

What is a partition key?

958

Is filemaker pro a relational database?

1067

What is record data type?

920

What is sql server used for?

1057

What is difference between mongodb and mysql?

921

What is entity relationship diagram?

911

How can a user-defined datatype be created?

989

Why having clause is used in sql?

983

Explain about Normalization?

1069

What are four common errors found in an alert .log?

563

how to create a new table in mysql? : Sql dba

989

For More Un-Answered { Databases } Questions Click Here