Online Access Free C_HANAIMP_15 Practice Test

You created a table function to remove previous records,sum the current total weekly working hours for each employee,and update the personnel table. The build of the table function fails.
Which of the following could be a valid reason?

• A.Your function refers to a scalar function.
• B.Your function includes a TRUNCATE statement
• C.You did NOT define a valid table type.
• D.You did not define at least one input parameter.

What do you use in the definition of a dynamic SOL analytic privilege?

• A.A table function that returns a list of allowed values.
• B.A scalar function that returns a list of the allowed values for each attribute.
• C.A procedure that returns the data access condition as an SQL expression.
• D.An organization hierarchy that provides role-based access to data.

You created a table function to sum the total weekly working hours for each employee and update the personnel table. You CANNOT activate the table function. What could be the problem?

• A.You do NOT have write permissions to the personnel table
• B.You CANNOT update records using a table function
• C.You did NOT create synonyms for the table
• D.You did NOT define a valid table type

You are building a new calculation view B that uses calculation view A as a data source. In the Semantics node of calculation view A,you define a mask for the first 10 digits of a 15 digit Account Number. When you preview calculation view B, the Account Number is not masked.
Why do you see the Account Number unmasked?

• A.The masking is based on the column of a row table.
• B.The Account Number is based on the Integer data type.
• C.You did not define masking in calculation view B.
• D.The UNMASKED privilege for calculation view A has been granted.

Why do you use a hierarchy function node in a calculation view?

• A.To assist the developer by visualizing hierarchies
• B.To generate additional Meta data that can be used for analysis of a hierarchy structure
• C.To display value help using hierarchies
• D.To enable hierarchical navigation in reporting tools