Explore topic-wise InterviewSolutions in .

SQL*Loader is a bulk loader utility used for moving data from EXTERNAL files into the Oracle database. SQL*Loader supports various load formats, selective LOADING, and multi-table loads. When a control file is fed to an SQL*Loader, it writes messages to the log file, bad rows to the bad file and discarded rows to the discard file.

Control file:

The SQL*Loader control file contains INFORMATION that describes how the data will be loaded. It contains the table name, column datatypes, field delimiters, etc.

controlfile.sql should be used to generate an accurate control file for a given table.

Log File:

The log file contains information about the SQL*loader execution. It should be viewed after each SQL*Loader job is COMPLETE.

SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database. SQL*Loader supports various load formats, selective loading, and multi-table loads. When a control file is fed to an SQL*Loader, it writes messages to the log file, bad rows to the bad file and discarded rows to the discard file.

Control file:

The SQL*Loader control file contains information that describes how the data will be loaded. It contains the table name, column datatypes, field delimiters, etc.

controlfile.sql should be used to generate an accurate control file for a given table.

Log File:

The log file contains information about the SQL*loader execution. It should be viewed after each SQL*Loader job is complete.

SGA (SYSTEM GLOBAL Area) is a dynamic memory area of an Oracle Server. In SGA,the allocation is done in granuels. The size of the SGA is dependent on SGA_MAX_SIZE parameter.

The memory structures contained by SGA are:

SHARED Pool :

this memory structure is divided into two sub-structures which are Library Cache and Data Dictionary Cache for storing recently used PL/SQL statements and the recent data definitions. The maximum size of the Shared Pool depends on the SHARED_POOL_SIZE parameter.

Database Buffer Cache :

This memory structure improves the performance while fetching or updating the recently used data as it stores the recently used datafiles. The size of this block is decided by DB_BLOCK_SIZE.

REDO Log Buffer :

This memory structure is used to store all the changes made to the database and it's primarily used for the data recovery purposes. The size of this block is decided by LOG_BUFFER.

Java Pool :

This memory structure is used when Java is installed on the Oracle server. Size that can be used is stored in parameter named JAVA_POOL_SIZE.

Large Pool :

This memory structure is used to reduce the burden of the Shared Pool, as the Session memory for the Shared Server, as the temporary storage for the I/O and for the backup and restore operations or RMAN. Parameter that stores the maximum size is LARGE_POOL_SIZE.

SGA (System Global Area) is a dynamic memory area of an Oracle Server. In SGA,the allocation is done in granuels. The size of the SGA is dependent on SGA_MAX_SIZE parameter.

The memory structures contained by SGA are:

Shared Pool :

this memory structure is divided into two sub-structures which are Library Cache and Data Dictionary Cache for storing recently used PL/SQL statements and the recent data definitions. The maximum size of the Shared Pool depends on the SHARED_POOL_SIZE parameter.

Database Buffer Cache :

This memory structure improves the performance while fetching or updating the recently used data as it stores the recently used datafiles. The size of this block is decided by DB_BLOCK_SIZE.

Redo Log Buffer :

This memory structure is used to store all the changes made to the database and it's primarily used for the data recovery purposes. The size of this block is decided by LOG_BUFFER.

Java Pool :

This memory structure is used when Java is installed on the Oracle server. Size that can be used is stored in parameter named JAVA_POOL_SIZE.

Large Pool :

This memory structure is used to reduce the burden of the Shared Pool, as the Session memory for the Shared Server, as the temporary storage for the I/O and for the backup and restore operations or RMAN. Parameter that stores the maximum size is LARGE_POOL_SIZE.

There are FOUR types of segments used in Oracle databases:

• data segments
• index segments
• rollback segments
• temporary segments

Data Segments:

