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 change the order of columns in Oracle SQL Plus ?

MCN Solutions,

1058

How to display Row Number with Records in Oracle SQL Plus?

MCN Solutions,

1047

How to display the records between two range in Oracle SQL Plus?

MCN Solutions,

1145

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

MCN Solutions,

1107

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

MCN Solutions,

1227

Can a procedure in a package be overloaded?

EXL,

1043

Can procedure in package be overloaded?

EXL,

1085

Can procedure in a package be overloaded?

HCL,

1 1514

Inline the values in PL/SQL, what does it mean.?

MCN Solutions,

1226

How can we store rows in PL/SQL using array?

MCN Solutions,

1219

How to Execute a Package in PL/SQL.?

MCN Solutions,

1202

Can we use the cursor's to create the collection in PL/SQL?

MCN Solutions,

1027

What is bulk compiling in pl/sql.?

MCN Solutions,

1129

What is the difference between 10g OEM and 11g OEM?

MCN Solutions,

965

What are the different types of failures that occur in Oracle database?

HCL,

1067

Un-Answered Questions { Databases }

At what levels can data validation be done in microsoft access database?

1034

How can I make sql query run faster?

1016

Is postgres a mpp?

921

Where can I learn sql for free?

987

What is the difference between a database and instance? What is the relation between them?

588

What is schema in mongodb?

Explain about Joins?

990

How many tables we can create in mysql database?

950

difference between anonymous blocks and sub-programs.

1133

What do you understand by a view? What does the with check option clause for a view do?

1003

what is dynamic SGA and static SGA

4417

code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

2213

what is the functionality of the function htmlentities? : Sql dba

961

What is lookup override?

1040

How do you change the name of a column?

802

For More Un-Answered { Databases } Questions Click Here