Question
Which of the following letter-clusters will replace the
question mark in the given series to make it logically complete? SBJO, PZHL, ?, JVDF, GTBCSolution
S – 3 = P, P – 3 = M, M – 3 = J, J – 3 = G B – 2 = Z, Z – 2 = X, X – 2 = V, V – 2 = T J – 2 = H, H – 2 = F, F – 2 = D, D – 2 = B O – 3 = L, L – 3 = I, I – 3 = F, F – 3 = C
Given a table employees(id, dept_id, salary), which query returns departments with average salary greater than overall average across the company?
Which SQL constraint ensures a column cannot have NULL values?
Which index type is most beneficial for queries that use range predicates (e.g., WHERE age BETWEEN 20 AND 30)?
Recursive CTEs are mainly used for:
Which of the following is true about a foreign key?
Which operator is used to combine results of two SELECT queries and remove duplicates?
Which SQL clause is used for filtering rows?
Which SQL operator is used to search for a pattern in a column?
Which SQL clause is used to filter results after a GROUP BY operation?
Which SQL keyword removes duplicate rows automatically from results?
