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

Does mongodb support primary-key, foreign-key relationship?

1 71

Is it possible to configure the cache size for mmapv1 in mongodb?

1 70

What will happen when you remove a document from database in mongodb? Does mongodb remove it from disk?

1 80

Why mongodb is known as best nosql database?

1 73

If you remove an object attribute, is it deleted from the database?

1 73

Why are mongodb data files large in size?

1 79

What will have to do if a shard is down or slow and you do a query?

1 66

Is mongodb a nosql database? Explain.

1 89

By default, which replica sets are used to write data?

1 75

Is it true that mongodb uses bson to represent document structure?

1 68

What is the difference between mongodb and redis database?

1 70

In which format mongodb represents document structure?

1 76

What are queries in ms access?

1 970

What is the role of where clause in ms access?

1 909

What is maximum size for an access database?

1 1021

Un-Answered Questions { Databases }

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2706

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1295

How to provide default values to function parameters?

1252

What versions of clipper does netlib support?

1090

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?

1910

How to write a left outer join with the where clause in oracle?

1151

Can delete statement be rollbacked?

1053

Can we shrink data file in sql server?

1123

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

2178

Have you used lexical parameters in reports?

What is the difference between upgrade and migration in sql server?

1180

How do I create a trace in sql server?

1116

Is primary key clustered index?

1018

what is spatial nonclustered index

1055

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1194

For More Un-Answered { Databases } Questions Click Here