Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3259)
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 dbcc command and why is it used?

1078

How will you decide the active and passive nodes?

1153

How can you hide the sql server instances?

1031

What is the difference between value type and reference type?

935

Define magic tables in sql server?

1079

Explain different types of collation sensitivity?

993

What command is used to rename the database?

1041

What is the sql server agent?

1107

What is sub-query in sql server? Explain its properties.

1107

What is the most common trace flags used with sql server?

1071

Explain the properties of sub-query in sql server?

1039

What are the different types of collation sensitivity in sql server?

1120

What are the advantages of using third-party tools?

1017

What is the usage of sign function?

1133

What are the different type of replication in sql server?

995

Un-Answered Questions { Databases }

Which is the best option used to move database from one server to another serve on same network and why?

556

Is access a good database?

816

Why is a primary key important?

1071

Why do you think it is advised to not to use guid and character columns as clustered index arrays?

1141

How can we check whether A S M instance is up or down?

2438

How to create a table?

1015

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

1183

What is exclusive locks?

980

Why not phenix, the zelinka/otwinoski libraries, etc?

1143

What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

1215

Explain transaction server isolation?

1063

What is use of dbms?

965

What is delete query?

958

How do temporal tables work?

984

How many types of keys are there?

1048

For More Un-Answered { Databases } Questions Click Here