List of top Questions asked in AP PGECET

A development team conducts interviews, observations, and questionnaires before starting system design. The goal is to understand user expectations, constraints, and workflows. This activity primarily supports?

A file is stored such that records are placed in no particular order, and searching requires scanning the entire file. This organization is known as?

Software project management involves multiple activities carried out throughout the project lifecycle, including planning, execution, and post-delivery support. Select the statement that correctly reflects this concept?

Two transactions execute concurrently, but their results are the same as if they were executed one after another. This property is called?

What is the primary difference between a B-tree and a B+ tree?

Which of the following is a conflict-serializable schedule?

Which of the following relational algebra operations is equivalent to a Cartesian product followed by a selection (sigma)?

A database designer is refining a relation that has a composite primary key. Some non-key attributes depend only on part of this key, leading to redundancy. Removing such dependencies ensures the relation satisfies a higher normal form. The correct statement describing this transformation is _______.

A relation R is in 3NF if every non-prime attribute of R is:

A relation $R(A, B, C)$ has the following functional dependencies:
$A \to B, B \to C$
If attribute $A$ is known, the value of $C$ can be determined due to:

Which of the following transitions is NOT possible in a standard process state transition diagram?

What is the main purpose of a Translation Lookaside Buffer (TLB)?

Which of the following is a solution to the "Critical Section Problem" that satisfies mutual exclusion, progress, and bounded waiting?

Which memory technique creates the illusion of larger memory?

What is the "Thrashing" phenomenon in virtual memory systems?

Consider the following C function:
int fun(int n){
if (n == 0) return 0;
else return n + fun(n - 1);
}
What does the function fun(4) return?

Three processes arrive at time 0 with burst times 5, 3, and 1 unit respectively. The scheduler always selects the process with the smallest burst time next. The order of execution will be?

In an I/O system, 'Direct Memory Access (DMA)' is used to:

'Belady’s Anomaly' refers to the phenomenon where the page fault rate increases as the number of allocated page frames increases. This is observed in which page replacement algorithm?

A system has 4 redundant units of a resource. There are 3 processes, each requiring 2 units of the resource. Which of the following is TRUE?

Which phase of a compiler checks variable declaration?

A handle in a bottom-up parser is a substring that matches the right-hand side of a production and whose reduction represents:

In Syntax Directed Translation (SDT), an attribute is called "inherited" if its value at a node in the parse tree is defined in terms of attributes at:

In the context of code optimization, "Loop Invariant Code Motion" refers to:

Which of the following intermediate code representations is typically used to represent expressions where each instruction has at most three operands?