Posts

Showing posts with the label IoT Interview questions

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

The tricky interview questions on IoT to read now

Internet of things is a tricky subject. I have given in this post on tricky interview questions asked for IoT Jobs. I have given simple to understand way. Mobile networks already deliver connectivity to a broad range of devices, enabling the development of innovative new services and applications. Why IoT you need This new wave of connectivity is going beyond tablets and laptops; to connected cars and buildings; TVs and game consoles; smart meters and traffic control; with the prospect of intelligently connecting almost anything and anyone. This is what the GSMA refers to as the “Connected Life”. As the Connected Life evolves, the number of mobile connections worldwide is set to rise dramatically to reach 10.5 billion by 2020, while the total number of connected devices across all access technologies could reach 25.6 billion1 . These devices will bridge the physical and digital worlds, enabling a new category of services that improve the quality of life and productivity of i