Explore topic-wise InterviewSolutions in .

There are 5 operators which cannot be OVERLOADED. They are:

1. .* - class MEMBER access OPERATOR 
2. :: - scope resolution operator 
3. . - dot operator 
4. ?:: - conditional operator 
5. Sizeof() - operator 

NOTE:- This is possible only in C++.

There are 5 operators which cannot be overloaded. They are:

Note:- This is possible only in C++.

Difference between overloading and overriding in PROGRAMMING language is:

1. In overloading, there is a relationship between METHODS available in the same class whereas in overriding, there is relationship between a SUPERCLASS method and subclass method.
2. Overloading does not block inheritance from the superclass whereas overriding blocks inheritance from the superclass.
3. In overloading, separate methods share the same name whereas in overriding, subclass method replaces the superclass.
4. Overloading must have DIFFERENT method SIGNATURES whereas overriding must have same signature.

Difference between overloading and overriding in programming language is:

Precondition: A condition that should return TRUE when a member FUNCTION is invoked. In order to use a function correctly a precondition should return true. If a precondition fails to HOLD, an operation will not take responsibility to perform any action of sensibility. For EXAMPLE, the interface invariants of stack class respond nothing about pushing even though the stack is already full. In this SCENARIO, sinful () is a precondition for push operation.

Post-Condition: A condition that should return true before returning from an invoked function. In order to use a function correctly a post condition should return true. Taking a stack as an example, is empty () must necessarily be true after pushing the element into the stack when an element is pushed. The function is empty () is a post condition.

Precondition: A condition that should return true when a member function is invoked. In order to use a function correctly a precondition should return true. If a precondition fails to hold, an operation will not take responsibility to perform any action of sensibility. For example, the interface invariants of stack class respond nothing about pushing even though the stack is already full. In this scenario, sinful () is a precondition for push operation.

Post-Condition: A condition that should return true before returning from an invoked function. In order to use a function correctly a post condition should return true. Taking a stack as an example, is empty () must necessarily be true after pushing the element into the stack when an element is pushed. The function is empty () is a post condition.

It is a PROCESS during EXCEPTION HANDLING when the DESTRUCTOR is called for all local objects between the place where the exception was thrown and where it is CAUGHT.

It is a process during exception handling when the destructor is called for all local objects between the place where the exception was thrown and where it is caught.

A CLASS does not INHERIT CONSTRUCTORS from any of its SUPER CLASSES.

A class does not inherit constructors from any of its super classes.

A property is a MEMBER that provides access to an attribute of an object or a class. EXAMPLES of properties INCLUDE the length of a string, the size of a FONT, the CAPTION of a window, the name of a customer, and so on.

A property is a member that provides access to an attribute of an object or a class. Examples of properties include the length of a string, the size of a font, the caption of a window, the name of a customer, and so on.

It is an OBJECT of some class whose PURPOSE is to INDICATE that a real object of that class does not exist. One common use for a NULL object is a return value from a member function that is supposed to return an object with some specified properties but cannot FIND such an object.

It is an object of some class whose purpose is to indicate that a real object of that class does not exist. One common use for a null object is a return value from a member function that is supposed to return an object with some specified properties but cannot find such an object.

• REDUCED client/server traffic
• EFFICIENT REUSE of CODE and programming abstraction
• Enhanced security CONTROLS

CREATE PROCEDURE - is a STORED procedure, which is a SAVED COLLECTION of Transact-SQL statements that can take and return user-supplied PARAMETERS.

CREATE procedure - is a stored procedure, which is a saved collection of Transact-SQL statements that can take and return user-supplied parameters.

Active objects are one which instigate an interaction which owns a thread and they are responsible for handling CONTROL to other objects. In SIMPLE WORDS it can be referred as client.

Passive objects are one, which passively waits for the message to be processed. It waits for another object that requires its services. In simple words it can be referred as server.

Active objects are one which instigate an interaction which owns a thread and they are responsible for handling control to other objects. In simple words it can be referred as client.

Passive objects are one, which passively waits for the message to be processed. It waits for another object that requires its services. In simple words it can be referred as server.

