Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
Describe the architecture of DBMS with a neat block diagram:
What are the three sections of PL/SQL block? What are the retrieval operations in SQL? Describe. Explain the First, Second and Third Normal forms with suitable examples.
With diagrams describe various types of access to a distribute database. With example describe horizontal and vertical fragmentation.
Describe the techniques used to increase concurrency in locking scheme. With a diagram describe backward validation technique. Compare the same with forward validation technique.
Describe multi valued dependency and Fourth normal form. Describe the different Armstrong’s axioms and why they are used. Describe the multi table clustering file organization.
What are attributes? Describe various types of attributes with example. How they are represented in an ERD. Describe the concept of recoverable and cascade less schedules.
What are the various categories of Hierarchical Clustering? Describe BIRCH technique of cluster representation in large databases with example.
How is association rules mined from large databases? Write Apriori algorithm to discover all frequent itemsets from large databases.
Describe two types of Priority Queue and the operations performed on them. Give two advantages and two disadvantages of a Linked List over an Array.
Describe knowledge discovery in databases process. Bring out the block diagram of KDD process and explain the components of KDD process. Describe generalized Bayes decision model. Describe decision t
Describe the features and advantages of SANCopy as a Data Migration Tool. Describe the different logs used in MirrorView.
How can you store the XML data in relational databases using tree representation? Describe. How the various geometric constructs can be represented in a database in a normalized fashion?
With essential examples, define the following: Super Key and Primary Key. How the EER diagram can be reduced to relations? Describe.
Data replication is an important mechanism commonly employed in a distributed database environment. Replication provides a number of benefits in terms of enhanced system performance.
an overloaded constructor with three parameters to assign values to the humidity, air_pressure, atmospheric_temperature.
Describe briefly the three components of a Client/Server Architecture, and use a fully labelled diagram to show the interaction between the components.
Air Mauritius Ltd publishes a weekly flight log report, which tracks each aircraft and the number of hours which were flown by an individual pilot in each aircraft.
Suppose that for each query, you could create up to two index structures to make the query faster. What index structures would you create, and how would this change the evaluation plans and running
What are the main differences between primary key and foreign key? Describe it in detail with the help of appropriate examples. Define logical database model. What are its types? Describe it in detail
How are relationships between tables expressed in relational database?
What do you understand by Primary Key and Foreign Key? Describe with example. What is Normalization? Why it is essential?
Create database schema for the tables given below using the CREATE TABLE command.
List the First Name, Last Name and telephone number of all employees who were appointed in the year 1995. List all details of employee who is not managed by any employee.
Draw Entity-Relationship model for the relational schema given in Appendix. Show all the entities, relationships names, relationship, and attributes and also underline the primary key for each and e
Write the SQL code that will create ALL the tables as given in the appendix. Your answer should not contain the primary key and foreign key constraint declaration.