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

Difference between 2NF &3NF ?

Cap Gemini,

1 1141

What will happen when a Rollback statement is executed inside a trigger?

Flextronics, Hexaware,

1 2075

What do you mean by a dependent functionality in a build?

HCL,

1 1213

How do you create type- insensitive operator?

EXL,

1 1118

Give me a SQL Query to find out the second largest company?

Ernst Young,

1 1234

Explain different types of Normalization.

HPCL, Hughes Systique Corporation, Ittiam Systems,

2 1920

What is the difference between Triggers and Stored Procedure?

HCL,

1 1167

Explain the concept of view and Types of views in SQL server?

HCL,

1 1040

How to connect of datebase with sql express.?

MCN Solutions,

1 1150

What do you mean by a Composite primary key?

Genpact,

1 1210

Are all views updatable ?

MCN Solutions,

1 1211

How each E-R model constructs can be mapped to the relational model?

HCL,

1 1058

Tell me about normalization in DBMS.

Honeywell, Zomato,

1 1070

what is the difference between count(*) and count(1) ?

MCN Solutions,

1 1140

Relational calculus is what type of language?

HCL,

1 1111

Un-Answered Questions { Databases }

How can you append an identity column to a temporary table?

1051

How to put more than 1000 values into an oracle in clause?

1095

Why and when do stored procedure recompile?

1042

How to start an oracle instance?

1086

Is microsoft getting rid of access?

877

Do we need to rebuild index after truncate?

1114

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2335

Can sql servers link to other servers like oracle?

900

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

What is an indexed view?

1013

Can delete statement be rollbacked?

1038

What is the difference between case version and decode version?

1091

What are the steps in creating a database?

985

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 did mongodb get its name?

For More Un-Answered { Databases } Questions Click Here