Online Access Free C-SASEAA-15 Exam Questions

Which command can be used to check the maximum number of locks used since ASE server was started?

• A.sp_monitorconfig
• B.sp_poolconfig
• C.sp_helpconfig
• D.sp_configure
• E.sp_countmetadata

Cursors can now be declared as which of the following? (Choose four.)

• A.forward_only
• B.non-scrollable
• C.insensitive
• D.scrollable
• E.backward_only
• F.semi-sensitive

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

• A.single user
• B.ddl in tran
• C.dbo use only
• D.no chkpt on recovery
• E.select into/bulkcopy/pllsort

Which of the following are TRUE about the dump database command? (Choose three.)

• A.makes a full backup copy of the database
• B.can write a single database dump across multiple devices
• C.truncates the transaction log
• D.makes a full backup copy of the transaction log
• E.drops the database because it is no longer necessary

Which command is used to display the current server EBF level?

• A.select @@version
• B.select @@servername
• C.select * from syslogshold
• D.select * from sysservers