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 transact-sql ddl trigger?

1 1167

What is read committed?

1 1199

How do we know if any query is retrieving a large amount of data or very little data?

1 1063

What is the maximum size per database for sql server express?

1 1132

What are basics of policy management?

1 1171

What is user-defined scalar function?

1 1033

What are different types of collation sensitivity?

1 1046

What are “phantom rows”?

1 1724

Explain error and transaction handling in sql server?

1 1084

Difference between primary key and clustered index?

1 1088

How many columns can we include on clustered index ?

1 1086

What is a covered index?

1 998

Why can there be only one clustered index and not more than one?

1 1062

How to Check if table exists in sql server?

1 1213

How does using a separate hard drive for several database objects improves performance right away?

1 1013

Un-Answered Questions { Databases }

How to connect php with different port numbers?

1171

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

1851

Explain system functions or built-in functions? What are different types of system functions?

1055

What is a concurrency problem in dbms?

1045

How to Change a users password from unix shell.

1209

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1041

How to convert numeric expression data types using the cast() function?

1142

What is the difference between case version and decode version?

1099

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

1170

what is schema? : Sql dba

1127

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

2564

Why use identity in sql server?

1189

Why and when do stored procedure recompile?

1052

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2088

Can we use distinct and group by together?

1129

For More Un-Answered { Databases } Questions Click Here