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

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

AI Explanation

To answer this question, you need to understand the SQL TRUNCATE statement.

The TRUNCATE statement in SQL is used to remove all the rows from a table, allowing you to delete all the data in the table while keeping the table structure intact.

Now let's go through each option to understand why it is correct or incorrect:

Option A) TRUNCATE Sales TABLE - This option is incorrect because the correct syntax for the TRUNCATE statement does not require the keyword "TABLE" after the table name. The correct syntax is simply "TRUNCATE Sales".

Option B) TRUNCATE * FROM TABLE Sales - This option is incorrect because the * symbol is not used with the TRUNCATE statement. The correct syntax is "TRUNCATE TABLE Sales" to specify the table name directly.

Option C) TRUNCATE TABLE Sales - This option is correct because it follows the correct syntax of the TRUNCATE statement. It specifies the table name "Sales" after the keyword "TABLE".

Option D) TRUNCATE * FROM COLUMN Sales - This option is incorrect because the TRUNCATE statement does not operate on individual columns. It is used to remove all rows from a table, not specific columns.

The correct answer is Option C) TRUNCATE TABLE Sales. This option is correct because it follows the correct syntax for the TRUNCATE statement, specifying the table name after the keyword "TABLE".

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