Sybase Certification Exam Interview Questions And Answers
Download Sybase Certification Interview Questions and Answers PDF
Strengthen your Sybase Certification interview skills with our collection of 32 important questions. These questions are specifically selected to challenge and enhance your knowledge in Sybase Certification. Perfect for all proficiency levels, they are key to your interview success. Secure the free PDF to access all 32 questions and guarantee your preparation for your Sybase Certification interview. This guide is crucial for enhancing your readiness and self-assurance.
32 Sybase Certification Questions and Answers:
Sybase Certification Job Interview Questions Table of Contents:
1 :: Explain Where are table/index level statistics stored?
A. sysstatistics
B. systabstats
C. On the leaf level of the index
D. The GAM page
E. The distribution page
B. systabstats
Read More2 :: Explain What is the purpose of dsync flag?
A. to synchronize primary and mirrored 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 Servers access to a dump device
C. to control whether writes to operating system files are buffered or not
Read More3 :: 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.
Read MoreC. Reclaim unused space in an index that uses datapages locking.
4 :: Explain Which of the following operations require "quiesce database"?
A. altering the database to a new size
B. performing non-Sybase unmirroring and backup operations.
C. truncating the transaction log
D. dumping the database using Sybase Backup Server.
B. performing non-Sybase unmirroring and backup operations.
Read More5 :: Explain What is the maximum number of tables allowed in a join query?
A. 50 User tables and 14 work tables
B. 32 User tables and 14 work tables
C. 30 User tables and 12 work tables
D. 16 User tables and 12 work tables
A. 50 User tables and 14 work tables
Read More6 :: Explain Which of the following cache or IO tuning methods can reduce the spinlock
contention on a single "hot" table that is already bound to a named cache?
A. Create 16K buffer pool in the named cache
B. Change the cache replacement strategy of the named cache to relaxed LRU
C. Partition the named cache
D. Increase the named cache size
C. Partition the named cache
Read More7 :: Explain Which of the following create table can prevent or minimize row
forwarding in DOL tables?
A. fillfactor
B. max_rows_per_page
C. exp_row_size
D. reservepagegap
C. exp_row_size
Read More8 :: How to reclaim space from a fragmented allpages heap table?
A. run reorg command
B. dump and load the database
C. create and drop a clustered index
D. truncate the least used pages
C. create and drop a clustered index
Read More9 :: Do you know Transaction Isolation Level 2 is directly supported in the following lock
scheme(s):
A. Allpages
B. Allpages, Datapages
C. Allpages, Datapages, Datarows
D. Datapages, Datarows
D. Datapages, Datarows
Read More10 :: If sp_sysmon output consistently shows a high number of Voluntary
Yields, which configuration parameter could be modified to improve performance?
A. user log cache size
B. time slice
C. identity grab size
D. stack size
E. cpu accounting flush interval
B. time slice
Read More11 :: 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 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
A. alter the table to use the Datarows locking scheme
C. partition the table
D. create a clustered index on a random key
Read MoreC. partition the table
D. create a clustered index on a random key
12 :: Suppose The titles table has 50,000 rows and a nonclustered index on the price
column. Which of the following queries use less logical I/Os?
A. select "Min" = min(price), "Max" = max(price) from titles
B. 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)
Read More13 :: Suppose All of the following tactics may reduce contention for cache spinlocks in an
ASE configured to support multiple online engines, except
A. Increasing the spinlock ratio
B. Creating additional named caches and binding frequently used tables to them
C. Creating partitions in heavily used caches
D. Returning to a single engine configuration
A. Increasing the spinlock ratio
Read More14 :: Explain Which of the following can NOT have an assigned execution class
A. database
B. A stored procedure
C. An application
D. A login
A. database
Read More15 :: Do you know What type of access method is used for a covered query?
A. parallel index scan
B. serial index scan
C. hash based index scan
D. hash based table scan
B. serial index scan
Read More16 :: 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.
Read More17 :: Can you explain Which two are advantages of use max_rows_per_page to reduce the row
density? (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.
Read MoreE. It may help to decrease row movement of frequently updated varchar columns.
18 :: 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.
Read MoreD. It allows select and readtext queries to silently skip all rows or pages locked with incompatible locks.
19 :: Do you know What is the purpose of dsync flag?
A. to synchronize primary and mirrored 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 Servers access to a dump device
C. to control whether writes to operating system files are buffered or not
Read More20 :: Suppose A query and any views in a query can reference how many user tables?
A. 12
B. 16
C. 32
D. 50
E. 192
D. 50
Read More21 :: Where are table/index level statistics stored?
A. sysstatistics
B. systabstats
C. On the leaf level of the index
D. The GAM page
E. The distribution page
B. systabstats
Read More22 :: Which of the following operations require "quiesce database"?
A. altering the database to a new size
B. performing non-Sybase unmirroring and backup operations.
C. truncating the transaction log
D. dumping the database using Sybase Backup Server.
B. performing non-Sybase unmirroring and backup operations.
Read More23 :: Which of the following can NOT have an assigned execution class
A. database
B. A stored procedure
C. An application
D. A login
A. database
Read More24 :: Explain Which of the following steps is NOT always necessary for performing a
tuning benchmark?
A. record a baseline measurement
B. change one variable, holding all others constant
C. make a new measurement
D. restart Adaptive Server
D. restart Adaptive Server
Read More25 :: Explain When does the optimizer consider a hash based table scan on an APL table?
A. if it is a heap table
B. if it is has a clustered index
C. If it is a table with a clustered index and a non clustered index
D. If it is a partitioned table with a clustered index
A. if it is a heap table
Read More