Oracle MySQL 8.0 Database Administrator 1z0-908 Question # 13 Topic 2 Discussion

1z0-908 Exam Topic 2 Question 13 Discussion:

Question #: 13

Topic #: 2

Examine this statement, which executes successfully:
Now examine this query:
Which two statements can do this? (Choose two.)

ALTER TABLE employees -

ADD INDEX (birth_date DESC);

ALTER TABLE employees -

ADD INDEX ((MONTH(birth_date)));

ALTER TABLE employees -

ADD COLUMN birth_month tinyint unsigned GENERATED ALWAYS AS (MONTH(birth_date)) VIRTUAL NOT NULL,

ADD INDEX (birth_month);

ALTER TABLE employees -

ADD COLUMN birth_month tinyint unsigned GENERATED ALWAYS AS (birth_date->>'$.month') VIRTUAL NOT NULL,

ADD INDEX (birth_month);

ALTER TABLE employees -

ADD INDEX ((CAST(birth_date->>'$.month' AS unsigned)));

ALTER TABLE employees -

ADD INDEX (birth_date);

Get Premium 1z0-908 Questions

Actual exam question for Oracle 1z0-908 exam by Rune8651 at Aug 2, 2025, 12:00:00 AM

Chosen Answer: A B C D E F
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.