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 differences between having and where clause.

1 1027

What are the options which must be set to allow the usage of optimistic models?

1 1042

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1 1048

Mention the command used to rename the database.

1 1059

Mention the differences between sql server and mysql.

1 1098

What are trace flags and mention a few common trace flags used with sql server?

1 1148

What are subqueries in sql server? Explain its properties.

1 1078

What do you understand by mirroring?

1 1056

What are joins in sql and what are the different types of joins?

1 1071

How can you check the version of sql server?

1 1177

Write a query to find 5th highest amount paid from the customer table.

1 997

What do you understand by physical_only option in dbcc checkdb?

1 1037

What are the differences between substr and charindex in sql server.

1 1203

What are relationships and mention different types of relationships in the dbms

1 1026

What do you understand by integration services in sql server?

1 1013

Un-Answered Questions { Databases }

How to connect php with different port numbers?

1159

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

2554

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8210

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2174

Is there some bulk load or other way to import a lot of data fast?

923

Is primary key clustered index?

1000

Can we do dml on views?

1024

Why use identity in sql server?

1185

What is oracle latest version?

1157

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?

1200

How to start an oracle instance?

1086

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

What are the different subsets of sql?

1634

What is the current version of sql?

1080

What are different types of constraints?

981

For More Un-Answered { Databases } Questions Click Here