Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
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?
What do you mean by E-R model? What are the components used to draw an E-R diagram? Write down the advantage and disadvantage?
Describe two-tier client/server architectures for DBMS? Describe three-tier client/server architectures for DBMS?
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.