Calfus
Mobulous Technologies Interview Questions and Answers
Q1. Which one is faster to run or execute function and procedure?
Procedures are faster as they are precompiled and stored in memory, while functions need to be compiled each time they are called.
Procedures are precompiled and stored in memory, making them faster to execute.
Functions need to be compiled each time they are called, which can slow down execution.
Procedures are commonly used for performing tasks, while functions are used to return a value.
Example: If you have a procedure to calculate employee salaries, it would be faster than a...read more
Q2. What is lexical parameter and bind parameter?
Lexical parameter is a placeholder in a SQL query that is replaced by a specific value at runtime. Bind parameter is a placeholder in a SQL query that is bound to a specific value before execution.
Lexical parameter is denoted by a colon followed by a name, like :parameter_name.
Bind parameter is denoted by a question mark, like ?.
Lexical parameters are replaced with values at runtime, while bind parameters are bound to values before execution.
Example: SELECT * FROM employees W...read more
Q3. What is O2C process?
O2C process stands for Order to Cash process, which involves all the steps from receiving an order to receiving payment.
Includes order entry, order fulfillment, invoicing, and payment collection
Involves multiple departments such as sales, operations, finance, and customer service
Key steps include order creation, order processing, shipping, invoicing, and payment processing
Ensures timely delivery of goods or services to customers and timely payment collection
Q4. Important points for package?
Important points for package include customization, integration, user training, and support.
Customization to meet specific business requirements
Integration with other systems for seamless data flow
User training to ensure effective utilization of the package
Ongoing support for troubleshooting and updates
Q5. Mention 5 tables from AR
Tables from AR module in Oracle Financials
RA_CUSTOMER_TRX_ALL
RA_CUSTOMER_TRX_LINES_ALL
AR_PAYMENT_SCHEDULES_ALL
AR_RECEIVABLE_APPLICATIONS_ALL
AR_PAYMENT_SCHEDULES_ALL
Q6. What are metrics of regression?
Metrics of regression are used to evaluate the performance of regression models.
Common metrics include Mean Squared Error (MSE), Root Mean Squared Error (RMSE), Mean Absolute Error (MAE), R-squared, and Adjusted R-squared.
MSE and RMSE measure the average squared difference between predicted values and actual values.
MAE measures the average absolute difference between predicted values and actual values.
R-squared indicates the proportion of the variance in the dependent variabl...read more
Interview Process at Mobulous Technologies
Top Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month