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 the cartesian product of table?

1 1104

What is log shipping?

1 1032

What are the properties of the transactions?

1 1197

What is cursors? And what are the different types of cursor?

1 1234

What is database white box testing?

1 1197

What are the properties of sub-query?

1 1154

What’s the distinction between dropping a info and taking a info offline?

1 1114

Explain the working of sql privileges?

1 1162

What are indexes in sql?

2 1393

What are the system database in sql server 2005?

1 1117

Define clusters?

1 1160

How we can refresh the view?

1 1180

What is the difference between set and select?

1 1197

What is the difference between stored procedure and user defined functions?

1 1266

What area unit the various kinds of info compression introduced in sql server 2008?

1 1173

Un-Answered Questions { Databases }

what is dbms? : Sql dba

1061

What are the kinds of subquery?

1099

What is the difference between case version and decode version?

1103

Why we use the openxml clause?

1072

Suppose database is running slow, what will you do?

2590

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

1856

How efficient you are in oracle and SQL server?

1251

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

1235

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

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2291

What are the properties of the transaction?

1069

What is the latest version of postgresql?

951

What is the current mysql version?

1093

Can we do dml on views?

1032

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

2100

For More Un-Answered { Databases } Questions Click Here