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
 
Hurst
 
 

 

Braindumps of 510-015
Adaptive Server Administrator Professional

 

Exam Questions, Answers, Braindumps (510-015)
Submitting dumps with some changes. The original is also available in www.braindumps.org


QUESTION 1
The ACME company has an 8 CPU SMP system running Adaptive Enterprise (ASE). The ASE server has been allocated 1.5 GB of 2.0 GB of memory available. The ASE server has been allocated 2 enginess. There are 1,000 concurrent users of the ASE server. The sp_sysmon report shoes the spinlock contention rate averages 70-80% for the default data cache. Which steps can be taken to correct this performance problem?
A. Add a 16KB buffer pool to the server.
B. Increase the size of the tempdb database.
C. Add two engines to the ASE server.
D. Add named caches to and bind the appropriate objects to the named caches.
E. Add more locks to the server.
Answer: D
QUESTION 2
What is the purpose of dsync flag?
A. to synchronize primary and mirroed devices.
B. to synchronize primary and secondary databases.
C. to control whether writes to operating system files are buffered or not.
D. to control Backup Server's access to a dump device.
Answer: c
QUESTION 3
All of the following execution class associations exist in the ASE when user FRED, running application ctisql, logs in. Which one will be applied to FREDs session?
A. sp_bindexeclass ctisql,AP,NULL,EC1
B. sp_bindexeclass ctisql,AP,FRED,EC2
C. sp_bindexeclass FRED,LG,NULL,EC1
D. sp_bindexeclass FRED,LG,ctisql,EC2
E. It depends on the order of the creations of the bindings
Answer: B
QUESTION 4
The reorg command may be used to:(Choose 2)
A. Compact a table that users datarows locking
B. Reclaim unused space in a table that uses allpages locking
C. Reclaim unused space in an index that uses datapages locking
D. Rebuild a table that uses allpages locking
Answer: A , C
QUESTION 5
What are some ways to reduce last data page lock contention for inserts?(Choose 3)
A. alter the table to use the Datarows locking scheme
B. alter the table to use the Datapages locking scheme
C. partition the table
D. create a clustered index on a random key
E. increase the server configuration for the number of locks
F.increase the server configuration for the deadlock checking peroid
Answer: A, C , D
QUESTION 6
What are some ways to reduce last data page lock contention for inserts?(Choose 3)
A. alter the table to use the Datarows locking scheme
B. alter the table to use the Datapages locking scheme
C. partition the table
D. create a clustered index on a random key
E. increase the server configuration for the number of locks
F.increase the server configuration for the deadlock checking period
Answer: A, C, , D
QUESTION 7
An application uses stored procedures to perform updates, inserts and deletes for an OLTP application. Some update stored procedures optimize with a join order of table_A->table_B. Other stored procedures optimize with a join order of table_B-> table_ A. Which solutions needs to be added within the stored procedures to guarantee that deadlocks are reduced or eliminated by always making the join order table _A-> table_B?
A. Non-correlated subqueries to force outside-in processing
B. SET FORCEPLAN ON
C. (index tableorder 1)- an index hint applied to table_A
D. SET SHOWPLAN ON
E. Define join-ordered Views on the affected tables
Answer: B
QUESTION 8
Increasing the number of pre-allocated extents to 16 is likely to help the performance of which of the following operations?
A. index creation
B. bcp in
C. select into
D. alter table lock datarows
E. dbcc checkstorage
Answer: B

S10-015


 

 

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