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

What is a database schema in oracle?

1113

What is open database communication (odbc) in oracle?

1004

How to drop an index in oracle?

1076

What is a read only transaction in oracle?

1030

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

1093

How to connect ms access to oracle servers?

1012

How to delete all rows a table in oracle?

1072

What is a parameter file in oracle?

1138

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

995

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

999

What is a static data dictionary in oracle?

1118

How to assign a tablespace to a users in oracle?

1048

How to drop an existing table in oracle?

1059

What is an oracle data file?

1106

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

1021

Un-Answered Questions { Databases }

What do you mean by e-r model & object-oriented model?

942

What do you understand by recursive stored procedures?

994

Is null vs coalesce?

891

What is concept of dbms?

917

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

999

Is database a hardware or software?

1004

Differentiate between ‘delete’, ‘truncate’ and ‘drop’ commands.

1157

What is intellisense?

1055

Why is a primary key important?

1052

What is difference between standardization and normalization?

1106

What skills do you need to be a database administrator?

544

How do you take the union of two tables in sql?

989

What is the difference between char and varchar in mysql?

1122

What are collection pools? What are the advantages?

896

How to define a specific record type?

1088

For More Un-Answered { Databases } Questions Click Here