MCSE2000--sql admin(2)

站 (Thu Apr 19 08:28:52 2001), 转信
1) Reponse poor, to prevent queries from running long:
a) Use SQL profiler to filter on queries
b) Set the query governor to stop long queiries
c) Use perfmonitor to send alerts and kill
d) Decrease query wait option
Aw: D (Im not 100% sure - B is also possible - but in the BOL
2) A query which load data on Production Server runs. Log is approaching 500
MB,
less since 50% done. 3GB HD was freeDB growth was auto. The query blocks out
other users.
How could you give the general user quick access to the database for use.
A. Kill update process
B. Let the update process runs until it finished
C: Kill the blocked processes
D. Stop and restart the SQL server
E. Truncate the transaction log
Aw: B (there is no need to abort your transaction at 50%)
3) You suspect, that most performance problems are caused by a small amount
of
process intensive queries. To reduce the overhead caused by these query you
first need to identify the specific queries that are causing the problem. Wh

at
should you do to identify these queries?
a) use T-SQL extended stored procedures in the querys to record trace
informations on each query.
b) Use Performance Monitor to log the SQLServer: Acces Methods object
c) Filter in Profiler, maximum time
d) Flter in Profiler, minimum time
Aw: D (filter out all the queries that are not at least X seconds long)
4) You want to examine the master database file settings in SQL Server
Enterprise Manager, but the master database is not listed in the Database
folder. You want to set the option to make the master database visible. Wher
e
can you set this option?
A. in the master database
B. in the server configuration
C. in the registry
D. in the Enterprise Manager registration
Aw: D
5) The trace you currently use is saved. You want to use similar traces
frequently. How must you edit the saved trace you currently use to include
additional events?
A. Import the trace in SQL Server Profiler, and edit the event classes.

