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 7605

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

Amity, Infosys, Rysigo, Unilogic Software, Wipro,

11 26849

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

8 58963

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 5418

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

NetApp,

1 9615

What is relational database ? Give me an example !

NetApp,

4 13043

What are triggers?Where are they used?

3 6482

What are cursor?where are they used?

2 6477

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

IBM,

6 19224

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

Eforce, Systematix,

26 32918

What is the difference between formula column and place holder?

3 7939

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 4427

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

1992

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

1708

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

Systematix,

9 16116

Un-Answered Questions { Databases }

What is the symbol of logical OR operation in mongodb?

How can you insert null values in a column while inserting the data?

1296

How do I make my sql query run faster?

954

How to load data through external tables?

1155

What are different types of data sources?

1036

How do you identify a foreign key?

1045

What is select query in mysql?

923

How to define and use table alias names in ms sql server?

1154

Define mongodb SUM?

Name the different type of indexes in sql?

990

How do I completely remove mysql from windows?

990

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

2521

Explain the difference between procedure and function in mysql?

1005

How do I manually create a database in oracle?

1037

What is user defined stored procedures?

958

For More Un-Answered { Databases } Questions Click Here