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 can you create an empty table from an existing table?

1 1142

What is clause?

1 1261

What are all different types of collation sensitivity?

1 1101

What are all types of user defined functions?

1 1161

How to fetch common records from two tables?

1 1696

What is the difference between delete and truncate commands?

1 1119

What are local and global variables and their differences?

1 1159

What is the difference between truncate and drop statements?

1 1292

What is a unique key?

1 1120

What is recursive stored procedure?

1 1161

What is auto increment?

1 1063

How to fetch alternate records from a table?

1 1328

Which operator is used in query for pattern matching?

1 1151

What is union, minus and interact commands?

1 1404

What is a constraint?

1 1101

Un-Answered Questions { Databases }

What is in place upgrade in sql server?

1119

What is the current mysql version?

1086

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

1184

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

1108

How to write a left outer join with the where clause in oracle?

1143

How to rebuild the master database?

1154

Any work done in oracle workflow builder. Did you customize or build a new workflow?

what is schema? : Sql dba

1127

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2091

What are the kinds of subquery?

1093

Have you created fact table and dimension tables?

696

Why use identity in sql server?

1189

What are the source of constraints?

1006

Can we do dml on views?

1027

Can delete statement be rollbacked?

1048

For More Un-Answered { Databases } Questions Click Here