SqlServer2008 考试范围（SqlServer2008 exam scope）.doc

SqlServer2008 考试范围（SqlServer2008 exam scope） 1. Single item selection (10 points) 1. In the following four items, the non-database features are (). A. data sharing b. data integrity C. Data redundancy is high D. Data independence is high In the following four items, the non-sql2008 utility is (). A. enterprise manager b. query analyzer C. Service manager D. Media player 3. SQL Server installer creates 4 system databases, which of the following is not () system database. Arjun aster B.m odel C.p ub D.m SDB 4. () is a layer of data management software between the user and the operating system, which is a system software that provides access to the database for the user or application. The database shall be unified and controlled in the establishment, use and maintenance of the database. A.D BMS B.D.B C.d. BS d.d. BA 5. In SQL, the command to set up the table is (). A.C REATE SCHEMA biggest REATE TABLE Arthur c. REATE VIEW, dc REATE INDEX 6. In the SQL language, the conditional age BETWEEN 15 AND 35 indicates age BETWEEN 15 AND 35, AND (). A. Including 15 and 35 B. Not including 15 and 35 C. Includes 15 but not 35 D. Includes 35 but not 15 7. In the following four items, the incorrect formulation is (). The A.S QL language is the international standard language for relational databases The B.S QL language has data definition, query, manipulation and control functions The C.S QL language can automatically normalize relational databases The D.S QL language is called structured query language In the SQL language, the command to delete data in the table is (). A. DELETE b. DROP C. the CLEAR d. REMOVE The view from SQL is exported from (). A. basic table b. view C. basic table or view d. database 10. Which of the following is not the suffix of the SQL database file? A. MDF b. LDF C.. MDB D.. = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = The answer: C, D, C, A, B, A, C, A, C, C 2. Judgment: (10 points) Is in that distant place a string constant in SQL? 2.