Category: Interview Preparation

What is Power Query in Excel? Power Query is a data transformation and data preparation tool that allows users to import, clean, transform, and load data from various sources such…

What is the IF function? It performs logical tests. Example: =IF(A1>50,”Pass”,”Fail”) What is nested IF? Using multiple IF functions within one formula. What is the AND function? Returns TRUE if…

What is Microsoft Excel? Microsoft Excel is a spreadsheet software used to store, organize, and analyze data. What is a workbook? A workbook is a file in Excel that contains…

1. What is Node.js? Node.js is a runtime environment that allows executing JavaScript on the server side using Chrome’s V8 engine. It is used to build scalable and fast backend…

1. What is React? React is a JavaScript library used for building user interfaces, especially single-page applications. It allows developers to create reusable UI components. 2. What are the features…

Write a JavaScript program to reverse a string. Answer: function reverseString(str){ return str.split('').reverse().join(''); } console.log(reverseString("hello")); Write a program to check if a number is prime. Answer: function isPrime(num){ for(let i=2;i<num;i++){…

What is JavaScript? JavaScript is a high-level, interpreted programming language used to create interactive web pages. What are the different data types in JavaScript? String, Number, Boolean, Undefined, Null, Object,…

1. Retrieve all records from the Employees table SELECT * FROM Employees; 2. Retrieve only employee names SELECT name FROM Employees; 3. Retrieve employees with salary greater than 50000 SELECT…

1. What is SQL? Answer: SQL (Structured Query Language) is a programming language used to manage and manipulate relational databases. It allows users to create, retrieve, update, and delete data…

1. What is SQL? SQL (Structured Query Language) is a programming language used to manage and manipulate relational databases. It allows users to create, retrieve, update, and delete data stored…