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?

1108

How many data types are supported?

1083

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

1024

How to define default values for formal parameters?

1047

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?

1078

How to create additional tablespaces for an new database?

1031

How many categories of data types?

997

Can you assign multiple query result rows to a variable?

991

How to use fetch statement in a loop?

1022

Can dml statements be used in pl/sql?

1082

Can variables be used in sql statements?

1036

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

1164

How to process query result in pl/sql?

1132

Un-Answered Questions { Databases }

What is meant by indexing?

1022

How is a database related to a table?

973

What is oracle used for?

1026

What is a clause in terms of sql?

1228

Is id a reserved word in sql?

1146

Illustrate physical database architecture in brief? : sql server architect

765

What is lexical units in pl sql?

1151

Where in the Oracle directory tree structure are audit traces placed?

2640

What is progress apama?

1062

Explain about protocol layer present in SQL server?

1209

State the difference between union and union all?

929

How do you know the all indexes available for a collection?

Does postgres create indexes for foreign keys?

902

What is the difference between a stored procedure and a user defined function?

1024

Is redis in memory database?

1010

For More Un-Answered { Databases } Questions Click Here