Question
What will come in the place of '?' in the following
equation, if '+' and 'β' are interchanged and 'Γ' and 'Γ·' are interchanged? 108 Γ 9 + 15 β 17 Γ· 2 = ?Solution
Given- 108 Γ 9 + 15 β 17 Γ· 2 = ? After interchanged- 108 Γ· 9 β 15 + 17 x 2 12 β 15 + 34 - 3 + 34 = 31
Which PL/SQL cursor attribute returns `TRUE` if the most recent `FETCH` statement returned a row, and `FALSE` otherwise?
What is the result of SELECT COUNT(NULL) on any table?
ROW_NUMBER() OVER (PARTITION BY dept ORDER BY salary DESC) assigns:
Which type of trigger fires once for each row affected by the triggering DML statement?
What is the output of this SQL snippet if the price column contains NULL values?
SELECT SUM(price) FROM products;
Which type of index physically reorders the data rows in the table itself based on the index key, meaning the data is stored in the order of the index?
What is the primary purpose of a `SEQUENCE` in SQL?
Which of the following is a key characteristic that distinguishes a PL/SQL `FUNCTION` from a PL/SQL `PROCEDURE`?
What is the correct sequence of operations for using an explicit PL/SQL cursor?
Which SQL command is used to modify existing records in a table?