-
what are the advantages and disadvantages of shared object repository and per test object repository in QTP
qptopm
- Apr 20th, 2016
Adv:Manage all the objects for a suite of tests or components in one central location.
Simple and easy to identify the objects.
Disadv: It consumes too much of memory when it is loaded and it will increase the execution time.Haresh Pakki
- Jun 18th, 2007
1. QTP cannot call Actions that use a shared Object Repository.2. QTP can call Actions that use a per Action Object Repository, but it will be read-only.3. QTP can call copy Actions that use a per Action Object Repository. 4. QTP cannot copy Actions that use a shared Object Repository.
-
What is Interoperability Testing?
Interoperability Testing can validate that two products work together and yet neither may be in compliance with the specification. This often happens when sets of two products are tested in a pair-wise manner but the sets are not tested with each other. This situation occurs for various reasons - foremost being the lack of universal test cases and unclear testing procedures. The principal risk in this...
qptopm
- Jul 28th, 2016
Interoperability testing involves testing whether a given software program or technology is compatible with others and promotes cross-use functionality. It checks whether software can inter-operate w...
kisskasa
- Jun 27th, 2008
Interoperability tests verify that the application can work in the production environment. Operability tests are performed AFTER or CONCURRENT with UAT(User Acceptance Testing). Plz correct me, if iam wrong.
-
What is difference between Trigger and a Stored Procedure?
Ashwini
- Jan 25th, 2018
Procedure - Definition - Procedure is a program unit or a module that performs a particular task. Execution - A stored procedure is executed explicitly by issuing procedure call Parameters - St...
qptopm
- Nov 3rd, 2016
Commit cannot be done in case of triggers except for autonomous transactions. When you create a trigger you have to identify event and action of your trigger. Triggers are implicitly called by DB itself
-
What are the advantages and disadvantages of primary key and foreign key in SQL?
qptopm
- Sep 9th, 2016
Foreign keys are both a method of ensuring data integrity and a manifestation of the relationship between tables. It is also known as referential integrity. Foreign Key is a field in database table...
shivkumarojha
- Sep 6th, 2006
Disadvantages:On primary key index will be created so during updation of table index need to be adjusted accordingly. this process makes the updation slower.
-
What are the advantages and disadvantages of View?
Read Best Answer
Editorial / Best Answer
Answered by: Mohan
- Jun 2nd, 2006
Hi,
Advantages of views:
1. View the data without storing the data into the object.
2. Restict the view of a table i.e. can hide some of columns in the tables.
3. Join two or more tables and show it as one object to user.
4. Restict the access of a table so that nobody can insert the rows into the table.
Disadvatages:
1. Can not use DML operations on this.
2. When table is dropped view becomes inactive.. it depends on the table objects.
3. It is an object, so it occupies space.
Pls. add , if I miss any of them.
Thanks,
Mohan
Raj
- Mar 7th, 2019
These are following some advantages
1. Performance
2. Security
3. Easy and Reusable
4. Consistency and independent
Marcus
- Apr 6th, 2018
The view uses virtual space when in use, this is a temporary space on the server that goes away when not in use.
-
What is Red Box Testing ? What is Yellow Box Testing ? What is Grey Box Testing ?
qptopm
- Sep 6th, 2016
Red Box Testing: It is User Acceptance testing. It is nothing but a Protocol testing. Red box testing is for Error Message Testing The name says that if the system is not accepted then it is a red box...
Sujatars
- Aug 15th, 2007
Grey box testing is the combination of white box testing & black box testing.Yellow box testing is testing the for warning messagesRed box testing is testing the error messages.
-
What are the disadvantages or drawbacks in QTP?
Rajitha Pasupuleti
- Mar 28th, 2017
QTP supports only windows based applications and it supports only VB scripting language. It does not support Java, PHP, etc.
qptopm
- Dec 19th, 2016
QTP requires more memory. And some knowledge of VB Script programming to create functions in project.
-
Difference between database & Database Server?
qptopm
- Apr 26th, 2016
Database Server - Database server will have your one or more database hosted such as Oracle, Sql Server, MySql, etc.A database is a collection of information that is organized so that it can easily b...
HARENDRA KUMAR SINGH
- Mar 5th, 2016
Database is used to store collection of data.
Database Server is collection of database stored separately.
-
What is the difference between adhoch testing,monkey testing and exploratory testing?
qptopm
- Apr 15th, 2016
Exploratory testing: 1) It is any testing to the extent that the tester actively controls the design of the tests as those tests are performed and uses information gained while testing to design new a...
kurtz182
- Dec 15th, 2009
Ad-hoc testing is performed after testers have already gained knowledge about an application and have executed their formal structured tests. The purpose is to use a tester's experience, kno...
-
What is the difference between stored procedures and stored functions in ORACLE?
qptopm
- Jul 22nd, 2016
Functions have a scalar return value. Procedures do not have a return value.
A Stored procedure may have arguments that are IN, OUT, or INOUT. Functions may only have IN arguments.Prasanjeet Das
- May 9th, 2012
SP 1-It is a subprogram that perform an action. 2-It does not contain any return clause. 3-Can return none,one or many values. 4-Can contain a return statement. SF 1-Invoke as a part of expression....
-
What is difference between Co-related sub query and nested sub query?
Co-related sub query is one in which inner query is evaluated only once and from that result outer query is evaluated.Nested query is one in which Inner query is evaluated for multiple times for gatting one row of that outer query.ex. Query used with IN() clause is Co-related query. Query used with = operator is Nested query
Abdul Rahman
- Jul 18th, 2017
A nested sub query is one sub query inside another sub query. A correlated sub query is a sub query that references a column from a table which appears in the parent statement.
qptopm
- Oct 13th, 2016
Co-Related Vs Nested-SubQueries. Technical difference between Normal Sub-query and Co-related sub-query are: 1. Looping: Co-related sub-query loop under main-query; whereas nested not; therefore...
-
-
What is the difference between testing and debugging?
Big difference is that debugging is conducted by a programmer and the programmer fix the errors during debugging phase. Tester never fixes the errors, but rather find them and return to programmer.
Karik
- Apr 5th, 2018
Testing: Basically, testing is a process of exploring the system to find defects present in the software, and not only that, this process has to locate the defects and define what will happen once the...
qptopm
- Jun 28th, 2016
Testing is the aim of finding errors. This is done by testers. It proves programmers failures.
Debugging is locating and fixing the errors. This is done by developers. -
What is difference between a PROCEDURE & FUNCTION ?
A FUNCTION is always returns a value using the return statement. A PROCEDURE may return one or more values through parameters or may not return at all.
Read Best Answer
Editorial / Best Answer
krishnaindia2007- Member Since Sep-2007 | May 3rd, 2008
1. Function is mainly used in the case where it must return a value. Where as a procedure may or may not return a value or may return more than one value using the OUT parameter.
2. Function can be called from SQL statements where as procedure can not be called from the sql statements
3. Functions are normally used for computations where as procedures are normally used for executing business logic.
4. You can have DML (insert,update, delete) statements in a function. But, you cannot call such a function in a SQL query.
5. Function returns 1 value only. Procedure can return multiple values (max 1024).
6.Stored Procedure: supports deferred name resolution. Example while writing a stored procedure that uses table named tabl1 and tabl2 etc..but actually not exists in database is allowed only in during creation but runtime throws error Function wont support deferred name resolution.
7.Stored procedure returns always integer value by default zero. where as function return type could be scalar or table or table values
8. Stored procedure is precompiled execution plan where as functions are not.
9.A procedure may modify an object where a function can only return a value The RETURN statement immediately completes the execution of a subprogram and returns control to the caller.
mahendra pal
- Sep 18th, 2018
Procedure may or may not return value
mangesh patil
- Aug 22nd, 2017
Procedure may or may not return value where as function should return one value. -
What is a pseudo column. Give some examples?
It is a column that is not an actual column in the table.eg USER, UID, SYSDATE, ROWNUM, ROWID, NULL, AND LEVEL.
Amol Kulkarni
- Dec 3rd, 2016
Pseudo columns are used to pass additional information on a row. A pseudo column is not actually part of a row like any other columns. but exists due to the row property, they cannot be updated or mod...
-
What is difference between SQL and SQL*PLUS?
SQL*PLUS is a command line tool where as SQL and PL/SQL language interface and reporting tool. Its a command line tool that allows user to type SQL commands to be executed directly against an Oracle database. SQL is a language used to query the relational database(DML,DCL,DDL). SQL*PLUS commands are used to format query result, Set options, Edit SQL commands and PL/SQL.
qptopm
- May 12th, 2016
PL/SQL provides the capability of the programming language and supports the above mentioned list. It also supports running of SQL statements inside the PL/SQL blocks. SQL provides access to the database for retrieving data from the objects. However SQL does not have the programming capabilities.
Das
- Nov 4th, 2015
Simply put, like a command prompt in Windows Operating system, we have SQL PLUS tool in Oracle DBA.
-
What is the purpose of the testing?
Answer posted by Radhika on 2005-05-23 17:50:13: The purpose of testing can be quality assurance, verification and validation, or reliability estimation. Testing can be used as a generic metric as well. Correctness testing and reliability testing are two major areas of testing. Software testing is a trade-off between budget, time and quality.
siri
- May 29th, 2019
The main purpose of testing is to find the defects and to deliver a quality product.
qptopm
- Jun 17th, 2016
Finding defects which may get created by the programmer while developing the software.
-
Does automation replace manual testing?
qptopm
- Jun 29th, 2016
Short Answer is No. Next thing you need to understand is difference between Manual Testing and Automation Testing. Manual testing means testing a product/app/website or anything that needs to be test...
Indrajeet Prajapati
- Sep 27th, 2015
Automation testing is not a replacement for manual testing its just a continuation for manual testing. Because initially every application will be tested manually once the application has come to a stable state then only it is suggested to do automation testing.
