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?

972

What happens to indexes if you drop a table?

1107

How to test null values?

1041

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

964

How to do a full database export?

1043

How to bring a tablespace online?

993

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

954

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

1061

How many file formats are supported to export data?

1135

Why cursor variables are easier to use than cursors?

1019

How to insert a record into a table?

1018

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

936

How to invoke the original export import utilities?

973

What is the difference between formal parameters and actual parameters?

1001

How to view the dropped tables in your recycle bin?

1 1392

Un-Answered Questions { Databases }

What is mysql community server?

870

What is a coalesce? What is the equivalent of oracle/db2 coalesce function in sybase?

848

Why are stored procedures used?

742

How much memory does mongodb need?

Explain storage manager?

964

How do I find users in mysql?

1021

What is the default port for SQL Server over a firewall?

1030

How to determine what records to extract?

What are the dis_advantages of stored procedures, triggers, indexes?

2170

What is data control language?

946

What is the federation in sql azure?

How do you open tables in pgadmin?

752

Mention some disadvantages of query?

901

What is the command enable-debug?

868

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

927

For More Un-Answered { Databases } Questions Click Here