微软认证考试:模拟题（workstatin）
添加时间: 2007-4-7 23:58:32 作者: 微软认证参考 阅读次数:87 来源: http://www.d9soft.com
When you browse an ASP on a web site, you got an error message: ODBC Driver error "80004005" Data source name not found and no default driver specified.
ODBC driver not configured
Database name is not configured correctly
Data source name is not configured correctly
IIS computer cannot resolve the DNS name of the SQL server database
Answer : 3
A user tries to connect to a database via your company website and receives the error (don’t know this exactly)Microsoft OLE DB Provider for ODBC Drivers error ’80004005’
(the 3 start the same way and end like this):
LOGIN FAILURE
GENERAL NETWORK ERROR
Can not find Name Space and no driver defined.
Each question has the same answers:
the user has insufficient permissions to access the database.
the user has insufficient permissions to access RESOURCES in the database.
recent revisions of the database changed the connection method from named pipes to TCP/IP.
the database was recently moved to another server....
3 questions on SQL ODBC errors:
A user tries to connect to a database via your company website and receives the error "ODBC ..." LOGIN FAILURE ? The user has insufficient permissions to access the database...
A user tries to connect to a database via your company website and receives the error "ODBC ..." General Network Error ? Due to heavy use the database has been recently moved to another server......
A user tries to connect to a database via your company website and receives the error "ODBC ..." SOURCE NAME NOT FOUND OR NO DEFAULT DRIVER FOUND ? Incorrectly configured Data Source Name (DSN) .......
The choices were:
The user has insufficient permissions to access the database.
The user has insufficient permissions to access RESOURCES in the database.
Recent revisions of the database changed the connection method from named pipes to TCP/IP.
Due to heavy use the database was recently moved to another server....
Incorrectly configured Data Source Name (DSN) ....
ODBC stuff from Microsoft themselves
The following resources address 80004005 errors:
http://support.microsoft.com/support/kb/articles/q183/0/60.asp
and
http://support.microsoft.com/support/odbc/faq/faq3663.asp
Error Message ------------- Microsoft OLE DB Provider for ODBC Drivers error ’80004005’ [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.
the most common cause is that the connection string is a session variable initialized in the Global.asa and Global.asa is not firing. You may check to see that the variable is being initialized correctly by adding the following code to the .asp page:
- If the Global.asa is not firing, check to make sure it is in an Application Root for IIS 4.0, or a Virtual Root with the "Execute" check box selected if running under IIS 3.0. Also, a bug detailed in the Microsoft Knowledge Base article Q173742, may prevent the Global.asa from being fired when Windows NT permissions have restricted access to the folder.
- The DSN name is not found. Check to make sure a ’User’ type DSN is not being used.
- If using a File or System DSN, try changing the connection string to "DSN=MySystemDSN" or "DBQ=MyFileDSN" as appropriate. Simplify!
- Check to make sure that the most current drivers are installed. If in doubt, download the latest MDAC (Microsoft Data Access Components) from the following Web site:
Error Message ------------- Microsoft OLE DB Provider for ODBC Drivers error ’80004005’ Microsoft][ODBC Microsoft SQL Driver] Logon Failed() Cause -----
-This error is generated by SQL server if it does not accept or recognize the logon account and/or password being submitted (if using Standard security) or if there is no Windows NT account to SQL account mapping (when using Integrated security).
-If you are using standard security, the SQL account name and password are incorrect. Try the system Admin account and password (UID= "SA" and NULL password). These must be defined on the connection string line. DSN’s do not store user names and passwords.
-If using Integrated security, check the Windows NT account that is calling the page, and find out what account (if any) it is mapped to.
-SQL does not allow an underscore in a SQL account name. If someone manually mapped the Windows NT IUSR_machinename account to a SQL account of the same name, it fails. Map any account that uses an underscore to an account name on SQL that does not use the underscore.
Error Message ------------- Microsoft OLE DB Provider for ODBC Drivers error ’80004005’ [Microsoft][ODBC SQL Server Driver][SQL Server] Login failed- User: Reason: Not defined as a valid user of a trusted SQL Server connection. Cause ----- -
-Integrated Security is turned on in the SQL Enterprise Manager, and the Windows NT account being used has not been mapped to a SQL account. –
-Try changing SQL to use Standard Security (In Enterprise Manager, select Server/ SQL Server/Configure[ASCII 133]/Security Options/Standard. - If running under IIS 4.0, turn off "Password Synchronization" for that project.
Error Message ------------- Microsoft OLE DB Provider for ODBC Drivers error ’80004005’ [Microsoft][ODBC SQL Server Driver][DBMSSOCN] General network error. Check your network document Cause -----
-This may occur when a SQL server computer is renamed. DSN’s that reference the old name fail when the computer name cannot be located
Which parameter listed below are store in metabase: (choose two)
IIS help file location
Virtual directory security settings
Web site home directorylocation
Microsoft Management Console Snap-In definitions.
Microsoft Site Server Express Content Analyzer Toolbar Positions
Answer:2,3
Key Metabase Entries
The metabase does not include all of the entries of the Windows NT registry, only those pertinent to Internet Information Server administration. For these settings, the metabase offers more advanced features including speed, scriptability, and remote administration. The following list describes the types of property settings stored in the metabase.
Computer and Web site properties. Properties configurable at the computer and Web site level.
Logging properties. Properties configurable for Web site activity logging.
FTP-specific properties. Properties configurable for FTP services only.
HTTP-specific properties. Properties configurable for Hypertext Transport Protocol (HTTP) services only.
Virtual directory and directory properties. Properties configurable at the virtual directory and directory level.
File properties. Properties configurable at the file level.
Filter properties. Properties configurable for filters.
SSL key properties. Properties configurable for Secure Sockets Layer (SSL) keys.
There are 100 web pages on a web site sharing common elements. If you are the administrator of this web site, and the web pages need to be updated three times every day, what is the most least administrative efforts way to maintain this web site?
Create common .idc filled for all HTML files
Create common .htx file for all HTML files
Rename all .htm files to .asp files
Use server-side include directives in the HTML file
Answer:4
The server-side include (SSI) directives component allows Internet Information Server to include text, graphics, or application information in a Hypertext Markup Language (HTML) page just before sending the HTML page to a user. SSI can be used to include, for example, a time or date stamp, a copyright notice, or a form for a customer to fill out and return to your organization. Using SSI to include a file is an easy way to incorporate text or graphics that will be repeated in many files. Rather than typing repeated information into every file, SSI allows you to use a statement to instruct the Web server to read from a single file instead.
The Web server processes SSI directives while it is processes the HTML page. When it reaches an SSI directive, the Web server inserts the contents of the included file directly into the HTML page. If the included file in turn contains an SSI directive, that file is also inserted.
You have three offices, each with an SMTP server connected via the internet. How do you secure them?
SSL
restrict by ip address
Answer:1
You want to publish the company newsletter to 500 users so that they can search the last six months by keyword. How?
NNTP
WWW and Index Server
Answer: 2 (use WWW to search the newsletter)
allow a range of IP addresses 192.168.0.96 - 192.168.0.127 deny all others.
192.168.0.0, 255.255.255.224
192.168.0.96, 255.255.255.192
192.168.0.96, 255.255.255.224
192.168.0.127, 255.255.255.192
Answer:3
Web Site configured to allow only a group of IP addresses to access it. The set-up was: 192.168.0.96 (Submask 255.255.255.224). What range of addresses allowed?
192.168.0.96 - 192.168.0.127
192.168.0.89 - 192.168.0.120
192.168.0.91 - 192.168.0.132
192.168.0.95 - 192.168.0.129
Answer: 1
You are behind a firewall and want to administer an IIS server with HTMLA, what port does the firewall have to let through.
HTMLA uses HTTP on a port chosen randomly at installation
HTTPS
SSL
RPC listener port
Answer: 1
When INSTALLING HTMLA it assigns itself a port number from 2000 to 9999, through which it connects the Administrative Web site EVERY time, and this port should be enabled in the firewall, RPC connection is nonsense. as the communication between the browser and the Administrative website is through purely through HTTP through this port number. from http://localhost/iishelp/iis/htm/core/iivsovr.htm#RemoteAdministration (IIS Server Documentation)
You want to decrease the amount of RAM that index server uses. Choose 2:
Increase number of Word Lists
Decrease number of Word Lists
Increase size of Word Lists
Decrease size of Word Lists
Answer 2,4
Word Lists: Word lists are small, in-memory indexes. Each word list contains data for a small number of documents. As soon as a document is filtered, its data is stored in a word list. Creation of a word list is very quick and does not require updating any on-disk data. It is used as a temporary staging area during indexing.
Once the number of word lists exceeds the MaxWordLists parameter, the word lists are merged into a shadow index. This merge process is called the shadow merge. Although the data in word lists is compressed to some extent, the compression is not very high because word lists are temporary structures. Because word lists are in-memory structures, documents in a word list must be refiltered whenever the Content Index service is restarted. The refiltering is automatically detected and performed by the Index Server engine.
MaxWordlistSize : Maximum amount of memory consumed by an individual word list. When this limit is reached, only the document being filtered will be added. Additional documents will be refiled and later placed in another word list. Each unit is 128 kilobytes (K) (for example, 20 = 2.5 megabytes).
MaxWordLists: Maximum number of word lists that can exist at one time.
reasons:
Stated in one of my reference materials (possibly the MS IIS Training Kit) was this phrase, "the ideal situation (for Index Server) is having a single Master Index with NO Shadow Indexes or Word Lists. Word lists reside only in the memory of the server and are merged into Shadow Indexes (stored on hard disk, but use more room than master indexes) when the number of Word Lists exceed the set parameter. While theoretically, increasing the number of Word Lists could result in a Shadow Merge, we of course can not assume (anything on an MS Certification test) the increase would trigger the Shadow merge. So fewer word lists and smaller word lists would obviously result in less memory since that is the only place word lists reside.
You are logging WWW with text logging and you want to know where to find the number of page hits?
in the log file
Event Viewer
Answer: 1
You configure multiple sites on a IIS 4.0 server. Both sites share the same IP address, Home Directory and TCP port. DNS entires have been setup that point each FQDN to the same IP address. However, when users try to go to the 2nd web site they open up t
Configure HOSTS files on the server
Configure HOSTS files on the clients
Configure the clients to use DNS
Configure Site 2 to use a Host Header
Answer: 4
You administer a NNTP server. How can you enable searching capabilities
Implement Index Server. Use .idq files.
Implement ODBC to SQL Server. Use SQL.
Instruct users to use the search features of their client newsreader
Nothing, newsgroups cannot be searched
Answer:1
You have 2 servers (NY and Ontario), what’s the easiest way to to change the IP ports on the 200 sites contained at those locations?
Use Inet Server Manager to change individual ports
Internet Server Manager HTML to change individual ports
write a VB script and run it on both sites
write a VB script and run it on one site
Answer: 3 (WSH cannot run remotely)
You set up three intranet web sites and set them to use headers. How do users find them.
Install modified Hosts file to the Server
Install modified Hosts file to all the clients
上一篇文章: 微软认证考试:基础知识篇（1） 下一篇文章: 微软认证考试:模拟题（tcpip）
相关文章: