Multiple choice technology databases

This query is: INSERT ALL INTO mytab (c1,c2) VALUES ('ram',12) INTO mytab (c1,c2) VALUES ('mani',15)

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

This is valid Oracle SQL syntax for INSERT ALL statement, which allows multiple insert operations in a single statement. The statement would insert two rows into mytab table. However, the statement shown is incomplete (missing SELECT or semicolon in some contexts), but the core syntax shown is valid Oracle multi-table insert.

Keep practicing — related questions