第1题
sa是SQL Server 2000的超级用户名。基于安全的原因,一般在创建实例的同时最好给sa用户设置()以防止其他用户使用sa权限。
A、权限
B、作用域
C、密码
D、关键字
第3题
A.系统存储过程提供了管理数据库和更新表的机制
B.所有系统存储过程都以sp_开头
C.所有系统存储过程都存放在master数据库中
D.用户不能使用系统存储过程更新系统表,只能查询系统表
第4题
A.使用视图可以筛选原始物理表中的数据,增加了数据访问的安全性
B.视图是一种虚拟表,数据只能来自一个原始物理表
C.CREATE VIEW语句中可以包含UPDATE语句
D.为了安全起见,一般只对视图执行查询操作,不推荐在视图上执行修改操作
第7题
在 SQL Server 系统中,通过使用主码约束或唯一值约束,系统将自动建立其相应的索引。()
第10题
A.支持大量数据类型
B.支持存储过程:它的数据类型、存储过程和传统的SQL Server具有很大的相似性
C.支持云中的事务:支持局部事务,但是不支持分布式事务
D.属于关系型数据库:支持使用TSQL来管理、创建和操作云数据库
第11题
&8226;Which seminar (A, B, C or D) does each statement 1-7 refer to?
&8226;For each statement 1-7, mark one letter (A, B, C or D) on your Answer Sheet.
&8226;You will need to use some of these letters more than once.
A
Access Databases
This seminar teaches you how to design and implement a smart user interface, giving you a robust, professional application with low maintenance and training requirements. A poorly designed and implanted interface can cause excessive support calls, data entry errors and user dissatisfaction. In this seminar you'll learn how to do forms tight, you'll learn the secrets of how expert Access developers use all of the power of the Access forms design tools and features to build applications users will love.
B
SQL Server 2000
In this seminar, you'll learn about the new features you can use in SQL Server 2000. You'll explore the interface changes in Enterprise Manager. You'll learn about the new relational database features. You'll dig into the how and why of user-defined functions. You'll learn how to run multiple instances of SQL Server on the same machine. After this seminar, you'll be ready to take full advantage of the rich set of features available in SQL Server 2000.
C
Stored Procedures Basics
In this seminar, you'll learn how to build robust and powerful stored procedures and how they are used to not only improve the performance of database applications, but to help protect critical data as well. You'll learn about input and output parameters, and how to add error handling and transaction processing to the stored procedures that you build. After this seminar, you will understand the many benefits of stored procedures, and you will feel comfortable using them in the database applications you build.
D
ActiveX Automation
Learn how to use ActiveX Automation, and you can communicate with and control all types of Automation-enabled products and components. This seminar teaches you to exchange data with and even run commands in other programs. You'll learn how to set up an Automation-enabled application, and how to hook into Word, Outlook, and other products and components. You'll learn how to use Office components to perform. tasks such as creating reports, generating charts, and even doing E-mail.
The seminar concerns new characteristics of the product.