Oracle Exam 1Z0-449 Topic 7 Question 5 Discussion

Actual exam question for Oracle's 1Z0-449 exam

Question #: 5
Topic #: 7

What are three correct results of executing the preceding query? (Choose three.)

AValues longer than 100 characters for the DESCRIPTION column are truncated.

BORDER_LINE_ITEM_COUNT in the HDFS file matches ITEM_CNT in the external table.

CITEM_CNT in the HDFS file matches ORDER_LINE_ITEM_COUNT in the external table.

DErrors in the data for CUST_NUM or ORDER_NUM set the value to INVALID_NUM.

EErrors in the data for CUST_NUM or ORDER_NUM set the value to 0000000000.

FValues longer than 100 characters for any column are truncated.

Show Suggested Answer

Suggested Answer: A, C, D

com.oracle.bigdata.overflow: Truncates string data. Values longer than 100 characters for the DESCRIPTION column are truncated.

com.oracle.bigdata.erroropt: Replaces bad data. Errors in the data for CUST_NUM or ORDER_NUM set the value to INVALID_NUM.

References:

by Frederica at May 09, 2022, 06:45 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!