数据库工程师-(29)

92 1 A B C D 2 Student Information A ALTER TABLE Information B TRUNCATE TABLE Information C DROP TABLE Information D DELETE TABLE Information 3 A DBMS B C D 4 r A B C D ABCD 1431 2711 3022 1233 A A B B B D C D C D A D 5 A B C ER D 6 A SELECT FROM a JOIN bON a b WHERE B SELECT FROM a R1GHT OUTTER JOIN b ON a b C SELECT FROM WHERE NOT IN SELECT FROM a JOIN b ON a b WHERE D SELECT FROM WHERE IN SELECT FROM a JOIN b ON a b WHERE 7 A B C D 8 A B C D 9 T1 T2 A B C D 10 A B C D 11 A T Q Q X B T Q S Q S C T Q S Q S D 12 A B C D 13 JDBC A JDBC Java DataBase Connection B SQL Java API C Java D JDBC SQL 14 R U u X Y Z U z U X Y A X Y T Y X T B X Y X Z C X Y X Y D z X Z 15 A B C D 16 A B C D 17 CS c1 cm CS m ci n Vi i1 in c i sim Vi Vj ci cj A CS k A A B C D 18 A B C D 19 A B C D 20 SQL A AGE IS NULL B AGE IS NOT NULL C AGE NULL D NOT AGE IS NULL 21 A B C D 22 A 1 1 B 1 n C m n D 23 A B C D 24 T a1 a2 an a 1 A T B a1 T C a1 T D a1 T T 25 SQL Server 2000 A B C D 26 A B C D 27 OLTP A B C D 28 A IDEFIX B C D 29 DFD ERD A B C D 30 A B C D 31 SC S C Grade SELECT FROM SC 32 33 34 Table Card CardID CardName Score 500 1000 H Y Card AS SELECT FROM Table Card WHERE 35 UML 36 SQL server 2000 varehar 20 int smalldatetime 37 3 Transact SQL 1 2 3 4 5 INSERT UPDATE 6 7 85 70 85 60 70 60 38 E R E R 1 D C2 DAC B1 MAC DBA 2 C DROP TABLE 3 B 4 B R U r r X Y A A 1 B 4 2 C D B 5 C ER 6 D D D 7 D X Y Y X 8 D 4 D 9 D 10 D 11 D 12 D 13 A 14 A R U U X Y Z U Z U X Y R U X Y R U x z Y x z B B 15 B 16 C 17 A 18 D 19 B 20 C AGE NULL 21 C C 22 D 1 1 1 n m n 1 n 1 1 23 D i 24 A 25 B SQL Server 2000 B 26 B B 27 D 28 D 29 A ER IDEF1X 30 C 31 C COUNT S GROUP BY C 32 33 34 CREATE VIEW HY Card Score BETWEEN 500 AND 1000 WITH CHECK OPTION BETWEEN AND CREATE VIEW AS WITH CHECK OPTION 35 36 Create function fun class varchar 20 orderyearChar 4 Return int As Begin Declare tem smalldatatime Declare cnt int set tem convert smallaatetime orderyear select cnt sum from join on where class and tem return cnt end 37 1 CREATE DATABASE ON PRIMARY NAME FILENAME C msSQL data md f SIZE 4MB MAX SIZE 6MB FILEROWHT 2MB CO 2 CREATE TABLE CHAR 10 PRI MARY KEY CLUSTERED CHAR 8 CHAR 2 SMALLINT VARCHAR 50 GO CREATE TABLE CHAR 10 PRIMARY KEY CLUSTERED VARCHAR 50 VARCHAR 50 GO CRE ATE TABLE CHAR 10 VARCHAR 50 SMALLINT CONSTRAINT C1 PRIMARY KEY CONSTRAINT C2 PRIMARY KEY REFERENCES CONSTRAINT FOREIGN KEY REFERENCES GO 3 CREATE INDEX student ind ON GO CREATE INDEX class ind ON GO CREATE INDEX select ind ON C0 4 CREATE RULE value rule AS VALUF IN CO CREATE DEFAULT AS GO FJXEC sp bindrule value rude GO EXEC sp binddefault GO 5 CREATE rFRIGCER sc insert ON FOR INSERT AS IF SELECT COUNT FROM insened WHERE inserted AND inserted 0 ROLL BACK TRANSACTION GO CREATE TRICGER sc up date ON FOR UPDATE AS IF SELECT COUNT FROM updated WHFRE updated AND updated 0 ROLLBACK TRANSACTION GO 6 CREArrE TRICGER delete all ON FORDELETE AS DELETE FROM WHERE deleted GO 7 SELECT CASE WHEN AVC 85 T