Braindumps of 510-022
Sybase Certified ASE 12.5 Administrator Professional
Exam Questions, Answers, Braindumps (S10-002)
This braindump is provided with ratings from different
students. I used www.examcheats.net study material and
the exam was not a problem for me.
Which ASE features can be used to determine the temporary
database assigned to a session other than your own?
A. The global variable @@tempdbid
B. The built-in function tempdb_id()
C. The commain #bcc pravailabletempdb
D. Sp_tempdb, with the @how?subcommand
E. Sp_tempdb, with the #ho?subcommand
Answer: B, E
Which of the following statements about update statistics
behavior are true in ASE? (Choose two)
A. Using sampled statistics can improve the concurrency
of update statistics
B. Using sampled statistics can improve the accuracy
C. Using sampled statistics can improve the response
time of update statistics
D. Update statistics can be run on a subset of data,
expressed as a percentage
E. Update statistics can be run on a subset of data,
expressed as a number of rows.
Answer: C, D
The improved recovery feature requires:
A. No additional configuration
B. #Umber of chackpoint tasks?1
C. user configured large IO buffer pool
D. #ax concurrently recovered db?>1
What will happen immediately after you reload the master
database from a backup?
A. All databases will be offline
B. ASE will shut down
C. The sa login will be locked
D. The server will switch from single from single-user
to normal mode
What is the default for Recovery Fault isolation offline
A master device failure has occurred which requires
the creation of a new master device. Which program must
you execute to build it?
What is the purpose of the disk reinit command when
restoring a failed master database?
A. Drop and recreate devices with the new page ranges
B. Drop and recreate devices with previous page ranges
C. Restore lost sysdevices entries with new page ranges
D. Restore lost sysdevices entries with previous page
E. Restore lost sysdevices entries with new segment
F. Restore lost sysdevices entries with previous segment
The master device is broken and you have no backup of
the master database. All other devices appear healthy.
Which of the following commands will be helpful to you
in this scenario? (Choose three)
A. disk init
B. disk refit
D. disk reinit
E. dataserver # #
Answer: B, C, E
Which of the following can be used to drop a corrupt
or suspect database?
A. reorg rebuild
B. dbcc dbrepair
C. drop database
Which of the following statements about indexes are
true? (Choose two)
A. sp_fixindex is used to drop corrupted indexes on
B. duplicate keys can cause overflow pages in clustered
C. duplicate keys can cause overflow pages in clustered
D. sp_fixindex is used to repair corrupted indexes on
E. sp_fixindex is used to drop corrupted indexes on
F. sp_fixindex is used to repair corrupted indexes on
Answer: D, E.