最全SQL数据库试题.docVIP

1 SQLêy?Y?aê?ìa ò??￠μ￥??????ìa(??D?ìa1·?￡?1210·?) ??áD?????D￡?2?ê?óúêy?Y?aì?μ?μ?ê?￡¨ C ￡??￡ êy?Y12?í B.êy?Yíê??D? C.êy?Yè?óàoü?? D.êy?Y?àá￠D??? 2.??áD?????D￡?2?ê?óúSQL2000êμó?3ìDòμ?ê?￡¨ D ￡??￡ ?óòμ1üàí?÷ B.2é?ˉ·????÷ C.·t??1üàí?÷ D.??ì?2￥·??÷ 3.SQL Server°2×°3ìDò′′?¨4???μí3êy?Y?a￡???áD????2?ê?￡¨ C ￡??μí3êy?Y?a?￡ master B.model C.pub D.msdb 4.￡¨ A ￡?ê???óúó??§ó?2ù×÷?μí3????μ?ò?2?êy?Y1üàíèí?t￡??üê?óú?μí3èí?t￡??ü?aó??§?òó|ó?3ìDò ìá1?·??êêy?Y?aμ?·?·¨?￡êy?Y?a?ú?¨á￠?￠ê1ó?oí???¤ê±óé??í3ò?1üàí?￠í3ò??????￡ A￡?DBMS B￡?DB C￡?DBS D￡?DBA 5. ?úSQL?D￡??¨á￠±íó?μ??üá?ê? ( B )?￡ CREATE SCHEMA B.CREATE TABLE C.CREATE VIEW D.CREATE INDEX 6.SQLó????D￡?ì??t?êá? BETWEEN 15 AND 35±íê??êá??ú15?á35????￡??ò( A )?￡ °üà¨15?êoí35?ê 2?°üà¨15?êoí35?ê °üà¨15?êμ?2?°üà¨35?ê °üà¨35?êμ?2?°üà¨15?ê 7.??áD?????D￡?2??yè·μ?ìá·¨ê?( C )?￡ 2 SQLó???ê?1??μêy?Y?aμ?1ú?ê±ê×?ó??? SQLó?????óDêy?Y?¨ò??￠2é?ˉ?￠2ù×Yoí????1|?ü SQLó????éò?×??ˉêμ??1??μêy?Y?aμ?1?·??ˉ SQLó???3??a?á112é?ˉó??? 8.?úMS SQL Server?D￡?ó?à′??ê?êy?Y?aD??￠μ??μí3′?′￠1y3ìê?( D )?￡ sp_dbhelp B. sp_db C. sp_help D. sp_helpdb 9.SQLó????D￡?é?3y±í?Dêy?Yμ??üá?ê?( A )?￡ DELETE B. DROP C. CLEAR D. REMOVE 10.SQLμ?êóí?ê?′ó￡¨ C ￡??Dμ?3?μ??￡ ?ù±?±í B. êóí? C. ?ù±?±í?òêóí? D. êy?Y?a SQLêy?Y?a ê?ìa2 ò??￠μ￥??????ìa(??D?ìa1·?￡?1210·?) 4. ??áD????2?ê?sql êy?Y?a???tμ?oó×o?￡C A￡?.mdf B￡?.ldf C￡?.tif D￡?.ndf 5. êy?Y?¨ò?ó???μ???D′′ê?a ( A )?￡ DDL B.DCL C.DML D.DBL 8. ?úSQLó????D￡??¨á￠′?′￠1y3ìμ??üá?ê?(A) A?￠CREATE PROCEDURE B?￠CREATE RULE C?￠CREATE DURE D?￠CREATE FILE 3 SQLêy?Y?a ê?ìa3 ò??￠μ￥??????ìa(??