Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
Explain and differentiate the record and parent child relationship concepts in the hierarchical model?
Explain and differentiate the two fundamental structures of network data model?
Illustrate the main software modules of a DDBMS? Describe the main functions of each of these modules in the context of client-server architecture.
What do you understand by the term UNDO-type and REDO-type log entries? Illustrate out the write-ahead logging protocol.
Why do practical recovery techniques use protocols which don’t permit cascading rollback? Which recovery methods don’t need any rollback?
Describe the given rules governing the manipulation of the relational algebraic expressions?
What are the different guidelines which require to be taken care of while designing a relational schema?
Describe in detail the term Relational Algebra. What are the relational algebra operations which can be performed?
Describe the significance of ER Model for the Database design?
Differentiate between the term logical and physical database design.
Write down the characteristics of data warehouse? Compare and contrast different clustering methodologies.
Write down the steps in data mining process and explain them in detail? What do you mean by data cleaning?
Explain any Data Ware House Architecture with proper explanation.
What do you mean by data Mart? Explain it in detail. What do you mean by Data cube Technology?
Explain cold's rule for OLAP tools. Present a diagnostic representation of a data ware house architecture.
Distinguish Star and Snow flake schemas of Data warehouse.
What do you mean by predictive modelling based data mining.
Describe the term Query Manager in detail. What do you mean by the term Data Mining. Explain it in detail.
Write down the different merits and demerits of data warehousing?
What is deadlock? What are the FOUR necessary conditions for a deadlock occurrence? How deadlock can be prevented?
Briefly explain the three levels of data abstraction? Describe indexed file organization?
Describe the basic operations that can perform using relational algebra. Also describe the concept of referential integrity in database management system.
What do you mean by data conversion function? What do you mean by partitioned views? Write down are the advantages of indexes?
What is Normalization and its need? Explain in brief the different steps used to normalize any data base.
Describe the architecture of Database system. Explain different types of security methods to be established in RDBMS.