Tag: testing

Questions Related to testing

Which technique is widely used in embedded software industry?
technology testing

  1. Use case testing

  2. Boundary value analysis

  3. State transition testing

  4. Decision table testing

Show answer
Correct Option: C

which of the following is incorrect?
technology testing

  1. Poor software characteristics comes under product risk

  2. Failure to follow up on information found in testing and reviews comes under product risk

  3. Problems in defining the right requirements comes under project risk

  4. The quality of the design, code and tests comes under project risk

Show answer
Correct Option: B

Testing is context independent.
technology testing

  1. True

  2. False

Show answer
Correct Option: B

Finalizing and archiving testware, the test environment and the test infrastructure for later reuse is one of the test closure activities.

technology testing

  1. True

  2. False

Show answer
Correct Option: A

Which of the following does not come under testing objectives?

technology testing

  1. Finding defects

  2. Fixing defects

  3. Gaining confidence about the level of quality

  4. Preventing defects

Show answer
Correct Option: B

We refer to a join as a self-join when…

technology testing

  1. We are joining two tables only

  2. we are using left and right join together

  3. we are joining table to itself

  4. we are joining more than 2 tables

Show answer
Correct Option: C

What does ACID stand for?
technology testing

  1. Access. Constant. Information. Data.

  2. Atomicity. Consistency. Isolation. Durability.

  3. Access. Constraint. Index. Data.

  4. Access. Consistency. Isolation. Data.

Show answer
Correct Option: B

If you don't specify ASC or DESC after a SQL ORDER BY clause, the following is used by default:

technology testing

  1. There is no default value.

  2. DESC

  3. Random

  4. ASC

Show answer
Correct Option: D

AI Explanation

To answer this question, you need to understand the behavior of the SQL ORDER BY clause.

The ORDER BY clause is used to sort the result set of a SQL query. By default, if you don't specify ASC (ascending) or DESC (descending) after the ORDER BY clause, the following is used by default:

Option A) There is no default value - This option is incorrect. By default, when you don't specify ASC or DESC, there is a default sort order.

Option B) DESC - This option is incorrect. DESC is not the default sort order.

Option C) Random - This option is incorrect. There is no random default sort order.

Option D) ASC - This option is correct. When you don't specify ASC or DESC, the default sort order is ascending (ASC).

Therefore, the correct answer is option D.

Which of the following SQL statements is correct?
technology testing

  1. TRUNCATE Sales TABLE

  2. TRUNCATE * FROM TABLE Sales

  3. TRUNCATE TABLE Sales

  4. TRUNCATE * FROM COLUMN Sales

Show answer
Correct Option: C

Which SQL statement selects all rows from table called Contest, with column ContestDate having values greater or equal to May 25, 2006?
technology testing

  1. SELECT * FROM Contest WHERE ContestDate >= '05/25/2006'

  2. SELECT * FROM Contest GROUPBY ContestDate >= '05/25/2006'

  3. SELECT * FROM Contest WHERE ContestDate < '05/25/2006'

  4. SELECT * FROM Contest HAVING ContestDate >= '05/25/2006'

Show answer
Correct Option: A