Oracle Database SQL — Question 165

You create a table named 123.
Which statement runs successfully?

Answer options

• A. SELECT * FROM TABLE(123);
• B. SELECT * FROM "123";
• C. SELECT * FROM \'123\';
• D. SELECT * FROM '123';

Correct answer: B

Explanation

The correct statement is B, as using double quotes around the table name allows you to reference a table with a numeric name. Options A, C, and D are incorrect because they either do not properly reference the table's name or use incorrect syntax for querying a table with a numeric identifier.