B. Open the trace file, and edit the event classes.
C. Open the trace definition, and edit the event classes.
D. Edit the saved registry settings for the trace.
Ans: C - lot of discussion about this one . if you save your trace i.e. Test
.trc
the extension is TRC, and if you open your trace again, you will have to use
Tes.trc. When you like to import (the help file says Import Definition is ne
eded
if you want to edit traces definitions from other servers), then an exportet
trace must exsist with the extension TDF i.e. Test.tdf
6) A user forgot his SQL Server password. You are a member of the SYSADMIN
role. What is the easiest way for you to change his password to a new one?:
A. use the login properties page in the Enterprise Manager.
B. delete his login and add it again.
C. use sp_password
D. something else
Aw: A (this is logical)
7) Your company acquired a new Company which has an Oracle database for its
employees. Your company uses SQL Server for its employee database. You want
to
merge the data from the new company into your SQL Server Employee database.
Below is the structure of both databases:
Oracle SQL Server
Employee ID I Employee ID
Name I Name
Addr1 I Address
Addr2 I City
City I State
State I Zip
Zip I
What method should be used to accomplish the merge.
a. bcp
b. SELECT..INTO
c. INSERT INTO with a SELECT clause
d. BULK INSERT
Aw: C (SELECT..INTO is only used when a destination table does not already
exist. INSERT INTO with a SELECT clause does the same thing but without crea
ting
a table)
8) Your company sql server is in the same BDC as the server running Exchange
Sever. The exchange server is performing poorly. What should you do to impro
ve
performance of the server running exchange while not adversly affecting SQL
server?
A. increase memory allocated to the procedure cache option
B. set the working size option to 1
C. decrease the min server memory setting
D. increase the min server memory setting
Aw: C, not sure - please check it
9) Exchange and SQL 7.0 are running on the same server. You notice the
performance in exchange is degraded. The Min server memory, Maximum server
memory and set working area are set as they were automatically in the
installation. What you do to free memory for exchange.
A. increase memory allocated to the procedure cache option
B. Set working area to 1
C. Set working area to 0
D. Reduce Min server memory
E. Increase Min server memory
Aw: D, not sure - please check it
10) What are the effective permissions when a user has both Windows NT and S
QL
Server login permissions:
a. Cumulative of NT and SQL
b. NT overrides SQL Server
c. SQL Server overrides NT
d.SQL only
Aw: D, not sure - please check it
11) The transation log in a published database is full. You attempt to trunc
ate
the log, but you notice that the log remains full.What is the most likely ca
use?
A. The Microsoft repl-commands table in the distribution database is full.
B. The distribution Agent has stopped.
C. The Log Reader Agent has stopped.
D. Subscribed database has become unavailable.
Aw: A (Transcender)
12) You have SQL 7.0 on Win 98 machines in Branch offices and in the corpora
te
you have SQL 7.0 on Win NT Server. Branch offices report slow performance. D
B
Admin is in the corporate office. How should the profiler be configured in t
he
branch offices so that they can be centrally collected in the Corporate offi
ce
by the DB Admin?
A. Use SQL Profiler Xtended sp and send them to the NT App log in the centra
l
office.
B. Use SQL pr.Xtended sp and send them to the centralized table in the corp.
office.
C. Use xp_sendmail procedure to send the statistics thru e-mail to the DB Ad
min
D. use OS commands to build a file etc., and send them to the corp office.
Aw: C
13) In Replicaiton: you have finance db. there are many publications on it.
accounting group subscribes to one of the publication. but they want to
subscribe only to one article..how it can be done with min admin steps.
A. filter on the publication so that they can subscribe to one article and u
se
pull subs.
B. filter on the publicaiton same as above but with push subs.
C. create a new publication with the above article.
Aw: C
14) The computer which was running SQL server crashed. Windows NT is
reinstalled. What is the quickest way to get SQL server up and running
a. Restore registry from backup
b. Run regrebld.exe
c. Restore database from last backup
d. Rebuilder Master database
e. Run SQL Server Setup again
Aw: B (with regrebld.exe you can backup SQL registry settings and restore th
em -
the first backup is made at setup)
15) Installing SQL on a network, there are Windows 95, NT Workstations and
Netware clients. All must be able to connect. Choose all that apply:
a) Create NT logons for Windows NT clients
b) Create NT logons for Windows 95 clients
c) Create NT logons for Netware clients

d) Create SQL logons for Windows NT clients
e) Create SQL logons for Windows 95 clients
f) Create SQL logons for Netware clients
Aw: a,e,f ( a, f are right and c is wrong )
16) You install SQL server on an IIS machine. You need to optimise IIS. What
do
you configure on SQL Server ?
a) Set working set size
b) Min Server memory
c) Max server memory
d) Max worker threads
Aw: C
17) You are moving a server from FINANCE DOMAIN to MONEY domain. SQL Server
is
not able to start.
a.Money is a Datatype in SQL. so it cannot be restarted.
b.SQL NT A/c is inaccessible.
c.Internal SQL server is now different than the Network name.
d.Domain name cannot be changed after installing SQL.
Aw: B ( sure )
18) SQL server is configured with a Net-library with TCP/IP socket 1450 whic
h is
non standard port setting. How to configure the client computers.
a. At the server use the SQL Server Network utility to use port 1450.
b. At the server use the SQL Server Client utility to use port 1450.
c At the Client configure the SQL Server Client Network Utility to change th
e
TCP/IP port to 1450.
d. At the Client modify TCP/IP services to associate to sqlserver on port 14
50.
Aw: C (note: default TCP/IP port is 1433)
19) Replication.
NY ( NY1----T1-----------NY2) -----56kbps------------>(
Seattle-----T1----SanFrancisco----T1---Los Angeles)
a.NY1=pub/dist NY1,Seattle,SF,LA as subscriber
b NY1=Pubs SF=subs/dist/pubs NY2,Seattle,LA as subscriber
c.NY1 =pubs NY2=dist Seattle,SF,LA as Subs.
d.NY1=Pubs LA= dis something not workable.
Aw: C (the distributer must not on the west side, because the connection bet
ween
pub / dist must be very fast)
20) Your company has five call centers that are located worldwide. These cal
l
centers manage the reservations for an airline.
The reservation application has a customer table on the cooperate server. Th
e
customer table is read locally and can be updated locally but the updates mu
st
maintain consistency across all five locations.
Which type of SQL Server replication should you implement?
A. Merge replication with push subscribers.
B. Merge replication with pull subscribers.
C. Transaction replication with push subscriptions.
D. Transaction replication with immediate-updating subscribers.
Aw: A ( what do you think?)
21). You install SQL Server onto MSWindows NT Server computer that is member
of
the Workgroup SQLGROUP. Your user"s computer are also memmbers of SQLGROUP.
None
of the users can conect to the SQLServer by using SQL Server Query Analyzer,
even though they are using valid SQL Server login ID"s and passwords. You us
e
the SQL Server Client Network Utility to confirm that the default Net-Librar
y is
Named Pipes. What is the most likely cause of the problem?
A. The users computers are not configured with a valid ODBC DSN for SQL Serv
er.
B. The users computers are not connecting by using trusted connection.
C. The SQL Server database files are not available in a network share.

