Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
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.
Explain the differences between trivial and nontrivial dependencies. Write down the difference between function and procedure?
Create two tables company_info with fields, emp_id, name, city, salary, designation, date_of_joining and personal_info with fields name, city, address, DOB, and phone_no. Modify the table by adding
Write down the syntax for creating the two table with primary key and foreign key as roll for both the table?
Describe the BOYCE-CODD Normal Form? Describe Normal Forms Based On Primary Key?