Featured Post

SQL Interview Success: Unlocking the Top 5 Frequently Asked Queries

Image
 Here are the five top commonly asked SQL queries in the interviews. These you can expect in Data Analyst, or, Data Engineer interviews. Top SQL Queries for Interviews 01. Joins The commonly asked question pertains to providing two tables, determining the number of rows that will return on various join types, and the resultant. Table1 -------- id ---- 1 1 2 3 Table2 -------- id ---- 1 3 1 NULL Output ------- Inner join --------------- 5 rows will return The result will be: =============== 1  1 1   1 1   1 1    1 3    3 02. Substring and Concat Here, we need to write an SQL query to make the upper case of the first letter and the small case of the remaining letter. Table1 ------ ename ===== raJu venKat kRIshna Solution: ========== SELECT CONCAT(UPPER(SUBSTRING(name, 1, 1)), LOWER(SUBSTRING(name, 2))) AS capitalized_name FROM Table1; 03. Case statement SQL Query ========= SELECT Code1, Code2,      CASE         WHEN Code1 = 'A' AND Code2 = 'AA' THEN "A" | "A

10 Tech Mahindra Fresher Interviews Questions

Here're the ten top interview questions asked during fresher interviews. These are general questions and applicable for all B. Tech branches.

10 Interview Questions

These are general interview questions who is looking for job either on/off campus drives.

1. What is Full-Service Web-hosting?

It is a service offered by website hosting companies. So that the site can be accessed via the world wide web.


2. What is meant by Port blocking within LAN?

It restricts the users to access services through various ports. The ports are USB, DVD port, Floppy, Removal device ports.

3. What is IDN?

It enables people to use Domain names in local languages.


4. Can we call one program (not include) from another program?

Yes, you can call. Here not include means external program.


5. How can you sort the elements of an array in descending order?

In C++, you can use Array.Reverse(arr);


10 Top Tech Mahindra Fresher Interviews Questions


6. How do I update my DNS records?

You can update DNS records in CNAME. Here're more options.


7. How do non-root -bridges decide, which port will affect the root port?

In each non-root bridge (CAT2, CAT3, CAT4), Root Port selection is based on the port having the lowest cost to the Root Bridge (CAT1).

8. Difference between response.write() and server.transfer()?

The response.write() - writes a string to the browser.

The server.transfer() - an ASP page transfers the current page request to another ASP page in the same server.


9. What are the top Organization structure attributes?

  • Simplicity
  • A clear line of authority
  • Lesser Managerial Levels
  • Unity of command and Direction
  • Here are more options

10. How does the browser knows to go to a certain IP address when you type google.com?

The router decides when it receives google.com. The router has configuration details such as routing IP address.

Comments

Popular posts from this blog

How to Fix datetime Import Error in Python Quickly

Explained Ideal Structure of Python Class

How to Check Kafka Available Brokers