Question
Explain the characteristics of a data warehouse. What are the components of a data warehouse? Explain. Also, explain the multi-dimensional data, star schema and snowflake schema in the context of a data warehouse with the help of an example. How is a data warehouse related to data mining?
Explain the characteristics of a data warehouse. What are the components of a data warehouse? Explain. Also, explain the multi-dimensional data, star schema and snowflake schema in the context of a data warehouse with the help of an example. How is a data warehouse related to data mining?
Explain the following with the help of an example.
(a) Stored Procedures and Triggers
(b) Embedded SQL
Create an XML document for Books using Book ID as an attribute. It should include information about the title of the Book, Author list of the Book, ISBN number of the book, Publisher of the Book, price of the book, year of publication and a brief description of the book. Create the necessary DTD to verify the document. You should show data of at least 3 books
Explain the term Serializability with the help of an example. Explain the two-phase locking protocol in the context of concurrent transactions. Also, explain the timestamp-based protocols for concurrent transactions.
What is access control in the context of DBMS? What are the different access permissions that can be granted using SQL? Explain with the help of an example of each. Explain the concept of Statistical database security with the help of an example.
Explain the concept of log-based recovery with the help of an example for the deferred database modification scheme. What is a checkpoint? How can it be used in recovery? Explain with the help of an example.
Briefly explain the architecture of the Oracle Database Management System
IGNOU Doubts & Queries
Click to Contact Us
Call - 9199852182 Call - 9852900088 myabhasolutions@gmail.com WhatsApp - 9852900088