Oracle
1Z0-074 · Question #27
The COMPATIBLE parameter is set to 12.2.0.0.0. Which two statements are true about SQL identifier lengths? (Choose two.)
The correct answer is B. Table names can be as long as 128 bytes. E. Database names can be as long as 128 bytes. Explanation/Reference: https://oracle-base.com/articles/12c/long-identifiers-12cr2
New Features for Manageability
Question
The COMPATIBLE parameter is set to 12.2.0.0.0. Which two statements are true about SQL identifier lengths? (Choose two.)
Options
- ADisk group, PDB, and tablespace names are limited to 30 bytes.
- BTable names can be as long as 128 bytes.
- CDatabase names can be as long as 30 bytes.
- DDatabase link names can be as long as 30 bytes.
- EDatabase names can be as long as 128 bytes.
How the community answered
(38 responses)- A8% (3)
- B76% (29)
- C3% (1)
- D13% (5)
Explanation
Explanation/Reference: https://oracle-base.com/articles/12c/long-identifiers-12cr2
Topics
#identifier length#COMPATIBLE parameter#object naming#128 byte limit
Community Discussion
No community discussion yet for this question.