English Русский Contacts Site map Add to favorites
Registration
Login
Master braindump list
New braindumps
Submit a dump
Get latest dump
braindumps.com.ua
flame
3COM (7)
Adobe (1)
BEA (1)
Checkpoint (22)
Cisco (20)
Citrix (21)
CIW (15)
Compaq (0)
CompTIA (51)
CWNA (2)
EMC (2)
Exin (4)
GEJOS (4)
HDI (1)
HP (4)
IBM (13)
Juniper (5)
Linux Prof Institute (LPI) (2)
Lotus (11)
Microsoft (2462)
Network Appliance (2)
Novell (16)
Oracle (422)
PLSQL (1)
PMI (4)
SAS (1)
Sun (87)
Teradata (4)
Login:
Password:
RSS feed

Contacts
Certification links
Links
Authorized users can post comments.
Please log in or sign up.

back to list
Back to main forum
Oracle 8i: Performance Tuning 

АвторSubject: Q92
written 18 October 2007 15:13   View profile Jonnik  Edit/Delete  Answer  Answer with quotation
Explanation:
It's better to allocate space explicitly to tables, clusters and indexes in OLTP system to avoid the performance load of dynamic space allocation. B-tree indexing is preferred to bitmap indexes in OLTP systems, because of locking issues affecting DML operations. Most of DML operations related with bitmap indexes will require high-level locking due to low cardinality nature of bitmap indexes and it will cause performance issues because of high level of DML operations in OLTP systems.
Incorrect Answers:

1: OLTP works mostly with bind variables due to nature of OLTP system, so it's impossible to work only with literals.
4: It's not reasonable to use hash clusters for tables with heavy inserts.
5: Constraints are cheaper to process if compare them with business rules in application code.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 793-795. Chapter 18: Tuning Memory and Operating System Use

Current tread:
back to list

Q92 - Go to question 15:13 18.10.07

back to list
Up ^ gen. 0.07 Server date 07:38 08-01-2009 Developed by Zip © 2006 Up ^
Forum
Start online exam simulation
Master braindump
User braindumps
Main forum
Question comments