The INNER JOIN clause…
returns all the matching rows from 2 tables.
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.
returns all rows from 2 tables.
returns all rows that have matching value in the field on which the 2 tables are joined.
What best describes the relationship between indexes and SQL performance?
Indexes are only used in special cases
Indexes are used to make table storage more efficient
Indexes rarely make a difference in SQL performance
Indexes exist solely to improve query speed
What is an index?
An index is the same as alias.
An index is a special way to join 2 or more tables.
An index is a database table attribute, which speeds-up data search within a table.
An index is a database row attribute, which speeds-up data search within a table.
Sub-queries can be nested in…
UPDATE, DELETE, INSERT and SELECT statements.
UPDATE statements only.
DELETE statements only.
INSERT statements only.
Which of the following database design features is most important to SQL performance?
Removal of data redundancy
The introduction of data redundancy
The introduction of non-first normal form relations
The introduction of SQL*Plus
Which of the following is an important consideration when tuning an SQL statement?
The number of CPUs on the server
The degree of parallelism on the tables
The quality of the SQL optimization
The use of bitmap indexes
Testing of the system to demonstrate system compliance with user requirements is
Black box testing
System testing
Independent testing
Acceptance Testing
A complete validation of a program can be obtained only by testing for every element of the domain
True
False
For locating errors which span modules it is more effective to do?
Reviews
Testing
Both
None of the above
To divide & conquer while testing requires
Stubs
Manual simulation
Coverage metrics
All of the above