SSC IMD Scientific Assistant – Full Length Mock 01

Question: In SQL, what is the effect of an INNER JOIN between two tables that share no matching rows based

Question: What is the total number of swappings performed by Bubble Sort on an array of \(n\) elements that is

Question: In relational algebra, which fundamental operator is used to select a subset of columns from a relation? रिलेशनल बीजगणित

Question: Which of the following problems cannot be solved in polynomial time by a deterministic Turing machine (i.e. is widely

Question: Which SQL clause is used to filter the results produced by the GROUP BY aggregate clause? GROUP BY एग्रीगेट

Question: Consider relation \(R(A, B, C, D)\) with functional dependencies \(F = \{A \rightarrow B, B \rightarrow C, C \rightarrow

Question: Which normal form strictly requires that every non-prime attribute must be non-transitively dependent on every candidate key (i.e. eliminates

Question: If a counting semaphore \(S\) is initialized to 10, and then 6 wait (P) operations and 4 signal (V)

Question: In a paging system, the page table is stored in main memory. To speed up address translation, a specialized

Question: What is the state of severe performance degradation where the operating system spends more time servicing page faults and