Technology Questions

Similar to system testing, the *macro* end of the test scale is testing a complete application in a situation that mimics real world use, such as interacting with a database, using network communication, or interacting with other hardware, application, or system.

Cursors help you manipulate the information retrieved by select statements. This can be done by assigning a name to the cursor.

Example:

CURSOR emp_cur 

IS 

SELECT emp_number from employee_tbl where employee_name = name_in;

Types of Cursors:

Implicit cursors- These cursors are not declared by the programmer. They are issued when the SQL statement is executed. The open, close and fetching is done by itself.

Example:

UPDATE employee SET salary = salary * 2.1;

Here, an implicit cursor is issued to identify the set of rows in the table which would be affected by the update.

Explicit cursors- These cursors are defined by programmer. They are used in queries that return multiple rows.

Example:

CURSOR emp_cur 

IS 

SELECT emp_number from employee_tbl where employee_name = name_in;

For inserting, deleting, and locating elements in a Map, the HashMap offers the best alternative. If, however, you need to traverse the keys in a sorted order, then TreeMap is your better alternative. Depending upon the size of your collection, it may be faster to add elements to a HashMap, then convert the map to a TreeMap for sorted key traversal.

The CACHE option means how many sequences will be stored in memory for access by the application objects. The performance is faster. However in case of the database is down the data is memory is lost for the sequence.

The NO CACHE option means values are not stored in memory. So there might be some performance issue. 

- Frames make it easier to navigate through a site. 

- The links that appear in the frame can appear through out the site.

XAML is a markup language used to define dynamic or static UIs for .NET applications. Though Windows Vista would be used to design XAML UIs, they can be applied to Windows XP or Windows 2003 too.

XAML is similar to MVC in terms of the separation of the UI code from application logic.

XAML is bound to Windows Presentation foundation to build a UI in .NET 3.0 and Windows Vista.

XAML Features:

- XAML inherits all XML definitions and rules.

- It also contains HTML, XHTML and other markup languages for UI.

- Every XAML element represents a .NET CLR class due to which working with XAML becomes simple.

- The application logic can be put in a separate file or be embedded in XAML file itself as XAML in conjunction with Windows Presentation Foundation model to provide the developers design a good UI in ASP.NET.

- XAML files get compiled to BAML files which are smaller than XAML and easier to read which make them faster to load.

The JVM performs three main tasks:

• Loads code

• Verifies code

• Executes code

To send the characters that can not be specified in a URL should be converted into their equivalent hex encoding. To perform this task the methods encodeURI() and decodeURI() are used.

For example, the following code snippet performs the encoding of URL:

<script type="text/javascript">

          var uri = https://www.mysite.com/city?=Banglore; // original URI

          var ncodeuri=encodeURI(uri);

          document.write("<br />ncodeuri”);

          var dcodeuri = decodeURI(ncodeuri); 

          document.write(“<br>/>dcodeuri”);

</script>