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 used to replicate sessions between instances in coldfusion clusters?

HCL,

1 1116

How to transfer a table from one schema to another?

MCN Solutions,

1 1062

Write the queries for commands like Create Table, Delete table, Drop Table etc.

HPCL, Hughes Systique Corporation,

1 1186

What is the difference RDBMS and Graph Database?

EXL,

1 1095

do views contain data ?

MCN Solutions,

1 1030

What is difference between global temporary tables and local temporary tables?

Tech Mahindra,

1 1292

What is trigger and different types of Triggers?

QuestPond,

1 1208

What are difference between Cluster index and Non-Cluster index?

QuestPond,

1 1143

How to delete duplicate records based on single column from a table?

Petranics Solutions,

1 1116

Which Model uses the SET concept

Infosys,

1 1049

What are Row versions of DataRow?

1 1093

What is data block and how to define data block size?

1 1089

What is cursors?

NA,

1 1277

Can you get second highest salary from the table?

QuestPond,

1 1020

What is the difference between a check constraint and a rule?

1 1376

Un-Answered Questions { Databases }

What are the types of database explain each of them briefly?

1038

Have you used lexical parameters in reports?

Suppose database is running slow, what will you do?

2580

How efficient you are in oracle and SQL server?

1234

Do we need to rebuild index after truncate?

1110

Can delete statement be rollbacked?

1038

1. Tell me about your self? 2. Latest Project Introduction? 3. Difference between server jobs and parallel jobs? 4. Seq-Seq Explain its behavior and execution mode and which parallelism technique is used? 5. What is padding characters? 6. Seq-Seq, Seq-Copy-Seq which one is the best and efficient? 7. How many reject links do we have to a transformer? 8. How many reject links to join stage? 9. Difference between join and lookup? 10. How to design PX routine? 11. How can we call job in another job? 12. Difference between batch and sequencer? 13. Which Database is used? 14. What is change capture? Give briefing of that? 15. What is change Code? Explain? 16. How you call UNIX in Ds? 17. How do you call JCL in UNIX? 18. How do you pass the job status of one job to another job? Have designed any job sequencer? 19. How do you find a file in existed directory? 20. How can you call parallel jobs in transformer? 21. Execution of jobs in command line? 22. Tuning of sql queries? 23. What is orchestrating metadata? 24. What are junk dimension? 25. What are the third party tools you are used? 26. What are the system variables you have used?

1899

How to define array in mongoose schema?

How to convert character strings into numeric values?

1166

How do I find query history in sql server?

1000

Does group by remove duplicates?

1099

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1015

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1055

what is the last version,the release date of that version and fix pack of ibm db2 udb?

2035

Where can you add custom error messages to sql server?

1190

For More Un-Answered { Databases } Questions Click Here