20+ MBit Interview Questions and Answers

SQL delete syntax and commands.

• Use the DELETE statement followed by the table name.

• Add a WHERE clause to specify the rows to be deleted.

• Use the TRUNCATE statement to delete all rows in a table.

• Use the DROP statement to delete an entire table.

• Be careful when deleting data as it cannot be recovered.

• Examples: DELETE FROM table_name WHERE column_name = value;

• TRUNCATE TABLE table_name;

• DROP TABLE table_name;

Clustered index determines the physical order of data in a table while non-clustered index creates a separate structure.

• Clustered index sorts and stores the data rows in the table based on their key values

• Non-clustered index creates a separate structure that contains the key values and a pointer to the data row

• A table can have only one clustered index while multiple non-clustered indexes can be created

• Clustered index is faster for retrieving large amounts of data while non-cl...read more

Telecom sources refer to the data sources used by telecommunication companies to collect Call Detail Records (CDRs) for billing and analysis purposes.

• Telecom sources are used to collect CDRs for billing and analysis purposes

• CDRs obtained from telecom sources include information such as call duration, call time, caller ID, and call location

• Examples of telecom sources include mobile network operators, landline service providers, and VoIP service providers

Logistic regression is used when the dependent variable is categorical, while linear regression is used for continuous variables.

• Logistic regression predicts the probability of an event occurring, while linear regression predicts the value of a dependent variable.

• Logistic regression uses a sigmoid function to map the output to a probability value between 0 and 1.

• Linear regression assumes a linear relationship between the dependent and independent variables, while logistic reg...read more

loc and iloc are two methods in pandas used for selecting data from a DataFrame based on labels or integer index.

• loc is label-based, meaning you specify the row and column labels to select data

• iloc is integer index-based, meaning you specify the row and column indices to select data

• Example: df.loc['row_label', 'column_label'] vs df.iloc[row_index, column_index]

Code to retrieve a file in C

• Use the fopen() function to open the file

• Use the fread() function to read the contents of the file

• Use the fclose() function to close the file

Questions on microservice architecture, REST vs GraphQL, Java SOLID principles, and pagination.

• Microservice architecture involves breaking down a monolithic application into smaller, independent services.

• REST is an architectural style for building web services, while GraphQL is a query language for APIs.

• Java SOLID principles are a set of design principles for writing maintainable and scalable code.

• Pagination is the process of dividing large amounts of data into smaller, more ...read more

To create an immutable class in Java, follow these steps:

• Make the class final

• Make all fields private and final

• Do not provide any setter methods

• Initialize all fields via constructor

• If any field is mutable, return a clone of it instead of the original object

Bagging and Boosting are ensemble learning techniques used to improve model performance.

• Bagging involves training multiple models on different subsets of the data and averaging their predictions.

• Boosting involves training models sequentially, with each model focusing on the errors of the previous model.

• Bagging reduces variance and overfitting, while boosting reduces bias and underfitting.

• Examples of bagging algorithms include Random Forest and Extra Trees. Examples of boostin...read more

Implement Hash Map with array and linked list.

• Create an array of linked lists

• Hash function maps keys to array indices

• Insert key-value pairs into linked lists

• Handle collisions by chaining

• Search for a key by hashing and traversing linked list

Random forest is an ensemble learning method using multiple decision trees to improve accuracy and reduce overfitting.

• Random forest uses multiple decision trees to make predictions.

• Decision tree is a single tree structure used for classification and regression.

• Random forest reduces overfitting by averaging the predictions of multiple trees.

• Decision tree can be prone to overfitting if not pruned properly.

• Random forest is more robust and accurate compared to a single decision t...read more

List of strings starting with 'a'

• Use a loop to iterate through each string

• Check if each string starts with 'a'

• Add the string to the list if it starts with 'a'

To count the number of triangles in a given picture, look for all possible triangles formed by connecting the vertices of the shapes.

• Identify all the shapes in the picture that can form triangles.

• Count the number of triangles formed by connecting the vertices of each shape.

• Include both equilateral and right-angled triangles in the count.

The question seems to be asking about the candidate's experience in interviews.

• Highlight specific experiences in previous interviews

• Discuss any challenges faced during interviews and how they were overcome

• Mention any successful outcomes or learnings from interviews

Linked list is a data structure where each node points to the next node.

• Create a Node class with data and next pointer

• Create a LinkedList class with head pointer

• Implement methods to add, remove, search, and traverse the list

Yes, I know VBA Macro.

• I have experience in writing VBA macros to automate tasks in Microsoft Excel.

• I am familiar with VBA programming concepts such as variables, loops, and conditional statements.

• I have used VBA macros to create custom functions, automate data manipulation, and generate reports.

• I can debug and troubleshoot VBA code to fix errors and improve efficiency.

• I have integrated VBA macros with other Microsoft Office applications like Word and PowerPoint.

• I am constantl...read more

Use SQL query to find max value from a table

• Use SQL query SELECT MAX(column_name) FROM table_name;

• For example, SELECT MAX(salary) FROM employees;

• Ensure proper column name and table name are used in the query

The resistance and the current are related by Ohm's Law, where resistance (R) is equal to the voltage (V) divided by the current (I).

• Ohm's Law states that R = V/I, where R is resistance, V is voltage, and I is current.

• If the resistance (R) and the current (I) are given, you can calculate the voltage (V) using Ohm's Law.

• For example, if R = 6 ohms and I = 3 amps, then V = R * I = 6 * 3 = 18 volts.

Use SQL query to find salary department wise

• Use GROUP BY clause to group salaries by department

• Use SUM() function to calculate total salary for each department

• Join with department table if necessary to get department names

UI is the visual and interactive elements of a product, while UX is the overall experience and satisfaction of using the product.

• UI focuses on the look and feel of a product, including its layout, colors, typography, and visual elements.

• UX focuses on the user's journey and overall experience when interacting with a product.

• UI is concerned with the presentation and aesthetics, while UX is concerned with the usability and functionality.

• UI is like the front-end of a product, whi...read more