Technology Questions

Q:

What are the benefits of using of ADO.NET in .NET 4.0.

Answer

The following are the benefits of using ADO.NET in .NET 4.0 are as follows:

 =>   Language-Integrated Query (LINQ) - Adds native data-querying capabilities to .NET languages by using a syntax similar to that of SQL. This means that LINQ simplifies querying by eliminating the need to use a separate query language. LINQ is an innovative technology that was introduced in .NET Framework 3.5.
 =>   LINQ to DataSet - Allows you to implement LINQ queries for disconnected data stored in a dataset. LINQ to DataSet enables you to query data that is cached in a DataSet object. DataSet objects allow you to use a copy of the data stored in the tables of a database, without actually getting connected to the database.
=>   LINQ to SQL - Allows you to create queries for data stored in SQL server database in your .NET application. You can use the LINQ to SQL technology to translate a query into a SQL query and then use it to retrieve or manipulate data contained in tables of an SQL Server database. LINQ to SQL supports all the key functions that you like to perform while working with SQL, that is, you can insert, update, and delete information from a table.
=>   SqlClient Support for SQL Server 2008 - Specifies that with the starting of .NET Framework version 3.5 Service Pack (SP) 1, .NET Framework Data Provider for SQL Server (System.Data.SqlClient namespace) includes all the new features that make it fully compatible with SQL Server 2008 Database Engine.
=>   ADO.NET Data Platform - Specifies that with the release of .NET Framework 3.5 Service Pack (SP) 1, an Entity Framework 3.5 was introduced that provides a set of Entity Data Model (EDM) functions. These functions are supported by all the data providers; thereby, reducing the amount of coding and maintenance in your application. In .NET Framework 4.0, many new functions, such as string, aggregate, mathematical, and date/time functions have been added.

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

1 4770
Q:

What is SPUFI?

Answer

SPUFI stands for SQL processing using file input. It is the DB2 interactive menu-driven tool used by developers to create database objects.


 

Report Error

View answer Workspace Report Error Discuss

0 4766
Q:

Explain Superglobal variables in PHP .

Answer

To access the global data which is originating externally, the super globals are used. The superglobals are available as arrays. These superglobals represents the data from URLs, HTML forms, cookies, sessions and also the web server. For this purpose, $HTTP_GET_VARS, $HTTP_POST_VARS are used. The super globals are pretty good enough to be used in functions. The following are the list of super globals.


$_GET, $_POST, $_COOKIE;$_REQUEST, $_SERVER, $_SESSION, $_ENV, $_FILE


Another PHP Superglobal, called $GLOBALS; is available for persisting every variable with global scope.

Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 4765
Q:

When are you supposed to use endif to end the conditional statement?

Answer When the original if was followed by : and then the code block without braces.
Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 4764
Q:

What are the two types of fields available in IMS DB?

Answer

Key Fields - (PROCOPT=K)


- Used to sequence the database and can't be changed


- It is the field within a segment, used to identify the occurrence of the segment


- Used to maintain the IMS segments in ascending sequence.


 


Search Fields - (PROCOPT=G)


- Used to search for a segment, without the segment being sequenced on that field


- A segment need not have a key or search field.


 


Both types of fields can be used to search the database.

Report Error

View answer Workspace Report Error Discuss

0 4754
Q:

How would you resolve an ASRA abend?

Answer

In COBOL II start with CEBR, and get the offset/instruction.

Report Error

View answer Workspace Report Error Discuss

0 4749
Q:

The SQL SELECT statement is capable of

A) Projection B) Selection
C) Protection & Security D) Both A & B
 
Answer & Explanation Answer: D) Both A & B

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: SQL
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO

2 4727
Q:

How can you make sure the web application is fit for release ?

Answer


1. We can operate majority of test cases, but importantly we can make use testing techniques such as Pair-wise testing to reduce combinations, and/or model based testing to plan user journeys to ensure major functionality of web application works or not.


2. We can also use analytics to get insight into what users do on the website, which page is most popular and which feature is most used by the users.



Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

9 4722