Technology Questions

Q:

What is the difference between Business Analyst & System Analyst?

Answer

The business analyst must understand IT and also has to understand the stakeholder’s needs. 


A systems analyst has the ability to look at a program or utility and see the code. They can go in and pinpoint where changes need to be made. 

Report Error

View answer Workspace Report Error Discuss

0 2332
Q:

What are the types of constraints avaialable in oracle?

Answer

Oracle constraints are used to maintain consistent of data and ensure the data is properly maintained. A constraint is more or less a restriction we try to apply on a table.
Types of constraints:
- Check constraints
- NOT NULL constraint
- PRIMARY KEY constraint
- REFERENCES constraint
- UNIQUE constraint

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2332
Q:

What are the steps you go through while creating a COBOL program executable?

Answer

DB2 precompiler (if embedded sql used), CICS translator (if CICS program), COBOL compiler, Link editor. If DB2 program, create plan by binding the DBRMs.

Report Error

View answer Workspace Report Error Discuss

0 2331
Q:

What are the differences between mysql_fetch_array(), mysql_fetch_object(), mysql_fetch_row()?

Answer

mysql_fetch_array:
Fetch a result row as an associative array and a numeric array.

mysql_fetch_object:
Returns an object with properties that correspond to the fetched row and moves the internal data pointer ahead. Returns an object with properties that correspond to the fetched row, or FALSE if there are no more rows.

mysql_fetch_row():
Fetches one row of data from the result associated with the specified result identifier. The row is returned as an array. Each result column is stored in an array offset, starting at offset 0.

Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 2331
Q:

What is Aggregate Functions?

Answer

Aggregate functions perform a calculation on a set of values and return a single value. Aggregate functions ignore NULL values except COUNT function. HAVING clause is used, along with GROUP BY, for filtering query using aggregate values.


Following functions are aggregate functions. 


AVG, MIN CHECKSUM_AGG, SUM, COUNT, STDEV, COUNT_BIG, STDEVP, GROUPING, VAR, MAX. VARP

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

0 2329
Q:

Explain how garbage collection deals with circular references?

Answer

The .Net runtime knows about all the references between the objects. It can identify all the circular references that are reachable from the root and hence finalize them to free them all at once if and when needed.

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

0 2327
Q:

Echo vs print statement

Answer

echo() and print() are language constructs in PHP, both are used to output strings. The speed of both statements is almost the same.


echo() can take multiple expressions whereas print cannot take multiple expressions.


Print return true or false based on success or failure whereas echo doesn't return true or false.

Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 2327
Q:

What are standard query operators in LINQ?

Answer

The standard query operators in LINQ are the extension methods that form the LINQ pattern. These operators form an API that enables querying of any .NET array or collection. It operates on sequences and allows you to perform operations, such as determining if a value exists in the sequence and performing an aggregated function, such as a summation over a sequence.

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

0 2325