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?

1079

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

1022

How to define default values for formal parameters?

1044

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?

1028

How many categories of data types?

997

Can you assign multiple query result rows to a variable?

988

How to use fetch statement in a loop?

1019

Can dml statements be used in pl/sql?

1081

Can variables be used in sql statements?

1033

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

1163

How to process query result in pl/sql?

1128

Un-Answered Questions { Databases }

how report can be generated if we have the database designed in oracle 10g?

1888

What are the advantages of views in a database?

1180

What is a longblob?

948

What is bind variable in oracle 11g?

1039

How do I run a sql query?

1022

What is pl sql in dbms?

950

How many joins in sql?

1011

Does index speed up select statements?

1012

What are different types of clusters present?

1079

What are the five major components of a dbms?

929

What is java sql package?

1097

Can we join more than 2 tables in sql?

1022

Tell me some differences between ODI 10g and ODI 11g?

563

Can files be stored in a database?

937

Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

1750

For More Un-Answered { Databases } Questions Click Here