[0:06]So Susmita, tell me about yourself. First of all, I have to thank you, sir, for introducing myself. I am Susmita. I'm from Kavali, Nellore District. Currently, I'm staying in Hyderabad. I have completed my graduation in SR Engineering College, Kadapa, in the year of 2018 in the stream of Electronics and Communication Engineering with the aggregate of 74%. As I am from IT background, I want to explore my skills and new and try to learn new technologies. And coming to my achievements at the end of my graduation, I have done a project on design of high speed carry selector using brain tang adder. In this project I have played a team loader, team leader role, so that I can have the team leader qualities, I know that. Very good. That's all about myself. Can you, can you give me, you know, what all technologies you used to develop this project? I have used Xilinx 14.3 version. I have used technology Verilog technology. Okay. Okay, very good. So, okay. So, you mentioned Python in your resume, right? So, how much you rate yourself in Python out of five? 3.5. 3.5, good, very good. So, tell me, what is the main objective of any programming language? Why we are, why we need programming language? Whether it is Python or anything. If we want to communicate with any person, it is very flexible, if we communicate what they in their language. Like that computer has also some languages to understand. These programming languages are useful to communicate with the computer, so that it can understand our, the programming language. Okay. Very good, very good. So, generally, I mean, what is the use of variables, Susmita? Variables are the building blocks of the program, which are used to store the data. Okay, very good. Can you store multiple values into a single variable at a time?
[2:22]It is list of arguments, sir. I mean, what I mean to say data structures. Okay. It data structures which are used to store the data in an organized manner. Like list, tuple, set, dictionary. Very good, very good. What's the difference between list and tuple? List is a data structure which is used to store heterogeneous values, which follows order, allows duplicate values, it is mutable in terms of appending, deleting. And coming to the tuple, tuple is also a data structure which stores heterogeneous values, which follows order, duplicate values, but it is immutable. Okay, okay, very good. What's the difference between shallow copy and deep copy? Whenever we are copying an object into another object using assignment operator, Python does not allocate different memory locations. It allocates same memory allocation, memory, I mean memory locations. It is shallow copy. Whereas coming to deep copy, it copies only objects but elements, but not the addresses. Okay, very good, very good. Can you write a program, you know, can you write a program to find the sum of uh one to 100 even numbers? one to 100. One to 100 even numbers sum I need. Yes.
[4:09]Very good, very good. So but one thing you should know that, I did not use a keyword as a variable name. That's okay. Okay, no worries. So, tell me, what is the use of slicing? Extracting a part of a data structure is called slicing. Okay. So meaning, I mean, can you, can you give me syntax for the slicing? I mean, what you have, what you need to get to do the slicing? Can I explain with an example? Exactly, yeah, okay. I will give you one example. Show you to slicing that. I want to read 135 from this list. I want to read 135 from this list. How do you do that?
[4:53]135.
[5:01]Okay, so what is what is the meaning of that? Sir, here it is the starting, it is ending, it is the step. Okay, okay, very good, very good. Very good. Okay. Tell me, what do you mean of function, Susmita? What is the use of function? The block of statements is called a function, sir. Uh we can, by dividing the program into functions, multiple persons can work on the same task. Uh, it has reusability. I mean, so it will be useful, so multiple persons can work on it. It can be useful to anyone to access that, I mean to work on it. Okay, very good, very good. Reusability is the main objective. Very good. So what is the use of generators? Generator is a special function, which uses yield keyword to return a value. Whenever we want to return a multiple values, if we use return, first it was storing all the values. After that, it return the value. But it takes lot of memory. Memory wastage. If we use yield keyword, whenever the program executing, if we get value, first it returns the value, and again go back to the function and again process it. Very good, very good. We don't need to waste the memory to store the values. Excellent, very good. What is the use of decorators? Decorators are used to add new functionality to the output without modifying its structure. Okay, very good. Can you give me an example? Can you write a small example for decorator?
[7:01]Okay.
[7:04]Very good. So you return decorator for sorting the elements, right? Okay. Original function is not sorting, not printing the elements from the list in your sorted way, but your decorator is making them short. Very good, excellent. So what what do you mean of anonymous functions? Lambda functions are the anonymous functions which are used to create small functionalities. It can have multiple inputs but only one expression. Okay, okay, okay. Where we generally use lambda functions? What is the purpose of lambda functions? Why not def keyword functions? Sir, it is a small functionality, I have said. Uh it can easily with a short code. Okay, very good. So to create the code in a short way, we use Okay. So, what do you mean of call stack? Call stack. Remembering the path of the program which is executing is called call stack. Call stack. Very good, very good. So can you explain me all oops concepts? Oops concept. Yes. Inheritance, in oops, inheritance, polymorphism, abstraction, encapsulation. Coming to the inheritance, acquiring the properties from one class to another class is called inheritance. It has code reusability. And coming to polymorphism, same piece of code behaving differently in different situations is known as polymorphism. And command to the abstraction, implementing hiding the implementation of the code from outside of the world is called abstraction. Encapsulation, coming to encapsulation, means wrapping up of the all the objects and methods is known as encapsulation. Very good, very good. What is the use of uh overriding, method overriding? Method overriding. Changing the behavior of the parent class method in child class is known as method overriding. Why we why we need that generally? Sometimes we have to update the parent update the parent class method. So that method overriding is used, uh, instead of overriding coming changing completely the parent class method, we can change in child class method also. Very good, very good. What is the use of MRO? MRO means Method Resolution Order. It is used to decide which method has to be called first and which method has to be called next. Very good. What do you mean of exception? Exception is a runtime error, sir. Whenever we have, of course, we are human beings. While we are running a program, there may be occurrence of exceptions. Before getting an error, initially we are writing exception handling. Very good, very good. Very good. So do you, I mean, how much you rate yourself in MySQL out of five? MySQL uh three, sir. Three, very good. What's the difference between SQL and MySQL? SQL means it is a structured query language. Uh it was it it is a root to the database, sir. MySQL itself it is a database, sir. Okay, okay, very good, very good. So what are the classification of commands we are having in MySQL? DDL commands, DCL commands, DQL commands, TCL commands. Very good, very good. What is the use of joins? Joins, it is used to extract the information from multiple tables, sir. Okay, okay, very good, very good. Can you write a small query to add primary key to the existing table? For example, you are having employee table, you are having the columns like employee number, employee name, salary. I want you to add primary key to the employee number. Sure, sir.
[10:58]Tell me, what is the use of foreign key? Foreign key. It is used to establish the parent to child class relationships, sir. It is used to validate the data before entering into the child class, it was validating against the parent class. Very good. What is the use of group by, by the way? Group by. It group the according to one particular department, whatever may be. Okay, so based on some criteria, you are grouping the data. Very good, very good, Susmita. So, it's good, nice talking to you, Susmita.
