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 a database schema in oracle?

1153

What is open database communication (odbc) in oracle?

1053

How to drop an index in oracle?

1121

What is a read only transaction in oracle?

1081

How to insert multiple rows with one insert statement in oracle?

1135

How to connect ms access to oracle servers?

1059

How to delete all rows a table in oracle?

1119

What is a parameter file in oracle?

1191

Can the query output be sorted by multiple columns in oracle?

1061

Can group functions be used in the order by clause in oracle?

1047

What is a static data dictionary in oracle?

1192

How to assign a tablespace to a users in oracle?

1090

How to drop an existing table in oracle?

1105

What is an oracle data file?

1163

How to revoke create session privilege from a user in oracle?

1069

Un-Answered Questions { Databases }

What is a heap in sql?

1149

What are sql server procedures?

1037

Explain data independence?

1092

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

2085

How much memory does postgresql need?

925

Does sql profiler affect performance?

1048

What is the limitations to run mongodb on 32 bits OS?

How to open postgresql gui in ubuntu?

967

Which operations lock the database in mongodb?

Is mysql owned by oracle?

1075

How many types of rdbms are there?

955

How does left join work in sql?

1041

what is union, minus and interact commands? : Sql dba

1257

What is index hunting and how does it help in improving query performance?

2059

What is de-normalization in sql database administration? Give examples?

1027

For More Un-Answered { Databases } Questions Click Here