Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
Illustrate out the method to create windows application. Illustrate out the term arrays? Describe one dimensional array with appropriate illustrations.
Illustrate out any two (2) full text search functions. Illustrate out any five (5) Flow Control Constructs.
Illustrate the key properties of the long duration transactions? How does the concurrency protocol influence the long duration transactions?
What do you mean by the primary goal of normalization? Illustrate how the concepts of functional dependency and multi valued dependency related with the normalization? Give an illustration for the s
Find out the names of pilots who can operate planes with a range more than 3,000 miles, however are not certified on any Boeing.
With respect to the relational data model, illustrate the concept of primary and foreign key constraints. Explain why are primary and foreign keys used? Describe your answer with illustration.
Illustrate the fields in which clustering methods are used? Illustrate any four fields. Describe fundamental requirements of the cluster analysis.
Describe in details three main reasons why the data warehouse modeling needs modeling methods other than OLTP database modeling.
What do you mean by the term Constraint-Based Association Mining?
What do you understand by software and hardware RAID systems?
What is a shadow copy scheme? What do you mean by access time, seek time and average seek time.
Describe in about Boyce code normal form and fifth normalization form with suitable example. Explain detail in decomposition using Functional Dependencies.
What do you mean by shared lock and Exclusive lock? What is meant by transaction rollback?
Describe String Operations and Aggregate functions used in SQL. Describe detail in domain relational calculus.
Write down the difference between RDBMS and OODBMS. Describe the concept of class, Abstraction, Encapsulation and inheritances. How do we make objects persist in OODBMS?
Explain different data types and operators in ORACLE. What is the function of cursors?
What are the various types of integrity constraints? Describe referential integrity constraints.
What do you mean by E-R model? What are the different symbols used to draw E-R diagram? Draw E-R diagram for the following organizations: Public Library, Educational Institute and Hospital.
Describe decomposition of a database in database design. Why consolidation of database after normalization is considered during designing a database.
What do you mean by a system log? What is the purpose of the system log in system recovery?
When does a server Roll Forward and rollback a Transaction. What is a Transaction? What are the properties of a Transaction? What are different transaction states?
Write down the difference between tuple relational calculus and domain relational calculus?
What is structured query language? How the DDL and DML are different? Describe.
Write down the difference between the strong entity set and weak entity set?
Sketch a Privacy preserving clustering method so that a data owner would be able to ask third party to mine the data for quality clustering without worrying about the potential inappropriate disclos