Home »
MCQs »
Oracle MCQs »
Oracle Tables MCQs
What is the syntax to declare the local temporary tables?
32. What is the syntax to declare the local temporary tables?
- DECLARE TABLES
- DECLARE TEMPORARY TABLE
- DECLARE LOCAL TEMPORARY TABLE
- DECLARE GLOBAL TEMPORARY TABLE
Answer: C) DECLARE LOCAL TEMPORARY TABLE
Explanation:
The syntax to declare the local temporary tables is DECLARE LOCAL TEMPORARY TABLE.