There is a single data segment to hold all the data of every non clustered table in an oracle database. This data segment is created when you create an object with the CREATE TABLE/SNAPSHOT/SNAPSHOT LOG command. Also, a data segment is created for a cluster when a CREATE CLUSTER command is issued. The storage parameters control the way that its data segment's extents are allocated. These affect the efficiency of data retrieval and storage for the data segment associated with the object.

Index Segments:

Every index in an Oracle database has a single index segment to hold all of its data. Oracle creates the index segment for the index when you issue the CREATE INDEX command. Setting the storage parameters directly affects the efficiency of data retrieval and storage.

Rollback Segments:

Rollbacks are required when the transactions that affect the database need to be undone. Rollbacks are also needed during the time of system failures. The way the roll-backed data is saved in rollback segment, the data can also be redone which is HELD in redo segment.

A rollback segment is a portion of the database that records the actions of transactions if the transaction should be rolled back. Each database contains one or more rollback segments. Rollback segments are used to provide read consistency, to rollback transactions, and to recover the database.

Types of rollbacks:

• statement level rollback
• rollback to a savepoint
• rollback of a transaction due to user request
• rollback of a transaction due to abnormal process termination
• rollback of all outstanding transactions when an instance terminates abnormally
• rollback of incomplete transactions during recovery.

Temporary Segments:

The SELECT statements need a temporary storage. When queries are fired, oracle needs area to do SORTING and other operation due to which temporary storages are useful.

The commands that may use temporary storage when used with SELECT are:

GROUP BY, UNION, DISTINCT, ETC.

There are four types of segments used in Oracle databases:

Data Segments:

There is a single data segment to hold all the data of every non clustered table in an oracle database. This data segment is created when you create an object with the CREATE TABLE/SNAPSHOT/SNAPSHOT LOG command. Also, a data segment is created for a cluster when a CREATE CLUSTER command is issued. The storage parameters control the way that its data segment's extents are allocated. These affect the efficiency of data retrieval and storage for the data segment associated with the object.

Index Segments:

Every index in an Oracle database has a single index segment to hold all of its data. Oracle creates the index segment for the index when you issue the CREATE INDEX command. Setting the storage parameters directly affects the efficiency of data retrieval and storage.

Rollback Segments:

Rollbacks are required when the transactions that affect the database need to be undone. Rollbacks are also needed during the time of system failures. The way the roll-backed data is saved in rollback segment, the data can also be redone which is held in redo segment.

A rollback segment is a portion of the database that records the actions of transactions if the transaction should be rolled back. Each database contains one or more rollback segments. Rollback segments are used to provide read consistency, to rollback transactions, and to recover the database.

Types of rollbacks:

Temporary Segments:

The SELECT statements need a temporary storage. When queries are fired, oracle needs area to do sorting and other operation due to which temporary storages are useful.

The commands that may use temporary storage when used with SELECT are:

GROUP BY, UNION, DISTINCT, etc.

The SMON background PROCESS PERFORMS all system monitoring functions on the oracle database.
Each time oracle is re-started, SMON performs a WARM start and makes sure that the transactions that were left incomplete at the LAST shut down are recovered.

SMON performs periodic cleanup of temporary segments that are no LONGER needed.

The SMON background process performs all system monitoring functions on the oracle database.
Each time oracle is re-started, SMON performs a warm start and makes sure that the transactions that were left incomplete at the last shut down are recovered.

SMON performs periodic cleanup of temporary segments that are no longer needed.

Difference between VB Debugger and the Script Debugger:

No "on the FLY" editing

Because the scripting window is read-only, you cannot edit the code during execution, as you can most of the time with VB.

No Instant Watch (Shift-F9)

The VB debugger's instant watch FACILITY, which ALLOWS you to highlight a variable in your code, PRESS Shift-F9, and see the value of the variable, is not available in the Script Debugger.

Cannot set watches Watches do not exist in the Script Debugger.

