Answered Questions

  • 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 17th, 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...

  • What are the advantages and disadvantages of View?

    Star 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...

  • 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...

  • 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 SQL and SQL Server?

    not known

    Abdul Rahman

    • Jul 18th, 2017

    Sql Server is the Database offering/ product of Microsoft. Examples of other database products are Oracle, MySql, etc. SQL is the query language that is used to handle/ manipulate data in the database...

    amit

    • Jun 12th, 2017

    SQL is a command language to perform operations on database. SQL server in the underlying software that will accept the SQL commands given to it to perform the operations in data handled/ stored by server.
    e.g. .net is language and Visual studio is software to run it.

  • 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...

  • 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.

    Star 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.

  • 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.