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 is global temp table?

1 1060

What is nonclustered index with included columns ?

1 1047

What is service broker?

1 1075

What is the difference between varchar and nvarchar datatypes?

1 1169

How can I track the changes or identify the latest insert-update-delete from a table?

1 1035

How many triggers are possible per table?

1 1160

What is the maximum number of index per table?

1 1139

How to recompile stored procedure at run time?

1 1141

What are the different types of stored procedures?

1 1175

What is difference between rollback immediate and with no_wait during alter database?

1 1152

What is merge statement?

1 1150

Explain throw statement in sql server 2008?

1 1075

What is nonclustered index on computed columns?

1 1021

Explain some stored procedure creating best practices or guidelines?

1 1021

Explain try...catch with sql server?

1 1087

Un-Answered Questions { Databases }

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

1061

How to rebuild the master database?

1154

What is subquery? Explain the properties of a subquery?

1053

What are the two main functions of queries in databases?

1520

Can we rollback truncate?

1070

What is standby servers? Explain types of standby servers.

1067

How to define array in mongoose schema?

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2346

How to Change a users password from unix shell.

1209

what is collation? : Sql dba

1223

Does group by remove duplicates?

1106

What is in place upgrade in sql server?

1119

what is the last version,the release date of that version and fix pack of ibm db2 udb?

2044

List out the different types of locks available in sql server?

1041

what is bcp? When does it used? : Sql dba

1051

For More Un-Answered { Databases } Questions Click Here