Interview Questions

USING HOST VARIABLE we can pass data from COBOL to DB2

The following are the usages of the Command object in AD0.NET:

The Command object in AD0.NET executes a command against the database and retrieves a DataReader or DataSet object.

  =>  It also executes the INSERT, UPDATE, or DELETE command against the database.
  =>  All the command objects are derived from the DbCommand class.
  =>  The command object is represented by two classes: SqlCommand and OleDbCommand.
  =>  The Command object provides three methods to execute commands on the database:
  =>  The ExecuteNonQuery() method executes the commands and does not return any value.
  =>  The ExecuteScalar() method returns a single value from a database query.
  =>  The ExecuteReader() method returns a result set by using the DataReader object.

-The shift() method is similar as the pop() method but the difference is that Shift method works at the beginning of the array. 

-The shift() method take the first element off of the given array and returns it. The array on which is called is then altered.

For example

var myarray = ["apple ", "banana ", "mango "]; 

console.log(myarray.shift());

console.log(myarray);

we get the following console output:

apple

["banana ", "mango "];

When we call shift() on an empty array, it will return an undefined value.

Different types of risk exist in ivesting schemes depending on what you've invested in.

Savings accounts are generally regarded as the least risky investments as in this we just save our wealth for future expenses.

Following guidelines to be following while writing Cobol program:

- Use ? EVALUATE ? statement for constructing cases.

- Use scope terminators for nesting.

- Use in-line Perform statement for writing ?do? constructions.

- Use Test Before and Test After in the Perform statement while writing Do-While statements.

-  A stored procedure can accept parameters while a trigger cannot.
-  A trigger can’t return any value while stored procedures can.
-  A trigger is executed automatically on some event while a stored procedure needs to be explicitly called.
-  Triggers are used for insertions, update and deletions on tables while stored procedures are often using independently in the database.
-  A trigger cannot be written in a stored procedure. However, the reverse is not possible.

The LMHOSTS file is a static method of resolving NetBIOS names to IP addresses in the same way that the HOSTS file is a static method of resolving domain names into IP addresses. An LMHOSTS file is a text file that maps NetBIOS names to IP addresses; it must be manually configured and updated.