Question
The “Digboi Oil fields” are located in which of
following states of India?Solution
The correct answer is A
What is the result of SELECT COUNT(NULL) on any table?
Which SQL function returns the number of rows in a table?
ROW_NUMBER() OVER (PARTITION BY dept ORDER BY salary DESC) assigns:
What is the output of this SQL snippet if the price column contains NULL values?
SELECT SUM(price) FROM products;
Recursive CTEs are mainly used for:
Which operator is used for pattern matching in SQL?
SQL Injection can be prevented by all EXCEPT:
Which SQL clause is used for filtering rows?
Which SQL keyword is used to eliminate duplicate rows in a query result?
Which SQL statement combines the results of two queries and removes duplicates?