|
Question |
Rating |
View Answer |
 |
Which of the following can NOT have an assigned execution class A. database B. A stored procedure C. An application D. A login
|
|
View Answer |
 |
Given: Adaptive Server physical storage space is divided into a hierarchy. What is the hierarchy sequence, from largest to smallest units of storage? A. allocation unit, extent, page, database fragment, device B. page, extent, database fragment, device, allocation unit C. device, database fragment, allocation unit, extent, page D. extent, allocation unit, page, device, database fragment
|
|
View Answer |
 |
All of the following execution class associations exist in the ASE when user FRED, running application ctisql, logs in. Which one will be applied to FREDs session? A. sp_bindexeclass ctisql, AP, NULL, EC1 B. sp_bindexeclass ctisql, AP, FRED, EC2 C. sp_bindexeclass FRED, LG, NULL, EC1 D. sp_bindexeclass FRED, LG, ctisql, EC2 E. It depends on the order of the creation of the bindings
|
|
View Answer |
 |
The "abstract plan language" is: A. A language used to tell the optimizer how to process a query. B. The internal command language used by sp_sysmon. C. A new type of command language for creating very complicated queries. D. The language used internally by the server for planning the most efficient use of memory.
|
|
View Answer |
 |
An application has been implemented in the production environment; and there has been a slowdown. To investigate that problem, you are looking at the procedure cache management section of the sp_sysmon output. The sp_sysmon output has reported a high percentage of 'percentage reads from disk'. What will be your action based on the above fact? A. No action is necessary based on this fact. B. The application is dynamically generating stored procedures and the server tuning will not help. C. This indicates that the procedure cache is too small and you will increase the procedure cache size. D. You will bind syscomments and sysobjects table to its own cache which will reduce the high percentage of 'procedures reads from disk'.
|
|
View Answer |
 |
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
|
|
View Answer |
 |
Q: 115 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
|
|
View Answer |
 |
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
|
|
View Answer |
 |
systabstats does not contain information on: A. Number of data pages for a table B. Average length of data rows and leaf rows C. Stopping points for the reorg command D. Column histograms
|
|
View Answer |
 |
Engine affinity restricts a task to run on: A. only one engine. B. an engine when it is made online using dbcc online (engine) C. an engine or a group of engines D. none of the above
|
|
View Answer |
 |
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. Creating a second buffer pool in a heavily used named cache E. Returning to a single engine configuration
|
|
View Answer |
 |
Which of the following can NOT have an assigned execution class A. database B. A stored procedure C. An application D. A login
|
|
View Answer |
 |
The employees table has an index created as follows: create index emp_index1 on employees(last_name, first_name desc) Which of the following queries would not require a sort? (Choose 2) A. select * from employees order by last_name, first_name B. select * from employees order by last_name ASC, first_name DESC C. select * from employees order by first_name DESC, last_name ASC D. select * from employees order by last_name DESC, first_name ASC
|
|
View Answer |
 |
Which statement is not true about cache partitioning? A. Default data cache can be partitioned B. A named cache with a 16K buffer pool can be partitioned C. Cache partitioning requires a server reboot D. A 2MB named cache can be divided into 8 cache partitions E. Named caches using the relaxed LRU cache replacement strategy can be partitioned
|
|
View Answer |
 |
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 Serv
|
|
View Answer |
 |
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.
|
|
View Answer |
 |
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
|
|
View Answer |
 |
What effect does the use of the command "set sort_merge on" have on the Server? A. It changes the server level setting to allow the use of merge joins. B. It overrides the server level setting to allow the use of merge joins in the current session. C. It overrides the server level setting to allow the use of merge joins by all currently connected users. D. It allows the use of merge joins in the current session only if the server level is set to "enabled".
|
|
View Answer |
 |
How does the optimizer choose the optimal degree of parallelism for partition based scans? A. It will use the maximum number of available worker processes B. It will use the maximum allowed worker processes based on "max parallel degree" C. It will use the maximum allowed worker processes based on "max scan parallel degree" D. It will use at most one worker process for every partition in the table. E. It will use no more than 3 worker processes.
|
|
View Answer |
 |
An 8-engine Adaptive Server is undergoing a high rate of Logical I/Os and spinlock contention in the default data cache. The DBA has used Sybase ASE Monitor and has found that two 4MB tables are table-scanning within the application. This is causing 50% of the server's Logical I/Os. The code within the application cannot be changed. The task for the DBA is to increase throughput of the Adaptive Server and lower the amount of spinlock contention without changing indexes, tables or the application. Which two are valid operations which should be done to meet this objective? (Choose 2.) A. Create two named caches of 2 MB each and then recycle the Adaptive Server to activate them. B. Create two named caches of 5 MB each and then recycle the Adaptive Server to activate them. C. Create two 5MB 16KB Page Pools within the default data cache. Bind the two small tables to these page pools. D. Bind the two tables to their own newly-created and active named cache. E. Compress the tables which join to the two small tables so that they are chosen as outer tables. This will eliminate the need to table scan the small tables.
|
|
View Answer |