REAL QUESTIONS SUBMIT MATERIAL ADVERTISE
Braindumps

Microsoft

Cisco

Citrix

CIW

CompTia

CWNA

Apple

Adobe

HP

Legato

Exin

Filemaker

Brocade

Ericsson

TIA

Veritas

ISEB

SCP

IISFA

ISM

OMG

Apc

Mile2

Foundry

Huawei

McData

Symantec

TeraData

RedHat

Solar Winds

Blue Coat

Riverbed

 

 
 
Click on name of dumper to view the dump
 
Nichole Hurst
 
 

 

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.

QUESTION 1
Which ASE features can be used to determine the temporary database assigned to a session other than your own? (Choose two)
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
F. Sp_helpdb
Answer: B, E
QUESTION 2
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 of statistics
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
QUESTION 3
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
Answer: A
QUESTION 4
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
Answer: B
QUESTION 5
What is the default for Recovery Fault isolation offline pages?
A. 16
B. 20
C. 30
D. 32
E. 48
Answer: B
QUESTION 6
A master device failure has occurred which requires the creation of a new master device. Which program must you execute to build it?
A. bcp
B. dataserver
C. buildmaster
D. installmaster
Answer:
QUESTION 7
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 ranges
E. Restore lost sysdevices entries with new segment mappings
F. Restore lost sysdevices entries with previous segment mappings
Answer: D
QUESTION 8
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
C. buildmaster
D. disk reinit
E. dataserver # #
Answer: B, C, E
QUESTION 9
Which of the following can be used to drop a corrupt or suspect database?
A. reorg rebuild
B. dbcc dbrepair
C. drop database
D. sp_dbcc_deletedb
Answer: B
QUESTION 10
Which of the following statements about indexes are true? (Choose two)
A. sp_fixindex is used to drop corrupted indexes on user tables
B. duplicate keys can cause overflow pages in clustered APL tables
C. duplicate keys can cause overflow pages in clustered DOL tables
D. sp_fixindex is used to repair corrupted indexes on user tables
E. sp_fixindex is used to drop corrupted indexes on system tables
F. sp_fixindex is used to repair corrupted indexes on system tables
Answer: D, E.

S10-002


 

 

Braindumps Real exam questions and verified answers - 100% passing guarantee - cheap prices.

 

Free brain dumps Braindumps, notes, books for free

 

Braindumps and Exams - Instant download real exam questions - Passing guarantee.

Follow us on FaceBook
Braindumps on Facebook
 
 
 
 
 

CheckPoint

Linux

Novell

DB/2

Network Appliance

EC-Council

Nortel

McAfee

Juniper

ISACA

PMI

Sybase

EMC

HDI

SNIA

ISC

Sair

IBM

Lotus

Exam Express

3COM

BICSI

DeLL

Enterasys

Extreme Networks

Guidance Software

Computer Associates

Network General

SAS Institute

Alcatel Lucent

SeeBeyond

TruSecure

Polycom

Hyperion

Hitachi

Nokia

Fortinet

Vmware

Fujitsu

Tibco

Intel

PostgreSQLCE

BusinessObjects

RESSoftware

BlackBerry

AccessData

ICDL

Isilon

SAP

The Open Group

ACSM

Altiris

Avaya

Cognos

F5

Genesys

SDI

ACI

ASQ

Google

H3C

HIPAA

HRCI

SOA

IIBA

Zend