Which one is correct? (a) DML includes a query language based on both relation…

2018

Which one is correct?

(a) DML includes a query language based on both relation algebra and tuple calculus

(b) DML includes a query language based on tuple calculus

(c) DML includes a query language based on relational algebra

(d) DML includes a query language based on none of the relational algebra and tuple calculus

  1. A.

    a

  2. B.

    b

  3. C.

    c

  4. D.

    d

Attempted by 133 students.

Show answer & explanation

Correct answer: A

Data Manipulation Language (DML) in relational databases involves commands for retrieving and manipulating data.

The theoretical foundation of DML query languages, such as SQL, is based on both relation algebra and tuple calculus.

This dual foundation allows for both set-oriented operations and logical query formulation.

A video solution is available for this question — log in and enroll to watch it.

Explore the full course: Tpsc Assistant Technical Officer