Technology Questions

C requires all the variables to be declared at the beginning of a scope but in c++ we can declare variables anywhere in the scope. This makes the programmer easier to understand because the variables are declared in the context of their use.

Dynamic method dispatch which is also known as runtime polymorphism is a process in which a call to an overridden method is resolved at runtime rather than at compile-time. In this process, an overridden method is called through the reference variable of a superclass. The determination of the method to be called is based on the object being referred to by the reference variable.

:: is the scope resolution operator

Return Code in JCL can b obtained by the use of COND paramater...it is used to know the return codes of previous steps.

$message is a variable with a fixed name. $$message is a variable whose name is stored in $message. 

If $message contains "var", $$message is the same as $var.

One can use simple conditions like >= and <=, or use between/and but the trick here is to know your exact data type.

- Sometimes date fields contain time and that is where the query can go wrong so it is recommended to use some date related functions to remove the time issue. In SQL Server common function for accomplishing the task datediff () function.

- Interviewees also have to be aware of different time zones and server time zone.

-To increase query performance you may still want to use between however you should be aware of proper format you should use if not it might misbehave during filtering.

ActiveX DLL:

It is an in process server. It runs within the application time.

ActiveX Exe:

It is an out of process server. MS-Excel is an activex exe.

when u call the excel from the vb application u can in the task manager an excel exe will run, whereas for dll u can't see like that.