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?

1039

What happens to indexes if you drop a table?

1171

How to test null values?

1108

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

1034

How to do a full database export?

1111

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?

1070

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

988

How to invoke the original export import utilities?

1064

What is the difference between formal parameters and actual parameters?

1089

How to view the dropped tables in your recycle bin?

1 1482

Un-Answered Questions { Databases }

Does sql server 2016 have ssms?

962

What is the difference between explicit and implicit cursors in oracle?

1069

What do you mean by stored procedures? How do we use it?

996

Explain the term specialization.

857

What is metadata and why should I use it?

932

how to get @@error and @@rowcount at the same time? : Sql dba

1028

What are the oracle built-in data types?

1074

what does the no logging option do? Why would we use it?

552

What is the use of Markers?

596

How do I view tables in mysql workbench?

920

what is 'mysqlshow'? : Sql dba

1027

What are the diifferences between the ms sql server vs mysql?

1175

How do I run a sql query?

1022

Does mongodb need a lot of ram?

What will be the new characteristics of postgre 9.1?

765

For More Un-Answered { Databases } Questions Click Here