Answer Posted / lakki

DBMS : Data Base Management System
..... for storage of data and efficient retrieval of data.
Eg: Foxpro

1)A DBMS has to be persistent (it should be accessible when
the program created the data donot exist or even the
application that created the data restarted).
2) DBMS has to provide some uniform methods independent of a
specific application for accessing the information that is
stored.
3)DBMS does not impose any constraints or security with
regard to data manipulation. It is user or the programmer
responsibility to ensure the ACID PROPERTY of the database
4)In DBMS Normalization process will not be present

RDBMS: Relational Data Base Management System
.....the database which is used by relations(tables) to
acquire information retrieval
Eg: oracle, SQL..,

1)RDBMS is based on relational model, in which data is
represented in the form of relations, with enforced
relationships between the tables.
2)RDBMS defines the integrity constraint for the purpose of
holding ACID PROPERTY.
3)In RDBMS, normalization process will be present to check
the database table cosistency
4)RDBMS helps in recovery of the database in case of loss of
database due to system failure or any other reason

What is rdbms with diagram?

488

---

What is a checkpoint and When does it occur in database?

677

---

How many number of columns can a RECORD GROUP have ?

1583

---

explain about the critical recovery scenario you had experienced

1645

---

What is dbms pdf?

605

---

---

How to drop all foreign keys in database?

528

---

What is a database in business?

538

---

Define normalization.

576

---

What is tuple in rdbms?

573

---

Define view, sequence and index in DBMS.

562

---

For each user who needs access, the DBA creates an account in which database?

570

---

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?

1451

---

does pl/sql support “overloading”? Explain

549

---

Who invented schema theory?

470

---

Explain the difference between physical and logical data independence?

486

---