Question 1.
What is the purpose of the dbccdb database?:

A. It is required for running any dbcc command
B. It is required for running the dbcc checkstorage command
C. It is required for running the dbcc memusage command
D. It is required for running dbcc trace
E. It is not required for anything

Answer: B

Question 2.
The sybsecurity database is only needed if you plan on using:

A. auditing
B. user defined roles
C. user defined groups
D. row level access control

Answer: A

Question 3.
The system table sysindexes exists in which of the following databases? (choose all that apply):

A. master
B. sybsystemprocs
C. tempdb
D. any user database

Answer: A, B, C, D

Question 4.
Identify the segment names that are common to all databases.

A. system
B. table
C. logsegment
D. default
E. index
F. user
G. data

Answer: A, C, D

Question 5.
Which databases are required for a properly functioning ASE?

A. master, model, tempdb, sybsystemprocs, sybsystemdb
B. master, model, tempdb, sybsystemprocs, sybsecurity
C. master, model, tempdb, sybsystemdb, sybsecurity, dbccdb
D. master, model, tempdb, dbccdb, sybsystemprocs

Answer: A

Question 6.
In order to use the unichar and univarchar datatypes to store Unicode data, the ASE default character set must be set to: (choose one)

A. iso_1
B. roman8
C. cp850
D. utf8
E. cp437

Answer: D

Question 7.
With the create database command you can specify database size in (choose all that apply):

A. megabytes
B. kilobytes
C. gigabytes
D. pages

Answer: A, B, C

Question 8.
With the disk init command you can specify database device size in (choose all that apply):

A. megabytes
B. kilobytes
C. gigabytes
D. pages

Answer: A, B, C, D

Question 9.
What is true of the master device (choose three):

A. The master database can be extended only on to the master device.
B. The master device must be left as a default device
C. The master device has a virtual device number of 0
D. The master device location is an optional parameter to the dataserver program on Unix (or the 
    sqlsrvr.exe program on Microsoft Windows) when starting the server
E. The master device is created by the database administrator executing the "disk init" command
F. The master device's minimum size increases as the logical page size increases

Answer: A, C, F

Question 10.
The logical page size can be set

A. when creating the server
B. when upgrading the server
C. when creating a database
D. when loading the database

Answer: A

	Web www.certsbraindumps.com