【ocp 12c】OCP 062最新考试题库原题解析-第16题

QUESTION 16

Examine the structure of the sales table, which is stored in a locally managed tablespace with

Automatic Segment Space Management (ASSM) enabled.

Name                                                    Null?                                                           Type

-------------------------------------------- ------------------------------------- -----------------------------

PROD_ID                                                  NOT NULL  NUMBER

CUST_ID                                            NOT NULL                                          NUMBER

TIME_ID                                            NOT NULL                                              DATE

CHANNEL_ID                                         NOT NULL                                              NUMBER

PROMO_ID                                              NOT NULL                                              NUMBER

QUANTITY___SOLD                          NOT NULL                                          NUMBER (10, 2)

AMOUNT SOLD                                  NOT NULL                                             NUMBER (10, 2)

You want to perform online segment shrink to reclaim fragmented free space below t he high water mark.

A. Row movement is enabled.

B. Referential integrity constraints for t he table are disabled.

C. No queries are running on this table.

D. Extra disk space equivalent to the size of t he segment is available in t he tablespace.

E. No pending transaction exists on t he table.

Correct Answer: A