http://commoninterview.com The source for Job Interview Questions and Job Search Networking Mon, 08 Mar 2010 02:56:38 -0700 en http://commoninterview.com/Programming_Interview_Questions/what-is-a-correlated-sub-query-how-can-these-queries-be-useful-1/ http://commoninterview.com/Programming_Interview_Questions/what-is-a-correlated-sub-query-how-can-these-queries-be-useful-1/ Mon, 08 Mar 2010 03:56:38 -0700 Devin Programming Interview Questions http://commoninterview.com/Programming_Interview_Questions/what-is-a-correlated-sub-query-how-can-these-queries-be-useful-1/
3 Vote(s) ]]> http://commoninterview.com/Programming_Interview_Questions/what-is-the-difference-between-an-output-parameter-and-a-return-parameter/ http://commoninterview.com/Programming_Interview_Questions/what-is-the-difference-between-an-output-parameter-and-a-return-parameter/ Mon, 08 Mar 2010 03:55:45 -0700 Devin Programming Interview Questions http://commoninterview.com/Programming_Interview_Questions/what-is-the-difference-between-an-output-parameter-and-a-return-parameter/ A return parameter is always returned by a stored procedure, and it is meant to indicate the success or failure of the stored procedure. The return parameter is always an INT data type.
An OUTPUT parameter is designated specifically by the developer, and it can return other types of data, such as characters and numeric values. (There are some limitations on the data types that can be used as output parameters.) You can use multiple OUTPUT parameters in a stored procedure, whereas you can only use one return parameter.


2 Vote(s) ]]> http://commoninterview.com/Programming_Interview_Questions/what-can-be-used-to-ensure-that-a-field-in-a-table-only-accepts-a-certain-range-of-values/ http://commoninterview.com/Programming_Interview_Questions/what-can-be-used-to-ensure-that-a-field-in-a-table-only-accepts-a-certain-range-of-values/ Mon, 08 Mar 2010 03:54:45 -0700 Devin Programming Interview Questions http://commoninterview.com/Programming_Interview_Questions/what-can-be-used-to-ensure-that-a-field-in-a-table-only-accepts-a-certain-range-of-values/ Triggers can also be used to restrict the values accepted in a field in a database table, but this solution requires the trigger to be defined on the table, which can hinder performance in certain situations. For this reason, Microsoft recommends Check constraints over all other methods for restricting domain integrity.


2 Vote(s) ]]> http://commoninterview.com/Programming_Interview_Questions/what-is-a-performance-consideration-of-having-too-many-indexes-on-a-production-online-transaction-processing-oltptable/ http://commoninterview.com/Programming_Interview_Questions/what-is-a-performance-consideration-of-having-too-many-indexes-on-a-production-online-transaction-processing-oltptable/ Mon, 08 Mar 2010 03:53:40 -0700 Devin Programming Interview Questions http://commoninterview.com/Programming_Interview_Questions/what-is-a-performance-consideration-of-having-too-many-indexes-on-a-production-online-transaction-processing-oltptable/
3 Vote(s) ]]> http://commoninterview.com/Programming_Interview_Questions/how-can-you-ensure-that-a-table-named-tableb-with-a-field-named-fld1-will-only-have-those-values-in-the-fld1-field-that-/ http://commoninterview.com/Programming_Interview_Questions/how-can-you-ensure-that-a-table-named-tableb-with-a-field-named-fld1-will-only-have-those-values-in-the-fld1-field-that-/ Mon, 08 Mar 2010 03:51:25 -0700 Devin Programming Interview Questions http://commoninterview.com/Programming_Interview_Questions/how-can-you-ensure-that-a-table-named-tableb-with-a-field-named-fld1-will-only-have-those-values-in-the-fld1-field-that-/
The other option is the use of triggers. Triggers can be used to ensure the same effect of constraints in a roundabout way, but it is much more difficult to set up and maintain, and the performance is typically worse. Because of this, Microsoft recommends that developers use foreign key constraints instead of triggers for maintaining referential integrity.


