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

How can I pass the inner procedure value to outer procedure ?

2 7737

what is difference between sap and oracle applications and which is now market leader?

Amity, Infosys, Rysigo, Unilogic Software, Wipro,

11 27316

What is the difference between anonymous block and named block or stored procedure?

8 59353

I need a exceptoin in pl/sql block so that if any errors occur in the block then no exception should errors should raise?

1 5519

What are indexes ? What are the advantages ? (Phone Screen)

NetApp,

1 9711

What is relational database ? Give me an example !

NetApp,

4 13210

What are triggers?Where are they used?

3 6653

What are cursor?where are they used?

2 6589

Please explain the difference between outer join and inner join? With examples would be appreciable..!

IBM,

6 19529

is there more the two primary key in a single table?

Eforce, Systematix,

26 33852

What is the difference between formula column and place holder?

3 8104

HI in report builder am creating paramters.for that i have taken emp table from scott user . in deptnum am displaying distinct deptno.if i select dept 10 ,empnum drop down should display empno's of deptno 10. .if i select dept 20 ,empnum drop down should display empno's of deptno 20.for this wat i have to do.

2 4534

how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g

1 2081

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

1 1772

how we can use more then one primary key in Single Table

Systematix,

9 16489

Un-Answered Questions { Databases }

How to rebuild the master database?

1161

Can you index views?

953

Is there some bulk load or other way to import a lot of data fast?

931

How to write a left outer join with the where clause in oracle?

1151

How to connect php with different port numbers?

1182

How efficient you are in oracle and SQL server?

1255

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2707

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1210

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1295

What are the source of constraints?

1007

What is your daily office routine?

2344

how many tables will create when we create table, what are they? : Sql dba

1141

Can we do dml on views?

1033

what is dbms? : Sql dba

1061

What are wait types?

1247

For More Un-Answered { Databases } Questions Click Here