Sybase Certification Questions And Answers

1⟩ If sp_sysmon output consistently shows a high number of VoluntaryYields, which configuration parameter could be modified to improve performance?A. user log cache sizeB. time sliceC. identity grab sizeD. stack sizeE. cpu accounting flush interval

B. time slice

Is this answer helpful? 0 Yes | 0 No

Answer This Question

228 views

2⟩ Explain What is the maximum number of tables allowed in a join query?A. 50 User tables and 14 work tablesB. 32 User tables and 14 work tablesC. 30 User tables and 12 work tablesD. 16 User tables and 12 work tables

A. 50 User tables and 14 work tables

Is this answer helpful? 0 Yes | 0 No

Answer This Question

213 views

3⟩ How to reclaim space from a fragmented allpages heap table?A. run reorg commandB. dump and load the databaseC. create and drop a clustered indexD. truncate the least used pages

C. create and drop a clustered index

Is this answer helpful? 0 Yes | 0 No

Answer This Question

215 views

4⟩ Explain Which of the following cache or IO tuning methods can reduce the spinlockcontention on a single "hot" table that is already bound to a named cache?A. Create 16K buffer pool in the named cacheB. Change the cache replacement strategy of the named cache to relaxed LRUC. Partition the named cacheD. Increase the named cache size

C. Partition the named cache

Is this answer helpful? 0 Yes | 0 No

Answer This Question

229 views

5⟩ Explain Which of the following operations require "quiesce database"?A. altering the database to a new sizeB. performing non-Sybase unmirroring and backup operations.C. truncating the transaction logD. dumping the database using Sybase Backup Server.

B. performing non-Sybase unmirroring and backup operations.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

248 views

6⟩ Explain The reorg command may be used to (Choose 2)A. Compact a table that uses 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.

A. Compact a table that uses datarows locking.

C. Reclaim unused space in an index that uses datapages locking.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

210 views

7⟩ Explain Which of the following create table can prevent or minimize rowforwarding in DOL tables?A. fillfactorB. max_rows_per_pageC. exp_row_sizeD. reservepagegap

C. exp_row_size

Is this answer helpful? 0 Yes | 0 No

Answer This Question

205 views

8⟩ Do you know Transaction Isolation Level 2 is directly supported in the following lockscheme(s)A. AllpagesB. Allpages, DatapagesC. Allpages, Datapages, DatarowsD. Datapages, Datarows

D. Datapages, Datarows

Is this answer helpful? 0 Yes | 0 No

Answer This Question

201 views

9⟩ Explain What is the purpose of dsync flag?A. to synchronize primary and mirrored devicesB. to synchronize primary and secondary databasesC. to control whether writes to operating system files are buffered or notD. to control Backup Servers access to a dump device

C. to control whether writes to operating system files are buffered or not

Is this answer helpful? 0 Yes | 0 No

Answer This Question

213 views

10⟩ Explain Which ASE commands or utilities can be used to examine partition skew?(Choose 2)A. sp_helpdbB. sp_helpartitionC. sp_helpD. optdiagE. reorg

B. sp_helpartition

C. sp_help

Is this answer helpful? 0 Yes | 0 No

Answer This Question

215 views

11⟩ Suppose Given FREDs login is assigned EC2. When he uses a stored procedurebound to EC3 his scheduling priority isA. highB. mediumC. lowD. unable to be determined

B. medium

Is this answer helpful? 0 Yes | 0 No

Answer This Question

201 views

12⟩ Explain When you run optdiag command on a allpages-locked table with 1000pages, what will be value of "Forwarded row count"?A. 1000B. 500C. 0D. 1

C. 0

Is this answer helpful? 0 Yes | 0 No

Answer This Question

229 views

13⟩ Parallel sorting can be used for (Choose 3)A. Sort Merge joinsB. slow bcpC. ReformattingD. Creating indexesE. reorg compact

A. Sort Merge joins

C. Reformatting

D. Creating indexes

Is this answer helpful? 0 Yes | 0 No

Answer This Question

233 views

14⟩ Do you know What is the maximum number of key columns allowed in an index?A.16B. 31C. 32D. 63

B. 31

Is this answer helpful? 0 Yes | 0 No

Answer This Question

220 views

15⟩ Do you know The reorg command may be used to (Choose 2)A. Compact a table that uses 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.

A. Compact a table that uses datarows locking.

