Question
The ratio of ages of P and Q is 4:7. If the sum of their
ages is 132 years, what is Q’s age?Solution
ATQ, Total parts = 4+7=11; 1 part = 132÷11=12 Q = 7 parts = 7×12 = 84
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: