HCLTech Senior Technology Lead Interview Questions and Answers

D365 CRM has many out-of-the-box capabilities such as sales, marketing, and customer service automation.

• Sales automation includes lead and opportunity management, quotes, orders, and invoices.

• Marketing automation includes email campaigns, lead scoring, and web forms.

• Customer service automation includes case management, knowledge base, and service level agreements.

• D365 CRM also has integration with other Microsoft produ...read more

Functions return a value while procedures do not in Oracle.

• Functions are used to perform a specific task and return a value.

• Procedures are used to perform a specific task but do not return a value.

• Functions can be used in SQL statements while procedures cannot.

• Functions can be called from within procedures while procedures cannot be called from within functions.

Cursor is a pointer to a private SQL area that stores information about processing a specific SELECT or DML statement.

• Attributes include %FOUND, %NOTFOUND, %ROWCOUNT, %ISOPEN, %BULK_ROWCOUNT, %BULK_EXCEPTIONS

• Used to fetch and manipulate data from a result set

• Can be declared and used in PL/SQL blocks

• Example: OPEN cursor_name FOR SELECT * FROM table_name WHERE column_name = value;

Removing duplicate records in SQL

• Use SELECT DISTINCT to retrieve unique records

• Use GROUP BY to group records by a specific column

• Use HAVING to filter out groups with more than one record

• Use DELETE to remove duplicate records from the table

Packages in Oracle provide modularity, encapsulation, and reusability of code.

• Packages group related procedures, functions, and variables together.

• Packages provide a namespace for the objects they contain, avoiding naming conflicts.

• Packages can be compiled and stored in the database for efficient execution.

• Packages can be granted privileges, allowing controlled access to their contents.

• Packages can be versioned and upg...read more