2 Vote(s) ]]> http://commoninterview.com/Programming_Interview_Questions/what-are-triggers-what-are-the-different-types-of-triggers-in-sql-server-2000/ http://commoninterview.com/Programming_Interview_Questions/what-are-triggers-what-are-the-different-types-of-triggers-in-sql-server-2000/ Mon, 08 Mar 2010 03:44:32 -0700 Devin Programming Interview Questions http://commoninterview.com/Programming_Interview_Questions/what-are-triggers-what-are-the-different-types-of-triggers-in-sql-server-2000/
A trigger is a specialized type of stored procedure that is bound to a table or view in SQL Server 2000. In SQL Server 2000, there are INSTEAD-OF triggers and AFTER triggers. INSTEAD-OF triggers are procedures that execute in place of a Data Manipulation Language (DML) statement on a table. For example, if I have an INSTEAD-OF-UPDATE trigger on TableA, and I execute an update statement on that table, the code in the INSTEAD-OF-UPDATE trigger will execute instead of the update statement that I executed.

An AFTER trigger executes after a DML statement has taken place in the database. These types of triggers are very handy for auditing data changes that have occurred in your database tables.


3 Vote(s) ]]> http://commoninterview.com/Programming_Interview_Questions/what-is-a-primary-key-what-is-a-foreign-key/ http://commoninterview.com/Programming_Interview_Questions/what-is-a-primary-key-what-is-a-foreign-key/ Mon, 08 Mar 2010 03:43:28 -0700 Devin Programming Interview Questions http://commoninterview.com/Programming_Interview_Questions/what-is-a-primary-key-what-is-a-foreign-key/
4 Vote(s) ]]> http://commoninterview.com/Programming_Interview_Questions/what-does-null-mean/ http://commoninterview.com/Programming_Interview_Questions/what-does-null-mean/ Mon, 08 Mar 2010 03:40:29 -0700 Devin Programming Interview Questions http://commoninterview.com/Programming_Interview_Questions/what-does-null-mean/ The value NULL means UNKNOWN; it does not mean '' (empty string). Assuming ANSI_NULLS are on in your SQL Server database, which they are by default, any comparison to the value NULL will yield the value NULL. You cannot compare any value with an UNKNOWN value and logically expect to get an answer. You must use the IS NULL operator instead.


4 Vote(s) ]]> http://commoninterview.com/Programming_Interview_Questions/what-is-an-index-what-types-of-indexes-are-available-in-sql-server-2000/ http://commoninterview.com/Programming_Interview_Questions/what-is-an-index-what-types-of-indexes-are-available-in-sql-server-2000/ Mon, 08 Mar 2010 03:39:49 -0700 Devin Programming Interview Questions http://commoninterview.com/Programming_Interview_Questions/what-is-an-index-what-types-of-indexes-are-available-in-sql-server-2000/
In its most simple terms, an index is a data structure used to provide quick access to data in a database table or view. In SQL Server, they come in two flavors: clustered and non-clustered. Clustered indexes store the data at the leaf level of the index. This means that whichever field(s) in your table are included in the clustered index, they will be stored in an orderly fashion in the table. Because of this sorting, you can only have one clustered index per table. Non-clustered indexes contain a row identifier at the leaf level of the index. This row identifier is a pointer to a location of the data on the disk. This allows you to have more than one non-clustered index per table.


