Sybase Database Mcq Questions

Sybase Database Mcq Questions contain set of 10 Sybase Database MCQ questions with answers which will help you to clear beginner level quiz.



Q1. Which of the following can NOT have an assigned execution class
A. database
B. A stored procedure
C. An application
D. A login
Answer: A
 
Q2. The “abstract plan language” is:
A. The internal command language used by sp_sysmon.
B. A new type of command language for creating very complicated queries.
C. The language used internally by the server for planning the most efficient use of memory.
D. A language used to tell the optimizer how to process a query.
Answer: D
 
Q3. When a row is deleted on a table with data rows locking:
A. Rows on the page are moved up so the empty space is at the end of the page.
B. The space occupied by the deleted row is not reclaimed immediately.
C. The space occupied by the deleted row is filled with zeros.
D. The last row on the page is moved into the space created by the deleted row.
Answer: B
 
Q4. Which of the following operations require “quiesce database”?
A. altering the database to a new size
B. performing non-Sybase un mirroring and backup operations.
C. truncating the transaction log
D. dumping the database using Sybase Backup Server.
Answer: B
 
Q5. 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
Answer: A
 
Q6. 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.
Answer: B
 
Q7. Which of the following can NOT have an assigned execution class
A. database
B. A stored procedure
C. An application
D. A login
Answer: A
 
Q8. Scheduling priority is a direct attribute of which of the following:
A. Engine Group
B. Execution Class
C. Application
D. Stored procedure
Answer: B
 
Q9. Where are table/index level statistics stored?
A. sysstatistics
B. On the leaf level of the index
C. systabstats
D. The GAM page
Answer: C
 
Q10. Which of the following stored procedures is used to display the current  sessions scheduling and engine affinity properties
A. sp_showcontrolinfo
B. sp_displaylogin
C. sp_who
D. sp_showpsexe
Answer: D