数据库工程师-(70)

29 A B C D 1 A B C D 2 A B E R C D 3 A B C D 4 A A A B C D 5 A XY Z X Z Y Z B X Y Y Z X YZ C X Y Z Y X Z D X Y Y Z X Z 6 A IDEFO B C D 7 A B C D 8 A X S B DBMS C D 9 A WHERE B ORDER BY GROUP BY C D 10 A B C D 11 SQL Server 2000 user1 user1 A db owner B public C db datawriter D sysadmin 12 C ZG ZGDA DBF C ZG DA DBFGE A SELECT FORM C ZG ZGDA INTO DBF C ZG DA B SELECT FORM C ZG ZGDA INTO DBFDA DBF C SELECT FORM C ZG ZGDA TO DBF C ZG DA D SELECT FORM C ZG ZGDA INTO CURSOR C ZG DA 13 A REDO B C D 14 A B C D 15 A B C D 16 A B C D 17 A B C D 18 A B C D 19 A B C D 20 UML A B C D 21 A B C D 22 SC U1 SQL A GRANT SELECT TO SC U1 WITH PUBLIC B GRANT SELECT ON SC TO U1 WITH PUBLIC C GRANT SELECT TO SC ON U1 WITH GRANT OPTION D GRANT SELECT ON SC TO U1 WITH GRANT OPTION 23 A B C D 24 trigger A B C SQL D 25 SQL student CREATE TABLE student NO CHAR 20 NOT NULL NAME CHAR 8 NOT NULL SEX CHAR 2 AGE INT A 1031 23 B 1031 NULL NULL C NULL 23 D 1031 NULL 23 26 A B C D 27 A B C D 28 A B C D 29 JDBC A JDBC Java DataBase Connection B SQL Java API C Java D JDBC SQL 30 T A A S X T A T A A B C D T1 T2 T3 D1 D2 D3 T1 T2 1 T2 T3 2 2 SP Sno Pno Qty Sno Pno Qty 168 SQL 4 FROM SP PX WHERE 5 SELECT FROM SP SPY WHERE 6 AND NOT EXISTS SELECT FROM SP SPZ WHERE 7 TEST AFTER S TUDENT 8 9 ON STUDENT 10 AS Print 5 VB 6 0 CommandType RecordSource 6 I O 7 Student Course U1 U2 GRANT ON TABLE Student Course TO U1 U2 14 15 1 R U A B C D E G F AB C C A BC D ACD B D EG BE C CG BD CE AG BD 2 Employees Eid Name DeptNO Departments DeptNO DeptName TotalNumber Employees Departments SQL Server Tansact SQL Employees 1 1 C 2 D 3 B 4 BXXT 5 C C 6 C IDEFO 7 B 8 D 9 D DBMS WHERE ORDER BY GROUP BY WHERE 10 C 11 A SQL Server 2000 db owner 12 A 13 A UNDO LIST UND O REDO LIST REDO A 14 A 15 C 16 C 17 C 18 B 19 C 20 A 21 D 22 D A B WITH GRANT OPTION C ON TO 23 C 24 D 25 B A SEX C NO D NAME 26 D 3 27 C 28 D 3 J 29 A JDBC Java DataBase Connectivity Standard SQL JAVA API JAVA JDBC SQL 30 A Q Q 1 2 3 3 4 SELECT Sno 5 NOT EXISTS 6 SPY Sno 168 7 SPZ Sno SPX Sno AND SPZ Pno SPY Pno SQL 8 CREATE TRIGGER TEST 9 AFTER UPDATE 10 FOR EACH ROW INSERT DELETE UPDATE FOR EACH ROW FOR EACH STATEMENT 11 adCmdUnknown VB6 0 CommandType CommandType 4 adCmdUnkown RecordSource adC mdText RecordSource adCmdTable RecordSotource ad CmdStoredProc RecordSource 12 CLUSTER 13 ALL PRIVILEGES 14 15 1 BD ABCDEG X 0 BD D EG X 1 BDEG BE C X 2 BD EGC CG BD CE AG X 3 BDEGCA X 3 BD X 3 ABCDEG T C TNO CNO TNO CNO TNO CNO S C SNO CNO SNO CNO SNO CNO Transact SQL CREATE TRIGGER ON WITH ENCRYPTION AS SQL AFTER FOR SQL 2 create trigger sq1 tri on employees for insert as declare eid varchar 11 declare name varchar 20 declare deptno varchar 11 declare yjy cursor for select from inserted open yjy fetch next from yjy into eid name deptno while fetch status 0 begin upda