Adaptive Server Enterprise 15.0 Administrator Associate Exam (510-025) Free Practice Test

Question 1

Which table identifies the process that has the oldest active transaction and how long thattransaction has been open?

A. master..systransactions

B. master..sysprocesses

C. master..syslogshold

D. master..syslogins

E. master..syslocks

Correct Answer: C

Question 2

For a full-merge join which of the following are TRUE? (Choose 2)

A. Tables being joined have useful indexes on join columns

B. Sort outer table in join order, then merge with the right inner table

C. Sort both tables,then merge

D. Sort inner table in join order, then merge with left outer table

E. Tables do not need to be sorted but can be merged using indexes

Correct Answer: A,E

Question 3

Which of the following will allow the system administrator to view database permissions for any given user?

A. sp_helprotect

B. sp_helpuser

C. sp_displaylogin

D. set role

Correct Answer: A

Question 4

Which of the following statements are NOT true about ASE security?

A. Grants give a user access to objects.

B. Logins give a user access to adatabasE.

C. Logins give a user access to the server.

D. Permissions on an object can be granted to user-defined roles.

Correct Answer: B

Question 5

Which system tables contain information regarding segments? (Choose 3)

A. sysobjects

B. sysdatabases

C. syspartitions

D. sysusages

E. sysindexes

F. sysdevices

Correct Answer: C,D,E

Question 6

Which database is most suitable for setting the "dsync" value to FALSE on its file systemdevice?

A. sybsystemdb

B. tempdb

C. sybsystemprocs

D. model

E. master

Correct Answer: B

Question 7

When rebuilding the master database without backups the disk refit command restores whichsystem tables? (Choose 2)

A. sysreferences

B. sysdatabases

C. sysconfiguresX

D. sysusages

E. sysdevices

Correct Answer: B,D

Question 8

Which database option must be set to run dbcc checkalloc in fix mode?

A. dbo use only

B. nochkpt on recovery

C. ddl in tran

D. select into/bulkcopy/pllsort

E. single user

Correct Answer: E

Question 9

In the create database syntax, the with override is necessary if

A. you need to invoke an abbreviated version of createdatabasE.

B. you need to separate log and data on the samedevicE.

C. you do not want to overwrite existingdatA.

D. you need to overwrite existing dat

Correct Answer: B

Welcome to TestSimulate

Sybase Adaptive Server Enterprise 15.0 Administrator Associate (510-025) Free Practice Test