Interview Questions

Static (embedded) SQL:

1.In static SQL how database will be accessed is predetermined in the embedded SQL statement.

2.It is more swift and efficient.

3.SQL statements are compiled at compile time.

4.Parsing, validation, optimization, and generation of application plan are done at compile time.

5.It is generally used for situations where data is distributed uniformly.

6.EXECUTE IMMEDIATE, EXECUTE and PREPARE statements are not used.

7. It is less flexible 

Dynamic (interactive) SQL:

1.In dynamic SQL, how database will be accessed is determined at run time.

2.It is less swift and efficient.

3.SQL statements are compiled at run time.

4.Parsing, validation, optimization, and generation of application plan are done at run time.

5.It is generally used for situations where data is distributed non-uniformly.

6.EXECUTE IMMEDIATE, EXECUTE and PREPARE statements are used.

7.It is more flexible.

CEDA 

The function unlink() is to remove a file, where as unset() is used for destroying a variable that was declared earlier.

Line of credit is an agreement or arrangement between the bank and a borrower, to provide a certain amount of loans on borrower’s demand. The borrower can withdraw the amount at any moment of time and pay the interest only on the amount withdrawn. For example, if you have $5000 line of credit, you can withdraw the full amount or any amount less than $5000 (say $2000) and only pay the interest for the amount withdrawn (in this case $2000).

1.  An injector is a service locator.
2.  It is used to retrieve object instances as defined by provider, instantiate types, invoke methods and load modules.
3. There is a single injector per Angular application, it helps to look up an object instance by its name.