Sybase Certification Exam Interview Preparation Guide Download PDF
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:
Table of Contents:
1 :: Explain Which ASE commands or utilities can be used to examine partition skew?
(Choose 2)
A. sp_helpdb
B. sp_helpartition
C. sp_help
D. optdiag
E. reorg
B. sp_helpartition
C. sp_help
C. sp_help
4 :: Do you know What is the maximum number of key columns allowed in an index?
A.16
B. 31
C. 32
D. 63
B. 31
5 :: Parallel sorting can be used for: (Choose 3)
A. Sort Merge joins
B. slow bcp
C. Reformatting
D. Creating indexes
E. reorg compact
A. Sort Merge joins
C. Reformatting
D. Creating indexes
C. Reformatting
D. Creating indexes
6 :: 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.
C. Reclaim unused space in an index that uses datapages locking.
7 :: Explain Which of the following are true of the Datarows Locking Scheme? (Choose
2)
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.
D. Server uses table locks and row locks, but not page locks.
9 :: 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
11 :: 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.
14 :: 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
15 :: 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.
D. It allows select and readtext queries to silently skip all rows or pages locked with incompatible locks.
16 :: 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.
E. It may help to decrease row movement of frequently updated varchar columns.
17 :: 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.
18 :: 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
21 :: 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)
22 :: 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
C. partition the table
D. create a clustered index on a random key