1445 お客様のコメント
質問 1：
Sybase IQ snapshot versioning?Sybase IQ snapshot versioning
A. stores a complete copy of each table per version.
B. supports ANSI isolation level 0 reads.
C. makes new table versions available automatically without explicit commit/rollbacks.
D. allows updates to tables while users are reading the data.
正解：D
質問 2：
Which of the following statements are TRUE if the command given below is executed? (Choose 2) CREATE DBSPACE MyDbspace USING FILE MyFile1 '/IQ/data/file1' SIZE 2000 RESERVE 1000;
A. The reserve of 1000MB is part of the 2000MB specified for the file.
B. Will create a raw devicedbfile of 2000MB.
C. IQ Main Storedbspace called MyDbspace?is created.IQ Main Store dbspace called ?MyDbspace?is created.
D. A Catalog Storedbspace is created.
正解：A,C
質問 3：
Which of the following circumstances warrant performing routine IQ Index Maintenance? (Choose 2)
A. 7 Days have passed since last index maintenance
B. After every data load
C. Cardinality of a column has changed, permitting a possible rebuilding with an optimized FP index
D. A table was created with MINIMIZE_STORAGE='OFF'
正解：C,D
質問 4：
What parameter is used to limit the number of user connections to the Sybase IQ server?
A. -gd
B. -cl
C. -gl
D. -gm
E. -gc
正解：D
質問 5：
What indexes will be created on the column COUNTRY_ID when the following statement is run? (Choose 2) CREATE TABLE T_COUNTRY (COUNTRY_ID integer IQ UNIQUE(500), COUNTRY_NAME varchar(100) IQ UNIQUE(500), primary key(COUNTRY_ID))
A. FP(3)
B. FP(2)
C. Unique HG
D. FP(1)
E. Unique LF
正解：B,C
質問 6：
How should you validate the database before a backup starts?
A. sp_iqtransaction
B. sp_iqstatus
C. sp_iqmpxvalidate
D. sp_iqcheckdb
E. dbcc
正解：D
質問 7：
Which are TRUE about the LOCK TABLE Write Lock command? (Choose 2)
A. Does not force a commit prior to obtaining the lock
B. Can only be used for delete command
C. Requires DBA authority
D. Can be specified for an unlimited period of time
E. Reserves an advance write lock on a table
F. Locks a table to prevent other users from accessing its data
正解：D,E
質問 8：
The _________________ and _________________ logs can be created to hold load error information? (Choose 2)
A. message
B. transaction
C. errorlog
D. row
正解：A,D
質問 9：
Which permissions can be inherited from group membership? (Choose 3)
A. REFERENCES
B. INSERT
C. CONNECT
D. KERBEROS LOGIN
E. ALTER
正解：A,B,E
Sybase IQ snapshot versioning?Sybase IQ snapshot versioning
A. stores a complete copy of each table per version.
B. supports ANSI isolation level 0 reads.
C. makes new table versions available automatically without explicit commit/rollbacks.
D. allows updates to tables while users are reading the data.
正解：D
質問 2：
Which of the following statements are TRUE if the command given below is executed? (Choose 2) CREATE DBSPACE MyDbspace USING FILE MyFile1 '/IQ/data/file1' SIZE 2000 RESERVE 1000;
A. The reserve of 1000MB is part of the 2000MB specified for the file.
B. Will create a raw devicedbfile of 2000MB.
C. IQ Main Storedbspace called MyDbspace?is created.IQ Main Store dbspace called ?MyDbspace?is created.
D. A Catalog Storedbspace is created.
正解：A,C
質問 3：
Which of the following circumstances warrant performing routine IQ Index Maintenance? (Choose 2)
A. 7 Days have passed since last index maintenance
B. After every data load
C. Cardinality of a column has changed, permitting a possible rebuilding with an optimized FP index
D. A table was created with MINIMIZE_STORAGE='OFF'
正解：C,D
質問 4：
What parameter is used to limit the number of user connections to the Sybase IQ server?
A. -gd
B. -cl
C. -gl
D. -gm
E. -gc
正解：D
質問 5：
What indexes will be created on the column COUNTRY_ID when the following statement is run? (Choose 2) CREATE TABLE T_COUNTRY (COUNTRY_ID integer IQ UNIQUE(500), COUNTRY_NAME varchar(100) IQ UNIQUE(500), primary key(COUNTRY_ID))
A. FP(3)
B. FP(2)
C. Unique HG
D. FP(1)
E. Unique LF
正解：B,C
質問 6：
How should you validate the database before a backup starts?
A. sp_iqtransaction
B. sp_iqstatus
C. sp_iqmpxvalidate
D. sp_iqcheckdb
E. dbcc
正解：D
質問 7：
Which are TRUE about the LOCK TABLE Write Lock command? (Choose 2)
A. Does not force a commit prior to obtaining the lock
B. Can only be used for delete command
C. Requires DBA authority
D. Can be specified for an unlimited period of time
E. Reserves an advance write lock on a table
F. Locks a table to prevent other users from accessing its data
正解：D,E
質問 8：
The _________________ and _________________ logs can be created to hold load error information? (Choose 2)
A. message
B. transaction
C. errorlog
D. row
正解：A,D
質問 9：
Which permissions can be inherited from group membership? (Choose 3)
A. REFERENCES
B. INSERT
C. CONNECT
D. KERBEROS LOGIN
E. ALTER
正解：A,B,E
Maruyama -
ひたすらソフト版を利用して、勉強し直しました。内容がしっかり覚えて、510-702試験を合格できました。