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

How to open a cursor variable?

1088

What happens to indexes if you drop a table?

1222

How to test null values?

1154

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

1080

How to do a full database export?

1152

How to bring a tablespace online?

1139

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

1073

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

1173

How many file formats are supported to export data?

1266

Why cursor variables are easier to use than cursors?

1138

How to insert a record into a table?

1120

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

1036

How to invoke the original export import utilities?

1132

What is the difference between formal parameters and actual parameters?

1153

How to view the dropped tables in your recycle bin?

1 1558

Un-Answered Questions { Databases }

State some of the criticism about sybase iq?

967

Does sql profiler affect performance?

1047

How secure is sql server database?

1067

How many commands are there in sql?

1086

How to unzip a file in ssis?

1121

Does sql use python?

1095

How do you write a complex sql query?

1141

How do I view an execution plan in sql?

1033

How do I debug a stored procedure in sql server?

1176

How do I keep my database up to date?

969

How to receive returning result from a query?

1191

Define indexes?

1094

What is primary key index?

1017

how to create a scrollable cursor with the scroll option? : Sql server database administration

1147

Explain odi architecture?

658

For More Un-Answered { Databases } Questions Click Here