Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
Describe the mapping of the given to the relational database schema.
Describe the two-phase locking protocol? Describe strict and conservative two-phase locking protocol? Which of them is favored and explain why?
List out the main responsibilities of a general purpose Database Manager (DBM)? What problems might take place if these responsibilities are not met by the DBM?
Describe the fundamental components or elements of the data warehouse with the help of a diagram.
Write down some of the reasons for the iterative development of data warehouse. As well describe the role of data model in the iterative development.
Describe primary and secondary data in the context of snapshots in data warehouse.
Critically discuss in detail about the objects of Access database. Write down the steps which are involved in the modifying the fields in a table.
Define the tern distributed database. Distinguish between distributed and parallel databases. As well illustrate some merits of distributed databases.
Write down the Apriori algorithm for discovering frequent item sets for the mining Boolean association rules.
Explain OLAP operations in the multidimensional data models.
Describe the various strategies for data reduction throughout the data pre-processing?
What do you mean by shadow page recovery scheme? Explain how does it compare and contrast with the log-based recovery methods in terms of ease of implementation and overhead costs?
Write down the relational algebra expression for the given:
Write down the fundamental operations in the Relational Algebra? Describe different joins in relational algebra with the help of appropriate illustrations.
Describe the recoverable and cascadeless schedules with the help of an illustration.
Describe the difference between dimensional data modeling and relational data modeling.
Describe the term Normalization in data warehouse. List all its merits.
Describe how the system development life cycle for data warehouse is just opposite to the classical SDLC.
Explain Floating horizon algorithm for the hidden surface removal. Illustrate the merits and demerits of the Floating horizon algorithm.
Write down the name of four hidden-surface algorithms.
Describe the different concurrency control measures which are used in DBMS.
The account holder can enquire regarding the balance in his account. Draw the ER Diagram for the bank.
Describe the different levels of abstraction in the DBMS with the help of a diagram. Explain why do we require mappings between various schema levels?
Describe the main steps of Extraction Transformation and Loading process (ETL).
Describe the Basic Concepts and Output Knowledge Representation of Data categorization.