Pass1000!

  About 510-014 braindumps exam is an important part of Sybase certifications and at Ase 12.0 Server Administration Associate Sybase 510-014 braindumps Killtest have the resources to prepare you for this.Core part of 510-014 certifications and once you clear the exam you will be able to solve the real time problems yourself.

1. A manual checkpoint issued in a user database:      
A. Writes a checkpoint record to each user log cache.      
B. Flushes the tempdb database.      
C. Writes dirty log and dirty data pages of the current database to disk.      
D. Commits all current transactions.    
Answer: C    
2. After  issuing  the dbcc engine(offline)  command,  if  that engine  tasks cannot be migrated  to another engine within approximately 5 minutes, then:    
A. The tasks are killed.      
B. The command is aborted.      
C. Only an error message is returned.      
D. The tasks are put into a state of recv sleep.  
Answer: A 
3. Given the following command: create database test
Which master database table will be affected by this command?      
A. sysobjects
B. syscomments
C. sysindexes
D. sysdatabases  
Answer: D
4. Which of the following can NOT be done with segments to improve performance?      
A. You can place heavily used objects on physical disks dedicated to those objects.      
B. You can split large tables across several disks.      
C. You can put a heavily used table on one disk and its nonclustered indexes on a separate disk.      
D. You can put a heavily used table on one disk and its clustered index on a separate disk.            
Answer: D
5. Cursors outside a stored procedure are optimized and compiled when:      
A. the program starts      
B. they are declared      
C. they are opened      
D. the first row is fetched   
Answer: C