Teleperformance SQL Developer Interview Questions and Answers

Q1. What is reactjs?
Ans. 
ReactJS is a JavaScript library for building user interfaces.
• ReactJS is developed and maintained by Facebook.

• It allows developers to create reusable UI components.

• ReactJS uses a virtual DOM for better performance.

• It follows a component-based architecture.

• ReactJS can be used to build single-page applications.
Answered by AI
Add your answer
Q2. What is call, apply and bind in javascript?
Ans. 
call, apply, and bind are methods in JavaScript used to manipulate the context of a function.
• call() is used to invoke a function with a specified 'this' value and arguments provided individually.

• apply() is similar to call() but arguments are passed as an array.

• bind() is used to create a new function with a specified 'this' value and initial arguments.
Answered by AI
Add your answer
Q3. Data Types in javascript
Ans. 
JavaScript has several data types including string, number, boolean, object, array, null, and undefined.
• String: 'hello'

• Number: 42

• Boolean: true or false

• Object: { key: value }

• Array: [1, 2, 3]

• Null: null

• Undefined: undefined
Answered by AI
Add your answer

2 DSA questions. Both medium level difficult

Q1. Mostly questions from Domain, JavaScript, Like output based questions of objects, their memory location, reference, one DSA question from recursion, output based questions mostly
Add your answer

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

MCQ questions only of 30 marks

Q1. Tell me about yourself
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. Tell me about yourself.
Add your answer
Q2. What is the business
Ans. 
The business refers to the organization or entity that provides goods or services to customers in exchange for payment.
• It involves creating and selling products or services

• It requires marketing and advertising to attract customers

• It involves managing finances and operations to ensure profitability

• Examples include retail stores, restaurants, and online businesses
Answered by AI
Add your answer

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