Tag: testing

Questions Related to testing

The INNER JOIN clause…
technology testing

  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.

Show answer
Correct Option: D

What best describes the relationship between indexes and SQL performance?
technology testing

  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

Show answer
Correct Option: D

What is an index?
technology testing

  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.

Show answer
Correct Option: C

Sub-queries can be nested in…
technology testing

  1. UPDATE, DELETE, INSERT and SELECT statements.

  2. UPDATE statements only.

  3. DELETE statements only.

  4. INSERT statements only.

Show answer
Correct Option: A

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

technology testing

  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

Show answer
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?
technology testing

  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

Show answer
Correct Option: C

Testing of the system to demonstrate system compliance with user requirements is

technology testing

  1. Black box testing

  2. System testing

  3. Independent testing

  4. Acceptance Testing

Show answer
Correct Option: D

AI Explanation

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

Option A) Black box testing - This option is incorrect. Black box testing is a method of testing where the tester does not have knowledge of the internal workings of the system. It focuses on testing the functionality and behavior of the system from a user's perspective. It does not specifically address the demonstration of system compliance with user requirements.

Option B) System testing - This option is incorrect. System testing is a type of testing that verifies the behavior and functionality of the entire system as a whole. It is performed to ensure that all the components of the system work together as expected. While system testing may include testing for compliance with user requirements, it is not specifically focused on demonstrating system compliance.

Option C) Independent testing - This option is incorrect. Independent testing refers to testing conducted by a third party or external entity that is not directly involved in the development of the system. It aims to provide an unbiased assessment of the system's quality. However, it does not specifically address the demonstration of system compliance with user requirements.

Option D) Acceptance testing - This option is correct. Acceptance testing is a type of testing that is conducted to determine whether a system meets the specified acceptance criteria and is ready for deployment. It involves testing the system against user requirements to demonstrate compliance. Acceptance testing is typically performed by the end-users or stakeholders to ensure that the system meets their needs and expectations.

The correct answer is D) Acceptance testing. This option is correct because acceptance testing specifically focuses on demonstrating system compliance with user requirements.

A complete validation of a program can be obtained only by testing for every element of the domain
technology testing

  1. True

  2. False

Show answer
Correct Option: A

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

  1. Reviews

  2. Testing

  3. Both

  4. None of the above

Show answer
Correct Option: B

To divide & conquer while testing requires

technology testing

  1. Stubs

  2. Manual simulation

  3. Coverage metrics

  4. All of the above

Show answer
Correct Option: B