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

1191

How many data types are supported?

1136

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

1060

How to define default values for formal parameters?

1093

What are the restrictions on external table columns?

1108

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

1056

How to loop through data rows in the implicit cursor?

1118

How to create additional tablespaces for an new database?

1076

How many categories of data types?

1042

Can you assign multiple query result rows to a variable?

1035

How to use fetch statement in a loop?

1066

Can dml statements be used in pl/sql?

1123

Can variables be used in sql statements?

1073

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

1218

How to process query result in pl/sql?

1199

Un-Answered Questions { Databases }

What is rename command in sql?

1093

What exactly is a database?

931

Explain parameter file in oracle.

1080

Can you selectively load only those records that you need? : aql loader

1092

What are the functions of commit and rollback statements?

1103

How many columns can you create for an index?

998

How to calculate expressions with sql statements?

1169

What is tkprof?

Explain the term entity type in dbms?

1085

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1110

what is a relationship and what are they? : Sql dba

1165

How do I know if localdb is running?

999

What is an indexed view?

1007

What are tables and fields?

1087

Can the old files in the ‘movechunk’ directory be removed?

For More Un-Answered { Databases } Questions Click Here