BCA Semester 4 – Database Management System – Unit 8: Query Processing and Security (5Hrs.)

Question 1

Discuss about materialized and pipelined evaluation of query expression in query optimization.

Marks: 5

Year: 2020 Final TU FOHSS

Materialized vs Pipelined Evaluation 1. Materialized Evaluation Materialized evaluation is a method where each operation of a query is executed separately, and its intermediate result is fully comput

Question 2

How cost of query is measured during query processing? Construct query expression tree for the relational algebra query:TLFName LName, Address(ODName="Research" ∧ Department Dnumber=Dno (Employee Wor

Marks: 5

Year: 2021 Final TU FOHSS

DBMS – Query Processing & Query Tree Construction --- 1. How Cost of a Query Is Measured? (5 marks) During query processing, the cost refers to the resources required to execute a query. ✅ Main fact

Question 3

Differentiate between discretionary access control and mandatory access control with example.

Marks: 5

Year: 2024 Final TU FOHSS

Discretionary Access Control (DAC) vs Mandatory Access Control (MAC) | Feature | Discretionary Access Control (DAC) | Mandatory Access Control (MAC) | |---------|----------------------------------|---