최신 Sybase Certification 510-702 무료샘플문제:
1. For a stored procedure to insert records into a table, the user other than the owner of the stored procedure must have...
A) EXECUTE permission on the stored procedure.
B) EXECUTE permission on the stored procedure and INSERT permission on the table.
C) INSERT permission on the table.
D) EXECUTE permission on the stored procedure and REFERENCES permission on the table.
2. Which ANSI Isolation Level does Sybase IQ employ?
A) 1
B) 0
C) 3
D) 2
3. Which command can NOT be used to assign a user to a specific login policy?
A) sp_iqmodifylogin
B) ALTER USER
C) CREATE USER
D) sp_iqaddlogin
E) GRANT CONNECT
4. Which of the following circumstances warrant performing routine IQ Index Maintenance? (Choose 2)
A) Cardinality of a column has changed, permitting a possible rebuilding with an optimized FP index
B) A table was created with MINIMIZE_STORAGE='OFF'
C) After every data load
D) 7 Days have passed since last index maintenance
5. What is the state of the dbspace when the database starts but one or more files cannot be opened?
A) Dbspace will be offline.
B) Dbspace will be dynamically online.
C) Dbspace will be dynamically offline.
D) Dbspace will be online.
질문과 대답:
질문 # 1 정답: B | 질문 # 2 정답: C | 질문 # 3 정답: E | 질문 # 4 정답: A,B | 질문 # 5 정답: C |