Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
Exam
: Sybase 510-014
Title
: Ase 12.0 Server
Administration Associate
Version : Demo
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
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
6. The minimum size of a named cache is
A. 512 Kb
B. 1024 Kb
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
C. 5.0 Mb
D. 10 extents
E. There is no enforced minimum size
Answer: A
7. Which databases are required for a properly functioning ASE 12.0?
A. master, model, tempdb, sybsystemprocs, sybsystemdb
B. master, model, tempdb, sybsystemprocs, sybsecurity
C. master, model, tempdb, sybs