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

Can multiple cursors being opened at the same time?

1117

How to invoke the data pump import utility?

1228

How to pass a cursor variable to a procedure?

1158

How to view the data files in the current database?

1148

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

1174

What are the logical operations?

1169

How to list all indexes in your schema?

1141

What is the data pump export utility?

1132

How to create a new table in your schema?

1129

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

1107

How to see free space of each tablespace?

1081

How to use "out" parameter properly?

1123

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

1069

What are data pump export and import modes?

1110

How to generate query output in html format?

1210

Un-Answered Questions { Databases }

How to create a new view in oracle?

1128

Can a procedure in a package be overloaded?

1102

Mention how indexing is done in neo4j?

What is greenplum db?

848

Explain left outer join and right outer join?

1092

Is mysql free software?

1016

What is deterministic in mysql?

1030

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2384

Define implicit and explicit cursors.

1207

What is a sql*loader control file?

1344

How many types of tables are there in oracle?

1111

Explain the difference between sql and couchdb?

What is sql engine in oracle?

1040

What’s the distinction between dropping a info and taking a info offline?

1090

What is blocking and how would you troubleshoot it? : sql server database administration

1097

For More Un-Answered { Databases } Questions Click Here