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,

1147

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

MCN Solutions,

1108

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

MCN Solutions,

1228

Can a procedure in a package be overloaded?

EXL,

1045

Can procedure in package be overloaded?

EXL,

1085

Can procedure in a package be overloaded?

HCL,

1 1516

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

MCN Solutions,

1229

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

MCN Solutions,

1220

How to Execute a Package in PL/SQL.?

MCN Solutions,

1206

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

MCN Solutions,

1028

What is bulk compiling in pl/sql.?

MCN Solutions,

1131

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 are the beneficial tools for administering the database?

543

How do you copy a database?

927

How to find table changes in sql server?

1124

What is system r?

968

What are some of the important security features of a dbms?

872

How different is ms access and oracle?

1040

what is a record in a database ? : Sql dba

1064

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

2440

What is the security principal at the server level that represents your session?

1014

What is variable dbms?

962

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2270

What is Fully Functional dependency?

956

What are stored procedures in mysql?

1019

Can we store pictures in the database and if so, how it can be done?

1045

What are the different types of backups that are available in oracle?

For More Un-Answered { Databases } Questions Click Here