Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Probelm:
a) In the context of OODBMS, define the following terms with appropriate examples.
(i) Object class. (ii) Abstract class. (iii) Aggregation. (iv) Overriding.
b) Parallelism deals with the issue of processing two or more activities in parallel.
(i) Flynn's taxonomy uses the relationship of program instructions to program data. Explain briefly on any one category of the Flynn's classification. Support your answer with appropriate diagram.
(ii) Distinguish between multiprocessing systems and multiprogramming systems. Support your answer with appropriate diagram.
(iii) Explain briefly any two needs of parallel database.
(iv) Briefly explain three advantages of parallel database.
Describe the static hash file with buckets and chaining and show how insertion, deletion and modification of a record can be performed. In static hash file organization, the wo
List the steps for converting state diagram to the code. a) Finding major control path b) Finding the conditional statements c) Finding the loops d) Finding error ro
How can you map NULL values to other values while display? IF( ) , IFNULL( ) keywords are used to do so. They are 'LIMIT' is used for the following kinds of problems: 1) Ans
What are the uses of functional dependencies? To test relations to see whether they are legal under a given set of functional dependencies. To state constraints on the set
What are the time stamps associated with each data item? W-timestamp (Q) denotes the largest time stamp if any transaction that implemented WRITE (Q) successfully. R-timesta
How does the system cope up with a record crash when recovery is going on after the first crash? Ans: In a system the undo and redo operations are needed to be idempotent to c
Write short notes on Schema diagram. A database schema along with primary key and foreign key dependencies can be depicted pictorially by schema diagram. Every relation appears
What is database Trigger? A database trigger is a PL/SQL block that can explained to automatically execute for insert, update, and delete statements against a table. The trigge
What is multiplicity in the associations? Give an example to explain multiplicity? Multiplicity in association indicate number of objects participate in any relationship. For
Question 1 Discuss about second normal form and third normal form Question 2 Write short note on 1) Data Manipulation Language 2) Data Definition La
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd