Question 1
Which relational algebra operation selects rows that satisfy a given predicate?
The Selection operator ($\sigma) filters tuples (rows$) in a relation that satisfy a specified boolean condition.
Which relational algebra operation selects rows that satisfy a given predicate?
The Selection operator ($\sigma) filters tuples (rows$) in a relation that satisfy a specified boolean condition.
In relational algebra, which operator is represented by the symbol $\pi$?
The Projection operator (pi) selects specified columns (attributes) from a relation and removes duplicate tuples from the result.
Which SQL statement is used to remove a table along with its structure and data permanently from the database?
DROP TABLE is a DDL command that completely deletes the table definition, its schema, indexes, constraints, and data from the database.
Which statement best describes the usual difference between DELETE and TRUNCATE in SQL?
DELETE is used to remove selected rows (or all rows) and supports a WHERE clause. TRUNCATE removes all rows without a WHERE clause while retaining the table definition. Logging, rollback, and classification details vary across DBMS products.
Which of the following normal forms deals with multivalued dependency (MVD)?
Fourth Normal Form (4NF) eliminates non-trivial multivalued dependencies (X ->-> Y) that are not functional dependencies.