Question
Three boys step off together from the same spot. Their
steps measure 64 cm, 80 cm and 88 cm respectively. The minimum distance each should cover so that all can cover the distance in complete steps isSolution
Required distance = LCM of 64, 80 and 88 cm = 3520 cm.
LCM = 8 × 2 × 4 × 5 × 11 = 3520
What is the primary purpose of a `SEQUENCE` in SQL?
In PL/SQL, what type of parameter allows a procedure to both receive a value from the calling environment and return a modified value back to it?
Which SQL clause is used for filtering rows?
Which SQL command is used to modify existing records in a table?
Which type of trigger fires once for each row affected by the triggering DML statement?
Which operator is used for pattern matching in SQL?
When does an implicit cursor get automatically declared and managed by PL/SQL?
Which SQL command is used to remove a table completely?
Which join returns rows from the left table even when there is no matching row in the right table, filling with NULLs for the right side?
What is an SQL `VIEW`?