510 questions and answers
How insertion sort and selection sorts are different?
Both sorting techniques maintains two sub-lists, sorted and unsorted and both take one element at a time and places it into sorted sub-list.
What is a Judy array?
Judy array is a complex but very fast associative array data structure for storing and looking up values using integer or string keys. Unlike normal arrays, Judy arrays may be sparse;
What is the benefit of using arrays of pointers instead of several pointer variables?
The benefit of using arrays of pointers is that you can use a for loop
What is attribute inheritance? Describe the concept of specialization and generalization in the context of ER-data model.
The higher-level entity type (or super-class) has the attributes that are common to all of its lower-level entity types (or sub-classes). These common attributes of the super-class are inherited by all of its sub-classes. This property is known as attribute inheritance.
State the advantages of using database system over file-based information system.
The database approach offers a number of potential advantages compared to traditional file processing systems.
Describe the Three-Schema Architecture of DBMS. Distinguish Physical Data Independence and Logical Independence.
The goal of the three-schema architecture is to separate the user applications and the physical database. In this architecture, schemas can be defined at 3 levels:
Discuss the ACID properties of transaction.
A transaction is a very small unit of a program and it may contain several low-level tasks. A transaction in a database system must maintain Atomicity, Consistency, Isolation, and Durability − commonly known as ACID properties − in order to ensure accuracy, completeness, and data integrity.
MindStudy - a preparation hub for all the students. The goal is to make it easier for pupils to get better grades on exams.
Copyright © 2025 MindStudy
A product by Shunya Intelliware Solution
(Registered under MSME Uddyam)