Skip to main content

Technical interview preparation for coding job.

 

Entry-level technical interview question for software engineer.(PART-3)



1.         What is the Primary key and Foreign key?

The primary key-A key which is used to check whether the data in the specific column is unique or not.

Foreign key-A column or group of columns that gives a link between data in two tables.

 

2.         What are DDL (Data Definition Language) and DML (Data Manipulation Language)?

DDL (Data Definition Language)- A computer language that is used to either modify or to create the structure of database objects like view, schemas, tables or indexes etc.

DML (Data Manipulation Language)- A computer language that is used to manipulate data in the structure of database objects like inserting, retrieving/deleting or modifying from existing data etc.

 

3.         What is SDLC? Its stages?

Software Development Life Cycle

The Software Development Life Cycle (SDLC) is a process that allows the preparation of high-quality and low-cost production software.

Stages involved in SLDC are

1.    Planning

2.    Defining/Analysis

3.    Designing

4.    Coding/Implementation

5.    Testing

6.    Deploy/Maintenance


4.         What is Delete, Truncate, Drop and Create?

(Tuples-rows, Attributes-Column, Schema-Structure of table)

Delete- It is a DML command used to delete the tuples (it deletes one-by-one, have the facility to delete a single row)

Drop- It is a DDL command used to delete the entire schema.

Truncate- It is a DDL command is used to delete the tuples (it do the entire deletion task in one go, it is faster)

 

5.         What is the logic behind Palindrome, Armstrong, Perfect, Prime, Fibonacci numbers?

Prime no. are no. that are only divisible by 1 or itself

Palindrome no. i.e. 1334331 =same on reversing order of digits

Armstrong no. i.e. 153 =1^3 + 5^3 + 3^3, where 3 is total numbers of digits here.

Perfect no. i.e. 28 = 1+2+4+7+14(sum of all factor excluding no. itself)

Fibonacci series is an addition of numbers i.e. 1,1,2,3,5…

 

6.         Do you know any latest technology? Like ML/AI, Cloud, IoT, Cyber security etc?

1. Artificial Intelligence (AI) and Machine Learning

2. Robotic Process Automation (RPA)

3. Edge Computing

4. Quantum Computing

5. Virtual Reality and Augmented Reality

6. Block chain

7. Internet of Things (IoT)

8. 5G

9. Cyber Security

 

7.         What are aggregate and scalar functions?

Aggregate Function is an in-built function of SQL that returns a single value by undergoing operations from collections.(i.e.- SUM(), COUNT(), MIN(), LAST(), etc.)

Scalar Function is an in-built function of SQL that returns a single value from a single input.(i.e.- LCASE(),LEN(),FORMAT(), etc.)


8.         Do you know any latest technology? Like ML/AI, Cloud, IoT, Cyber security etc?

1. Artificial Intelligence (AI) and Machine Learning

2. Robotic Process Automation (RPA)

3. Edge Computing

4. Quantum Computing

5. Virtual Reality and Augmented Reality

6. Block chain

7. Internet of Things (IoT)

8. 5G

9. Cyber Security

 

9.         What are aggregate and scalar functions?

Aggregate Function is an in-built function of SQL that returns a single value by undergoing operations from collections.(i.e.- SUM(), COUNT(), MIN(), LAST(), etc.)

Scalar Function is an in-built function of SQL that returns a single value from a single input.(i.e.- LCASE(),LEN(),FORMAT(), etc.

10.         What are global and local variables?

A variable is like a box that stores values in a given memory location

Global Variables- The variable whose scope is declared even outside the function or block.

Local Variables- The variable whose scope is declared only inside the function or block.


Read more...

--- !!! Happy Reading !!!--- 

Please do leave your comment below in the comment section 

Your feedback is always welcome.

© punchTank


Comments

Popular posts from this blog

Lessons learned from a bicycle.

M y Bicycle tales 🚲 I vividly remember my first cycling experience on a Hero 'Cyclone' bike, a sky blue colored that belonged to my elder sister. As a child, riding that cycle felt like a privilege, but due to my height, it wasn't the perfect fit for me. My parents always reassured me that once I grew taller, my sister would lend it to me. I longed for the day when I could ride that cycle. Finally, in 7th grade, my patience paid off. My sister offered me the Cyclone bicycle. The feeling of joy I experienced that day is indescribable. For two months, I felt like a prince, seizing every opportunity to go outdoors with my bicycle. Whether it was fetching groceries, to buy milk, or helping my dad with bringing hardware accessories from nearby store, I was always ready for a ride, exploring the streets near my home. But one unfortunate day, tragedy struck. Returning home from my tuition classes, my  Cyclone bicycle was nowhere to be found. Panic set in, and I rushed to a nearby...

Basic knowledge of cars which everyone should have.

Let’s drive towards the automobiles industry. A.    Well-known car manufacturing companies with their country of origin. ·       Mercedes, AUDI, BMW, Volkswagen, Porsche - Germany ·       TATA, Mahindra, Maruti -India ·       Suzuki, Isuzu, Honda, Toyota, Nissan, Mitsubishi, Datsun – Japan ·       Ford, Chevrolet - America ·       Hyundai, Kia - South Korea ·       MG Motors - China ·         Landrover, Jaguar, Mini – England   B.    Types of cars ·       Hatchback ·       Sedan ·       SUV (Sport Utility Vehicle) ·       Coupe ·       Limousine ·       ATV (All Terrain Vehicle) ·     ...

How to know behavior patterns of the buyer like their basic needs, influences and motives?

 How to learn making customer strategy through case study. (PART -2) How to know the buyer behavior patterns like their basic needs, influences and motives? Maslow’s Hierarchy of Needs   1)    Social Needs:- Buyers are conscious towards numerous variables of chocolates like structure and size of the chocolate, its consistency in the mouth, contact, its softening and so forth. There are different elements like moral obligation of Hershey’s company and corporate social duty influences the buying choice of the chocolate customers. For instance corporate social duty of the organization incorporates lawful consistence, ecological issue and so on. In assembling the item organization ought to pursue the principles and controls made by the controllers of the business. Hershey dependably pursued the legitimate necessities of the chocolate manufacturing industry. Likewise the corporate social obligation of the organization impacts the buyers to consider the organization on...