Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
Describe hiding and un- hiding a column? Describe the steps for the printing the tables?
Describe the advantages and disadvantages of hierarchical model? What do you mean by relationship and describe the types of relationships?
Describe the record based data models in RDBMS? What are the logical operator describe all with their syntax?
Write down three kinds of Record based logical model? Explain entity set, attributes, entities in detail with suitable example?
What do you understand by database package? Distinguish between DBMS and RDBMS? What do you mean by DBMS?
Name some DDL and DML command? Write down the syntax for Alter command? What do you mean by RDBMS, entity?
Make a Relational Data Model to implement a business state that is explained by using an Entity Relationship Diagram and text.
Use a join to display the employee identification number and employee name of all employees of the production department.
Describe in detail about Multi dimensional analysis and descriptive mining of complex data objects.
Describe data warehouse process. Describe the different system management tools in a data warehouse.
Write down the advantages of SQL CODE? Write in detail Triggers predicates and Trigger Mutating tables.
Describe embedded SQL and dynamic SQL in detail:
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.