WNS VBA Developer Interview Questions and Answers

2 DSA questions. Both medium level difficult

HTML CSS javascript jQuery

Q1. Tell me about yourself
Add your answer
Q2. What is DBMS? Are you aware about mysql
Ans. 
DBMS stands for Database Management System. Yes, I am aware of MySQL.
• DBMS is a software that manages databases, allowing users to interact with the data stored within them.

• MySQL is a popular open-source relational database management system.

• DBMS provides functionalities like data storage, retrieval, update, and deletion.

• MySQL uses SQL (Structured Query Language) for querying and managing the database.

• DBMS ensures data
Answered by AI
Add your answer
Q3. What is relational database
Ans. 
Relational database is a type of database that stores and provides access to data points that are related to one another.
• Organizes data into tables with rows and columns

• Uses structured query language (SQL) to manipulate data

• Establishes relationships between tables using keys (primary and foreign keys)

• Examples: MySQL, PostgreSQL, Oracle Database
Answered by AI
Add your answer

Q1. Salary negotiation
Add your answer

Q1. Joins , index, keys and sp
Add your answer
Q2. Function plsql queries
Add your answer

Q1. How to handle data load
Ans. 
Handle data load by optimizing database queries, using indexing, caching, and load balancing.
• Optimize database queries to reduce load on servers

• Use indexing to speed up data retrieval

• Implement caching to store frequently accessed data

• Utilize load balancing to distribute data load evenly across servers
Answered by AI
Add your answer
Q2. What is paging describe how it works
Ans. 
Paging is a memory management scheme that allows the operating system to use secondary storage as an extension of the computer's primary memory.
• Paging divides the physical memory into fixed-size blocks called pages.

• Virtual memory is divided into fixed-size blocks called frames.

• The operating system keeps track of the mapping between pages and frames using a page table.

• When a process requests data that is not in physical...read more
Answered by AI
Add your answer
Q3. What is connection string
Ans. 
A connection string is a string that specifies information about a data source and the means of connecting to it.
• Contains information such as server name, database name, authentication details, etc.

• Used by applications to establish a connection to a database or other data source.

• Formatted in a specific way depending on the database management system being used.

• Example: 'Server=myServerAddress;Database=myDataBase;User I
Answered by AI
Add your answer
Q4. Difference between procedure and functions
Ans. 
Procedures do not return values, functions return values.
• Procedures are a set of instructions that perform a specific task, but do not return a value.

• Functions are also a set of instructions that perform a specific task, but they return a value.

• Functions can be called within expressions, while procedures cannot.

• Example: Procedure to display a message vs Function to calculate the sum of two numbers.
Answered by AI
Add your answer

Q1. Telephonic interview of SQL
Add your answer

Q1. SQL technical coding test
Add your answer

Q1. Basic information and qualifications and experience
Add your answer

A carrer test evaluating a person's capability to work

Q1. Qualification and experience and subject questions
Add your answer

This aptitude test is very important so time will be increased better than 5minutes.

Q1. Tell me about your self.
Add your answer
Q2. Self introduction is main important, and eye contact is very important, perfect internetwork, and speaking skills is very important.
Add your answer