510-026 Sybase,Inc Certification Braindump
ExamSoon 510-026 Exams
Sybase, Inc Sybase ASE SQL Developer Professional Exam (Version 45.0)
O rder : 510-026 Exam
Practice Exam: 510-026
Exam Number/Code: 510-026
Exam Name: Sybase ASE SQL Developer Professional Exam (Version 45.0)
Questions and Answers: 120 Q&As
Free 510-026 Braindumps
Exam : Sybase 510-026
Title : Sybase ASE SQL Developer Professional Exam (Version 15.0)
1. Which of the following are TRUE about the cursor fetch statement? (Choose 2)
A. The row number starts at 0.
B. If fetch behavior is not specified, the next row is assumed by default.
C. For a scrollable cursor, @@rowcount cannot exceed the total number of rows in the result set.
D. @@fetch_status=0 implies the last fetch was successful.
Answer: BD
2. Locks escalate from (Choose 2)
A. latch to page.
B. latch to row.
C. page to table.
D. row to page.
E. row to table.
Answer: CE
3. Metrics capture gives the administrator the ability to see which query performed (Choose 2)
A. the most physical I/O.
B. the least logical I/O.
C. a table scan.
D. a clustered index scan.
E. large I/O.
Answer: AB
4. Which of the following structures can be used to enforce entity integrity? (Choose 2)
A. Trigger
B. sp_primarykey
C. Check constraint
D. References constraint
E. Primary key constraint
Answer: AE
5. What methods are available to enforce entity integrity?
A. check constraints
B. primary key constraints
C. reference constraints
D. rules
Answer: B
6. Which function measures the amount of change in the data distribution since update statistics?
A. data_pages
B. count
C. datachange
D. used_pgs
Answer: C
7. In which of the following partition types is data distributed in order of operation?
A. hash
B. range
C. list
D. round robin
Answer: D
8. The allrows_oltp optimization goal considers
A. bushy trees.
B. hash joins.
C. merge joins.
D. nested loop joins.
E. parallelism.
F. all optimization methods.
Answer: D
9. An operator tree is displayed as a result of which command?
A. set showplan on
B. set optio