3 Vote(s) ]]> http://commoninterview.com/Programming_Interview_Questions/can-you-give-me-an-overview-of-some-of-the-database-objects-available-for-use-in-sql-server-2000/ http://commoninterview.com/Programming_Interview_Questions/can-you-give-me-an-overview-of-some-of-the-database-objects-available-for-use-in-sql-server-2000/ Mon, 08 Mar 2010 03:38:59 -0700 Devin Programming Interview Questions http://commoninterview.com/Programming_Interview_Questions/can-you-give-me-an-overview-of-some-of-the-database-objects-available-for-use-in-sql-server-2000/
3 Vote(s) ]]> http://commoninterview.com/Programming_Interview_Questions/what-is-isolation-level-/ http://commoninterview.com/Programming_Interview_Questions/what-is-isolation-level-/ Mon, 08 Mar 2010 03:38:11 -0700 Devin Programming Interview Questions http://commoninterview.com/Programming_Interview_Questions/what-is-isolation-level-/ Read uncommitted (the lowest level where transactions are isolated only enough to ensure that physically corrupt data is not read).
Read committed (SQL Server default level).
Repeatable read.
Serializable (the highest level, where transactions are completely isolated from one another).


1 Vote(s) ]]> http://commoninterview.com/Programming_Interview_Questions/what-is-transaction--3/ http://commoninterview.com/Programming_Interview_Questions/what-is-transaction--3/ Mon, 08 Mar 2010 03:36:50 -0700 Devin Programming Interview Questions http://commoninterview.com/Programming_Interview_Questions/what-is-transaction--3/
1 Vote(s) ]]> http://commoninterview.com/Programming_Interview_Questions/what-are-the-constraints-/ http://commoninterview.com/Programming_Interview_Questions/what-are-the-constraints-/ Mon, 08 Mar 2010 03:35:53 -0700 Devin Programming Interview Questions http://commoninterview.com/Programming_Interview_Questions/what-are-the-constraints-/
1 Vote(s) ]]> http://commoninterview.com/Programming_Interview_Questions/what-is-dts-/ http://commoninterview.com/Programming_Interview_Questions/what-is-dts-/ Mon, 08 Mar 2010 03:34:52 -0700 Devin Programming Interview Questions http://commoninterview.com/Programming_Interview_Questions/what-is-dts-/
1 Vote(s) ]]> http://commoninterview.com/Programming_Interview_Questions/what-is-dtc-/ http://commoninterview.com/Programming_Interview_Questions/what-is-dtc-/ Mon, 08 Mar 2010 03:33:51 -0700 Devin Programming Interview Questions http://commoninterview.com/Programming_Interview_Questions/what-is-dtc-/
4 Vote(s) ]]> http://commoninterview.com/Programming_Interview_Questions/what-is-a-livelock-/ http://commoninterview.com/Programming_Interview_Questions/what-is-a-livelock-/ Mon, 08 Mar 2010 03:32:48 -0700 Devin Programming Interview Questions http://commoninterview.com/Programming_Interview_Questions/what-is-a-livelock-/
2 Vote(s) ]]> http://commoninterview.com/Programming_Interview_Questions/what-is-a-deadlock-/ http://commoninterview.com/Programming_Interview_Questions/what-is-a-deadlock-/ Mon, 08 Mar 2010 03:31:41 -0700 Devin Programming Interview Questions http://commoninterview.com/Programming_Interview_Questions/what-is-a-deadlock-/
4 Vote(s) ]]> http://commoninterview.com/Programming_Interview_Questions/whats-the-difference-between-delete-table-and-truncate-table-commands-/ http://commoninterview.com/Programming_Interview_Questions/whats-the-difference-between-delete-table-and-truncate-table-commands-/ Wed, 03 Mar 2010 20:23:02 -0700 Devin Programming Interview Questions http://commoninterview.com/Programming_Interview_Questions/whats-the-difference-between-delete-table-and-truncate-table-commands-/
2 Vote(s) ]]> http://commoninterview.com/Programming_Interview_Questions/how-to-find-6th-highest-salary-from-employee-table/ http://commoninterview.com/Programming_Interview_Questions/how-to-find-6th-highest-salary-from-employee-table/ Wed, 03 Mar 2010 20:21:20 -0700 Devin Programming Interview Questions http://commoninterview.com/Programming_Interview_Questions/how-to-find-6th-highest-salary-from-employee-table/ ORDER BY salary DESC) a ORDER BY salary