SQL Profiler UTILITY allows us to basically track connections to the SQL Server and also DETERMINE activities such as which SQL Scripts are RUNNING, failed jobs ETC.

SQL Profiler utility allows us to basically track connections to the SQL Server and also determine activities such as which SQL Scripts are running, failed jobs etc.

SQL> delete from table_name where rowid not in (SELECT MAX(rowid) from table group by duplicate_values_field_name);

SQL> delete from table_name where rowid not in (select max(rowid) from table group by duplicate_values_field_name);

Both an abstract class and an interface are specific types of COMPUTER objects that ALLOW a programmer to loosely define one type of object as if it were another type, while retaining all of the object's original properties. While multiple different computer languages use one or both of these concepts, JAVA is the most well-known. Abstract classes and interfaces have a variety of similarities, but also incorporate significant differences in STRUCTURE, syntax, and usage.

Both an abstract class and an interface are specific types of computer objects that allow a programmer to loosely define one type of object as if it were another type, while retaining all of the object's original properties. While multiple different computer languages use one or both of these concepts, Java is the most well-known. Abstract classes and interfaces have a variety of similarities, but also incorporate significant differences in structure, syntax, and usage.

An Internet Protocol address (IP address) is a numerical label ASSIGNED to each device (e.g., computer, printer) participating in a computer network that uses the Internet Protocol for communication.An IP address SERVES two principal functions: host or network interface identification and LOCATION addressing.

An Internet Protocol address (IP address) is a numerical label assigned to each device (e.g., computer, printer) participating in a computer network that uses the Internet Protocol for communication.An IP address serves two principal functions: host or network interface identification and location addressing.

An operating system (OS) is a set of software that manages computer hardware resources and PROVIDES common services for computer programs. 

 To ACT as interface between hardware and users, an operating system must be able perform the following functions:

 1. Enabling startup application programs. THUS, the operating system must have:

• A text editor
• A translator
• An editor of links

 2. The allocation of resources needed to execute programs is done by identifying: the programs that are running, the need for memory, peripheral devices and data PROTECTION requirements.

3. Facilities for data compression, sorting, mixing, cataloging and MAINTENANCE of libraries, through utility programs available.

4. Plan implementation works according to certain criteria, for efficient use of central processing unit.

5. Assisting implementation of programs through computer-user communication system, at both hardware and software level.

Examples of operating systems:BS2000,BS3000,DOS,PC-DOS,MS-DOS,LINUX,SOLARIS,MAC OS,UNIX,WINDOWS

An operating system (OS) is a set of software that manages computer hardware resources and provides common services for computer programs. 

 To act as interface between hardware and users, an operating system must be able perform the following functions:

 1. Enabling startup application programs. Thus, the operating system must have:

 2. The allocation of resources needed to execute programs is done by identifying: the programs that are running, the need for memory, peripheral devices and data protection requirements.

3. Facilities for data compression, sorting, mixing, cataloging and maintenance of libraries, through utility programs available.

4. Plan implementation works according to certain criteria, for efficient use of central processing unit.

5. Assisting implementation of programs through computer-user communication system, at both hardware and software level.

Examples of operating systems:BS2000,BS3000,DOS,PC-DOS,MS-DOS,LINUX,SOLARIS,MAC OS,UNIX,WINDOWS

• The C programming language manages memory statically, automatically, or dynamically. 
• Static-duration variables are allocated in main memory, usually ALONG with the executable CODE of the program, and persist for the lifetime of the program
• Automatic-duration variables are allocated on the stack and come and go as functions are called and return. 
• For static-duration and automatic-duration variables, the SIZE of the allocation is required to be compile-time constant.
• Dynamic memory allocation in which memory is more explicitly (but more FLEXIBLY) managed, typically, by allocating it from the heap, an area of memory structured for this purpose.
• In C, the library function malloc is used to allocate a block of memory on the heap. The program accesses this block of memory via a pointer that malloc returns. When the memory is no longer needed, the pointer is passed to free which deallocates the memory so that it can be used for other purposes.