Question
Six person F, G, H, I, J and K are sitting around a
circular table facing each other and they are all adjacent to each other (not necessarily in the same order). G is on the immediate right of F. J is on the immediate right of H. H and I are facing each other. How many people are sitting between I and G when counting from the left of I?Solution
Which of the following is a key characteristic that distinguishes a PL/SQL `FUNCTION` from a PL/SQL `PROCEDURE`?
Which of the following statements about SQL `INDEXES` is generally TRUE?
What is the correct sequence of operations for using an explicit PL/SQL cursor?
Which clause is used to sort query results in SQL?
Which command removes all rows but keeps table structure?
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?
Which of the following is a mandatory component of a PL/SQL function's definition?
In SQL, the ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW clause applies to:
Which SQL constraint ensures that a column’s values are unique across the table?
Which SQL keyword prevents duplicate rows in result?