1 Vote(s) ]]> http://commoninterview.com/Programming_Interview_Questions/what’s-the-difference-between-a-primary-key-and-a-unique-key-/ http://commoninterview.com/Programming_Interview_Questions/what’s-the-difference-between-a-primary-key-and-a-unique-key-/ Wed, 03 Mar 2010 20:18:16 -0700 Devin Programming Interview Questions http://commoninterview.com/Programming_Interview_Questions/what’s-the-difference-between-a-primary-key-and-a-unique-key-/
2 Vote(s) ]]> http://commoninterview.com/Programming_Interview_Questions/write-an-sql-query-to-delete-duplicate-records-from-a-table-using-rowid/ http://commoninterview.com/Programming_Interview_Questions/write-an-sql-query-to-delete-duplicate-records-from-a-table-using-rowid/ Fri, 19 Feb 2010 05:28:19 -0700 Devin Programming Interview Questions http://commoninterview.com/Programming_Interview_Questions/write-an-sql-query-to-delete-duplicate-records-from-a-table-using-rowid/
2 Vote(s) ]]> http://commoninterview.com/general_questions/tell-me-about-yourself/ http://commoninterview.com/general_questions/tell-me-about-yourself/ Mon, 08 Feb 2010 04:49:12 -0700 Devin General Questions http://commoninterview.com/general_questions/tell-me-about-yourself/
2 Vote(s) ]]> http://commoninterview.com/general_questions/what-questions-do-you-have-about-the-job--1/ http://commoninterview.com/general_questions/what-questions-do-you-have-about-the-job--1/ Fri, 05 Feb 2010 16:58:02 -0700 Devin General Questions http://commoninterview.com/general_questions/what-questions-do-you-have-about-the-job--1/
The recruiter would be interested in knowing your thoughts about the job, its security, etc.

2 Vote(s) ]]> http://commoninterview.com/Testing_Interview_Questions/what-is-the-use-of-text-output-value-in-qtp--1/ http://commoninterview.com/Testing_Interview_Questions/what-is-the-use-of-text-output-value-in-qtp--1/ Fri, 08 Jan 2010 07:18:30 -0700 Devin Testing and QA Interview Questions http://commoninterview.com/Testing_Interview_Questions/what-is-the-use-of-text-output-value-in-qtp--1/
[Source: JAGAN MOHAN "Interview questions bible"]


1 Vote(s) ]]> http://commoninterview.com/Testing_Interview_Questions/explain-the-keyword-createobject-with-an-example--/ http://commoninterview.com/Testing_Interview_Questions/explain-the-keyword-createobject-with-an-example--/ Fri, 08 Jan 2010 07:16:54 -0700 Devin Testing and QA Interview Questions http://commoninterview.com/Testing_Interview_Questions/explain-the-keyword-createobject-with-an-example--/
[Source: JAGAN MOHAN "Interview questions bible"]


1 Vote(s) ]]> http://commoninterview.com/Testing_Interview_Questions/give-me-an-example-where-you-have-used-a-com-interface-in-your-qtp-project-/ http://commoninterview.com/Testing_Interview_Questions/give-me-an-example-where-you-have-used-a-com-interface-in-your-qtp-project-/ Fri, 08 Jan 2010 07:16:52 -0700 Devin Testing and QA Interview Questions http://commoninterview.com/Testing_Interview_Questions/give-me-an-example-where-you-have-used-a-com-interface-in-your-qtp-project-/
[Source: JAGAN MOHAN "Interview questions bible"]


1 Vote(s) ]]> http://commoninterview.com/Testing_Interview_Questions/few-basic-questions-on-commonly-used-excel-vba-functions--/ http://commoninterview.com/Testing_Interview_Questions/few-basic-questions-on-commonly-used-excel-vba-functions--/ Fri, 08 Jan 2010 07:14:29 -0700 Devin Testing and QA Interview Questions http://commoninterview.com/Testing_Interview_Questions/few-basic-questions-on-commonly-used-excel-vba-functions--/
[Source: JAGAN MOHAN "Interview questions bible"]