D. The Server"s Windows NT Guest account is disabled
Aw: A
22). Your company"s current applications use MSAccess. New application will
use
SQL Server. The new application must be able to access data from the Access
database. What must you do, so that SQL Server queries can access the Access
database?
A. Register connection information for the Access database in SQL Server.
B. Register connection information for SQL Server in the Access database.
C. Establish a connection to the Access database when a query is executed.
D. Use the same MS Windows NT domain account for the Access database and SQL
Server.
Aw: C
23). You install merge replication. You are investigating the default confli
ct
resolution. Name Contact Name field is CS for customer 10 in a merge article
on
Publisher and Subscriber. The value of CN for customer 10 on Publisher is
changed to AJ.
The value of CN for customer 10 on Subscriber is changed to JS. The merge ag
ent
runs.
What is the value of CN for customer 10 on Publisher and Subscriber after

conflict resolution?
A. AJ on both.
B. JS on both.
C. AJ on Publisher and CS on Subscriber.
D. JS on Publisher and AJ on Subscriber.
Aw: A
24) DBO creates table A, grants Franz to create view and sp, Franz creates a
view based on A, and a sp updating A, Franz grants Susan to select view and
execute sp, Susan fails to use either:
a) DBO grants Susan SELECT on view and sp
b) Franz grants Susan SELECT on A
c) DBO grants Susan SELECT and UPDATE on A
d) Franz grants Susan SELECT on A and execute on sp
Aw: C (because the ownership chain was broken)
25) SQL 6.5 upgraded to SQL 7.0, some 6.5 stored procedures are showing
constraints by collecting data from sysobjets, syscolumns, sysconstraints, y
ou
can no longer run them:
a) recompile
b) rewrite, access new system tables.
c) rewrite, access information schema views.
d) upgrade other databases first.
Aw: C
26) Transaction replication, updates synchronized on Publisher and Subscribe
r,
MSrepl_commands is empty, why:
a) automatically cleaned up after transaction
b) log reader purged it for next batch
c) replication distribution clean up job ran and purged it
d) log reader did not log activity to it
You want export data from the temp tabel with bcp, but it does not
work:
bcp #tempdb..table out c:tempfiel.txt -n -Sserver -Uuser -Ppassword
A. wrong syntax
B. 目标文件必须存在
C. you can"t do that on a temp table
D. you have used native format instead of character format
You have database files and a fulltext catalogue on the same disk.
You want to use max. 25% of the disk space for the catalogue.
How can you monitore it best?
A. batch/job with net send or mail
B. performens monitor
C. use NT Performens Monitor
C?
27. You need to provide access to the Sales database for internet users
who do n


收藏到ViVi   收藏此页到365Key
上一篇： MCSE2000----sql admin(1)
下一篇： MCSE---sql admin(3)