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

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

2 7587

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

Amity, Infosys, Rysigo, Unilogic Software, Wipro,

11 26783

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

8 58924

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 5409

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

NetApp,

1 9597

What is relational database ? Give me an example !

NetApp,

4 13022

What are triggers?Where are they used?

3 6462

What are cursor?where are they used?

2 6458

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

IBM,

6 19189

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

Eforce, Systematix,

26 32783

What is the difference between formula column and place holder?

3 7924

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 4403

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

1985

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

1702

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

Systematix,

9 16064

Un-Answered Questions { Databases }

What is a database example?

990

Which autogrowth database setting is good? : sql server DBA

1163

Is mongodb orm?

What are the different types of upgrades that can be performed in sql server? : sql server DBA

1218

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

1026

How to increment dates by 1 in mysql?

1041

If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

2331

Can we insert data if clustered index is disabled?

951

How to use copy and concatenate commands in SQL?

1151

Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ?

2945

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2344

What is a flashback query and when should it be used?

How is use pl and sql?

1071

What is a procedure example?

931

What do you mean by cdb and pdb in oracle 12c?

1063

For More Un-Answered { Databases } Questions Click Here