1 Vote(s) ]]> http://commoninterview.com/Testing_Interview_Questions/explain-what-the-difference-between-shared-repository-and-per-action-repository-/ http://commoninterview.com/Testing_Interview_Questions/explain-what-the-difference-between-shared-repository-and-per-action-repository-/ Fri, 08 Jan 2010 07:13:13 -0700 Devin Testing and QA Interview Questions http://commoninterview.com/Testing_Interview_Questions/explain-what-the-difference-between-shared-repository-and-per-action-repository-/
[Source: JAGAN MOHAN "Interview questions bible"]


1 Vote(s) ]]> http://commoninterview.com/Testing_Interview_Questions/discuss-qtp-environment--/ http://commoninterview.com/Testing_Interview_Questions/discuss-qtp-environment--/ Fri, 08 Jan 2010 07:13:11 -0700 Devin Testing and QA Interview Questions http://commoninterview.com/Testing_Interview_Questions/discuss-qtp-environment--/
[Source: JAGAN MOHAN "Interview questions bible"]


1 Vote(s) ]]> http://commoninterview.com/Testing_Interview_Questions/what-is-the-difference-between-call-to-action-and-copy-action-/ http://commoninterview.com/Testing_Interview_Questions/what-is-the-difference-between-call-to-action-and-copy-action-/ Fri, 08 Jan 2010 07:11:23 -0700 Devin Testing and QA Interview Questions http://commoninterview.com/Testing_Interview_Questions/what-is-the-difference-between-call-to-action-and-copy-action-/
[Source: JAGAN MOHAN "Interview questions bible"]


1 Vote(s) ]]> http://commoninterview.com/Testing_Interview_Questions/explain-the-concept-of-how-qtp-identifies-object--/ http://commoninterview.com/Testing_Interview_Questions/explain-the-concept-of-how-qtp-identifies-object--/ Fri, 08 Jan 2010 07:10:07 -0700 Devin Testing and QA Interview Questions http://commoninterview.com/Testing_Interview_Questions/explain-the-concept-of-how-qtp-identifies-object--/
[Source: JAGAN MOHAN "Interview questions bible"]


1 Vote(s) ]]> http://commoninterview.com/Testing_Interview_Questions/differentiate-the-two-object-repository-types-of-qtp--1/ http://commoninterview.com/Testing_Interview_Questions/differentiate-the-two-object-repository-types-of-qtp--1/ Fri, 08 Jan 2010 07:08:57 -0700 Devin Testing and QA Interview Questions http://commoninterview.com/Testing_Interview_Questions/differentiate-the-two-object-repository-types-of-qtp--1/
[Source: JAGAN MOHAN "Interview questions bible"]


1 Vote(s) ]]> http://commoninterview.com/Testing_Interview_Questions/what-projects-have-you-used-winrunner-on-tell-me-about-some-of-the-challenges-that-arose-and-how-you--1/ http://commoninterview.com/Testing_Interview_Questions/what-projects-have-you-used-winrunner-on-tell-me-about-some-of-the-challenges-that-arose-and-how-you--1/ Fri, 08 Jan 2010 07:08:23 -0700 Devin Testing and QA Interview Questions http://commoninterview.com/Testing_Interview_Questions/what-projects-have-you-used-winrunner-on-tell-me-about-some-of-the-challenges-that-arose-and-how-you--1/
[Source: JAGAN MOHAN "Interview questions bible"]


