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
  1. Finding defects

  2. Fixing defects

  3. Gaining confidence about the level of quality

  4. Preventing defects


Correct Option: B
  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
  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
  1. TRUNCATE Sales TABLE

  2. TRUNCATE * FROM TABLE Sales

  3. TRUNCATE TABLE Sales

  4. TRUNCATE * FROM COLUMN Sales


Correct Option: C
  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
  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

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
  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
  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

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
  1. Black box testing

  2. System testing

  3. Independent testing

  4. Acceptance Testing


Correct Option: D
  1. Stubs

  2. Manual simulation

  3. Coverage metrics

  4. All of the above


Correct Option: B
- Hide questions