SQL Question Answer For Beginners - Part A

1. What is SQL Server 2000?
2. On what operating systems can you install SQL Server 2000?
3. Name at least three installation versions of SQL Server 2000. What are the
differences between them?
4. What is collation order and how do you choose one?
5. What is a named instance and how does it differ from a default server?
6. What are the two authentication modes supported by SQL Server 2000?
7. What visual tool does Microsoft supply to manage SQL Server?
8. What are SQL Server services and how do you manage them?
9. How do you register a server with the SQL Server Enterprise Manager?
10. How many top-level objects do you see for each registered SQL Server?
11. Can you change your SQL Server configuration options?
12. How do you add or remove SQL Server components after installation?
13. How do you uninstall SQL Server 2000?
14. What are the SQL Server Books Online and where can you find them?
15. What is a wizard in SQL Server 2000 context?
16. What is RDBMS? What does it have to do with SQL Server?
17. What is the purpose of the BCP command-line utility?
18. What are ISQL and OSQL?
19. What are SQL Server Agent jobs and alerts?
20. What is the Web Assistant Wizard?.

1. SQL Server 2000 is a relational database management system (RDBMS)
from Microsoft.

2. You can install SQL Server 2000 on Windows NT 4.0, Windows 2000 Server,
Windows 98 and Windows CE.

3. Enterprise, Standard, Professional, Developer Edition and Windows CE
The differences between these versions lie in the maximum size of the
supported database, the number of CPUs, and support for enterprise-level
features such as replication, scheduling, and so forth.

4. Collation order refers to the way the data in a database are sorted and
compared. Collation order for the server is set during installation; you
can change it later, though it requires reinstalling the SQL Server.
Collation order for a custom database can be set during creation of
the database - it could be different from the default collation order of the

5. Starting from SQL Server version 7.0 you can run several instances of SQL
Server on the same machine. The first installed instance is designated the
default and given the name of the machine on which it is installed; every
named instance must have a unique name.

6. Windows authentication mode and mixed mode.

7. The SQL Server Enterprise Server Manager.

8. Services are a specific type of Windows programs that run as background
process and usually do not require(or allow) direct user interaction. SQL
Server depends on the following services to run: SQL Server Service,
SQL Server Agent Service and MSDTC Service; you manage services
through the SQL Server Service Manager or from Control Panel’s Services

9. Through the Register SQL Server Wizard in the Enterprise Manager

10. Depending on the installation version, you will have anywhere from five
to seven top-level objects with each registered server.

11. Yes. Doing so usually requires re-running install and selecting different
options; sometimes it might be necessary to reinstall SQL Server altogether.

12. By re-running installation and selecting the components you wish to add.

13. Rerun the installation program and select the uninstall option, or use the
Add/Remove Programs utility in the Control Panel.

14. They are the most comprehensive source of information on SQL Server,
and they are installed with every version of SQL Server.

15. A program that guides you step by step through the process of complet-ing
a specific task.

16. A relational database management system (RDBMS) is a means of storing
and managing data in a system of related entities/tables; SQL Server is
one of many implementations of the RDBMS concept.

17. It assists in speedily transferring large amount of data into or out of a

18. Both are command-line utilities for performing ad-hoc SQL queries. ISQL
is a command-line utility based on the DB Library interface; it is provided
for compatibility with previous versions of SQL Server and does not sup-port
all SQL Server 2000 features. OSQL is ODBC-based and supports all
the features of SQL Server 2000; it can also run UNICODE stored scripts.

19. SQL Server Agent assists with automating some of your database-management
chores. A SQL Server Agent job is a sequence of database
tasks scheduled for execution, either periodically or as the result of some
predetermined condition. SQL Server alerts enable you to take action in
response to some event that occurs on the system by notifying an opera-tor
- either via e-mail or pager.

20. The Web Assistant Wizard is a tool for generating (HyperText Markup
Language (HTML) documents based on the data extracted from SQL Server

No comments: