Question
Pavan started from his office. After walking a distance
of 35 m towards the west, he turned to the right and walked 20 m to reach a garden. Again, he turned to the right and walked 25 m to reach a shopping mall. In which direction is he now from his initial position? Read the directions carefully and answer the following.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?
