184k views
0 votes
Which of the following is a valid table name in Oracle 12c?

a) jimm8 Y%c _5_H76ang
b) S_c#oT#2t_321sM#_i_T6h
c) 2LaN_n23_es#M#m
d) mAU$reE78_&_n1

User Lizabeth
by
7.6k points

1 Answer

3 votes

Final answer:

Option (D), The valid table name in Oracle 12c from the options provided is 'mAU$reE78_&_n1' as it adheres to the Oracle naming conventions by starting with a letter and containing only letters, numbers, underscores, dollar signs, and number signs.

Step-by-step explanation:

You asked which of the following is a valid table name in Oracle 12c:

  • a) jimm8 Y%c _5_H76ang
  • b) S_c#oT#2t_321sM#_i_T6h
  • c) 2LaN_n23_es#M#m
  • d) mAU$reE78_&_n1

In Oracle, table names must begin with a letter and may include letters, numbers, underscores (_), dollar signs ($), and number signs (#). Based on these rules, option d) mAU$reE78_&_n1 is the correct answer, because it starts with a letter and contains only valid characters.

Options a), b), and c) are not valid due to containing invalid characters or starting with a number, which is not permitted in Oracle's naming conventions for tables.

User Polentino
by
7.6k points