Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
Exam
: Sybase 510-701
Title
: Sybase IQ Administrator
12.6 Professional Exam
Version : Demo
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
1. Which index(es) should you create on a DATE datatype column with 3000 unique values for users to
search on both an exact date as well as a range of dates?
A. HG
B. DATE
C. DATE and HNG
D. HG and DATE
Answer: D
2. Which index type supports multiple columns?
A. LF
B. HG
C. FP
D. HNG
Answer: B
3. What index is created automatically on a column with a foreign key constraint?
A. LF
B. HG
C. Unique HG
D. JOIN
Answer: B
4. When you perform Alter Table abc Drop Primary Key, what happens?
A. The HG index on the Primary Key column(s) is/are dropped.
B. The Unique HG index on the Primary Key column(s) is/are dropped.
C. The column(s) for the Primary Key are dropped from the table.
D. You receive an error since you must use the Drop Index Command.
Answer: B
5. What index types are supported for CHAR columns over 255 bytes? (Choose 2)
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
A. FP
B. LF
C. HG
D. HNG
E. WD
Answer: AE
6. A load into a column with a LF index fails when
A. 1,500 unique values are reached.
B. 500 unique values are reached.
C. 10,000 unique values are reached.
D. 65,537 unique values are reached.
Answer: C
7. A global temporary table (Choose 2)
A. must be explicitly dropped.
B. exists until the connection or the compound statement in which it is declared ends.
C. writes data to the IQ Catalog Store.
D. uses one table definition but maintains a separate instance of the data per user.
Answer: AD
8. Given the command: create table t1 (col1 char(10) IQ UNIQUE(70000)) What index will be built for col1
when initially loading the table?
A. 1-byte FP
B. 2-byte FP
C. Flat FP
D. HG
Answer: C
9. Which indexes provide the optimizer with both column cardinality AND distribution of