MCSE2000----sql admin(1)

站 (Thu Apr 19 08:27:20 2001), 转信
Please check the answer by yourself.
1) Every night the backup fails. Which DBCC command could repair
the Sales DB and check the data integrity and indices?
a) DBCC NEWALLOOC
b) DBCC CHECKALLOC
c) DBCC CHECKDB
d) DBCC DBREPAIR
Aw: C
2) Some front end applications receive error 1205. The developers
invoked error handling. The queries appear to be very slow and sometimes app
ear to stop responding. You want to find out which objects are causing the e
rror 1205 error message
and weather the objects are degrading user response time.
a) NT Performance Monitor : SQLServer:Locks
b) NT Performance Monitor : SQLServer:Lock .request/sec
c) SQL Profiler trace lock: acquired, lock:released, lock cancel
d) SQL Profiler trace lock: dead lock, lock:dead lock:chain,
lock: timeout
Aw: D
3) 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: B
4) You suspect, that most performance problems are caused by asmall 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.
What 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
5) 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. Where
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
6) Load a lot of data to Parts table in Inventory database,
quickest way to
ensure statistics reflect the changes made.
a) sp_updatestats on Inventory database
b) sp_updatestats on Parts database
c) UPDATE STATISTICS on Parts table
d) UPDATE STATISTICS on each index in Parts table
Aw: C
7) SQL1 and SQL2 are linked Servers. They have standard logins in
both, you
can connect both and SELECT on both, issue distributed query for
SQL2 on
SQL1, failed what is the reason
a) not executed in SQL2
b) login in SQL1 not mapped in SQL2
c) not use NT login
d) must directly connect to SQL2
Aw: B (the german translation of this answer was very funny,
without knowing the english original I wouldn"t have known what they
mean)
8) 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: A
9) Publisher (SQL6.5;TOR01), Distributor (SQL6.5;TOR02),
Subscriber(SQL6.5;TOR03)
In which order should you upgrade the server to SQL 7.0?
a) TOR01, TOR02, TOR03
b) TOR02, TOR01, TOR03
c) TOR03, TOR02, TOR01
d) TOR03, TOR01, TOR02
Aw: B
10) 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
Aw: A
11) 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
d) BULK INSERT
Aw: C
12) 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: E
13) You have 50,000 records in a database file and you know you
want to add
another 100,000 records in the next several weeks.What fill
factor would you
use to maximize performance.
a) 0 (default setting)
b) 30
c) 70
d) 100
Aw: B
14) Maria preceeded you as administrator for Microsoft Windows NT
Server and
SQL Server. Maria created SQL Server logins and passwords
matching users
Windows NT accounts. When users logon to the Windows NT Server
domain they
obtain access to the SQL Server. Witch permissions do users
receive to access
SQL Server by using a trusted connection?
a.) Only the same permissions as those that are granted to their
SQL Server
login
b.) Only the same permissions as those that are granted to their
Windows NT
account
c.) The cummulative permissions that are granted to their SQL
Server login and
their Windows NT account
d.) Only the permissions that are granted in common to their SQL
Server login
and their Windows NT account
Aw: B
15) You define full-text indexing on the ProductName column in
the Products
table. You then execute a full-text query on the column. You
specify a word
that you know is present in the column, but the result set is
empty.
What is the most likely cause?
a) The catalog is not populated
b) You did not crete a unique SQL Server index on the ProductName
column
c) The Microsoft Service is not running
d) The SQL ServerAgent Service is not running
Aw: A
16) Your server is running SQL Server 4.21 on NT Server 3.51. You
plan to
upgrade this server to SQL Server7.0. Which two steps must you
take prior to
the upgrade? (choose two)
a) Install the most recent SQL Server 4.21 Service Pack
b) Upgrade SQL Server to version 6.5
c) Install the most recent NT Server 3.51 Service pack
d) Upgrade NT Server to version 4.0
e) Backup your databases in SQL Server 4.21
f) Export the data from your SQL Server 4.21 database tables, and
script your
database objects
Aw: B,D
17) You are relocating a computer running SQL Server to a
different region,and
you want to change the unicode collation.What must you do?
A. Run the SQL Server setup program
B. Back up your database; Run the rebuidm.exe utility;Restore
your database.
C. Script your database objects, and export your data to
files;Run Regrebld.exe;
Re-create your database objects, and reload the data.
D. Script your database objects, and export your data to files;
Run
Rebuildm.exe;
Re-create your database objects, and reload the data.
Aw: D
18) You plan to give users in the Windows NT Sales group limited
access to the
Sales and Inventory databases. All access for data modifications
and reporting
will be through a Micrsoft Excel Application.
How should you set up access for the Sales group in both
databases?
A. Create a single application role. Grant the Sales group
permissions on that
role in each database.
B. Create an application role for each database. Grant the Sales
group
permissions in each database.
C. Create a single application role, and grant it permissions in
each database.
D. Create an application role in each database, and grant it the
appropriate
permissions.
Aw: D
19) To increase security, your company decides to prohibit
Windows NT

