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

Can multiple cursors being opened at the same time?

1060

How to invoke the data pump import utility?

1162

How to pass a cursor variable to a procedure?

1109

How to view the data files in the current database?

1096

How to turn on or off recycle bin for the session?

1109

What are the logical operations?

1125

How to list all indexes in your schema?

1093

What is the data pump export utility?

1081

How to create a new table in your schema?

1081

What happens to the data files if a tablespace is dropped?

1059

How to see free space of each tablespace?

1034

How to use "out" parameter properly?

1080

Can you drop an index associated with a unique or primary key constraint?

1019

What are data pump export and import modes?

1065

How to generate query output in html format?

1116

Un-Answered Questions { Databases }

Can we use bind variables in oracle stored procedure?

949

What do you mean by mainframe connect tool in sybase?

898

Will there be journal replay programs in case of incomplete entries (if there is a failure in the middle of one)?

Explain transaction server consistency?

973

What are the methods used to protect against sql injection attack?

1065

What is internal database?

979

Explain the use of ignore option in imp command.

1035

What do you understand by lov?

1035

What are cursors and when they are useful?

1089

If you have an example table, what is the best way to get sizing data for the production table implementation?

554

how to increment dates by 1 in mysql? : Sql dba

977

What are the different windows events activated at runtime ?

2900

Explain about Normalization?

1064

What are types of exception?

922

How many categories of functions based their return modes?

1103

For More Un-Answered { Databases } Questions Click Here