Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3253)
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

What is ordinary table in oracle?

MCN Solutions,

1243

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

CGI,

1170

Can I create users through internet explorer in oracle 10g?

MCN Solutions,

1160

What is user managed backup in Oracle?

MCN Solutions,

1206

What is index in Oracle?

MCN Solutions,

1135

What is the difference between Delete, Truncate and Drop in Oracle?

MCN Solutions,

1187

What is index-organized table in Oracle?

MCN Solutions,

1123

what are the default admin accounts in Oracle 10g ?

MCN Solutions,

1026

What is Library Cache in Oracle?

MCN Solutions,

1195

What is recycle bin in Oracle?

MCN Solutions,

1202

What is the difference between I and G in Oracle?

MCN Solutions,

1155

What is Data Dictionary Cache in Oracle?

MCN Solutions,

1251

How many types of auditing in Oracle?

MCN Solutions,

1093

How many types of segments in Oracle?

MCN Solutions,

1122

Define view, sequence and index in DBMS.

HAL,

993

Un-Answered Questions { Databases }

How do you rename a table in mysql?

1109

What are security principals used in sql server 2005?

1042

What is dbo in sql?

1021

Define sql delete statement.

1067

How would you get the current date in mysql?

1162

How to send email from database?

1076

What are the differences between drop, truncate and delete commands?

1115

What does rownum mean in sql?

1093

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

2085

What is temporary stored procedure?

990

Is postgresql a relational database?

900

What is procedure explain with example?

1013

How can you export the table as an xml file in mysql?

933

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2342

How do I find duplicates in the same column?

1177

For More Un-Answered { Databases } Questions Click Here