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

How to open a cursor variable?

1031

What happens to indexes if you drop a table?

1169

How to test null values?

1104

How to define a data source name (dsn) in odbc manager?

1028

How to do a full database export?

1107

How to bring a tablespace online?

1079

Can group functions be mixed with non-group selection fields?

1020

What is the relation of a user account and a schema?

1134

How many file formats are supported to export data?

1220

Why cursor variables are easier to use than cursors?

1094

How to insert a record into a table?

1068

How to define a variable to match a table column data type?

988

How to invoke the original export import utilities?

1062

What is the difference between formal parameters and actual parameters?

1086

How to view the dropped tables in your recycle bin?

1 1480

Un-Answered Questions { Databases }

What is the purpose of using pl/sql?

1144

Can access database be used online?

784

what's the difference between a primary key and a unique key? : Sql dba

1049

What is database connection pool size?

914

what does the t-sql command ident_current does? : Transact sql

977

What is function of ROLLUP ?

1083

What is system global area (sga) in oracle?

991

What is the difference between the 2 operating modes of database mirroring?

1111

What is the difference between sql, mysql and sql server?

1102

What is a dirty read sql?

1137

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1682

What does a dba stand for?

577

How to convert character types to numeric types?

1130

What is the difference between I and G in Oracle?

1099

How to Declare Fixed Length String Value In PL SQL

1155

For More Un-Answered { Databases } Questions Click Here