70-029 SQL7.0實現
1). Users report slow response times when they are modify data in your application. Response times are Excellent when users are merely retrieving data. The search criteria used for modifying data are the same as the search criteria for retrIEving data.
All transactions are short and follow standard guidelines for coding transactions. You monitor blocking locks, it’s ok.
What is the most likely cause?
A. The transaction log is placed on an otherwise busy disk drive.
B. The transaction log is nearly full
C. The checkpoint process is set too short
D. The tempdb database is too small
E. The tempdb database is on the same physical disk drive as the
database.
Answer: A
2). Database includes a table named experiments that is defined as follows:
CREATE TABLE experiments { experimentid char(32),
description text,
status integer,
results text}
You write the following:
SELECT* from experiments where contains(description, 'angina')
you are certain that there are matching rows, but you receive an empty result set when you run the query.
what should you do?(choose two)
A. ensure that there is a nonunique index on the description column of the experiments table.
B. ensure that there is a clustered index on the results column
experiments table.
C. create a full-text catalog that includes the experiments table.
D. create a scheduled job to populate the full-text catalog.
Answer: C,D
3). Database includes a job_cost table that typically holds 100000 rows but can grow or shrink by as much as 75000 rows at a time. the job_cost table is maintained by a batch job that runs at night.
during the day, the job_cost table is frequently joined to other tables by many different queries. Users report that their initial queries are very slow, but then response time improves for subsequent querIEs.
How should you improve the response time of the initial querIEs?
A. run the sp_updatestats stored procedure as part of the nightly batch
job.
B. run the sp_createstats stored procedure as part of the nightly batch
