Test Results for Tonci Korsano |
| ID Number :
|
885-88-5555 |
| Company Name :
|
The Laxmi Group |
| Customer ID# :
|
9z3rm |
| Test Administrator's Name
: |
Alan Armijo |
| Test Administrator's Email
: |
aarmijo@laxmigroup.com; aboyd@laxmigroup.com;
bpillai_2000@yahoo.com |
| Test Name :
|
SQL Server 6.5 |
| Test Date :
|
4/7/00 |
| Test Start Time :
|
10:52:43 PM |
| Test Finish Time :
|
11:18:13 PM |
| Elapsed Time :
|
00:21:52 |
| Questions Attempted
: |
40 out of 40 |
| Questions Correct :
|
28 out of 40 |
| Percent Correct :
|
70% |
| Global Average :
|
59.3% | The
elapsed time is the sum of the time to complete each question.
Internet
connections and download speeds may result in a discrepancy in Start Time,
End Time and Elapsed Time.
Please use elapsed time to judge efficiency
in completing questions.
Detail Score
Report |
| Q# |
Status |
Topic |
Type |
Level |
Time |
| 1 |
Correct |
Stored Procedures |
T-SQL Programming |
Intermediate |
00:00:43 |
| 2 |
Correct |
Troubleshooting |
System Administration |
Advanced |
00:00:54 |
| 3 |
Correct |
Troubleshooting |
System Administration |
Advanced |
00:00:38 |
| 4 |
Correct |
Temporary Objects |
T-SQL Programming |
Basic |
00:00:08 |
| 5 |
Correct |
Query Optimization |
Performance & Tuning |
Basic |
00:00:21 |
| 6 |
Correct |
Views |
T-SQL Programming |
Intermediate |
00:00:51 |
| 7 |
Correct |
Tables |
T-SQL Programming |
Basic |
00:00:22 |
| 8 |
Incorrect |
Data Access Options |
Open Client Programming |
Advanced |
00:01:43 |
| 9 |
Correct |
Table Structure |
T-SQL Programming |
Basic |
00:00:25 |
| 10 |
Correct |
Select - Group |
T-SQL Programming |
Basic |
00:01:15 |
| 11 |
Correct |
SQL Mail |
System Administration |
Advanced |
00:00:27 |
| 12 |
Correct |
Defaults |
T-SQL Programming |
Basic |
00:00:24 |
| 13 |
Incorrect |
Select - Order - Compute |
T-SQL Programming |
Basic |
00:00:47 |
| 14 |
Correct |
Select Statement |
T-SQL Programming |
Basic |
00:00:18 |
| 15 |
Correct |
Triggers |
T-SQL Programming |
Basic |
00:00:20 |
| 16 |
Correct |
Constraints |
T-SQL Programming |
Basic |
00:00:13 |
| 17 |
Incorrect |
Select Statement |
T-SQL Programming |
Basic |
00:00:55 |
| 18 |
Correct |
Stored Procedures |
T-SQL Programming |
Basic |
00:00:06 |
| 19 |
Correct |
Datatypes |
System Administration |
Basic |
00:00:27 |
| 20 |
Correct |
Triggers |
T-SQL Programming |
Intermediate |
00:00:08 |
| 21 |
Correct |
Ext-Stored Procedures |
T-SQL Programming |
Basic |
00:00:12 |
| 22 |
Incorrect |
Data Recovery |
System Administration |
Basic |
00:01:26 |
| 23 |
Correct |
System variables |
T-SQL Programming |
Basic |
00:00:15 |
| 24 |
Correct |
Triggers |
T-SQL Programming |
Basic |
00:00:14 |
| 25 |
Incorrect |
Permissions |
System Administration |
Basic |
00:01:03 |
| 26 |
Correct |
Error Messages |
T-SQL Programming |
Intermediate |
00:00:06 |
| 27 |
Correct |
Device Management |
System Administration |
Basic |
00:00:08 |
| 28 |
Incorrect |
Database Management |
System Administration |
Basic |
00:00:18 |
| 29 |
Correct |
Incorporating Delays |
T-SQL Programming |
Intermediate |
00:00:12 |
| 30 |
Correct |
Data Transfer |
System Administration |
Intermediate |
00:00:23 |
| 31 |
Incorrect |
Database Consistency |
System Administration |
Intermediate |
00:00:14 |
| 32 |
Correct |
Transaction Management |
System Administration |
Basic |
00:00:11 |
| 33 |
Correct |
SQL Executive |
System Administration |
Advanced |
00:01:06 |
| 34 |
Correct |
Data Transfer |
System Administration |
Intermediate |
00:00:47 |
| 35 |
Incorrect |
Permissions |
System Administration |
Advanced |
00:01:46 |
| 36 |
Incorrect |
Cursors |
T-SQL Programming |
Basic |
00:00:38 |
| 37 |
Incorrect |
Security |
System Administration |
Intermediate |
00:00:16 |
| 38 |
Incorrect |
SQL Executive |
System Administration |
Intermediate |
00:00:28 |
| 39 |
Correct |
Code Optimizing |
Performance & Tuning |
Basic |
00:00:13 |
| 40 |
Incorrect |
Index Optimizing |
Performance & Tuning |
Intermediate |
00:00:31 |
Question Level
Statistics |
|
Number of Questions |
Number Correct |
Total Percentage |
| Basic |
23 |
17 |
74% |
| Intermediate |
11 |
7 |
64% |
| Advanced |
6 |
4 |
67% |
| Total |
40 |
28 |
70% | |
Question Type
Statistics |
|
Number of Questions |
Number Correct |
Total Percentage |
| Open Client Programming |
1 |
0 |
0% |
| Performance & Tuning |
3 |
2 |
67% |
| System Administration |
16 |
9 |
56% |
| T-SQL Programming |
20 |
17 |
85% |
| Total |
40 |
28 |
70% | |
Test
Description |
|
SQL (Structured Query Language) was developed in 1977 and is the
standard set language. SQL is an integral part of many client/server
applications including Oracle, Sybase and Informix. SQL is a very
popular language used to connect database applications with other
applications and is extensively used in Client/Server
implementations. This 40 question test specifically tests the SQL
dialect used in Microsoft's product called SQL Server and would be
appropriate to be given to programmers.
A score of 60% or better demonstrates knowledge of SQL Server
6.5
A score of 80% or better demonstrates superior knowledge of SQL
Server
6.5 | |
