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

How to rebuild an index in oracle?

1070

What is oracle open database communication (odbc)?

1086

What are the restrictions in a oracle read only transaction?

1084

What is an oracle database?

1111

What privilege is needed for a user to create views in oracle?

1094

How to write a query with a right outer join in oracle?

1224

How to experiment a data lock in oracle?

1113

How to write text literals in oracle?

1120

How to convert times to characters in oracle?

1073

How to install oracle database 10g xe?

1064

How to change program global area (pga) in oracle?

1148

How to convert numbers to characters in oracle?

1080

How to delete a column in an existing table in oracle?

1131

What are transaction isolation levels supported by oracle?

1117

How to write a query with an inner join in oracle?

1097

Un-Answered Questions { Databases }

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

1030

What is the difference between cold backup and hot backup?

621

What is the usage of save points in oracle database?

1015

Which should I use, repagent or ltm in sybase?

1031

What is a session in mysql?

1018

How to create and drop temp table in sql server?

1100

You need to add a notnull column in a table by using alter command (without using default command). How would you do that?

1014

How many sql statements are used? Define them.

1081

Other than truncate statement, which other command can by-pass the trigger on the tables?

1193

what is constraints? Also explain the different types of constraints?

1023

What is the use of mysqli_num_rows?

965

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

1347

What is rownum and rowid?

1078

Do you know data definition language, data control language and data manipulation language?

1091

Can we perform backup restore operation on tempdb?

1078

For More Un-Answered { Databases } Questions Click Here