510-014 Exam

Quality and Value for the 510-014 Exam

Test4pass Practice Exams for Sybase, Inc 510-014 are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.

100% Guarantee to Pass Your 510-014 Exam

If you prepare for the exam using our Test4pass testing engine, we guarantee your success in the first attempt. If you do not pass the Sybase,Inc Certification 510-014 exam (ProCurve Secure WAN) on your first attempt we will give you a FULL REFUND of your purchasing fee AND send you another same value product for free.

Sybase, Inc 510-014 Downloadable, Printable Exams (in PDF format)

Our Exam 510-014 Preparation Material provides you everything you will need to take your 510-014 Exam. The 510-014 Exam details are researched and produced by Professional Certification Experts who are constantly using industry experience to produce precise, and logical. You may get questions from different web sites or books, but logic is the key. Our Product will help you not only pass in the first try, but also save your valuable time.

510-014 Downloadable, Interactive Testing engines

We are all well aware that a major problem in the IT industry is that there is a lack of quality study materials. Our Exam Preparation Material provides you everything you will need to take a certification examination. Like actual certification exams, our Practice Tests are in multiple-choice (MCQs) Our Sybase, Inc 510-014 Exam will provide you with free 510-014 dumps questions with verified answers that reflect the actual exam. These questions and answers provide you with the experience of taking the actual test. High quality and Value for the 510-014 Exam:100% Guarantee to Pass Your Sybase,Inc Certification exam and get your Sybase,Inc Certification Certification.

Hot KeyWords On 510-014 test

We collect some hot keywords about this exam:
Test4pass , Pass 4 Sure , Test in Side ,Pass Guide ,Test King 510-014 exam | 510-014 pdf exam | 510-014 braindumps | 510-014 study guides | 510-014 trainning materials | 510-014 simulations | 510-014 testing engine | 510-014 vce | 510-014 torrent | 510-014 dumps | free download 510-014 | 510-014 practice exam | 510-014 preparation files | 510-014 questions | 510-014 answers.

How to pass your 510-014 exam

You can search on Search Engine and Find Best IT Certification site: Test4pass.com - Find the Method to succeed 510-014 test,The safer.easier way to get Sybase,Inc Certification Certification .

��
��
Exam : Sybase 510-014
Title : Ase 12.0 Server Administration Associate


1. To change the locking scheme for an existing table you must:
A. unload target database using bcp out, use alter database, load the data back using bcp in
B. use the alter table command
C. change the server configuration for locking schemes
D. none of the above
Answer: B

2. 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, sybsystemdb, sybsecurity, dbccdb
D. master, model, tempdb, dbccdb, sybsystemprocs
Answer: A

3. Which system database is used to store intermediate results from queries?
A. master
B. model
C. tempdb
D. sybsystemprocs
Answer: C

4. 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

5. 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

6. When the server has an additional connection attempt beyond what you are licensed for, what action does the license monitor take?
A. the connection hangs until someone else disconnects
B. ASE sends an error to the user notifying them of the license restriction, and asks them to try later
C. ASE executes an extended stored procedure that pages the local SYBASE sales rep, but allows the connection attempt to succeed
D. ASE locks the violating login from using the server until an SSO unlocks this violating login
E. none of the above
Answer: E

7. 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

8. 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

9. ASE has the following locking schemes: (Choose 3)
A. allpages - index page(s) and data page(s) are locked for the duration of the modification transaction
B. datapages - locks just data page(s) for the duration of the modification transaction
C. datapages - locks just data page(s) and index row(s) for the duration of the modification transaction
D. datarows - locks only data row(s) and index row(s) for the duration of the modification transaction
E. datarows - locks only data row(s) for the duration of the modification transaction
Answer: ABE

10. The minimum size of a named cache is
A. 512 Kb
B. 1024 Kb
C. 5.0 Mb
D. 10 extents
E. There is no enforced minimum size
Answer: A

11. The premium features in ASE 12.0 consist of:
A. Java in the database, High Availability, Distributed Transaction Management, Advanced Security Mechanisms
B. Java in the database, High Availability, Distributed Transaction Management, Server to Server Communications
C. Distributed Transaction Management, Advanced Security Mechanisms, Server to Server Communications
D. High Availability, Distributed Transaction Management, Advanced Security Mechanisms, Homogeneous Component Integration Services
Answer: A

12. The database sybsystemdb provides support for:
A. advanced security
B. high availability failover
C. java classes and stored procedures
D. distributed transaction management
E. system stored procedures
Answer: D

13. 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

14. Which three segments are created when a database is created? (Choose 3)
A. system
B. logsegment
C. dbdevice
D. default
Answer: ABD