Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Go to Exam

Question 52

You create a table named 123.

Which statement runs successfully?

SELECT * FROM TABLE(123);

SELECT * FROM "123";

SELECT * FROM \'123\';

SELECT * FROM '123';

Correct Answer: B

When querying a table with a name that starts with a number or contains special characters, the table name must be enclosed in double quotes to be recognized correctly in SQL syntax. Therefore, using SELECT * FROM "123"; is the appropriate way to reference the table named 123.

Discussion

Monesha_GanesanOption: B

You have to use double quotes to refer to the table names

lucemqyOption: B

You have to use double quotes to refer to the table names since you can't create a table named 123 using regular means

Tyler4747Option: D

Why wont Option D work when it works for me.

RonerosOption: B

Object Quoted Names. https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/Database-Object-Names-and-Qualifiers.html#GUID-75337742-67FD-4EC0-985F-741C93D918DA

Izzicertificacion

las 4 me salen ERROR