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 define an anonymous procedure without variables?

1106

How many data types are supported?

1079

How to connect to the server with user account: sys?

1017

How to define default values for formal parameters?

1044

What are the restrictions on external table columns?

1052

What privilege is needed for a user to insert rows to tables in another schema?

1014

How to loop through data rows in the implicit cursor?

1073

How to create additional tablespaces for an new database?

1026

How many categories of data types?

994

Can you assign multiple query result rows to a variable?

987

How to use fetch statement in a loop?

1019

Can dml statements be used in pl/sql?

1078

Can variables be used in sql statements?

1030

How to revise and re-run the last sql command?

1163

How to process query result in pl/sql?

1128

Un-Answered Questions { Databases }

What is the maximum database size for sql express?

1023

What are nested tables?

1173

What is database architecture?

699

How can I create database in mysql?

925

What are the advantages of ms access over ms excel?

790

Is the primary key an index?

1026

Does sql support programming?

1065

Explain the different types of queries created in reports?

Explain few examples of stored procedure over triggers?

1041

What are .mdf files?

939

Differentiate between mongodb vs. Sql server?

1095

Can we insert data in view oracle?

1028

What are the indexes in sql server?

1113

Explain the different levels at which oracle form services interact.

1048

What is an advantage to using a stored procedure as opposed to passing an sql query from an application ?

925

For More Un-Answered { Databases } Questions Click Here