0

testing Online Quiz - 87

Description: testing Online Quiz - 87
Number of Questions: 20
Created by:
Tags: testing
Attempted 0/20 Correct 0 Score 0

which of the following is incorrect?

  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


Correct Option: B

Testing is context independent.

  1. True

  2. False


Correct Option: B

AI Explanation

To answer this question, you need to understand the concept of testing in the context of software development.

Option A) True - This option is incorrect. Testing is not context independent. The effectiveness and appropriateness of testing methods and techniques can vary depending on the context, such as the type of software being tested, the development process, and the specific requirements and constraints.

Option B) False - This option is correct. Testing is not context independent. The context in which software testing is performed can greatly influence the selection of testing approaches, techniques, and tools. Different contexts may require different testing strategies and methods to ensure the quality and reliability of the software.

The correct answer is B) False. This option is correct because testing is not context independent and the effectiveness of testing can vary depending on the specific context.

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

  1. True

  2. False


Correct Option: A

Which of the following does not come under testing objectives?

  1. Finding defects

  2. Fixing defects

  3. Gaining confidence about the level of quality

  4. Preventing defects


Correct Option: B

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

  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


Correct Option: C

What does ACID stand for?

  1. Access. Constant. Information. Data.

  2. Atomicity. Consistency. Isolation. Durability.

  3. Access. Constraint. Index. Data.

  4. Access. Consistency. Isolation. Data.


Correct Option: B

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

  1. There is no default value.

  2. DESC

  3. Random

  4. ASC


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?

  1. TRUNCATE Sales TABLE

  2. TRUNCATE * FROM TABLE Sales

  3. TRUNCATE TABLE Sales

  4. TRUNCATE * FROM COLUMN Sales


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?

  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'


Correct Option: A

The INNER JOIN clause…

  1. returns all the matching rows from 2 tables.

  2. returns only the rows from the first table, which have non-matching values with the second table in the field on which the 2 tables are joined.

  3. returns all rows from 2 tables.

  4. returns all rows that have matching value in the field on which the 2 tables are joined.


Correct Option: D

AI Explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) Returns all the matching rows from 2 tables - This option is incorrect. The INNER JOIN clause returns only the rows that have matching values in the field on which the two tables are joined, not all matching rows from both tables.

Option B) Returns only the rows from the first table, which have non-matching values with the second table in the field on which the 2 tables are joined - This option is incorrect. The INNER JOIN clause returns only the rows with matching values, not non-matching values.

Option C) Returns all rows from 2 tables - This option is incorrect. The INNER JOIN clause only returns the rows that have matching values, not all rows from both tables.

Option D) Returns all rows that have matching value in the field on which the 2 tables are joined - This option is correct. The INNER JOIN clause returns all rows that have matching values in the field on which the two tables are joined.

The correct answer is D. This option is correct because the INNER JOIN clause is used to return all rows that have matching values in the field on which the two tables are joined.

What best describes the relationship between indexes and SQL performance?

  1. Indexes are only used in special cases

  2. Indexes are used to make table storage more efficient

  3. Indexes rarely make a difference in SQL performance

  4. Indexes exist solely to improve query speed


Correct Option: D

What is an index?

  1. An index is the same as alias.

  2. An index is a special way to join 2 or more tables.

  3. An index is a database table attribute, which speeds-up data search within a table.

  4. An index is a database row attribute, which speeds-up data search within a table.


Correct Option: C

Sub-queries can be nested in…

  1. UPDATE, DELETE, INSERT and SELECT statements.

  2. UPDATE statements only.

  3. DELETE statements only.

  4. INSERT statements only.


Correct Option: A

Which of the following database design features is most important to SQL performance?

  1. Removal of data redundancy

  2. The introduction of data redundancy

  3. The introduction of non-first normal form relations

  4. The introduction of SQL*Plus


Correct Option: B

AI Explanation

To answer this question, you need to understand the concept of database design and its impact on SQL performance. Let's go through each option to understand why it is correct or incorrect:

Option A) Removal of data redundancy - This option is incorrect because removing data redundancy is generally considered a good practice in database design, but it does not necessarily have a direct impact on SQL performance.

Option B) The introduction of data redundancy - This option is correct because introducing data redundancy can improve SQL performance in certain situations. Redundancy allows for denormalization, which can speed up query execution by reducing the number of joins required.

Option C) The introduction of non-first normal form relations - This option is incorrect because introducing non-first normal form relations can lead to data duplication and redundancy. While it may have some benefits in terms of query simplicity, it generally does not improve SQL performance.

Option D) The introduction of SQL*Plus - This option is incorrect because SQL*Plus is a command-line interface for Oracle databases and is not directly related to database design features. It does not have a significant impact on SQL performance.

The correct answer is B) The introduction of data redundancy. This option is correct because introducing data redundancy can improve SQL performance by allowing for denormalization and reducing the need for joins.

Which of the following is an important consideration when tuning an SQL statement?

  1. The number of CPUs on the server

  2. The degree of parallelism on the tables

  3. The quality of the SQL optimization

  4. The use of bitmap indexes


Correct Option: C

AI Explanation

To answer this question, you need to understand the concept of tuning an SQL statement. Tuning an SQL statement involves optimizing its performance by making changes to the statement or the database structure.

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

Option A) The number of CPUs on the server - This option is incorrect because the number of CPUs on the server does not directly impact the tuning of an SQL statement. The performance of an SQL statement can be affected by the server's hardware, but it is not a consideration for tuning the statement itself.

Option B) The degree of parallelism on the tables - This option is incorrect. The degree of parallelism refers to the number of parallel processes that can be used to execute a query. While parallelism can improve performance, it is not a specific consideration for tuning an individual SQL statement.

Option C) The quality of the SQL optimization - This option is correct. The quality of the SQL optimization is an important consideration when tuning an SQL statement. SQL optimization involves analyzing the structure of the SQL statement, the database schema, and the available indexes to determine the most efficient execution plan. By optimizing the SQL, the performance of the statement can be improved.

Option D) The use of bitmap indexes - This option is incorrect. The use of bitmap indexes can improve query performance in specific scenarios, but it is not a general consideration for tuning an SQL statement.

The correct answer is C) The quality of the SQL optimization. This option is correct because optimizing the SQL statement is a crucial step in tuning its performance.

  1. Black box testing

  2. System testing

  3. Independent testing

  4. Acceptance Testing


Correct Option: D

For locating errors which span modules it is more effective to do?

  1. Reviews

  2. Testing

  3. Both

  4. None of the above


Correct Option: B

To divide & conquer while testing requires

  1. Stubs

  2. Manual simulation

  3. Coverage metrics

  4. All of the above


Correct Option: B

It is advisable to have a separate department for reviews & testing

  1. True

  2. False


Correct Option: A
- Hide questions