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 to check if a column is nullable before setting to nullable?

1147

Can we use threading in pl/sql?

1048

Difference between table function and pipelined function?

1047

What is the difference between explicit and implicit cursors in oracle?

1085

How to convert comma separated string to array in pl/sql?

1207

How to raise user-defined exception with custom sqlerrm ?

1148

Can you select everything, but 1 or 2 fields, without writer's cramp?

1003

Does oracle roll back the transaction on an error?

1038

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1225

What is the difference between function and procedure in pl/sql?

1106

How can I get the number of records affected by a stored procedure?

1086

How to return an array from java to pl/sql?

1157

How can I combine multiple rows into a comma-delimited list in oracle?

1081

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1099

How to load excel data sheet to oracle database

1044

Un-Answered Questions { Databases }

How to use sql*plus built-in timers?

1218

In the oracle version 9.3.0.5.0, what does each number shows?

1323

What is the candidate key used for?

1113

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2202

what is the difference between sql and t-sql? : Transact sql

1108

What is bind reference and how can it be created?

1039

What to do if the binary spfile is wrong for the default instance?

1087

what is commit? : Sql dba

1091

What are the types of database schema? : sql server analysis services, ssas

1153

Explain sql server authentication modes?

1147

Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

150

How to improve query performance using index hunting?

1193

What is redo log?

1088

Which is faster mongodb or mysql?

922

How to use attributes of the implicit cursor in oracle?

1027

For More Un-Answered { Databases } Questions Click Here