administratiors from accession SQL Server administrative
functions.What should
you do to prohibit access?
A. Deny access to the Windows NT Administrator group.
B. Rename the current Windows NT Administrator group, and create
and empty
Windows NT administrator group.
C. Remove the Windows NT Administrator group from the sysadmin
role in SQL
Server.
D. Install SQL Server on a member Server instead of an a domain
controller.
Aw: C
20) The transation log in a published database is full. You
attempt to truncate
the log, but you notice that the log remains full.What is the
most likely cause?
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: C
21) You have SQL 7.0 on Win 98 machines in Branch offices and in
the
corporate you have SQL 7.0 on Win NT Server. Branch offices
report slow
performance. DB Admin is in the corporate office. How should the
profiler be
configured in the branch offices so that they can be centrally
collected in the
Corporate office by the DB Admin?
A. Use SQL Profiler extended stored procedure and send them to
the NT App log
in the corporate office.
B. Use SQL Profiler extended stored procedure and send them to
the table in the
corporate office.
C. Use xp_sendmail procedure to send the statistics thru e-mail
to the DB Admin.
D. Use OS commands to build a batch file, and send them to the
corporate
office.
Aw: B
22) 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 use 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
23) You are a member of fixed server role serveradmin. You create
a job which
backup up the database and then copies the backup file on a
network driver.
When you do the individual steps, they run okay. However, when
executed as a
job, it backs up the database but fails to copy to the network
drive. Why ?
a. SQLServerAgent service is not running
b. SQLServerAgent has no rights for the network share
c. SQLAgentCmdExe does not have permissions to write on the
network drive
d. The Alerter service is not running.
Aw: C
24) Katrin is the system administartor of SQL Server and she is
in the role of
db_owner of the corporate database. Carlos is in the roles of
setupadmin and
db_accessadmin. Julia is in the roles securityadmin and
db_securityadmin.Katrin
must ensure that only she can grant permissions in the database
and that only
Julia can grant users and groups access to SQL Server and the
corporate
database?How must role membership be changed to meet these
requirements?
(Chose three)
A. Add Julia to the serveradmin role.
B. Remove Carlos from db_accessadmin role.
C. Remove Julia from db_securityadmin role.
D. Add Julia to the db_accessadmin role.
E. Add Katrin to the db_securityadmin role.
F. Add Katrin to the db_accessadmin role.
G. Remove Carlos from the setupadmin role
Aw: B,C,F
25) You need to provide access to the Sales database for internet
users
who do not have Window NT accounts.
How cna you provide access? (Choose all that apply)
A. Add a guest user account to the Sales database, and grant the
guest
user account the appropriate permissions in the Sales database.
B. Create a SQL Server login for internet guest access.
C. Add the Windows NT Domain users account to the SQL Server
public role
in the Sales database.
D. Grand the Windows NT Guest account access to SQL Server.
Aw: A,B
26). You are developing security strategy for a new installation
of SQL. You
want to minimize the administration required of login. What
should you do?
A. Use Windows NT Authentication
Add Windows NT accounts as SQL Server login.
B. Use Windows NT Authentication
Add Windows NT groups as SQL Server login.
C. Use SQL Server Authentication
Add SQL Server login for authorized users
D. Use SQL Server Authentication.
Add Windows NT accounts as SQL Server login.
Aw: B
27). 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
28) 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
29) A database of one table, 5,000 bytes per row, totally 100,000
rows, size of
data file is:
D) 800M, because one row cannot expand across pages.
Aw: D
30) You have a DB of 25GB in size and want to install it on a new
PC with five
disks of 18.2GB each. You want high disk performance and you want
fault
tolerance. How to set up this PC?
a) Set up a hardware RAID 0 on all five disks, then install
everything there.
b) Set up a software RAID 5 on all five disks, then install
everything there.
c) Install NT & SQL to C:. Make D: and E: a software RAID 1 and
install DB
there. Make F: and G: a software RAID 1, too, and install
transact log there.
d) Set up software RAID 1 on F and G and place the transaction
logs there.
Make hardware RAID 5 out of C, D, and E and install everything
else there,
including the databases
Aw: D
31) Stephen tries to connect to tho Salesdtabase by using
Enterpris Manager.
He receives the massage "Unable to open default database<ID>".
You notice
that neither Stephen nor guest account was granted access to the
Sales
database.
What must you do to give only Stehpen access with tho minimum
permissions?
A. Remove Stephens account from the db_danydatareader and
db-.danydatawriter roles.
B. Add Stephen login as a new user in the Sales database.
C. Change the default database in Stephen- login properties
dialog box.
D. Add tho gues account to the Sales database in the database
users dialog
box.
Aw: B
32) You have installes Windows NT Server with the dafualts. You
are going to
have Windows 95 and Netware clients. What else must you do befor
you install
SQL server?
A) Install Windows NT service pack 4
B) Install Internet Explorer 4.01 with service pack 1
C) Install gateway Service for Netware
D) Install NWLink IPX/SPX
E) Install TCP/IP
F) Install the Option Pack
Aw: A,B,D
33) Laura is the new sales coordinator for your company. She will
process all
orders. You want Laura to be able to
modify the order database only through the order applications.
How should you
control access to the order
database?
A. Use a stored procedure the Laura has permission to execute
B. Use a User-defined application role that has UPDATE permission
on the order
database.
C. Use SQL Server user account that has UPDATE permission on the
order
database.
D. Use a view of the Order database in which Laura has UPDATE
permission on
the Order database.
Aw: B
34) The size of your database has increased and you want to
examine
performance statistics in specific database objects. The original
SQL Trace file
was saved to a table. How should you replay the trace one step at
a time.
a.) Query the trace table for the event classes, and create a
trace definition file
that uses those events.
b.) In SQL Server Profiler, open the trace table, save it to a
file and replay the
trace one step at a time.
c.) In SQL Server Profiler, open the trace table and replay the
trace one step at
a time.
d.) In SQL Server Profiler, import the trace and replay the trace
one step at a
time.
Aw: C
35)You want to maintain the accuracy and performance of the Full
Text index and
you want to minimize the overhead assotiated with the
maintenance. What
should you do?
a.) expand databases to accommodate furure growth of the Full
Text indexes
b.) backup the Full Text indexes
c.) schedule regular repopulation of the Full Text indexes
d.) schedule regular rebuilds of the Full Text indexes
e.) create Triggers to automaticaly repopulate the
correspondending Full Text
indexes whenever data modification occures
Aw: C
36) The departmental server has Full Text search implemented on
it"s SQL Server
database. Currently both the Full Text database and the database
files reside on
the same logical drive. You do not want the Full Text indexing to
use more than
25% of the available drive space because you want to allow space
for dynamic
expansion of the data files. You want to be able to remotely
monitor the
ammount of space in use by the catalogs. How should you remotly
monitor the
space usage with a minimum number of additional administrative
steps?
a.) Use the Windows NT Performance Monitor to connect to the
Server and to
monitor the size of the Microsoft Search catalog
b.) Create a scheduled job to regulary monitor the size of the
Full Text indexes
and send the result to your E-Mail address.
c.) Create a batch file to monitor the size of the Full Text
indexes and send the
result to you via Network Message. Use the Windows NT Scheduler
Service to
schedule the batch file to run regulary
d.) Create a batch file to monitor the size of the Full Text
indexes and send the
result to you via Network Message. Create a scheduled job to run

