List of top Computer Science and IT Engineering Questions on Database Management Systems asked in AP PGECET

Which testing technique focuses on exercising the internal logic, control flow, and data structures of a software module?
Which of the following is true about a good hash function?

The term that optimizes subexpressions shared by different expressions in a program is called ________.
 

The optimizer that explores the space of all query-evaluation plans is called ________.
 

The database design that consists of multiple tables that are linked together through matching data stored in each table is called a _______.
 

If A $\to$ B has trivial functional dependency, then _______.
 

Which is the candidate key for the relation R(ABCDE) with functional dependencies F=A→BC, B→D, CD→E, E→A?
 

A relation \(R(A,B,C,D)\) with functional dependencies A→B, B→C is in _______ .
 

Which of the following commands is used to delete all rows and free up space from a table?
_______ uses Quantifiers that can be either Existential (*) or Universal (V).
In _______ relation, each tuple has relation R within it.
The rule which states that addition of same attributes to the right side and left side will result in other valid dependency is classified as _______ .
The separation of the data definition from program is known as _______ .
Natural Join can also be termed as _______ .
Which SQL operation is not part of the ACID properties?
A B+ tree is preferred over a B-tree for databases because _______ .
In two-phase locking (2PL), a transaction must be _______ .
The isolation level that prevents dirty reads but allows non-repeatable reads is _______ .
In a relational database, a table has 5 attributes and 1000 records. If a query returns 200 records after applying a condition, what is the selectivity of the query?