Question
If 45780x52 is divisible by 72, then find the sum of all
possible values of 'x'.Solution
72 = 8 X 9 So, the given number must be divisible by both 8 and 9. If the given number is divisible by 8, then x52 is divisible by 8 So, possible values of 'x' are 1, 3, 5 and 7. If the given number is divisible by 9, then sum of the digits must be divisible by 9, So, 4 + 5 + 7 + 8 + 0 + x + 5 + 2 = (31 + x) must be divisible by 9 So, only possible value of x is 5 So, required sum = 5
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?