최신 Sybase Certification 510-022 무료샘플문제:
1. What is the default for Recovery Fault isolation offline pages?
A) 20
B) 16
C) 30
D) 32
E) 48
2. The master device is broken and you have no backup of the master database. All other devices appear healthy. Which of the following commands will be helpful to you in this scenario? (Choose three)
A) disk init
B) disk refit
C) dataserver # #
D) disk reinit
E) buildmaster
3. Which of the following commands will not perform a checkpoint on the database?
A) dump database
B) dump tran
C) dump tran...with no_truncate
D) dump tran....with truncate_only
4. Which of the following statements are true about this extract from a histogram?
5 0.00526000 <="T20051"
6 0.00526000 <="T23041"
7 0.00179000 <="T274000"
8 0.12260000 <="T27400"
9 0.00526000 <="T29382"
10 0.00526000 <="T31228"
A) Step 10 describes the percentage of nulls in the column.
B) Value greater than T23041 and less than T27400 make up 12.26%of the table.
C) This column has a unique index on it.
D) Value greater than T27400 and less than T31228 make up 1.052%of the table.
E) Step 8 is a frequency count cell.
5. Which of the following commands can be used to find out when update statistics was last executed? (choose 2)
A) select*from sysstatistics
B) delete statistics
C) optdiag
D) update statistics
E) select*from systabstats
질문과 대답:
질문 # 1 정답: A | 질문 # 2 정답: B,C,E | 질문 # 3 정답: C | 질문 # 4 정답: D,E | 질문 # 5 정답: A,C |