the batch file
regulary
Aw: B
37) You need to setup SQL Server security to base access for two
applications.
The applications are named Payroll and Sales. Two types of users
in the Payroll
application. Those who can modify data and those who can only
query on
existing data. There is only one type of users in the Sales
application. Those
who can both modify and query on existing data. What should you
do to setup
security access to the table?
a.) Create a single application role. Grant permissions for the
role for each type
of access to the Payroll application. Grant permissions for the
role for the single
type of access to the Sales application.
b.) Create one application role for each application. Grand
permissions on each
role with different passwords.
c.) Create two application roles for the Payroll application and
grant permissions
on each role for each type of access. Create one application role
for the Sales
application and grant permissions to the role for the single type
of access.
d.) Create two application roles for the Payroll application and
grant permissions
on each role for each type of access. Create one application role
for the Sales
application and grant all users of the sales application the same
permissions.
Aw: C
38) You want export data from a temp tabel #tempdb with bcp, but
it does not
work. bcp #tempdb..table out c:tempfiel.txt -n -Sserver -Uuser
-Ppassword
A) temfiel.txt does not exist
B) you have native format and not the textformat (-c)
C) bcp cannot export data from the tempdb
D) can"t remember
Aw: B
39) A company operates N stores. Each store keeps thier own SQL
sever and tracks only their own customers. Central office need
information from all stores. Central office personel occasionaly
changes data in stores tables. Central office need data locally
for application.
What kind of replication You will use?
A) Snapshot with blah-blah-blah
B) Transactional with Central Publisher/Multiple Subscribers
C) Transactional with Multiple Publishers/Multiple Subscribers
D) Merge with Multiple Publishers/Multiple Subscribers
Aw: B
39) Consider the following time line:
8:00 Backup starts
8:01 Jan enters order 84 for customer 10, whose name in the
database is Bill
Smith
8:11 Transaction for order 84 is committed
8:12 Backup finishes
8:14 Joan changes the name for customer 10 to James Jones.
Transaction is
committed
8:30 Media fails for database
8:40 Database is restored from 8:00 backup
What is the state of the order 84 and customer 10?
a) Order 84 is not in the database
b) Order 84 is in the database for Customer 10 whose name is Bill
Smith
c) Order 84 is in the database for Customer 10 whose name is
James Jones
Aw: C
40) You place the distribution database on the publication
for replication. You then decide to use the distribution
db that is located on the remote server.
What must you do to enable your publication to use the
distribution database that is on the remote server?
A. Using SQL server Enterprise Manager, drag the publication
to the distribution database on the remote server.
B. Disable the current publication and enable a new
publication to use the distributor database on the remote
server. Recreate all publication and subcribers.
C. Configure the current publication to use the distributor
database on the remote server.
D. Back up the current distribution database and restore the
backup to the distribution database on the remote server.
Ans : B
41) 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
42) You want to transfer a data


收藏到ViVi   收藏此页到365Key
上一篇： 我装Oracle8i for linux的痛苦7天之最终版
下一篇： MCSE2000--sql admin(2)