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?

1107

How many data types are supported?

1080

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

1023

How to define default values for formal parameters?

1045

What are the restrictions on external table columns?

1054

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

1015

How to loop through data rows in the implicit cursor?

1074

How to create additional tablespaces for an new database?

1029

How many categories of data types?

997

Can you assign multiple query result rows to a variable?

989

How to use fetch statement in a loop?

1020

Can dml statements be used in pl/sql?

1081

Can variables be used in sql statements?

1034

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

1163

How to process query result in pl/sql?

1129

Un-Answered Questions { Databases }

Explain how many types of relationship?

1030

How to use regular expression in pattern match conditions?

953

What is the main reason behind using an index?

1018

What do you understand by data model?

1098

What do you know about system database? : SQL Server Architecture

986

What are the disadvantages of microsoft access?

911

What is secondary key?

934

what are the three command line utilities and what are their primary functions?

145

How to create a new table in mysql?

1047

What is compound operators?

1059

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

948

Explain the different types of database keys?

980

Should I use mbr or gpt?

1026

What is reportserver and reportservertempdb ?

152

Can multiple cursors being opened at the same time?

1060

For More Un-Answered { Databases } Questions Click Here