Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Solved Assignments
Asked Questions
Answered Questions
what is difference between truncate and delete- truncate cant be rolled back whereas delete can be- truncate keeps the lock on table whereas delete
you want to implement following relationships when designing tables how would you do ita one-to-oneb one-to-manyc many-to-manya one-to-one
what do you mean by an execution plan why is it used how will you view ita an execution plan can be known as a road map which textually or
what are the benefits of using stored procedures- they help in reducing network traffic and latency which in turn boosts application performance-
what is recursion is it possible for a stored procedure to call itself or recursive stored procedure how many levels of sp nesting is
differentiate between a unique key and a primary key- by default clustered index on column are created by primary key while nonclustered index are
give detail description on transactions - using transactions we can group all sql commands into a single unit- transaction begins with some task and
what is the function of sql server agent windows service- its a windows service that handles tasks scheduled within sql server environment these
explain query execution plan- optimizer available in sql server optimizes code to be effectively executed- a query execution plan demonstrates how
what do you understand by a view what does with check option clause for a view do- a view is a virtual table which comprises fields from one or more
what is the difference between a having clause and a where clausehaving clause- having clause is used only with select statement- it is normally used
when is updatestatistics command used- when processing of large data is done this command is used- whenever large number of modification deletions or
when must a function throw an exceptiona function must throw an exception when its not able to fulfil its promiseas soon as function detects a
describe the advantages of proper inheritancethe biggest advantages of proper inheritance are a substitutability andb
what things will you remember when making an interface- a classs interface must be sensible enough it should act the way user expects it to- it must
what can be main reasons for a bug not being to reproduce what must be done if such a bug is founda bug cant be reproduced for below reasons1 low
illustrate parameterization in qtp- parameterization - passing values from external source into script- the number of values passed can be single or
what are repositories used by qtp to store object propertiesqtp uses two kinds of repositories to store object propertiesa shared object repository a
what is the difference between test plan and master test planmaster test plan -i it is mandatory in all projectsii it provides strategy to be used to
an application which is under development how would you develop a test case for itwhen application is under development business requirement document
what kinds of bottlenecks can be expected in performance testingbottlenecks in performance testing can have below effects- it can affect the
name certain common tools which are used for load testing- rational performance tester by ibm rational- open sta an open source tool- loadrunner by
determine the shared mode of qtp- best used in subsequent cases- when there are numerous tests which correspond to interface objects or application-
explain the per-action modeof qtp- best used in below cases- when creating simple record and run tests when there is just one or very few tests which
what tasks do checkpoints perform in qtpcheckpoints in qtp are used to verify information which is expected to be displayed when running test