面向面试准备、在线测试、教程与实战练习的学习平台

通过聚焦学习路径、模拟测试和面试实战内容持续提升技能。

WithoutBook 将分主题面试题、在线练习测试、教程和对比指南整合到一个响应式学习空间中。

搜索资源库

面试准备

MSSQL 面试题与答案

问题 26. What are system databases in MS SQL Server?

System databases are created by the SQL Server itself during the installation process. System databases are used by the SQL server to help manage other user databases and client execution sessions. SQL Server 2005 Express Edition uses 4 system databases:

* master - The brain of a SQL server - Stores server configuration, runtime information, and database metadata.

* model - An empty database model - Used to clone new databases.

* msdb - The background job scheduler - Used for background jobs and related tasks.

* tempdb - The temporary database - Used by the server as a scratch pad.

这有帮助吗？是否添加评论查看评论

问题 27. How to download and install SQL Server 2005 Books Online?

1. Go to the SQL Server 2005 Books Online download page.

2. Click the download button, the File Download box shows up. Save the download file to c:temp.

3. Double click on the downloaded file: c:tempSqlServer2K5_BOL_Feb2007.msi. The installation setup window shows up. Follow the instructions to finish the installation.

4. When the installation is done. You will see a new entry in the Start menu: Start > Programs > Microsoft SQL Server 2005 > Documentation and Tutorials

这有帮助吗？是否添加评论查看评论

问题 28. What is a database table?

A table in database is a data object used to store data. Tables have the following features:

* Data is stored in a table with a structure of rows and columns.
* Columns must be pre-defined with names, types and constrains.
* A table object may have other associated data objects like, constrains, triggers, indexes, and statistics.

For example, a table called Address may have columns defined to store different elements of an address like, street number, city, country, postal code, etc.

这有帮助吗？是否添加评论查看评论

问题 29. How to run Queries with SQL Server Management Studio Express?

1. Launch and connect SQL Server Management Studio Express to the local SQL Server 2005 Express.

2. Click on the "New Query" button below the menu line. Enter the following SQL statement in the query window:

SELECT 'Welcome to GlobalGuideLine.com Tips on SQL Server!'

3. Click the Execute button in the toolbar area. You should get the following in the result window:

Welcome to GlobalGuideLine.com Tips on SQL Server!

这有帮助吗？是否添加评论查看评论

问题 30. What are DDL (Data Definition Language) statements for tables in MS SQL Server?

DDL (Data Definition Language) statements are statements to create and manage data objects in the database. The are three primary DDL statements to create and manage tables:

* CREATE TABLE - Creating a new table.
* ALTER TABLE - Altering the definition of an existing table.
* DROP TABLE - Dropping an existing table.

这有帮助吗？是否添加评论查看评论

用户评价最有帮助的内容：