Question
The average number of taxis of three colours (black,
white and yellow) in a taxi stand is 123. The number of black taxis is 40 more than that of yellow taxis. The total number of black and white taxis is 270. Find the number of white taxis in a taxi stand.Solution
Let the number of white taxis be βxβ Therefore, number of black taxis = (270 β x) Number of yellow taxis = (270 β x β 40) = (230 β x) According to the question, 230 β x + 270 β x + x = 123 Γ 3 Or, x = 131
Which PL/SQL cursor attribute returns `TRUE` if the most recent `FETCH` statement returned a row, and `FALSE` otherwise?
Materialized views differ from normal views because:
SQL Injection can be prevented by all EXCEPT:
Which SQL command is used to modify existing records in a table?
Which SQL operator is used to search for a pattern in a column?
Deadlock in DBMS can be prevented using:
What is the primary purpose of a PL/SQL `CURSOR`?
Which SQL command is used to remove a table completely?
What is the main function of a PL/SQL `TRIGGER`?
A `BEFORE INSERT` trigger fires: