510-025 Online Practice Questions and Answers

Which alter table clause will change an APL table to allow row level locking?

A. lockdatarows

B. lock datapages

C. lock allpages

D. withfillfactor = 1

During the installation, which of the following databases are created on the master device? (Choose 2)

A. dbccdb

B. model

C. sybsecurity

D. sybsystemprocs

E. tempdb

Given the following partial histogram from optdiag, what percentage of the rows for thiscolumn have a value of 500.00? Step Weight Value 1 0.00000000 < 0.00 2 0.36899999 = 0.00

3 0.00000000 < 1000.00 4 0.07100000 = 1000.00 5 0.00000000 < 2000.00 6 0.06580000 = 2000.00

A. 0.0%

B. 36.9%

C. 7.1%

D. 6.6%

The session level setting sort_resource is used for diagnostic purposes to see whatdegree of parallelism would be used to

A. create a tablE.

B. execute a query.

C. partition a tablE.

D. create an index.

Using the sp_who output, how can you identify a system process?

A. The process ID is below 15

B. Theorigname is NULL

C. Theloginame is system

D. The hostname is the name of the machine ASE is running from

Maximum database size for 2K pages is?

A. 32 GB

B. 256 GB

C. 2 TB

D. 4 TB

E. 8 TB

What happens when a row is inserted into a list partitioned table but the key value is not within the list?

A. The row is inserted into the first partition.

B. The row is inserted into the last partition.

C. The insert fails with an errormessagE.

D. The insert is discarded without an errormessagE.

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

A. master

B. sybsystemdb

C. sybsystemprocs

D. tempdb

E. model

Automatic database expansion

A. can be configured to run diskinit.

B. is configured viasp_dbextenD.

C. is only available on file system devices, NOT raw partitions.

D. is only available on system databases.

E. occurs by default on user databases.

Which system table contains a row for every transaction log fragment?

A. sysdatabases

B. sysusages

C. sysdevices

D. syslogs

Cross-platform dump and load requires (Choose 2)

A. additional syntax for the dump databasecommanD.

B. additional syntax for the online databasecommanD.

C. that all non-unique indexes be rebuilt following theloaD.

D. that all statistics be updated following theloaD.

E. thatservers use the same byte order.

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

A. sysdatabases

B. sysreferences

C. sysusages

D. sysdevices

E. sysconfiguresX

Which of the following are true regarding creating, modifying or dropping buffer pools?

A. The sum of all the buffers in the pool must be less than or equal to the total memory size of cache

B. New pools are created using memory from the largest pool unless otherwise specified

C. The minimum pool size is determined by a configuration parameter

D. The maximum I/O size for any cache is 8 pages

E. As long as 1 pool remains in the cache, any pool can be removed

Which of the following statements is TRUE about caches?

A. Each named cache must have an eight-page buffer pool.

B. Each buffer pool has a single MRU-LRU chain.

C. Each buffer pool has its own hashtablE.

D. The default data cache can be deleted if another named cache is created first.

Permissions on a table can be granted by all of the following EXCEPT: (Choose 2)

A. table owner

B. database owner

C. logins withsa_role

D. logins withsso_role

E. logins withoper_role