Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmasmnth

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

Examine this statement, which executes successfully:

Now examine this query:

Which two statements can do this? (Choose two.)

A.

ALTER TABLE employees -

ADD INDEX (birth_date DESC);

B.

ALTER TABLE employees -

ADD INDEX ((MONTH(birth_date)));

C.

ALTER TABLE employees -

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

ADD INDEX (birth_month);

D.

ALTER TABLE employees -

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

ADD INDEX (birth_month);

E.

ALTER TABLE employees -

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

F.

ALTER TABLE employees -

ADD INDEX (birth_date);

Oracle 1z0-908 Summary

  • Vendor: Oracle
  • Product: 1z0-908
  • Update on: Jul 28, 2025
  • Questions: 140
Price: $52.5  $149.99
Buy Now 1z0-908 PDF + Testing Engine Pack

Payments We Accept

Your purchase with ExamsVCE is safe and fast. Your products will be available for immediate download after your payment has been received.
The ExamsVCE website is protected by 256-bit SSL from McAfee, the leader in online security.

examsvce payment method