Questions with Complete Solutions - Hamro CSIT

Explain deadlock with example. What are different deadlock prevention protocols? Explain deadlock detection and starvation.

Not Answered Database Management System Asked on 2080(new) Exam

Consider a banking database with three labels and primary key underlined as given below:

Customer (CustomerID , CustomerName, Address, Phone, Email)

Borrows (CustomerID, LoanNumber )

Loan ( LoanNumber , LoanType, Amount )

Write both relational algebra and SQL queries:

To display name of all customers who live in “Lalitpur” in ascending order of name.

To count total number of customers having loan at the bank.

To find name of those customers who have loan amount greater than or equal to 500000.

To find average loan amount of each accoun’t type.

Not Answered Database Management System Asked on 2080(new) Exam

What is relational database? Explain different characteristic of a relation. Defain domain constraint.

Not Answered Database Management System Asked on 2080(new) Exam

Write short notes on:

Transaction processing

Weak entity

Not Answered Database Management System Asked on 2080(new) Exam

Explain different features of enhanced ER(EER) model. Compare specialization with generalization.

Not Answered No Subject Asked on 2080 Exam

Compare object oriented database with object relational database. What are different object database features that have been included in SQL ?

Not Answered No Subject Asked on 2080 Exam

Why distributed database is important? What is transparency? Explain different types of transparencies in distributed databases.

Not Answered Advanced Database Asked on 2080 Exam

Why hashing is important to store data in databases? What is primary file organization?

Not Answered Advanced Database Asked on 2080 Exam

Explain aggregation with suitable example.

Not Answered Advanced Database Asked on 2080 Exam

What is ODMG object model? What is object definition language?

Not Answered No Subject Asked on 2080 Exam

HAMROCSIT.COM

Copyright 2024 | HAMROCSIT.COM | All Right Reserved - Nymna Technology