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

What are the recovery models in sql server 2000?

1 1029

What is filestream?

1 1074

Where the sql logs gets stored?

1 1063

What is the syntax to execute the sys.dm_db_missing_index_details?

1 1097

What is policy management?

1 1079

What is awe?

1 1106

When columns are added to existing tables, what do they initially contain?

1 1119

What is the order by used for?

1 1073

What is a transactions?

1 1121

What is row_number()?

1 1066

What stored by the master?

1 1033

What is 'write-ahead log' in sql server 2000 ?

1 1136

What is bcp? When does it used?

1 1068

Which are new data types introduced in sql server 2008?

1 1132

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

1 1241

Un-Answered Questions { Databases }

Can one drop a column from a table?

1082

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1065

If a cursor is open, how can we find in a pl/sql block?

1235

How to Change a users password from unix shell.

1214

Can you index views?

953

What is current version of mysql?

1072

What are the different types of subquery?

1232

Why and when do stored procedure recompile?

1055

How raid can influence database performance?

1114

What is oracle latest version?

1171

How to define array in mongoose schema?

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1208

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

1129

please send me oracle pl/sql exp resume. and also faqs...

2567

What is sql server query analyzer?

1124

For More Un-Answered { Databases } Questions Click Here