Online Access Free 510-025 Exam Questions

Which of the following are true regarding partitions? (Choose2)

• A.Each partition must reside on its own segment.
• B.Tables may be partitioned logically as well as physically
• C.Global indexes may be created on each partition.
• D.Global indexes can be clustered ornonclustered on range, hash, or list partitioned tables.
• E.Data in each partition may be processed differently.

Based on the command "dump database pubs2 to pubs2.dmp with compression = 6",
whichcommands could be used to load it? (Choose 2)

• A.load database pubs2 from"compress::6::pubs2.dmp"
• B.load database pubs2 from"pubs2.dmp" withcompression level 6
• C.load database pubs2 from "pubs2.dmp" withcompression
• D.load database pubs2 from"pubs2.dmp" withcompression = 6
• E.load database pubs2 from "pubs2.dmp"

What is the value of @@trancount after the execution of a rollback transaction in a nestedtransaction?

• A.Equal to the number of begin transaction statements executed
• B.0
• C.Equal to the number of begin transaction statements minus 1
• D.1

Which of the following commands allow you to specify the partition? (Choose 3)

• A.insert
• B.truncate table
• C.update statistics
• D.reorg rebuild tablename
• E.bcp in

What is the maximum system device size which ASE 15.0 can support?

• A.4 TB
• B.6 TB
• C.2 TB
• D.1 TB