Cannot set the next statement Using the VB Debugger, you can place the cursor on a line of code and, by clicking CTRL-F9, have program execution resume at that line. This is particularly useful to backtrack or to re-execute a section of code. UNFORTUNATELY, this feature is not available in the Script Debugger.

Difference between VB Debugger and the Script Debugger:

No "on the fly" editing

Because the scripting window is read-only, you cannot edit the code during execution, as you can most of the time with VB.

No Instant Watch (Shift-F9)

The VB debugger's instant watch facility, which allows you to highlight a variable in your code, press Shift-F9, and see the value of the variable, is not available in the Script Debugger.

Cannot set watches Watches do not exist in the Script Debugger.

Cannot set the next statement Using the VB Debugger, you can place the cursor on a line of code and, by clicking CTRL-F9, have program execution resume at that line. This is particularly useful to backtrack or to re-execute a section of code. Unfortunately, this feature is not available in the Script Debugger.

These statements are acceptable for specific conditions, but they often make code less readable, which makes it difficult for others who look at your code to know what's really going on. If you make sure the only way out of a loop is to not satisfy the loop's condition, it's much easier to FOLLOW your code. Often, BREAKING out of a loop by force with an exit statement is a sign of a poorly CONSTRUCTED loop with a condition that does not meet your GOALS. TAKE a look at the loop structure and condition again to make sure you're not leaving something out.

These statements are acceptable for specific conditions, but they often make code less readable, which makes it difficult for others who look at your code to know what's really going on. If you make sure the only way out of a loop is to not satisfy the loop's condition, it's much easier to follow your code. Often, breaking out of a loop by force with an exit statement is a sign of a poorly constructed loop with a condition that does not meet your goals. Take a look at the loop structure and condition again to make sure you're not leaving something out.

Option EXPLICIT

Option Explicit

If IsNumeric(Age) = FALSE Then

If IsNumeric(Age) = False Then

DIM NAME

Name = "HARRY MANIS"

Dim Name

Name = "Harry Manis"

The VBScript CODE that comes along in a Web page cannot directly ACCESS any files on the client's computer. This prevents a Web page from making any modifications to sensitive files on the user's computer. VBScript is also very safe in that it doesn't give programmers the ABILITY to create unrecoverable CRASHES by virtue of its language syntax.

The VBScript code that comes along in a Web page cannot directly access any files on the client's computer. This prevents a Web page from making any modifications to sensitive files on the user's computer. VBScript is also very safe in that it doesn't give programmers the ability to create unrecoverable crashes by virtue of its language syntax.

Document.Write (TEXT).

Document.Write (text).

VBScript is script - a text-based CODE that GETS interpreted by a "HOST", like the Windows Script Host or IE. VB.Net is a semi-compiled language for WRITING java-like software.

VBScript is script - a text-based code that gets interpreted by a "host", like the Windows Script Host or IE. VB.Net is a semi-compiled language for writing java-like software.

ERR OBJECT.

Err Object.

The On Error RESUME Next statement provides you some degree of error handling by preventing program interruptions from runtime errors.

When an error occurs, by using this statement, the line of code CONTAINING the error is simply skipped over and the program continues.

On Error Resume Next statement does not correct an error, just ignore it, without EVEN displaying the error message.

The Statement essentially has two WAYS it is used. First to TURN off the script engine error checking:

On Error Resume Next

The second is to turn it on, thereby allowing the script engine to stop execution of a script when an error is encountered. Like so:

On Error Goto 0

The On Error Resume Next statement provides you some degree of error handling by preventing program interruptions from runtime errors.

When an error occurs, by using this statement, the line of code containing the error is simply skipped over and the program continues.

On Error Resume Next statement does not correct an error, just ignore it, without even displaying the error message.

The Statement essentially has two ways it is used. First to turn off the script engine error checking:

On Error Resume Next

The second is to turn it on, thereby allowing the script engine to stop execution of a script when an error is encountered. Like so:

On Error Goto 0

