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,

1224

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,

1217

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,

1025

What is bulk compiling in pl/sql.?

MCN Solutions,

1127

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 }

What is domain in dbms?

953

How concurrency problems effect the database?

1159

What is left join in sql?

1047

What is the server name in sql server?

1010

What is 'mysqld'?

944

What are the different parts of a package?

1115

Explain difference between cross join and full outer join?

1005

What are keys in sql?

999

How would you manager data tasks?

932

How to improve query performance using index hunting?

1174

Difference between Logical Page and Physical Page in SSRS.

476

Is postgresql free for commercial use?

809

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1059

Why would someone use a database?

921

Can we insert data in view?

962

For More Un-Answered { Databases } Questions Click Here