what is the difference between DBMS and RDBMS??
Answer Posted / janma
DBMS:
# small organization with small amount of data.
# less memory.
# contains only flat data.
# no concept of primary key & foreign key.
# supports single user.
# can be saved in any order.
RDBMS:
# designed to take care of large amount of data.
# more memory.
# contains some relation between entities.
# includes primary key & foreign key.
# supports multiple user.
# should be sved in table format.
| Is This Answer Correct ? | 39 Yes | 8 No |
Post New Answer View All Answers
What is database management system explain?
Define entity set.
Is dynamodb a document database?
What is the purpose of database?
Define truncate and delete commands?
Give the cobol definition of a varchar field 177 when can an insert of a new primary key value threaten referential integrity?
Enlist some commands of ddl?
What are the two types of indexes and explain them in detail?
What is database normalization with example?
What is a relation in dbms?
What is meant by database system?
What is tabular form?
What does fill factor concept mean with respect to indexes?
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?
How is view stored in database?