510-025 Online Practice Questions and Answers

Which of the following are true about using the load database command?(Choose 3)

A. the database must be at least as large as the size of the database dump

B. the database must have been created with the for load option

C. the database must be exactly the same size as the database dump

D. the database must not be in use

E. the database need not exist because load database will create the database

F. thedatabase must not be marked as suspect

Which of the following databases are required for an Adaptive Server installation? (Choose 2)

A. sybsyntax

B. sybsystemdb

C. sybmgmtdb

D. sybsecurity

E. sybsytemprocs

F. dbccdb

When sizing additional network memory, how many packets does each connection require?

A. 2

B. 3

C. 4

D. 5

If a transaction places an update lock on a data page, what type of lock will a second transaction get if it attempts to read the data using a SELECT statement?

A. Another UPDATE lock

B. SHARED lock

C. EXCLUSIVE lock

D. No lock is placed as process will be blocked

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%

A table, column and index name can be bytes long?

A. 32

B. 64

C. 128

D. 255

What will be the result if the 'disk init' command is run to create a database device and no"vdevno" is specified?

A. The command will fail but the operating system file will be created

B. The command will create the device with avdevno assigned by the server

C. The command will fail without any adverse affects to the server

D. The command will function properly because the server no longer uses 'vdevno'

By default, every table in ASE 15.0

A. is hashpartitioneD.

B. is round-robinpartitioneD.

C. requires a placement index.

D. requires a primary key.

Which of the following may be performed against a database created with the for load clause? (Choose 3)

A. alter database for load

B. drop database

C. dump database

D. load database

E. sp_changedbowner

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

A. you need to overwrite existing datA.

B. you do not want to overwrite existingdatA.

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

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

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 load database parameter is used to view the archive page size?

A. listonly

B. blocksize

C. dumpvolume

D. headeronly

What is the largest I/O size that ASE supports?

A. 1 page

B. 2 pages

C. 4 pages

D. 8 pages

E. depends on the server page size

Which of the following is FALSE?

A. Groups are database-specifiC.

B. A user can only be a member of one user-defined group.

C. Groups cannot contain other groups.

D. Groups must beenableD.

Which of the following system roles will permit the use of the dump database command? (Choose 2)

A. mon_role

B. oper_role

C. sa_role

D. sso_role

E. is_admin_role