数据库工程师 (72)

26 A B C D 1 A DBMS A A B C D 2 A B C D 3 A B C D 4 T1 T2 A B C D 5 SC Sno Cno Grade 90 A SELECT Sno AVG Grade FROM SC WHERE AVG Grade 90 GROUP BY Sno B SELECT Sno AVG Grade FROM SC GROUP BY Sno HAVING AVG Grade 90 C SELECT Sno AVG Grade FROM SC WHERE AVG Grade 90 ORDER BY Sno D SELECT Sno AVG Grade FROM SC GROUP BY Cno HAVING AVG Grade 90 6 W C P S G T R C P S G T R F C G S C G T R C T P R T S W A 1NF B 2NF C 3NF D 4NF 7 A B C D 8 A B C D 9 A B C D 10 A B C D 11 A IN NOT IN B BETWEEN AND NOT BETWEEN AND C AND OR D LIKE NOT LIKE 12 A B C D 13 A B C D 14 A B C D 15 T0 T1 Tn T0 T1 A T1 T2 A2 Tn 1 Tn An Tn T0 A0 A B C D 16 UML A B C D 17 A B OLAP OLAP C D 18 A B C D 19 A B C D 20 A db owner B db denydatawriter C db datawriter D sysadmin 21 A B C D 22 DBAS A A B B C C D D 23 A B C D 24 SQL A SQL B C SQL D SQL 25 A CREATE VIEW SalaryView AS SELECT COUNT FROM GROUP BY B CREATE VIEW SalaryView AS SELECT SUM FROM GROUP BY C CREATE VIEW SalaryView AS SELECT COUNT FROM GROUP BY D CREATE VIEW SalaryView AS SELECT SUM T FROM GROUP BY 26 A B C D 27 A B DBMS C D 28 A B C D 29 Visual Basic 6 0 A Basic B Visual Basic C OLE D 30 A B C D SC S C Grade SELECT 1 FROM SC 2 VB6 0 3 ADO 4 Table Goods GoodsName GoodsClassID Sa leUnitPrice Table GoodsClass GoodsClassID GoodsClassNam e City SELECT GoodsName SaleUnltPrice FROM 5 ON a GoodsClassID b GoodsClassID WHERE SaleUnitPrice SELECT 6 FROM Table Goods c JOIN Table GoodClass d ON 7 WHERE GoodsClassName AND 8 4 C DBMS C Tabk Card CardID CardName Score 500 1000 H Y Card 10 AS SELECT FROM Table Card WHERE 11 12 6 A B A B T1 T2 T3 1000 T4 1000 T5 100 9 00 T6 T7 900 T4 7 SQL Server 2000 4 8 1 E R E R 2 S Sno Sname Status City P Pno Pname Weight Color J Jno Jname City SPJ Sno Pno Jno QTY SQL QTY 300 500 S1 1 A A DBMS A 2 C 3 D 4 D T1 A T2 T1 T1 100 T2 200 5 B WHERE 6 A T P R R W 2NF 7 D 8 C 9 C C 10 D 11 C A B D C 12 D 13 A 14 A 15 D T0 T1 Tn T0 T1 A T1 T2 A2 Tn 1 Tn An Tn T0 A0 16 D 17 B OLAP OLAP 18 D 19 A 20 B db denydatawriter 21 D 22 C DBAS DBAS DBAS C C2 B 23 C 24 D SQL 25 B SUM COUNT B 26 A 27 B DBMS 28 C C 29 D VB 30 B 1 C COUNT S 2 GROUP BY C 3 Rowsouree 4 Datasource VB6 0 Rowsource ADO Datasource 5 Table GoodsClass a JOIN GoodsClass b 6 AVG SaleUnitPrice 7 c GoodsClassID d GoodsClassID 8 GoodsClassName 9 10 CREATE VIEW HY Card 11 Score BETWEEN 500 AND 1000 12 WITH CHECK OPTION BETWEEN AND CREATE VIEW AS WITH CHECK OPTION 13 14 15 RAID RAID 1 E R 2 SELECT FROM SPJ WHERE QTY BETWEEN 300 AND 500 SELECT Jname FROM J WHERE Jno IN SELECT Jno FROM SPJ WHERE Sno IN SELECT Sno FROM SPJ WHERE Pno IN SELECT Pno FROM P WHERE Color SELECT Jname FROM J WHERE NOT