C. Reclaim unused space in an index that uses datapages locking.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

210 views

16⟩ Explain When does the optimizer consider a hash based table scan on an APL table?A. if it is a heap tableB. if it is has a clustered indexC. If it is a table with a clustered index and a non clustered indexD. If it is a partitioned table with a clustered index

A. if it is a heap table

Is this answer helpful? 0 Yes | 0 No

Answer This Question

197 views

17⟩ Explain Which of the following are true of the Datarows Locking Scheme? (Choose2)A. Index pages are locked.B. No transaction locks are held on index pages.C. Server uses page locks and row locks, but not table locks.D. Server uses table locks and row locks, but not page locks.

B. No transaction locks are held on index pages.

D. Server uses table locks and row locks, but not page locks.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

246 views

18⟩ Explain Which of the following steps is NOT always necessary for performing atuning benchmark?A. record a baseline measurementB. change one variable, holding all others constantC. make a new measurementD. restart Adaptive Server

D. restart Adaptive Server

Is this answer helpful? 0 Yes | 0 No

Answer This Question

212 views

19⟩ Which of the following operations require "quiesce database"?A. altering the database to a new sizeB. performing non-Sybase unmirroring and backup operations.C. truncating the transaction logD. dumping the database using Sybase Backup Server.

B. performing non-Sybase unmirroring and backup operations.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

227 views

20⟩ Which of the following can NOT have an assigned execution classA. databaseB. A stored procedureC. An applicationD. A login

A. database

Is this answer helpful? 0 Yes | 0 No

Answer This Question

226 views

Sybase Certification

Home Certifications Sybase Certification

32 Sybase Certification Questions And Answers

1⟩ If sp_sysmon output consistently shows a high number of VoluntaryYields, which configuration parameter could be modified to improve performance?A. user log cache sizeB. time sliceC. identity grab sizeD. stack sizeE. cpu accounting flush interval

2⟩ Explain What is the maximum number of tables allowed in a join query?A. 50 User tables and 14 work tablesB. 32 User tables and 14 work tablesC. 30 User tables and 12 work tablesD. 16 User tables and 12 work tables

3⟩ How to reclaim space from a fragmented allpages heap table?A. run reorg commandB. dump and load the databaseC. create and drop a clustered indexD. truncate the least used pages

5⟩ Explain Which of the following operations require "quiesce database"?A. altering the database to a new sizeB. performing non-Sybase unmirroring and backup operations.C. truncating the transaction logD. dumping the database using Sybase Backup Server.

6⟩ Explain The reorg command may be used to (Choose 2)A. Compact a table that uses 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.

7⟩ Explain Which of the following create table can prevent or minimize rowforwarding in DOL tables?A. fillfactorB. max_rows_per_pageC. exp_row_sizeD. reservepagegap

8⟩ Do you know Transaction Isolation Level 2 is directly supported in the following lockscheme(s)A. AllpagesB. Allpages, DatapagesC. Allpages, Datapages, DatarowsD. Datapages, Datarows

9⟩ Explain What is the purpose of dsync flag?A. to synchronize primary and mirrored devicesB. to synchronize primary and secondary databasesC. to control whether writes to operating system files are buffered or notD. to control Backup Servers access to a dump device

10⟩ Explain Which ASE commands or utilities can be used to examine partition skew?(Choose 2)A. sp_helpdbB. sp_helpartitionC. sp_helpD. optdiagE. reorg

11⟩ Suppose Given FREDs login is assigned EC2. When he uses a stored procedurebound to EC3 his scheduling priority isA. highB. mediumC. lowD. unable to be determined

12⟩ Explain When you run optdiag command on a allpages-locked table with 1000pages, what will be value of "Forwarded row count"?A. 1000B. 500C. 0D. 1

13⟩ Parallel sorting can be used for (Choose 3)A. Sort Merge joinsB. slow bcpC. ReformattingD. Creating indexesE. reorg compact

14⟩ Do you know What is the maximum number of key columns allowed in an index?A.16B. 31C. 32D. 63

15⟩ Do you know The reorg command may be used to (Choose 2)A. Compact a table that uses 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.

16⟩ Explain When does the optimizer consider a hash based table scan on an APL table?A. if it is a heap tableB. if it is has a clustered indexC. If it is a table with a clustered index and a non clustered indexD. If it is a partitioned table with a clustered index