1 Vote(s) ]]> http://commoninterview.com/Testing_Interview_Questions/what-are-the-properties-you-would-use-for-identifying-a-browser-page-when-using-descriptive-programming-/ http://commoninterview.com/Testing_Interview_Questions/what-are-the-properties-you-would-use-for-identifying-a-browser-page-when-using-descriptive-programming-/ Fri, 08 Jan 2010 07:06:33 -0700 Devin Testing and QA Interview Questions http://commoninterview.com/Testing_Interview_Questions/what-are-the-properties-you-would-use-for-identifying-a-browser-page-when-using-descriptive-programming-/
[Source: JAGAN MOHAN "Interview questions bible"]


1 Vote(s) ]]> http://commoninterview.com/Testing_Interview_Questions/what-is-a-run-time-data-table-where-can-i-find-and-view-this-table--1/ http://commoninterview.com/Testing_Interview_Questions/what-is-a-run-time-data-table-where-can-i-find-and-view-this-table--1/ Fri, 08 Jan 2010 07:05:18 -0700 Devin Testing and QA Interview Questions http://commoninterview.com/Testing_Interview_Questions/what-is-a-run-time-data-table-where-can-i-find-and-view-this-table--1/
[Source: JAGAN MOHAN "Interview questions bible"]


1 Vote(s) ]]> http://commoninterview.com/Testing_Interview_Questions/what-is-the-difference-between-check-point-and-output-value--/ http://commoninterview.com/Testing_Interview_Questions/what-is-the-difference-between-check-point-and-output-value--/ Fri, 08 Jan 2010 07:05:12 -0700 Devin Testing and QA Interview Questions http://commoninterview.com/Testing_Interview_Questions/what-is-the-difference-between-check-point-and-output-value--/
[Source: JAGAN MOHAN "Interview questions bible"]


1 Vote(s) ]]> http://commoninterview.com/Testing_Interview_Questions/how-the-exception-handling-can-be-done-using-qtp-/ http://commoninterview.com/Testing_Interview_Questions/how-the-exception-handling-can-be-done-using-qtp-/ Fri, 08 Jan 2010 07:03:37 -0700 Devin Testing and QA Interview Questions http://commoninterview.com/Testing_Interview_Questions/how-the-exception-handling-can-be-done-using-qtp-/
[Source: JAGAN MOHAN "Interview questions bible"]


1 Vote(s) ]]> http://commoninterview.com/Testing_Interview_Questions/what-are-the-different-scripting-languages-you-could-use-when-working-with-qtp--/ http://commoninterview.com/Testing_Interview_Questions/what-are-the-different-scripting-languages-you-could-use-when-working-with-qtp--/ Fri, 08 Jan 2010 07:00:55 -0700 Devin Testing and QA Interview Questions http://commoninterview.com/Testing_Interview_Questions/what-are-the-different-scripting-languages-you-could-use-when-working-with-qtp--/
[Source: JAGAN MOHAN "Interview questions bible"]


1 Vote(s) ]]> http://commoninterview.com/Testing_Interview_Questions/how-do-you-test-siebel-application-using-qtp--1/ http://commoninterview.com/Testing_Interview_Questions/how-do-you-test-siebel-application-using-qtp--1/ Fri, 08 Jan 2010 07:00:06 -0700 Devin Testing and QA Interview Questions http://commoninterview.com/Testing_Interview_Questions/how-do-you-test-siebel-application-using-qtp--1/
[Source: JAGAN MOHAN "Interview questions bible"]


1 Vote(s) ]]> http://commoninterview.com/Testing_Interview_Questions/how-to-handle-the-exceptions-using-recovery-secnario-manager-in-qtp-/ http://commoninterview.com/Testing_Interview_Questions/how-to-handle-the-exceptions-using-recovery-secnario-manager-in-qtp-/ Fri, 08 Jan 2010 06:59:19 -0700 Devin Testing and QA Interview Questions http://commoninterview.com/Testing_Interview_Questions/how-to-handle-the-exceptions-using-recovery-secnario-manager-in-qtp-/
[Source: JAGAN MOHAN "Interview questions bible"]


1 Vote(s) ]]>