21⟩ Suppose A query and any views in a query can reference how many user tables?A. 12B. 16C. 32D. 50E. 192
D. 50
Sybase Certification
Home Certifications Sybase Certification
“Sybase Certification Exams Frequently Asked Questions in various Sybase Certification Exams Interviews asked by the interviewer. So learn Sybase Certification Exams with the help of this Sybase Certification Exams Interview questions and answers guide and feel free to comment as your suggestions, questions and answers on any Sybase Certification Exams Interview Question or answer by the comment feature available on the page.”
32 Sybase Certification Questions And Answers
22⟩ Do you know 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
23⟩ Explain Which of the following statements describes readpast locking? (Choose 2)A. It can be specified at the session, transaction, and table level.B. It allows insert, update, and delete commands to read past any incompatible lock.C. It allows readers to not block writers.D. It allows select and readtext queries to silently skip all rows or pages locked with incompatible locks.
B. It allows insert, update, and delete commands to read past any incompatible lock.
D. It allows select and readtext queries to silently skip all rows or pages locked with incompatible locks.
24⟩ Can you explain What is the maximum row size for DOL tables?A. 1024 bytes of data.B. 1958 bytes of data.C. 1962 bytes of data.D. 2000 bytes of data.
B. 1958 bytes of data.
25⟩ Can you explain Which two are advantages of use max_rows_per_page to reduce the rowdensity? (Choose 2.)A. It may decrease the disk space used.B. It may decrease the contention.C. It may decrease the number of page splits.D. It may decrease the number of page I/Os.E. It may help to decrease row movement of frequently updated varchar columns.
B. It may decrease the contention.
E. It may help to decrease row movement of frequently updated varchar columns.
26⟩ Where are table/index level statistics stored?A. sysstatisticsB. systabstatsC. On the leaf level of the indexD. The GAM pageE. The distribution page
B. systabstats
27⟩ Explain Which of the following can NOT have an assigned execution classA. databaseB. A stored procedureC. An applicationD. A login
A. database
28⟩ Suppose All of the following tactics may reduce contention for cache spinlocks in anASE configured to support multiple online engines, exceptA. Increasing the spinlock ratioB. Creating additional named caches and binding frequently used tables to themC. Creating partitions in heavily used cachesD. Returning to a single engine configuration
A. Increasing the spinlock ratio
29⟩ Suppose The titles table has 50,000 rows and a nonclustered index on the pricecolumn. Which of the following queries use less logical I/Os?A. select "Min" = min(price), "Max" = max(price) from titlesB. select "Min" = (select min(price) from titles), "Max" = (select max(price) from titles)C. They will both use the same number of I/Os
B. select "Min" = (select min(price) from titles), "Max" = (select max(price) from titles)
30⟩ Explain What are some ways to reduce last data page lock contention for inserts?(Choose 3)A. alter the table to use the Datarows locking schemeB. alter the table to use the Datapages locking schemeC. partition the tableD. create a clustered index on a random keyE. increase the server configuration for the number of locksF. increase the server configuration for the deadlock checking period
A. alter the table to use the Datarows locking scheme
C. partition the table
D. create a clustered index on a random key
31⟩ Do you know What type of access method is used for a covered query?A. parallel index scanB. serial index scanC. hash based index scanD. hash based table scan
B. serial index scan
32⟩ Explain Where are table/index level statistics stored?A. sysstatisticsB. systabstatsC. On the leaf level of the indexD. The GAM pageE. The distribution page
B. systabstats
