C-BODI-20 무료 덤프문제 온라인 액세스

Which three expressions convert a null value to 0? (Choose three)

• A.Case (field is NULL, 0, field)
• B.Decode (field is NULL, 0, field)
• C.Nvl (field,0)
• D.If then else (field is NULL,0,field)

You are unfamiliar with the data in your customer dimension table. You decide to run column profile on the table. Which three insights will you gain from reviewing the column profile results? (Choose three)

• A.Distinct values in a column
• B.Columns that contain only null data
• C.SUM of the numeric column values
• D.Count of distinct values in a column

How do you commit all rows in a single transaction?

• A.Select "Include in transaction" in the target table options
• B.Select "Commit at the end of Insert... Select"
• C.Specify "Rows per commit" equal to zero
• D.Specify the "Number of loaders" equal to one.

Which two engines process jobs on the Application server? (Choose two)

• A.Job Server
• B.Designer
• C.Batch Server
• D.Access Server
• E.Web Administrator

Your data flow loads the contents of "order_details "and" order_headers "into one XML file that contains a node <HEADER> and a child mode <DETAIL>. How should you populate the structure in your Query?

• A.In the header schema use the order_header for from and leave where empty in the detail schema use the order_header for from and put order_header order_id = order_details order_id in where clause.
• B.In the HEADER schema use the order headers for from and leave where empty in the detail schema use the order details for From and Where clause put order_header_id =order_details order_id.
• C.In the HEADER schema use the order_headers for from and put order_header.order_id = order details.order_id in where clause. In the detail schema use the order_details for from and leave where empty.
• D.In the header schema use the order_headers for from, and in where clause put order_header order_id = order details order_id in the detail schema use the order_header, order_details for from and leave where empty.