A dictionary can't be multidimensional but an array can be.

A dictionary has extra methods to add new items and check for EXISTING items.

When you delete a particular ITEM from a dictionary, all the subsequent items automatically shift up. For example, if you delete the second item in a three-item dictionary, the original third item automatically shifts up into the second-item slot.

A dictionary can't be multidimensional but an array can be.

A dictionary has extra methods to add new items and check for existing items.

When you delete a particular item from a dictionary, all the subsequent items automatically shift up. For example, if you delete the second item in a three-item dictionary, the original third item automatically shifts up into the second-item slot.

The Dictionary OBJECT stores name / VALUE pairs (referred to as the key and item respectively) in an array.

Write the below code in a notepad and save it with a .vbs extension and RUN it from COMMAND Prompt by just typing the name of the file.

Dim Beers

The Dictionary object has many PROPERTIES like Count, Item, CompareMode etc and many methods like Exists, Add, and Keys etc.

The Dictionary object stores name / value pairs (referred to as the key and item respectively) in an array.

Write the below code in a notepad and save it with a .vbs extension and run it from Command Prompt by just typing the name of the file.

Dim Beers

The Dictionary object has many properties like Count, Item, CompareMode etc and many methods like Exists, Add, and Keys etc.

CREATEOBJECT FUNCTION.

CreateObject function.

By DEFAULT, arguments are passed to functions and SUBROUTINES by reference; that is, the ADDRESS of the argument is PROVIDED to the FUNCTION or subroutine.

By default, arguments are passed to functions and subroutines by reference; that is, the address of the argument is provided to the function or subroutine.

VBScript has only one data type called a Variant. There are DIFFERENT categories of information that can be contained in a Variant, called subtypes. These subtypes are:

Empty, Null, Boolean, Byte, Integer, Long Single, DOUBLE, Date/Time, CURRENCY , String , OBJECT and Error.

VBScript has only one data type called a Variant. There are different categories of information that can be contained in a Variant, called subtypes. These subtypes are:

Empty, Null, Boolean, Byte, Integer, Long Single, Double, Date/Time, Currency , String , Object and Error.

VBScript is a CASE-insensitive PROGRAMMING LANGUAGE; i.e. case is ignored when reading VBScript SCRIPTS. So myVar, MyVar, MYvar all refer to the same variable.

VBScript is a case-insensitive programming language; i.e. case is ignored when reading VBScript scripts. So myVar, MyVar, MYvar all refer to the same variable.

A function, which is called differently from a subroutine, returns a value to the code that calls it, while a PROCEDURE (subroutine) does not. Functions must be set EQUAL to a RETURN value:

Variable_1 = My_Function(A, B, C)

A subroutine, on the other hand, isn't set to a variable. It can be called like

My_Subroutine A, B, C
Or
CALL My_Subroutine(A, B, C)

A function, which is called differently from a subroutine, returns a value to the code that calls it, while a procedure (subroutine) does not. Functions must be set equal to a return value:

Variable_1 = My_Function(A, B, C)

A subroutine, on the other hand, isn't set to a variable. It can be called like

My_Subroutine A, B, C
Or
Call My_Subroutine(A, B, C)

VBScript is a subset of Visual BASIC for Applications, but there are STILL many differences:

VBScript doesn't have a debugger like Visual Basic or you can say that VBScript does not provide any debugging features.You'll resort to using lots of message boxes, instead.

Unlike Visual Basic and Visual Basic for Applications, in which the developer can define the data type of a VARIABLE in advance, all variables in VBScript are variants.

There is no integrated development environment for VBScript that parallels the IDE for Visual Basic and Visual Basic for Applications.