17⟩ Explain Which of the following are true of the Datarows Locking Scheme? (Choose2)A. Index pages are locked.B. No transaction locks are held on index pages.C. Server uses page locks and row locks, but not table locks.D. Server uses table locks and row locks, but not page locks.

18⟩ Explain Which of the following steps is NOT always necessary for performing atuning benchmark?A. record a baseline measurementB. change one variable, holding all others constantC. make a new measurementD. restart Adaptive Server

19⟩ Which of the following operations require "quiesce database"?A. altering the database to a new sizeB. performing non-Sybase unmirroring and backup operations.C. truncating the transaction logD. dumping the database using Sybase Backup Server.

20⟩ Which of the following can NOT have an assigned execution classA. databaseB. A stored procedureC. An applicationD. A login

Quick Links:

Sybase Certification

Home Certifications Sybase Certification

32 Sybase Certification Questions And Answers

1⟩ If sp_sysmon output consistently shows a high number of VoluntaryYields, which configuration parameter could be modified to improve performance?A. user log cache sizeB. time sliceC. identity grab sizeD. stack sizeE. cpu accounting flush interval

2⟩ Explain What is the maximum number of tables allowed in a join query?A. 50 User tables and 14 work tablesB. 32 User tables and 14 work tablesC. 30 User tables and 12 work tablesD. 16 User tables and 12 work tables

3⟩ How to reclaim space from a fragmented allpages heap table?A. run reorg commandB. dump and load the databaseC. create and drop a clustered indexD. truncate the least used pages

5⟩ Explain Which of the following operations require "quiesce database"?A. altering the database to a new sizeB. performing non-Sybase unmirroring and backup operations.C. truncating the transaction logD. dumping the database using Sybase Backup Server.

6⟩ Explain The reorg command may be used to (Choose 2)A. Compact a table that uses 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.

7⟩ Explain Which of the following create table can prevent or minimize rowforwarding in DOL tables?A. fillfactorB. max_rows_per_pageC. exp_row_sizeD. reservepagegap

8⟩ Do you know Transaction Isolation Level 2 is directly supported in the following lockscheme(s)A. AllpagesB. Allpages, DatapagesC. Allpages, Datapages, DatarowsD. Datapages, Datarows

9⟩ Explain What is the purpose of dsync flag?A. to synchronize primary and mirrored devicesB. to synchronize primary and secondary databasesC. to control whether writes to operating system files are buffered or notD. to control Backup Servers access to a dump device

10⟩ Explain Which ASE commands or utilities can be used to examine partition skew?(Choose 2)A. sp_helpdbB. sp_helpartitionC. sp_helpD. optdiagE. reorg

11⟩ Suppose Given FREDs login is assigned EC2. When he uses a stored procedurebound to EC3 his scheduling priority isA. highB. mediumC. lowD. unable to be determined

12⟩ Explain When you run optdiag command on a allpages-locked table with 1000pages, what will be value of "Forwarded row count"?A. 1000B. 500C. 0D. 1

13⟩ Parallel sorting can be used for (Choose 3)A. Sort Merge joinsB. slow bcpC. ReformattingD. Creating indexesE. reorg compact

14⟩ Do you know What is the maximum number of key columns allowed in an index?A.16B. 31C. 32D. 63

15⟩ Do you know The reorg command may be used to (Choose 2)A. Compact a table that uses 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.

16⟩ Explain When does the optimizer consider a hash based table scan on an APL table?A. if it is a heap tableB. if it is has a clustered indexC. If it is a table with a clustered index and a non clustered indexD. If it is a partitioned table with a clustered index

17⟩ Explain Which of the following are true of the Datarows Locking Scheme? (Choose2)A. Index pages are locked.B. No transaction locks are held on index pages.C. Server uses page locks and row locks, but not table locks.D. Server uses table locks and row locks, but not page locks.

18⟩ Explain Which of the following steps is NOT always necessary for performing atuning benchmark?A. record a baseline measurementB. change one variable, holding all others constantC. make a new measurementD. restart Adaptive Server

19⟩ Which of the following operations require "quiesce database"?A. altering the database to a new sizeB. performing non-Sybase unmirroring and backup operations.C. truncating the transaction logD. dumping the database using Sybase Backup Server.

20⟩ Which of the following can NOT have an assigned execution classA. databaseB. A stored procedureC. An applicationD. A login

BE THE FIRST TO KNOW

Quick Links: