Which four are correct guidelines for naming database tables? (Choose four)

The correct answer is B. Must be 1-30 characters long. C. Should not be an Oracle Server reserved word. E. Must contain only A-Z, a-z, 0-9, _, $, and #. F. Must begin with a letter. Oracle database object must begin with a letter and can usually be between 1 and 30 characters long, except for databases (which have a maximum of eight characters) and database links (with a maximum of 128 characters). Name cannot be an Oracle Server reserved word. Name must…

Creating and Managing Schema Objects

Question

Options

AMust begin with either a number or a letter.
BMust be 1-30 characters long.
CShould not be an Oracle Server reserved word.
DMust contain only A-Z, a-z, 0-+, _, *, and #.
EMust contain only A-Z, a-z, 0-9, _, $, and #.
FMust begin with a letter.

How the community answered

(30 responses)

A
10% (3)
B
83% (25)
D
7% (2)

Explanation

Oracle database object must begin with a letter and can usually be between 1 and 30 characters long, except for databases (which have a maximum of eight characters) and database links (with a maximum of 128 characters). Name cannot be an Oracle Server reserved word. Name must contain only A-Z, a-z, 0-9, _, $, and #. Incorrect Answers A: Database tables may not begin with number. D: It cannot contain symbols "+" or "*".

Topics

#table naming rules#identifier length#reserved words#valid characters

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice