10+ R Systems International Interview Questions and Answers

Excel has various functions for calculations, data analysis, and manipulation.

• Math & Trig functions (e.g. SUM, AVERAGE, MAX, MIN)

• Logical functions (e.g. IF, AND, OR)

• Text functions (e.g. CONCATENATE, LEFT, RIGHT)

• Date & Time functions (e.g. TODAY, NOW, DATE)

• Lookup & Reference functions (e.g. VLOOKUP, INDEX, MATCH)

• Statistical functions (e.g. COUNT, AVERAGE, STDEV)

• Financial functions (e.g. PV, FV, PMT)

Incoterms are international commercial terms used in international trade to define the responsibilities of buyers and sellers.

• Incoterms are standardized terms published by the International Chamber of Commerce (ICC)

• There are 11 main types of Incoterms, such as EXW, FOB, CIF, DAP, etc.

• Each Incoterm specifies the responsibilities and obligations of the buyer and seller in terms of transportation, insurance, customs clearance, and risk transfer

• Incoterms help avoid misunderstandi...read more

Logistics is the management of the flow of goods and services from the point of origin to the point of consumption.

• Logistics involves planning, implementing, and controlling the efficient movement and storage of goods, services, and information.

• Modes of logistics include transportation (road, rail, air, sea), warehousing, inventory management, and packaging.

• Examples of logistics modes include trucking companies, shipping companies, and third-party logistics providers.

Advanced Excel refers to the use of complex functions, formulas, and tools to analyze and manipulate data efficiently.

• Involves using advanced functions like VLOOKUP, INDEX-MATCH, and PivotTables

• Utilizes macros and VBA programming for automation

• Includes data visualization techniques using charts and graphs

• Incorporates complex data analysis tools like Power Query and Power Pivot

• Requires proficiency in managing large datasets and creating dynamic reports

Remove vowels from a given string while maintaining the relative position of other characters.

• Iterate through each character in the string and check if it is a vowel (a, e, i, o, u).

• If the character is not a vowel, add it to the modified string.

• Return the modified string as the output.

Supply chain management offers opportunities for optimization, cost reduction, and efficiency in procurement processes.

• Opportunity to optimize processes and reduce costs through efficient supply chain management

• Ability to identify and mitigate risks in the procurement process

• Enhanced collaboration with suppliers for better negotiation and relationship management

• Opportunity to implement innovative technologies for improved efficiency, such as AI and blockchain

• Potential for car...read more

MySQL is a relational database management system, while MongoDB is a NoSQL database.

• MySQL is a relational database, meaning it stores data in tables with rows and columns.

• MongoDB is a NoSQL database, storing data in collections of JSON-like documents.

• MySQL uses SQL for querying data, while MongoDB uses a query language similar to JSON.

• MySQL is ACID-compliant, ensuring data integrity, while MongoDB sacrifices some ACID properties for scalability and flexibility.

• MySQL is suitab...read more

Major issues with Android mobile phones include security vulnerabilities, fragmentation, and battery life.

• Security vulnerabilities due to delayed updates and lack of standardization

• Fragmentation leading to inconsistent user experience and app compatibility issues

• Battery life problems due to resource-intensive apps and poor optimization

Warehousing is the process of storing goods in a designated location for future use or distribution.

• Warehousing involves receiving, storing, and organizing goods in a facility.

• It includes inventory management, order fulfillment, and shipping logistics.

• Examples of warehousing facilities include distribution centers, warehouses, and storage units.

Logistics is the process of planning, implementing, and controlling the efficient flow and storage of goods, services, and related information from point of origin to point of consumption.

• Involves transportation, warehousing, inventory management, and information flow

• Focuses on optimizing processes to ensure timely delivery of goods and services

• Includes activities such as procurement, production planning, packaging, and distribution

• Examples: managing a supply chain, coordinat...read more

Quality degradation after usage is a common issue.

• Quality degradation can be caused by wear and tear of the product.

• It can also be caused by improper maintenance or usage.

• Regular quality checks and maintenance can prevent degradation.

• Examples include car parts, electronic devices, and furniture.

Yes, I am available for night shifts and have no issues working during those hours.

• I am comfortable working night shifts and have no scheduling conflicts.

• I understand the importance of being flexible with work hours.

• I have experience working night shifts in previous roles.

• I am willing to adjust my sleep schedule to accommodate night shifts.