What are the various methods provided by the dataset object to generate XML? note:- XML is one of the most important leap between classic ADO and ADO.Net.So this question is normally asked more generally how can we convert any data to XMLformat. Best answer is convert in to dataset and use the below...
What determines touch potential
You create a low-impedance path by bonding the metal parts of the electrical system and the grounded (neutral) conductor. You can achieve a touch potential of < 50v by reducing the resistance between...
How to explain sales project in interview.
How to explain sales project in interview.Could u tell me modules or dim table with some column names and facts how to move data from dim to facts.And give me what logic u implement in that projects
For explaining your sales project: You can follow these points and cover them based on your actual project. 1. Name of the Project 2. Name of the Client 3. Brief Description of the Client 4. Brief ...
What is the advantage in creating force view?
Force view creates the view even if the underlying tables / referenced objects are not present. Force View are used while executing a script that has create tables and views statements or while creating a view for remote table.
Who is responsible for the maintenance of the software after it is deployed?
In case of computer networks, the network engineer is responsible for the maintenance of computer hardware and software that comprises a computer network otherwise maintenance group and the maintenance programmer is responsible for the maintenance.
How to export the contents of a combo box to the table?
I want to export the contents of a combo box to the data table so that I can parametrize the test using the data present in the combo box. thanks in advance roli
You can see the combo box values in the run time data table. "vb cb_count=Window("window name").WinComboBox("Combobox name").GetItemsCount For x = 0 to cb_count-1 cb_item = Wind...
combo_box = Window("Window Name").WinComboBox("ComboBox Name");
cb_count = combo_box.GetItemsCount
For x = 0 to cb_count-1
cb_item = comboBox.GetItem(x)
INSERT INTO TableName VALUES(cb_item)
Next
Explain when Java application can run out of memory ?
if you have an infinite loop that keeps on doing things that take up memory (like creating objects).
We all know Java automatically garbage collects unused objects. But you must remember that an object is considered as unused only when the object no longer referenced. That means a referenced class continues to exist and to take up memory space even if it is not used.
Why is multiple inheritance not allowed in c#?
One reason is to avoid name collision or avoid the problem of Identity which can lead to collision in method overriding. However, please note that absolute multiple inheritance is not possible in C# but C# partially supports multiple inheritance via Interfaces.
What is picking and packing in computer networking
As far as I know this term is used for items that needs to be picked from various locations in a warehouse whenever a customer fills the shopping cart and & submits the list for purchase.
Can constructor throw an exception?
yes,if exception related statements are there in constructor then it automatically throws an exception,if that is un-checked.
How can that be if constructors are not inheritable?
Can we declare main() as final?
Yes we can.
As main is static we cant declare final.
Tiny, large, huge memory models
I need the above said memory types explanation. please tell me any one.
There are six types of memory models. 1. TINY Memory Model: Used when code under 64KB is and data is under 64KB 2. SMALL Memory Model: Used when code under 64KB is and data is under 64KB 3. MEDIUM Me...
What is decommission liability? In which senior it will occurs in balance sheet?
Decommission Liability is costs that a company expects to incur in the future when the plant is shut down.
What are properties in c#? What are the advantages of using properties ?
Properties combine the behavior of method & variable.
Properties are members of classes. They are also used in structs and interfaces. Properties are an extension of fields but they do not designate storage locations. Properties provide a flexible mech...
What is bit twiddling in Java?
Bit Twiddling was used in earlier days for efficiency. It is a technique used for bit manipulation. Java bitwise and bit shift operators such as NOT, AND, OR, XOR, LEFT-SHIFT, RIGHT-SHIFT, UNSIGNED-RI...
What is the usage of abstract method?
Abstract classes used to implement polymorphism. Abstract class allows additional method declaration in the class.
Please read detailed discussion here http://www.geekinterview.com/question_details/19145
What should be responsibility and scope for system integration testing
I am strongly against the point "Developers are responsible for System integration testing". UNIT testing is the only testing area of developer. It should be modified as "Unit testing on integration of systems is responsibility of developer"
I am not satisfied by your answer, SIT is end to end testing and is done by tester.
Singleton class is a class in which only one instance of the object exist at any point of time. So a Singleton class is basically used when we want to restrict instantiation of a class to only one obj...
What is the purpose of clonable interface?
Cloneable interface is a marker interface and has no members. Cloneable is used whenever you want to manipulate a copy of the object without altering the original object. It is used to indicate that...
XRef data is written for Assembler, COBOL, or PL/I programs. XREF makes the Compiler produce a cross-reference listing. XRef data is written for the file and each field in the file that are accessed in the program using an
EXEC ADABAS GENERATE or a COPY statement.
Non numeric data transfer to numeric causes soc 7.But I want with reference to .....Xref,line number,..
You can make use of Tool Expeditor to get the SOC7 Abbend corrected. S0C7 error is caused due to data exception or bad record because of wrong data in the program. Find out the offset value in joblog. Mapping that offset value to the lines of codes where error occurred. Get it corrected.
NIM Server stands for Network Installation Management server. It is used for maintenance as well as management of AIX images on LPARs and also on individual stand alone servers. NIM can group instance...
How can I get off a error message Oracle form a0001 ask me to save the record when I change a record to other ?
If it an oracle error you are trying to trap than I would use ON-ERROR trigger on specific block, use built ins DBMS_ERROR_CODE, DBMS_ERROR_TEXT to trap the error.
I would write ON_MESSAGE trigger on block level, trap particular message with built ins MESSAGE_CODE, MESSAGE_TEXT and handle the error...
What is clustered table in Oracle? Difference between clustered table and view?
A cluster is a schema object that contains data from one or more tables, all of which have one or more columns in common.
Clustered table store data of multiple table based on common columns.
View is virtual table or which has attached select query.Its not actual table.
A cluster is a group of tables which share the same data blocks. Clusters are an optional method of storing table data. Cluster share common columns and are often used together. It is a powerful met...
What does the extract statement do in ABAP program?
Extract statement is a shortform for EXTRACT HEADER. It is used to extract dataset.
When Extract statement is encountered then the System creates the extract dataset and adds the first extracted record.
What do you define in domain and data element?
domain is used to assign data type and values for a field to be created in a program. if you make any changes in the domain the attributes of the table related to that domain also changes accordingly ...
domain is a technical characteristic of a field such as data types and length.
Description of a field is provided by a data element
What is table maintenance generator?
About Table maintenance generator: If your table maintenance generate end user easily enter data for the table. there are two types in it. 1. one-step 2. two-step if you do one-step processor what are...
Without using data dictionary end user can access the data by using a t.code it is to modify, change, delete.
Table maintanace genarator t.code is sm30.
What will be happen if data store down in citrix?
If Data store is down then MetaFrame administrators will not be able to edit any configurations in the Management Console such as publishing applications and new MetaFrame Presentation Servers cannot be added to the farm.
- Gather, transfer and transmit complete information and details related to credit claims such as identification, assessment and valuation - Assign of identification numbers for the claim - Check eli...
Write function vowels to count the vowels and letters
Write function vowels to count the vowels and letters in free text given as string. Then print out the number of occurrences of each of the vowels a, e, i, o and u in the string, the total number of letters, and each of the vowels as an integer percentage of the letter total. suggested output format...
I would suggest you make use of string.find() and string.substring() methods, make use of loops and counter variables to achieve the objective.
Write a function reverse which takes a strings as a parameter and prints it out in reverse.
Example:reverse (hello) prints out (olleh)
Code
#include<stdio.h> #include<string.h> void main() { int a,i; char b[100]; char s[100]="in this world let there be a name and fame to those who can"; a=strlen(s); for(i=0;i<=s;i++) { b[i]=s[a-i]; } }
What are some methods to allocate support cost?
Some methods to allocate support cost are:
1. Direct Allocation Method
2. Step-Down Method (also known as Sequential Allocation Method)
3. Reciprocal Method
What are the etl tester responsibilities?
Some of the ETL Testers Responsibilities are as follows: - Test ETL software. - Test ETL datawarehouse components. - Executing backend data-driven test. - Create, design and execute test plans, test ...
As an etl tester what are the things to test in Informatica tool. What are the types of testing has to do in Informatica and the things to test in each type? If there is any documents on etl testing
ETL Testing in Informatica: 1. First check the workflow exist in specified folder. 2. Run the workflow. If the workflow is success then check the target table is loaded on proper data else we can nee...
- Test ETL software. - Test ETL datawarehouse components. - Executing backend data-driven test. - Create, design and execute test plans, test harnesses and test cases. - Identify, troubleshoot and pro...
What are Oracle hints and how do you use them ?
Explain the real-time situation where would you use Oracle hits
Oracle optimizer is responsible for handling different situations by making appropriate decisions based on database statistics. It will create route path that is most appropriate to execute the code. ...
Query subject is nothing but a Table
A query subject is like a select statements which contain certain columns from the database. It is not exactly the replica of the columns in the database so you cannot say it as the database table. It is a view of the database table containing few or all of its columns.
How to generate systemutil.Run command automatically while recording?
I have QTP 9.2(mercury) when I record a test the scripts are generated but the very first line (i.E)systemutil.Run is not generated and while running the test I get the message as cannot find all programs object parent.
Navigate to Tools Menu -> Options -> Windows Applications Here Click on "Advanced" button and the scroll down You will see "Utility Object" Select the "Record SystemUtil.Run commands" Click on OK bu...
What is index property in descriptive programming?
Could you explain, why is it bad practice to use index property in descriptive programming?
1. get cell data using webtable("webtable").getcelldata(row,column) and we can click the link
2. Get all the links count in the webtable and click the link
Hi Lokesh,
Can you please elaborate your answer with example, how an index property negates the DP?
How to hide the files with vbscript ?
Hi, i want code in vbscript that make all (files and folders) : a- if there are some (files and folders) not hidden make them hidden and if there are other (files and folders) hidden stay hidden without any change.
You need to make use of GetFile method on FileSystemObject and then set the value of "Attributes" property to -1 to hide the file.
How to find which type driver used in Java or j2ee applications? Which type used commonly?
You also have AWRSQRPT that collects statistics and tracks SQL statements as well.
Automatic Workload Repository (AWR) is the enhanced version of statspack and is used as performance gathering and reporting tool. AWR is basically used to gather performance related statistic such as ...
Informatica error rep_12014 : error occured while accessing the registry
Hiiam learning Informatica 8.1 ( which is what I could get my hands on)..I am connecting to Oracle 10g.I created 2 connections to the db using connection --> relational connection browser.The source and target are the same db in this case, just diff table names. But created 2 separate connections .I...
Delete it
Try these and see if it helps
- Delete statics and try to retrieve.
- Try to export with INDEXES=n STATISTICS=none
- Disable auditing with "noaudit session"
SQL> noaudit session;
How do you find the size of the object in Java ?
How an insert method of the SQLdata source control works in asp .Net
The SQLDataSource methods such as Insert method is associated with ad Hoc SQL queries or stored procedures. When SQLDataSource is invoked via Web control: - A database connection is established, - O...
How to get local repository as shared repository?
There are many ways to move objects from Local Repository to Shared Repository. For instance, you can "Export Local Object" option under "File" Menu in the Object Repository to perform this.
How to drag the QTP code(actions) to qc bpt components
Create Components in Quality Center BPT Tab Create Initialization Component Create One Component for Each Tab Create Verification Components Create QTP Automation for New BPT Components Drag and Drop ...
What is the significance of ordinance in web_reg_save_param during correlation?
Ordinance is used to capture all the values of a dropdown
In Manual correlation web_reg_save_param("C_xxx", "LB=xxxxx", "RB=xxxxxx", "ORD=All", ...
How does MPFI works? & explain me the mechanism of it? What is the purpose of it ?
MPFI means Multi point fuel injection.MPFI injects fuel into the intake ports just upstream of each cylinder's intake valve, rather than at a central point within an intake manifold. MPFI (or just MPI...
MFIS stands for Multi Fuel Injection System. MFIS controls timing along with the amount of fuel that gets injected. In MFIS, air and the fuel is mixed just before the inlet. MPFI system injectors ar...
What is descriptive object program?
The object diagram should use , When relationship of objects are getting at the runtime and system is very complex
The technique of identifying objects on the basis of their properties collection or by giving description in the form of string arguments is known as Descriptive Programming. It is mainly used in the...
How to set GLobal setting for query studio?
Steps to set / modify Global Setting for Query Studio: 1. Stop the Cognos 8|ReportNet server. 2. On the Cognos 8|ReportNet Server, go to the directory /c8|crn/templates/ps/async/ 3. Either create a n...
What does locality of reference mean in term of operating system
In order to run a computer, several data locations needs to be referenced in a short period of time. Such data locations consists are in relatively well predictable clusters. This concept of frequentl...
Vertical and horizontal cluster
What are the advantages & disadvantages of vertical cluster & horizontal cluster? Which is the best? Why?
In horizontally clustered environment, cluster-enabled application is deployed on multiple physical machines. Each machine is available for requests. Horizontal clusters offers protection over hardwar...
Alternative to tk prof in Oracle 11g
Hi, what is alternative to tk prof (used in Oracle 9i) in 10g and 11g? regards, shashi
Trace Analyzer Traditionally, tkprof has been the best tracing diagnostics tool available. That is, until the introduction of Trace Analyzer which is everything tkprof is and more. However, as ...
You can make use of PL/SQL based TRCA
Other notable alternatives are
SQLTXPLAIN
Method-R profiler
OraSRP
TVD$XTAT
What is disk scheduling algorithm?
Disk scheduling algorithms are algorithms designed and used for scheduling disk operations Disk scheduling algorithms dramatically increase disk performance Disk scheduling algorithms aims to minimiz...
Hybrid automation framework structure
I was been asked to write the hybrid framework structure in an interview. Could you please let me know the hybrid framework structure.
As the name implies, Hybrid framework is a combimation of many frameworks. Frameworks such as Data Driven Framework, Keyword Driven Framework and Functional Decomposition framework are combined togeth...
Explain with an example which situation that pivot tables can save time compared to any other reporting tools available
Using Pivot Table we can view data multidimensionally. It is basically used for improved presentation of data. A Pivot Table not only summarizes data by categories but also by subcategories. One of t...
If someone finds that their internet connectivity is down, how would you fix the problem?:
If someone is using a laptop they may have accidentally turned their wifi connection off. This is fixed by:
Looking for the wifi connection button on the top row of the keyboard. It looks similar to the letter A surrounded by parenthesis. Push it to turn the wifi connection back on.
I would ask them to do the following steps.
Step 1. Reset / Restart the Modem.
If no connection then
Step 2. Reset Network Connection / Restart the PC
If not connection then
Step 3. Call up the Internet Service Provider and log a complaint.
What is high water mark? Give an example where it can be useful ?
High Water Mark (HWM) represents total number of extent blocks used by a table. The value of High Water Mark could sometime be more then the actual size required/used by a table. This is because, some...
What is the significance of Java.Lang.Object class?
java.lang.Object provides several methods which are common to objects. java.lang.Class object is created whenever JVM creates an object.
java.lang.Object provides several methods which are common to objects. java.lang.Class object is created whenever JVM creates an object. java.lang.Class is a superclass of all objects and it describe...
I have two table a and b.With table a I fired a query to get a count, and a query with table b to get a count.Now I want total of both count.But I want to this all in one query.Example:- I fired tqo queries as-1- select date(today_date), count(1) from table day1 group by date(today_date);2- select date(yesturday_date),...
You can do it like this
SELECT (SELECT COUNT(1) FROM table DAY1 GROUP BY DATE(Today_DATE)) + (SELECT COUNT(1) FROM table DAY2 GROUP BY DATE(Yesterday_DATE)) AS TotalCount FROM day1 LIMIT 1
Why we use sort_area_size parameter in init.Ora file?Kindly let me know?
SORT_AREA_SIZE is one of the deferred Oracle Server Parameters which is set in init.ora. Its value as bytes (integer) sets the size of in-memory sort work area. The default is 64K and the maximum valu...
Difference between data abstraction, schema and instance
Difference between the three levels of data abstraction, and between a schema and instances.. Consider a two dimensional integer array of size n*m that is to be used in your favorite programming language. Using the array as an example, illustrate the difference (a) between the three levels of data abstraction,...
Data Abstraction means suppression of information / details of data organization and storage. Data Abstraction gives importance to mainly essential aspects in order to help better understanding of th...
In what situation you have to prefer offline and online backups ?
Online backup also known as hot backup / open backup can be performed even the database is open and while users are working and is available for read and write activity. To perform Online backup, the ...
How do you resolve a invoice discrepancy that you discover
Send a debit note/memo to vendor
Ask the vendor to send credit note/memo for the discrepancies caused.
Define rom image and explain each section of a rom image in an exemplary system?
A ROM image captures the data from a read-only memory chip, such as hardware firmware, video and arcade game boards, etc. It is often used for emulation.
Run PL/SQL block from SQL server
How do you run PL/SQL block from SQL server
Try these and see...
Go To Options -> Run SQL
Set "Statement Delimiter" to None
Go To Options -> Technical Parameters
Tick "Use SQLExecDirect"
What is vlan trunking? How does it work?
VLAN trunking enables single network adapter to act as "n" number of virtual network adapters, "n" has a theoretical upper limit of 4096 VLAN network segments. However it is limited to 1000 VLAN n...
Quality and productivity measures
The individual who supports in preparing metrics need to have working knowledge of quality and productivity measuresa – trueb – false
Yes, Answer is A True,
Test metrics team is required to possess a working knowledge of quality and productivity measures.
How to delete a entire linked list?
You delete a linked list by iterating through the list and deleting the nodes one by one. Begin at the head Get address of first node Get address of next node Delete first node Do not to access next ...
What is the difference between ip vpn and internet vpn ? Does both comes with static ip adress?
Both IP VPN as Internet VPN are generalised terms. These are not proper usage terms. Inetnet based VPNs IPsec Layer-3 network level protocol open standard technology SSL/TLS PPTP These VPNs are acce...
Hi all,what are the tools or the softwares required or used by knowledge brokers in knowledge mangement sytem for their processing?Thanks,avinash
Knowledge Management System generally comprises of:
Collaborative Environments
Social Computing Tools
Simulation Tools
Knowledge Ecosystem
Knowledge Management Softwares
Contact Centers
Self-help portals
Call Centers
Service Desks
FAQ systems
Web self-service
When you run an EIm job using configuration file(ifb). If you get an error and the log says invalid file name. What will you do?
This error occurs when the file is not located in the folder from the Batch file is run. You need to verify if the configuration .ifb file name and the path to the file is valid and is correctly spe...
Explain a one-to-many strong vs. One-to-many weak entity relationship.
entity relationship when attribute are connected to entity there are different different type attribute are available weak entity and strong entity when we are using key that called strong entity and when key are not connected that called weak entity
Weak Entity generally don't possess key attributes of their own whereas a Strong Entity possess its own key attributes that are independent of other entities. Weak entity is usually existence-dependent on another entity type and does not have enough attributes to form its own primary key.
Why is Oracle called kernel package?
Oracle introduced the Unbreakable Enterprise Kernel for Oracle Linux during Sep 2010 which runs directly on Oracle LINUX 5 with fast, modern, reliable kernel that is optimized for Oracle software and hardware.
List different types of labyrinth seals how to measure labyrinth seal clearrence?What is the allowable clearence?
Different Types of Labyrinth Seal are as follows: Axial Labyrinth Seal Radial Labyrinth Seal Low Cost Labyrinth Seal Bearing Shield Labyrinth Seal Nilos Ring (AV) Labyrinth Seal Nilos Ring (JV) Labyr...
What is evaluated receipt settlement?
Evaluated Receipt Settlement also known as ERS is a business transaction process between trading parties. In this type of process, the PO information as well as the goods receipt information is used to make direct payment to the supplier without even receiving an invoice.
Before the introduction of operating systems what concept was used in computer?
Prior to the introduction of Operating System, operation instructions were generally fed into the electronic system bit by bit on rows of mechanical switches or by jumper wires on plug boards.
List down the advantage and disadvantages of covering indexes.
Covering Indexes are useful for Input / Output intensive workloads.
Covering indexes are smaller in size
Covering Indexes are sorted by values
It is easier to cache date in Covering Indexes
Covering Indexes cannot be used to select all the columns / entire table.
Calculate the size of earthing conductor between earth pit & 2000 kva generator.
Earth Grounding Conductor (EGC) size should not be less than 25 percent of the capacity of the phase conductors or the over-current device. For rating or setting of automatic overcurrent device not ex...
How will you find-out if your database is using recovery catalog or not?
Querying views like rc_database in each catalog will identify the target database it is registered with.
There are few ways through which you would find if your database uses recovery catalog: Check backup scripts and findout if the scripts are making any connection to a recovery catalog. Check tnsnames...
Relationship between database and data warehouse
What is the relationship between a company's databases and its data warehouse?
Database is a structured collection of relational data. Database is used to store the relational, network or hierarchical data. It contains some sort of data and it is being used by the organization...
In simple words, a database is used to store information, and a data warehouse is used to query and analyse the stored data in several ways. Data warehouse helps business management to take important...
Representing SQL server objects
How do represent objects in SQL server? Is it possible? If yes, how?If not? Why?
Try using Server Management Objects (SMO) classes
How to create regular and measure dimensions? How we will use these dimensions in the report?
A regular dimension organizes the information. It is stored in a hierarchy, from the highest level of granularity to the lowest. It usually has multiple levels. Each level requires a key and a captio...
What is control accounting? What is the use of it?
A control account represents a summary of general ledger. It helps us to keep the general ledger free of innumerable transaction details. However the details of all transactions will still be maintai...
What is the treatment of depreciation on gift items?
It may depend and differ based on what the gift items are.
What is measure dimension?
A measure dimension is nothing but a collection of facts.
A measure dimension can be created for one or more query subjects provided they have a valid relationship between them.
How to calculate response time in client-server technology?
This can be done by measureing the time taken by the first byte to reach the client (TTFB) and the time taken by the last byte of the response to reach the client (TTLB) by using various network bandwidths between the client and the server.
When a small amount of cu is added to a ni conductor, then the?A) resistivity of ni will decrease at all temperatures because cu is better conductor than nib) residual resistivity of ni at low temperatures will increase as cu atoms acts as defect centersc) resistivity of ni will increase at all temperatures...
Answer is C. If a small amount of Cu is added to Ni conductor, then resistivity of Ni will increase at all temperatures as Cu destroys the periodicity of Ni and acts as defects. According to Matthies...
Retail invoice vs. Tax invoice
What difference between retail invoice and tax invoice?
Retail invoice is a normal invoice given to a customer at the time of sales, it is not concerned with tax-credit. Whereas tax invoice is a mandatory invoice precribed by the tax authorities containin...
Whenever sales transaction does not involve any tax component, then retail invoice is issued. Such type of invoice is also known as cash memo. No VAT credit can be claimed on retail invoices. Wheneve...
What is cost control? What are the duties of a cost controller?
Cost control is a process that is followed in order to reduce the overall cost of production / service which results in not only saving more but also ensures competitive strategy. Cost controls ensur...
Freight charges is the cost of transporting the goods from the seller place to the purchasers location. This cost shall include packing, loading / unloading, carriage, shipping cost etc.,
What are the parameter of resource manager?
Resource Parameters are classified under 2 categories: Main Parameters Additional Parameters Main parameters are the most important parameters pertaining to functionality, performance, and availabil...
What should you do when you find a stacktrace in the server errorlog?
When the server crashes, it generates core dump. If value of orclsdumpflag is set to 0, then the server will also attempt to leave a stack trace. The location for the stack trace is: ORACLE_INSTANC...
Outline the steps for recovery with missing online redo logs?
Create pfile from spfile Edit pfile with _allow_resetlog_currpuation=true 1) Connect / as sysdba 2) Startup 3) Recover database until cancel; 4) Alter database open resetlogs; In RMAN restore: RMAN...
How to calculate the row length?
You can make use of VSIZE function to get the number of bytes in the internal representation of individual field. However this cannot be applied on fields that has BLOB data type and in such case you have to use dbms_lob.getlength function on BLOB data type field.
High raised building construction
Soil density test, bearing capacity of soil?
For Bearing Capacity, Plate load test is required to conduct and for soil density core cutter or sand replacement method is used.
Soil density is found by using core cutter method or sand replacement method. Similarly bearing capacity of soil can be found by using plate load bearing test.
Improve hard disk transfer rate
How to increase transfer rate of an hard disk?
See if any among these helps to increase Hard disk transfer rate... - Try using RAID setup - In Device Manager under ATA/ATAPI Controllers verify if the hard disk is running in UDMA mode. - Update m...
It is a part of Oracle Order Management Implementation. Seeded meaning initial data or pre-defined data provided with the system. Order Management sends invoices and credit memos to Receivables via t...
Seeded invoice in accounts payable
What is seeded invoice?
It is a part of Oracle Order Management Implementation. Seeded meaning initial data or pre-defined data provided with the system. Order Management sends invoices and credit memos to Receivables via t...
How to write script using database
Hello, I have imported log file into ms access with columns server,date,time,url.I need to write vb script in vb editor for accessing rows in between given date and time.It's urgent.Please can any body help with this.Thanks
MS Access has built-in Visual Basic Module Editor, Click on Modules Tab Click New Create Public Function Put in your code Save, Close, Re-Open, Now you can use your VB Script anywhere in MS Access...
Definitions, usage and its information in Oracle forms 9i
Oracle Applications - Folder Functionality are made use of in custom forms. Folder Functionality enables user to perform host of actions on fields such as ordering, renaming, resizing, moving, including, excluding etc., in a multi-row block.
Layered structure of an operating system: LAYERS ===== User User Interface Program / Application Program System Services and File System Input and Output Management User Console Memory Management Pro...
Why QTP is called a "keyword driven test tool"?
QTP is called A "Keyword Driven Test Tool" because it is based on Keyword-driven testing technique. Keyword-driven testing is one type of Test Automation frameworks. There are other types for framewor...
How is user interfaces powerful in Ajax?
Using Ajax, a web application can request only the content that needs to be updated, thus drastically reducing bandwidth usage and load time. The use of asynchronous requests allows the client's W...
AJAX helps in refreshing / requerying parts of web page without reloading the entrie webpage there by increasing performance and ultimately user interface
How is stored procedures managed in MySQL?
Details of existing stored procedures in MySQL can be obtained from ROUTINES table in INFORMATION_SCHEMA database.
Stored Procedures can be managed using the following:
CREATE [FUNCTION|PROCEDURE]
ALTER [FUNCTION|PROCEDURE]
DROP [FUNCTION|PROCEDURE]
SHOW CREATE [FUNCTION|PROCEDURE]
What is the format used for real numbers by clipper?
Clipper uses binary floating point format for Real Numbers which could result in precision related errors.
What are the steps to be taken for improving performance in Microsoft access database?
Few of the steps that can be taken to improve the performance of Microsoft Access Database are as follows: Plan and Design your tables appropriately as required. Create Normalized Tables. Do not cr...
What is the way for summing up a column in a table in Microsoft access database?
You can create a query using SUM function to calculate the sum of a column.
SELECT SUM([Column_Name]) FROM [Table_Name]
or
In reports You can place a field in footer with control source as "=SUM([Column_Name])" which will calculate the sum of the column.
How can one get the deleted records in Microsoft access database?
Though there are options to recover a deleted table, there is no option to get back records that are deleted directly from database tables.
Records once deleted from database tables cannot be undone.
How can one implement the concept of triggers in Microsoft access database?
There are several methods in MS Access where the concept of triggers can be put to use From Tables, Forms, Reports You can create triggers at various levels and events. In fact MS Access makes this p...
What are the objects present in the table msysobjects of Microsoft access database?
The following objects are present in MsysObjects table of Microsoft Access
Connect
Database
DateCreate
DateUpdate
Flags
ForeignName
Id
Lv
LvExtra
LvModule
LvProp
Name
Owner
ParentId
RmtInfoLong
RmtInfoShort
Type
Hows do electrons travel through a lightning bolt?
Generally, lightning is negatively charged. During thunderstorms. The Earths is recharged and its surface becomes good conductor of electricity. The Earth is charged negatively and the atmosphere i...
Hello Mr Kondalarao Your major plus point is Masters in IIT, While you have a good chance in getting into development,make sure you start sharping your C and/or C++ skills. Since you are experienced...
How to maintain prefix no in tr.Code sale
We know that workflow definition will have 8-digit number with the prefix WS Out of this 8-digit number, first 3 digits of this number is used for prefix number and the system automatically assigns t...
What is the role for a manual tester
Hi, I am planing to get a job in manual testing. Can any help me in what a manual tester does from initiation of the project to end of the project.What are his role from base.Thanks,priya
Please send your resume to rawoof@sbbhome.com.
Soft Bits and bytes is hiring for Software testers.
Please walk in at the below mentioned address:
Soft Bits and Bytes
#615/3,2nd floor,3rd stage,
Dr.Rajkumar Road,Rajaji Nagar,
Above TVS showroom
Bangalore-21.
hi priya,
If you are looking for a change to take up manual testing forward your CV to richardson.george@hotmail.com.
CV must include your 10,+2 and UG marks percentage and year of passing.
catch you later,
with regards,
Richie
Group discussion in recruitment process
Respected sir, I am doing my m.C.A.I want to know which i.T companies are conducting group discussion in their recruitment process? Sir plz kindly inform me the recruitment process of different companies(like which phases we need to face,percentage cutoff). Thanking...
Most of the companies will have GD as part of recruitment process.
kamalnath today most of the major MNc companies conduct Group Discussion in their recruitment process. To get a idea of the paper type of different placement comapnies you could refer the link
http://www.geekinterview.com/Global-Interview-Questions
This is a very good huge collection. All the Best.
What is your short and long term goals ?
An interviewer asks me,what's your short and long term goal? What should I answer to impress him?
You certainly cant get a readymade answer for this question. You should not even expect to answer it without pondering over the question for yourself. Think about the basic objective...
In case the institute where you are getting trained, provide placement assistance, it will be helpful to you.If no placement assistance is provided by your training institute, you will have to search ...
RahulBoth MBA and MCA are exciting options.Since you are very good at computers, you can opt for MCA too.As for Banking, In case you join work, then you still can persue MBA or MCA via corre...
Finding job with backlog subjects
Hai, I am ravindra form padmashri dr b.V.Raju institute of technology,i am having a backlog in my 3-ii semester as I was absent for that exam ,will it be any problem for me for my jobs which I apply?
RAVINDRA PAIDIPARTHI you would be defintely asked about the backlog which you would have to face. BUt dont lsoe hope.Do well and get good percentage in your exams and strengthen your communication,aptitude,technical skill for getting an entry.
You will certainly asked to give valid reason for the backlog.Most of all, major companies will insist only on candidates with consistent track record and who average percentage over 60-70%.
What does an extract statement do in the ABAP program?
Once you have declared the possible record types as field groups and defined their structure, you can fill the extract dataset using the following statements: extract . When the first extract statement occurs in a program, the system creates the extract dataset and adds the first extract record to it....
Extract statement is a shortform for EXTRACT HEADER. It is used to extract dataset.
When Extract statement is encountered then the System creates the extract dataset and adds the first extracted record.
What is a batch input session?
Batch input session is an intermediate step between internal table and database table. Data along with the action is stored in session ie data for screen fields, to which screen it is passed, program name behind it, and how next screen is processed.
The R/3 system normally executes the transactions in a session non-interactively. Whenever there is more than one transaction call and data process such session are known as batch input session. This ...
DataSet object provides the following methods to generate XML:
ReadXML
WriteXML
GetXML