SQL Question Answer For Beginners - Part F

1. What are the three major components of a database system?
2. How does preparing a disaster scenario help in the recovery process?
3. What is a standby server?
4. How do you rebuild the Registry for SQL Server 2000?
5. How do you rebuild the Master database in SQL Server 2000?

6. What are the two Authentication modes for SQL Server 2000?
7. What are the two groups of roles in SQL Server 2000?
8. What is a fixed role?
9. To which groups does an application role belong?
10. What makes a SQL Server view suitable for security purposes?

11. What are the most commonly used connection interfaces for
SQL Server 2000?
12. How do you configure an ODBC data source?
13. What are ADO, RDO, and DAO in the context of SQL Server 2000?
14. What Microsoft application is required to provide access to SQL Server via
the Internet?
15. How do you install the English Query? What would you use it for?

16. What data sources can you search once you’ve installed the full-text
search capabilities?
17. Where is a full-text index physically stored?
18. What is the primary use of SQL Server Analytical Services?
19. How can you automatically update a Web page created with the Web
Publishing Wizard for SQL Server 2000?
20. What is XML and how does SQL Server 2000 support it?


1. Every SQL Server RDBMS system consists of at least three components: an
operating system, SQL Server, and the client applications that connect to
SQL Server.
2. It enables you to identify potential problems and practice steps for recov-ery
in order to minimize downtime and data loss.
3. A standby server is an identical copy of a production SQL Server that is
usually installed on a different machine. It mirrors the production server
very closely so you can use it as a substitute production server in case of
a server disaster.
4. By running the SQL Server installation program again and choosing
Advanced options.
5. Using the command-line utility Rebuildm.exe.

6. Windows Authentication and Mixed Authentication modes.
7. Server roles, which are applied and administered at the SQL Server level,
and database roles, which are applied and administered at the database
level.
8. A predefined role in SQL Server that cannot be changed. There are eight
fixed server roles.
9. It is a database role.
10. Normally, a SQL Server view does not allow updates and inserts into
underlying tables; you can limit a view to several columns in the table
while hiding the rest.

11. OLE DB and ODBC.
12. Through the ODBC component in the Control Panel (Windows NT) or Data
Sources from the Administrative Tools menu.
13. ADO, RDO, and DAO are ActiveX components for accessing data sources
through ODBC or OLEDB provider interfaces.
14. Microsoft Internet Information Server.
15. By choosing English Query during the SQL Server 2000 installation
process. This helps to create custom solutions that enable you to query
SQL Server in plain English rather than with Transact-SQL.

16. Any data in SQL Server database as well as any text contained in system
files.
17. It is stored as a system file, separate from SQL Server.
18. Analyzing large amount of data in a process called data mining in order
to discover hidden trends.
19. Using the SQL Server Web Publishing Wizard you may specify that the
data in the published set be updated periodically or upon changes to the
data in a particular column(s).
20. XML stands for eXtensible Markup Language. It is an emerging standard
for data-interchange formats for the distributed systems. SQL Server 2000
supports XML by providing special keywords, FOR XML and OPENXML.

No comments: