Adaptive Server SQL Associate
Answers, Braindumps (510-410)
to www.examcheets.com and www.exams.ws for providing
How many parameters can be returned from a stored
Which definition accurately describes domain integrity?
A. Every row of a table can be uniquely identified.
B. Any value in a column is within the acceptable
set of values for that column.
C. Each column in each row holds a single data value.
D. A given value cannot be entered in on table unless
the value already exists in another table.
E. Every attribute that is not part of a primary key
is directly dependent on the entite primary key.
What is the maximum number of colums that may be included
in a composite index?
E. depends on server page size.
Which of the following statement are true for data
A. All approximate numberic data types are T-SQL extensions.
B. bit columns can be defined as NULL
C. special permissions are needed to create or use
a user-defined data type.
D. user-defined data types are a T-SQL entension.
Which of the following are valid ASE datatypes? (Choose
D. long binary
Answer: B , C ,E
Which of the following statements about Adaptive Server
object names are true? (Choose Three)
A. Names can be up to 30 characters long.
B. Names must be unique within the server.
C. Names must be unique within the database.
D. Names cannot be a Transact-SQLO keyword.
E. The first character must be alphabetic or an underscore.
F. The last character must be alphabetic or an underscore.
Answer: A, D ,E
Given that a table has a clustered index and 3 partitions,
scan parallel degree is set to 2, max parallel degree
is set to 5, and plenty of worker processes are available,
how many worker process will be used for a partition
Which of the indexes below can be used to cover the
following query? (Choose Three) Select a, b from mytable
where c > 0
A. index on (c)
B. index on (a, b)
C. index on (c, a, b)
D. index on (c, b, a, d)
E. index on (d, c, b, a)
Answer: C, D ,E
Which of the following are true about indexes? (Choose
A. You can create an index on a column of any datatype.
B. A table can have multiple clustered indexes.
C. You can create an index on a temporary table.
D. You can create an index on a view.
E. You can create an index on a table in another database.
Answer: C ,E
Which of the following statement are true for parallel
access? (Choose Two)
A. Paralled access is always faster than serial access.
B. Parellel access is recommended for DSS and batch
C. Lock contention and deadlocks ay increase when
parallel access is enabled.
D. The optimizer chooses the paralled access plan
with the least logical and physical i/o.
Answer: B ,C