InterviewSolution
This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Explain the concept of Memory allocation in C/C++. |
|
Answer» C/C++ uses calloc( ) function to allocate a particular amount of memory area. It comprises of TWO settings and the resulting length will be the product of its two parameters. Calloc works in C/C++ by filling the memory area with Zeros and then returning a pointer to the first byte. If the calloc() function FAILS to locate ENOUGH space it the CPU, it simply returns the NULL pointer. |
|
| 2. |
What is Data Abstraction? Explain its importance. |
|
Answer» Data Abstraction is the process of showing only the information that is relevant for the users and HIDING all the other information from them. All the software is based on the basis of the concept of Data Abstraction because there are many points that are not important for the users and if they are shown on the application CONSOLE then the users will only get confused. This concept helps in showing only the essential parts of the system. There are three levels of data abstraction, Logical level, PHYSICAL level, and view level. At the logical level, we have the data administrators who DEAL with the data stored in the DATABASE, the physical level is the level where the data is stored physically in the database, and at the last, View level resides the end user. |
|
| 3. |
Explain the structural difference between bitmap and b-tree index. |
||||||
Answer»
|
|||||||
| 4. |
Explain the difference between the foreign key and the referenced key. |
||||||
Answer»
|
|||||||
| 5. |
Explain Database Management System. |
|
Answer» DATABASE Management System or DBMS is the system that is used to store and manage data in a systematic manner so that it can be EXTRACTED easily as per the need of its USERS and can be safe. The users can CREATE the rules of their database according to their needs. In other words, DBMS can also be defined as the interface between the users and the application. |
|
| 6. |
What are the advantages of DBMS? |
|
Answer» There are numerous advantages of DBMS :
|
|
| 7. |
Explain Software Development Life Cycle. |
|
Answer» All the steps involved in the life cycle of the software development phase are known as the Software development life-cycle. It is GENERALLY followed by the development team that deals with the development of the software in a PARTICULAR organization. The steps in the Software development life cycle CLEARLY DEFINE the RULES and regulations that should be followed to ensure the quality of the software and to efficiently and quickly complete the development process. |
|
| 8. |
What are the different types of Inheritance? |
|
Answer» There are SEVERAL types of INHERITANCE NAMELY :
|
|
| 9. |
Define Array |
|
Answer» An Array can be defined as a DATA type that can store more than one element of the same type. The only condition of the data type Array is that all the elements that are going to be STORED in it should be the same, for example, all of them should either be INTEGERS, floats, or characters. An Array has three basic parts, the first one is the data type that the array will follow, then the name and then size is defined, the example of how to declare an array is shown below: |
|
| 10. |
What are Joins, Views, Normalization, Triggers? |
|
Answer» Joins: Join is a keyword used in SQL statements to operate two tables BASED on the relationship between given tables in the database. |
|
| 11. |
What do you understand by loops? |
|
Answer» Through loop, a statement or a block of statements can be executed several TIMES. In a loop we can define the initial value from which the loop should start, the value till we want the loop to run and the increment or decrement counter. The process of the execution of the loop starts with the checking of the value that is going to be its key, we check if it is following the condition that we declared in the statement when we started it. Then the statement inside the loop is executed, the value is incremented or decremented ACCORDINGLY. And then that value is CHECKED again and the loop ends after the value FALLS out of the condition of the loop. |
|
| 12. |
Explain the normalization of the database, joins, and keys. |
|
Answer» The organization of data in a DATABASE in a systematic and efficient manner is known as Normalization. There are two goals of normalization, the first one is to remove the data redundancy( removing duplicate data) and the second one is to ensure that the data dependency makes sense( only storing the data that is relevant in the TABLES). Both of these goals are very IMPORTANT because if these goals are fulfilled then the database will take less space and it will ensure that only logical data is ENTERED in it. Related Article Google ADWORDS Interview Questions |
|
| 13. |
How is class different from an interface? |
|
Answer» Classes and interfaces are two different concepts which can be understood by the following points :
|
|
| 14. |
Define Inheritance. |
|
Answer» Inheritance is the PROCESS of creating new classes from the ALREADY existing classes. A coder can create a new CLASS from one or more than one existing class taking some of their CAPABILITIES or combining all their capabilities. The already existing classes known as the parent class or the superclass and the class that is created from those parent class i.e., the new class is known as the child class or subclass. The subclass can have its own attributes and CHARACTERISTICS too they are not totally inherited from other classes. Related Article Google Interview Questions |
|
| 15. |
Explain the four basic principles of OOPS. |
|
Answer» There are four basic pillars on which OOPS (Object ORIENTED Programming) is based. These are:
|
|