List of top Computer Science and IT Engineering Questions asked in AP PGECET

In Java, when we implement an interface method, it must be declared as ________.
 

In asynchronous transmission, the gap time between bytes is ________.
 

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 _______ .
Among the four criteria for synchronization mechanism, which of the two criteria are mandatory?
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?