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 i Relate Tables in SSIS

HCL,

1142

What are audit control procedures?

Ernst Young, Thomson Reuters,

1045

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

MCN Solutions,

1040

What is the Disadvantage of indexed sequential file.

HCL,

1141

Explain Geography datatype in SQL Server

Infosys,

1203

What is the difference between implicit and explicit transaction?

1058

Tell me about joins in database system and explain each in detail.

Axtria, ITC Indian Tobacco Company,

1116

What is SubQuery in SQL Server 2008

HCL,

1083

How to find Duplicate Records In table?

HCL,

1081

What is the beast way to write CTE in SQL Server ?

HCL,

1102

Why is DML provided?

Ernst Young, Thomson Reuters,

1 2784

What are the types of database recovery models?

HCL,

1201

What is function of CUBE ?

HCL,

1092

What is RAID? What are the different types of RAID configurations?

Flextronics,

1198

What is order of B+tree?

HCL,

1162

Un-Answered Questions { Databases }

What is @@error in sql?

1121

How to drop an index in oracle?

1128

Explain 3 basic parts of a trigger.

1379

What is the use of double ampersand (&&) in sql queries? Give an example

1199

can any body tell me how to know the password of current user in sql server

2129

8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?

1899

What is raid? : SQL Server Architecture

1244

What is the difference between set and select?

1173

Can I create users through internet explorer in oracle 10g?

1167

Is storing images in a database a good idea?

1054

How many servers can we create in a single subscription?

162

What is full text indexing in mysql?

1006

Is mysqli faster than mysql?

988

What is subreport?

144

What is pl sql commands?

1103

For More Un-Answered { Databases } Questions Click Here