Question
Find the wrong number in the given number series.
80, 84, 75, 88, 66, 102Solution
ATQ, 80 + 2 2 = 84 84 β 3 2 = 75 75 + 4 2 = 91 91 β 5 2 = 66 66 + 6 2 = 102 Therefore, 91 should come in place of 88.Β
Which of the following is a key characteristic that distinguishes a PL/SQL `FUNCTION` from a PL/SQL `PROCEDURE`?
Given a table employees(id, dept_id, salary), which query returns departments with average salary greater than overall average across the company?
What is the main function of a PL/SQL `TRIGGER`?
Which operator is used for pattern matching in SQL?
Which SQL constraint ensures a column cannot have NULL values?
Which of the following is a key characteristic that distinguishes a PL/SQL `FUNCTION` from a PL/SQL `PROCEDURE`?
Which type of trigger fires once for each row affected by the triggering DML statement?
Which SQL command is used to remove a table completely?
Which SQL function returns the number of rows in a table?
Which SQL keyword is used to remove duplicate records from a query result?