Question
What is the name of the international convention and
expo centre inaugurated by Prime Minister Narendra Modi in Dwarka, New Delhi, on September 17, 2023?Solution
Prime Minister Narendra Modi inaugurated the first phase of the international convention and expo centre 'Yashobhoomi' in Dwarka, New Delhi on September 17. Developed at a cost of about Rs 5,400 crore and spread over a project area of more than 8.9 lakh square metres, the Yashobhoomi convention centre houses 15 convention rooms, a grand ballroom and 13 meeting rooms, with a total seating capacity of more than 11,000 delegates. The Yashobhoomi project boasts of a “magnificent convention centre” equipped with the largest LED media façade in the country and with state-of-the-art seating facilities, aimed at ensuring world-class experience to visitors.
Which of the following is a key characteristic that distinguishes a PL/SQL `FUNCTION` from a PL/SQL `PROCEDURE`?
Which SQL statement combines the results of two queries and removes duplicates?
Which SQL clause is used to filter records based on aggregate functions?
Which SQL clause is used to filter results after a GROUP BY operation?
Which of the following statements about SQL `INDEXES` is generally TRUE?
Which SQL clause is used for filtering rows?
Given a table employees(id, dept_id, salary), which query returns departments with average salary greater than overall average across the company?
What is the main function of a PL/SQL `TRIGGER`?
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?
Which SQL clause is used to group rows?