nerdexam
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)
  • A
    8% (3)
  • B
    76% (29)
  • C
    3% (1)
  • D
    13% (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.

Full 1Z0-074 Practice