Because variables are untyped and code is not compiled, all external objects instantiated in VBScript code are necessarily late-bound. This has a number of implications. First, late binding typically entails a substantial performance penalty in comparison to early binding. Second, while the properties and methods of early-bound objects can be examined in Visual Basic or hosted VBA environments using the Object Browser, this is not the CASE with late-bound objects. Finally, the help facilities available for early-bound objects in VB and VBA (like Auto List Members and Auto Quick Info) are not available, making syntax errors more likely and READY access to good documentation all the more necessary.

VBScript is a subset of Visual Basic for Applications, but there are still many differences:

VBScript doesn't have a debugger like Visual Basic or you can say that VBScript does not provide any debugging features.You'll resort to using lots of message boxes, instead.

Unlike Visual Basic and Visual Basic for Applications, in which the developer can define the data type of a variable in advance, all variables in VBScript are variants.

There is no integrated development environment for VBScript that parallels the IDE for Visual Basic and Visual Basic for Applications.

Because variables are untyped and code is not compiled, all external objects instantiated in VBScript code are necessarily late-bound. This has a number of implications. First, late binding typically entails a substantial performance penalty in comparison to early binding. Second, while the properties and methods of early-bound objects can be examined in Visual Basic or hosted VBA environments using the Object Browser, this is not the case with late-bound objects. Finally, the help facilities available for early-bound objects in VB and VBA (like Auto List Members and Auto Quick Info) are not available, making syntax errors more likely and ready access to good documentation all the more necessary.

Use of dim ,PRIVATE and public variables in VB script function first

Use of dim ,private and public variables in vb script function first

ANSWER : SET xl=createobject(“excel.application”) set wb=xl.workbooks.open(“d:/sample.xls”) set ws=wb.worksheets(1) ws.cells(3,4)=”WELCOME” wb.save wb.close set wb=nothing set ws=nothing set xl=nothing

Variant is the only datatype in vb script.There are many SUBTYPES under variant.They are EMPTY, Null, Boolean, Byte, Integer, Currency, Long, SINGLE, Double,Date, STRING, Object, Error.

Variant is the only datatype in vb script.There are many subtypes under variant.They are Empty, Null, Boolean, Byte, Integer, Currency, Long, Single, Double,Date, String, Object, Error.

ANSWER : function ADD(a,B) sum=a+b add=sum end function s=add(6,8) msgbox s sub ADD2(x,y) sum=x+y msgbox sum end sub CALL add2(6,8)

Answer : i=5 J=6 if i>j then msgbox i elseif i msgbox j
else
msgbox “nothing”
end if
for i=5 to 10 step 2
msgbox i
next
do while i<15
msgbox i
i=i+3
loop
mycase=”GITAM”
SELECT CASE mycase
case “abcd”
msgbox “abcd”
case mycase
msgbox mycase
case else
msgbox “wrong”
end select

How to READ from file and WRITE into the file

How to read from file and write into the file

If we DECLARE variables with some values and while USING if we use (spell MISTAKE) then USER can’t KNOW

If we declare variables with some values and while using if we use (spell mistake) then user can’t know

