1
SP_01...3 SP_03 JAVA...6 SP_10 SQL...8 SP_51...12 SP_32...15 SP_53...18 SP_20...21 SP_22...24 SP_21...27 SP_23...30 SP_04.NET...33 SP_02 C...37 SP_05 FLASH...39 SP_06...42 2
SP_01 1. 8. Excel 2. 9. PowerPoint 3. Word 10. PowerPoint 4. Word 5. Word 11. 6. Excel 12. 7. Excel 13. 1. Windows XP 2. 3. 4. Word Excel PowerPoint 5. 6. 3
40 60 100 4
11 5
SP_03 JAVA JAVA JAVA // 1. Java 6. Java 2. Java 7. Java 3. Java 8. Java 4. Java 9. 5. java 10.Java Java JAVA 30 70 100 6
7
SP_10 SQL, / / 1. 11. 2. 12. 3. SQL 13. 4. SQL 14. 5. SQL 15. 6. 16. 7. 17. 8. 18. 9. 19.SQL 10. 20. SQL SQL 8
SQL Server2000 40 60 100 A. B. C. D. R R BCNF Exam Exam 6 orders distributors suppliers city items products 1 orders OrderNum Int 9
OrderDate Datetime DistriNum Int PaidDate Datetime 2 distributors Distrinum Int BossName Char Company Char CityCode Char Address Char Phone Char 3 6 suppliers city items products 1. SQL 6 T2-1.sql 2. Exam XW TZ DC T2-2.sql 4. T-SQL newview orders OrderNum DistriNum T2-9.sql 5. T2-10.sql 10
6. T-SQL Exam storedproc orders OrderNum OrderDate T2-11.sql 11
SP_51 Photoshop / / / 1. Photoshop 11. 2. Photoshop 12. 3. 13. 4. 14.Web 5. ( ) 15. 6. ( ) 16. 7. 17. 8. 18. 9. 19. 10. 20. Photoshop 12
1. Photoshop CS3 2. 3. 4. 5. 6. 7. 25 75 100 13
14
SP_32 1. 5. 2. 6. 3. 7. 4. 1. 2. 3. 4. 5. 6. WEB 15
7. 8. 50 50 100 A. B. C. D. 1 3 [ ] ERP 16
M P S M R P [ 1] [ 2] a. e. b. f. c. g. MPS d. h. 17
i. k. j. l. MRP SP_53 AutoCAD 2008 AutoCAD 2008 / / 1. AutoCAD 8. 2. AutoCAD 9. 3. 10. 4. 11.AutoCAD 5. 12.AutoCAD Internet 6. 13. 7. 14. AutoCAD 18
1. 2. 3. AutoCAD 2008 4. AutoCAD 2008 5. AutoCAD 2008 6. 7. 8. 9. 10. AutoCAD Internet 11. 25 75 100 0.5mm0.25mm Standard A1 19
20
SP_20 / / 1. SNMP 13.WEB 2. 14. 3. IP 15.VLAN 4. 16.tcpdump 5. 17.PGP 6. 18.SSL 7. 19.Norton Antivirus 8. 20. Snort 9. 21.OpenVPN 10. 22. RRDTOOL CACTI 11.Linux 12.DNS 23. 21
1. 7. 2. 8. 3. 9. 4. 10.Windows Server 2003 5. 11.Linux 6. 50 50 100 22
Eth0 Eth0 A B 23
SP_22 / / 1. 7. 2. 8. 3. 9. 4. IP 10. 5. 11. 6. 1. 7. 2. 8. 3. 9. 4. 10.Windows Server 2003 5. 11.Linux 6. 24
1. 2. OSI TCP/IP IEEE 802 3. TCP/IP 4. IP IP 5. 6. 7. 8. RIP OSPF 9. Windows Server 2003 AD 10. Windows 11. WSUS 25
50 50 100 26
SP_21 / / / 1. 2. 27
3. Internet/Intranet 9. 4. Internet 10. 5. Internet 11. 6. 12. Internet 7. E-mail 13. 8. FTP 14. TCP/IP 1. 7. 2. 8. 3. 9. 4. 10.Windows Server 2003 5. 11.Linux 6. 28
50 50 100 29
SP_23 / / / / / / / / 1. 11. 2. 12. 3. 13. 4. 14. 5. 15. 6. 16. 7. 17. Windows 8. 18. UNIX/Linux 9. VPN 19. 10. 20. 1. 3. 2. 4. 30
5. 9. 6. 10. Windows Server 2003 7. 11. Linux 8. 50 50 100 31
32
SP_04.NET ASP.NET / 8. 33
.Net 1. ASP.NET 2. ASP.NET Web 3. C# ASP.NET 4. ASP.NET 2.0 5. ASP.NET2.0 ASP.NET 2.0 6. 7. 8. 9. 20 80 100 34
1 1 35
2 1 Vote create database Vote go USE [Vote] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[voteitem]( [ItemID] [int] IDENTITY(1,1) NOT NULL, COLLATE Chinese_PRC_CI_AS NOT NULL, [ItemName] [nvarchar](30) [ItemCount] [int] NULL CONSTRAINT [DF_VoteItem_ItemCount] DEFAULT ((0)) ) ON [PRIMARY] 36
SP_02 C C 1. C 6. 2. 7. 3. 8. 4. 9. 5. 10. 20 80 100 string.h A. #define B. #include C. #if D. #iend 37
I am a student., a I m student. #include<stdio.h>void main( ){ char str1[81],str2[81],ch; inti,j=0; printf("input a string:"); 1 ; printf("\n delete?"); ch=getchar(); for(i=0; 2 ;i++) if(str1[i]!=ch) str2[ 3 ]=str1[i]; else 4 ; str2[i-j]= 5 ;puts(str2);} 38
SP_05 FLASH / 1. 7. 2. 8. 3. 9. 4. 10. 5. 11. 6. 12. Flash 1. 2. 3. Flash 39
4. 5. 6. 7. 8. Flash 25 75 100 40
41
SP_06 / / 1. 8. 2. 9. 3. 10. 4. 11. 5. 12. 6. 13. 7. 14. 1. 2. 42
3. 4. 5. 6. 7. 50 50 100 43
44