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?

1 1235

How many data types are supported?

1 1170

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

1 1092

How to define default values for formal parameters?

1 1116

What are the restrictions on external table columns?

1 1140

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

1 1089

How to loop through data rows in the implicit cursor?

1 1149

How to create additional tablespaces for an new database?

1 1104

How many categories of data types?

1 1068

Can you assign multiple query result rows to a variable?

1 1062

How to use fetch statement in a loop?

1 1093

Can dml statements be used in pl/sql?

1 1152

Can variables be used in sql statements?

1 1110

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

1 1250

How to process query result in pl/sql?

1 1224

Un-Answered Questions { Databases }

How can I check that whether automatic statistic update is enabled or not?

1111

i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: summi4you@yahoo.co.in

1861

what is dbms? : Sql dba

1061

Is there some bulk load or other way to import a lot of data fast?

931

How to start an oracle instance?

1103

What is your daily office routine?

2345

What is the difference between upgrade and migration in sql server?

1183

Can we do dml on views?

1035

What is an indexed view?

1021

Which statement is used in a select query for partial matching?

1241

Can sql servers link to other servers like oracle?

915

Do we need to rebuild index after truncate?

1137

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1196

Explain “row_number()” in sql server with an example?

1076

Is primary key clustered index?

1018

For More Un-Answered { Databases } Questions Click Here