ANSWER : SET IE=createobject(“internetexplorer.application”) ie.navigate(“HTTP://www.google.co.in/”) ie.visible=true set ie = NOTHING

This is a SCRIPTING language developed by Microsoft and is based LOOSELY on Visual Basic. Its functionality in a WEB environment is defendant UPON either an ASP engine or the Windows Scripting Host, and must be used on a Windows hosting platform.

This is a scripting language developed by Microsoft and is based loosely on Visual Basic. Its functionality in a web environment is defendant upon either an ASP engine or the Windows Scripting Host, and must be used on a Windows hosting platform.

Answer : ASC() - Returns ANSI Character Code Chr() - Returns Character from ANSI Code InStr() - Find a string WITHIN ANOTHER InStrRev() - Find a string within another (Reverse) LCase() - Convert a string to LOWERCASE Left() - Crops a string from left Len() - Determine the length of a string LTrim() - Remove leading spaces from a string Mid() - Crops a string Replace() - Replace a substring within a string Right() - Crops a string from right RTrim() - Remove trailing spaces from a string Space() - Creates a string with the specified number of spaces StrComp() - Compare two strings String() - Creates a repeated character string StrReverse() - Reverse the characters of a string Trim() - Remove both leading and trailing spaces from a string UCase() - Convert a string to uppercase

Answer : Date(), Time(), Now(), LEFT(), RIGHT(), Mid()

The actions that are performed by CLICKING, pressing keys, moving mouse, dragging and dropping ETC are called as events. EVENT handling is the WAY to capture these events and perform the actions accordingly.

The actions that are performed by clicking, pressing keys, moving mouse, dragging and dropping etc are called as events. Event handling is the way to capture these events and perform the actions accordingly.

Order of evaluation of operators is, first arithmetic operators are evaluated, and comparison operators are evaluated NEXT and at the last logical operators are evaluated at the last. In arithmetic operators NEGATION, Exponentiation, MULTIPLICATION and division, integer division, modulus arithmetic, addition and subtraction and STRING concatenation are provided.

Order of evaluation of operators is, first arithmetic operators are evaluated, and comparison operators are evaluated next and at the last logical operators are evaluated at the last. In arithmetic operators negation, Exponentiation, multiplication and division, integer division, modulus arithmetic, addition and subtraction and string concatenation are provided.

In operator precedence expressions are evaluated and RESOLVED in a predetermined ORDER. The order of EVALUATION can be MODULATED if you use parenthesis. Expressions present in parenthesis are evaluated first.

In operator precedence expressions are evaluated and resolved in a predetermined order. The order of evaluation can be modulated if you use parenthesis. Expressions present in parenthesis are evaluated first.

Tristate constants can be used with FUNCTIONS which ALLOW FORMATTING of numbers. These constants can be used with VB Script without DEFINING them. It can be used anywhere in the code to reflect and represent the values.

Tristate constants can be used with functions which allow formatting of numbers. These constants can be used with VB Script without defining them. It can be used anywhere in the code to reflect and represent the values.

There are many USEFUL CONSTANTS present in Visual BASIC SCRIPT which you can use in your code. They ease your work load by REMEMBERING value and implementing in the code. Maintenance is easy with VB Script because it can easily change the feature of constants.

There are many useful constants present in Visual basic script which you can use in your code. They ease your work load by remembering value and implementing in the code. Maintenance is easy with VB Script because it can easily change the feature of constants.

Filter expression returns an ARRAY based on a specific filter search condition and it returns a zero based array. ARGUMENTS included in the filter array are Input STRINGS, value, include and COMPARE. If there is no MATCH for the value it returns an empty string.

Filter expression returns an array based on a specific filter search condition and it returns a zero based array. Arguments included in the filter array are Input strings, value, include and compare. If there is no match for the value it returns an empty string.

According to the first LETTER in a string it returns the ANSI code relevant to that first letter. If string is not present then a runtime ERROR occurs. ASC function returns the first byte used. It is used only with ELEMENTS containing byte data in a string.

According to the first letter in a string it returns the ANSI code relevant to that first letter. If string is not present then a runtime error occurs. Asc function returns the first byte used. It is used only with elements containing byte data in a string.

Arrays in VB SCRIPT should be assigned within the variant separated by a comma. If arguments are not SPECIFIED then the string is regarded as EMPTY. After specifying the elements in an array an index number should be USED INDICATING the desired element.

Arrays in VB Script should be assigned within the variant separated by a comma. If arguments are not specified then the string is regarded as empty. After specifying the elements in an array an index number should be used indicating the desired element.

ADODB.Stream CLASS can be used as STRING builder. VBScript string CONCATENATION can be very costly because of frequent memory ALLOCATION features. Binary FILE and memory I/O operation is provided by ADODB.Stream class. This is widely used to convert bytes into string, etc.

ADODB.Stream class can be used as string builder. VBScript string concatenation can be very costly because of frequent memory allocation features. Binary file and memory I/O operation is provided by ADODB.Stream class. This is widely used to convert bytes into string, etc.

Scripting Runtime LIBRARY is very important for the functioning of VISUAL basic script because it gives much more functionality such as File management, text operations and file modification FEATURES. Scrrun.dll is USED very much in PROGRAMMING VB.

Scripting Runtime library is very important for the functioning of Visual basic script because it gives much more functionality such as File management, text operations and file modification features. Scrrun.dll is used very much in programming VB.

Active X TECHNOLOGY can be used to GIVE much more functionality to VB SCRIPT. VB provides SUB routines, functions, string MANIPULATION, data/time, error handling, etc. VB can have more functionality added to it by working with languages such as ASP.

Active X technology can be used to give much more functionality to VB Script. VB provides sub routines, functions, string manipulation, data/time, error handling, etc. VB can have more functionality added to it by working with languages such as ASP.

VISUAL BASIC should rely on ASP for sever side processing. Asp.dll is used to make VB Script run on ASP engine and it invokes vbscript.dll. VB Script should be EMBEDDED with in &LT;% and %> context switches. ASP can provide VARIED functionality to VB Script.

Visual Basic should rely on ASP for sever side processing. Asp.dll is used to make VB Script run on ASP engine and it invokes vbscript.dll. VB Script should be embedded with in <% and %> context switches. ASP can provide varied functionality to VB Script.

VB and Java SCRIPT are much similar in functionality. They both interact with the document object model of the page. Many browsers have COMPATIBILITY with Java Script but they are not compatible with VB script as such. For client side scripting developers using VB Script should always make SURE of CROSS browser compatibility which is not the case when working with VB script.

VB and Java Script are much similar in functionality. They both interact with the document object model of the page. Many browsers have compatibility with Java Script but they are not compatible with VB script as such. For client side scripting developers using VB Script should always make sure of cross browser compatibility which is not the case when working with VB script.

If functionality aspect is considered VB Script ACTS SIMILAR to Java Script but it is compatible only on internet explorer. They INTERACT with Document object model. VISUAL basic script can also be used for SERVER side processing with ASP.

If functionality aspect is considered VB Script acts similar to Java Script but it is compatible only on internet explorer. They interact with Document object model. Visual basic script can also be used for server side processing with ASP.

.hta extension is used whenever you WANT to include a VB script in HTML. Here HTML acts as an interface and VB Script as the PROGRAMMING language. .hta extension files do run in the safe and trusted zone of Internet explorer. Although they run in the trusted zone QUERYING is restricted as it has to pass the guidelines of internet explorer.

.hta extension is used whenever you want to include a VB script in HTML. Here HTML acts as an interface and VB Script as the programming language. .hta extension files do run in the safe and trusted zone of Internet explorer. Although they run in the trusted zone querying is restricted as it has to pass the guidelines of internet explorer.

.WSF FILES are modeled in similar to XML. They can be executed with the help of Wscript.exe and it can be done from the command line also. This .wsf FILE can have multiple visual basic files. Reuse FUNCTIONALITY is present with this extension file.

.wsf files are modeled in similar to XML. They can be executed with the help of Wscript.exe and it can be done from the command line also. This .wsf file can have multiple visual basic files. Reuse functionality is present with this extension file.

A simple example detailing the running of VB Script is by utilizing WINDOWS Script host environment. VISUAL basic is a stand alone APPLICATION which has a .vbs as extension. Input can be provided through graphical user interface and output can be obtained by Wscript.exe from dialog and input BOXES. From COMMAND line it can be invoked by Cscript.exe.

A simple example detailing the running of VB Script is by utilizing Windows Script host environment. Visual basic is a stand alone application which has a .vbs as extension. Input can be provided through graphical user interface and output can be obtained by Wscript.exe from dialog and input boxes. From command line it can be invoked by Cscript.exe.