Hot Topics
Wipro Solution
Technical Round
What is data?
Data in context of DBMS is a single item that are stored in a database, either individually or as a set.
What is database?
A database is a logically coherent collection of data with some inherent meaning, representing some aspect of real-world and which is designed, built and populated with data for a specific purpose.
What is primary key?
Primary key is a constraint that uniquely identify each record in a table. It must be unique and cannot contain NULL values.
Which programming language do you prefer?
Tell about the most preferable programming language as interviewer will further ask you questions from that language.
Why and which platform do you use for coding?
Tell Which you use and the reasons why you use that platfrom.
Tell me about you project.
Describe your project. Tell about
Project topics
Your responsibility
Difficulties you faced
What you learnt
What is the future scope of the project
What were the challenges you faced while working on this project?
Describe the challenges you faced while working on the project and also how you overcame the difficulty.
What exactly was your role in this project?
Tell about the role you were given to handle the project.
What are Python libraries? Name any 5 of them.
Python library is a bundle of code of related modules that can be used repeatedly in different programs. E.g. NumPy, Pandas, Anaconda, PyTorch, SciPy.
What is SQL?
SQL stands for Structured Query Language which is a domain specific language because it is only used in relational models.
What is the difference between DELETE and TRUNCATE command?
DELETE | TRUNCATE |
1. It is a DML command. | It is a DDL command. |
2. If we want to delete rows from a table then we use this command. | We use this command to delete all the rows in a table at one go. |
3. Syntax: DELETE from Table_name | Syntax: TRUNCATE Table_name |
4. We can roll back before commit. | We can’t roll back to previous log. |
How will you insert values into the table?
We can insert values into the table by using the following command:
INSERT INTO table_name (column1, column2, column3, etc.) VALUES (value1, value2, value3, etc.)
How will you rate yourself in Java?
Rate yourself in Java on the basis of how much you know about Java.
How to define variable in Java?
To define a variable we write the following:
type variable_name = value
type: type of variable e.g. int, String
variable_name: any name can be given according to your wish
What is a constructor and how to define it?
In Java constructor refers to a block a code which is used to initialize an object. It must have same name as that of class and has no return type. It is automatically called when an object is created.
We have two kind of constructor:
Default constructor: It has no arguments and is called when there is no other constructor defined by the user. Its main purpose is to initialize the instance variables with the default values.
Parameterized constructor: The constructor which is capable of initializing the instance variables with provided values. In other words parameterized constructors take arguments.
What is inheritance and abstraction?
Inheritance is a process where one class acquires the properties of another class.
Abstraction is a methodology of hiding the implementation details from the user and only providing functionality to the users.
What is a dangling pointer?
A pointer pointing to a non-existing memory location is called Dangling pointer.
What is public and private IP?
Public IP is basically assigned by the Internet Service Provider to communicate outside the network.
Private IP is used to communicate within the same network by sending and receiving information.
What do you know about DBMS?
DBMS is a general purpose software that provides user easiness to define, construct and manipulate the database for various applications.
What do you know about networking protocols like TCP, UDP?
TCP stands for Transmission control protocol which establishes a connection before transmitting data and closes once the transmission is done. The data is divided in to packets and the receiver receives the data in sequential order.
UDP stands for User datagram protocol which is used efficiently for broadcasting and multicasting.
What are the important features of OOPS?
Important features of OOPs are
Inheritance: It is a concept of Object Oriented Programming in which a new class is created from the existing one.
Polymorphism: Poly means many and morph means form. A concept that enables programmers to assign a different meaning or usage to a variable, function or an object in different context.
Polymorphism can be of two types:
Runtime Polymorphism
Compile Time Polymorphism
Abstraction: Creating a new data type using encapsulated items that is well suited for an application.
Encapsulation: It is called data hiding and encapsulation is the way of packing data and function into a single unit to hide the implementation details of a class from outer world.
Method Overriding: In place of inheritance if the parent class and child class both have the same method signature then child class method overrides the parent class method.
Method Overloading: If a class has more than one method with the same method name with variety of parameter list then method will be overloaded.
Object: Object is the reality of a class.
Class: Class is a blue print of similar type of objects.
Constructor: Constructor is a special member function that is automatically invoked at the time of object creation and does not have any return type.
How to connect a DB in Java?
To connect a database with a Java program:
Import packages
Register the driver class
Create connection with connection class object
Create statement
Execute the query
Close connections
What is JVM?
JVM stands for Java Virtual Machine which is an abstract machine that provides a run-time environment in which Java bytecode can be executed.
How to get data frame from list?
There are different ways to get data frame from list:
Basic method
Using a list with index and column names
Using zip() function
Creating from the multi-dimensional list
Using a multi-dimensional list with column names
Using a list in the dictionary
Difference between call by value and call by reference.
Call By Value | Call By Reference |
1. When a copy of a value is passed to the function, then the original value is not modified. | When a copy of value is passed to the function, then the original value is modified. |
2. Actual arguments and formal arguments are created in separated memory locations. | Actual arguments and formal arguments are created is same memory location. |
3. In this case, actual argument remain safe as they cannot be modified. | In this case, actual arguments are not reliable, as they are modified. |
4. The copied of the actual arguments are passed to the formal arguments. | The address of actual arguments are passed to their respective formal arguments |
What is abstract class in Java?
Abstract class is a special kind of class in which we can give the method but its implementation should be in other class. It must contain at least one abstract method.
What are compound statement?
Compound statement appears as the body of another statement. Example: if block.
Automata Fixing