Which two statements are true?
A. Separate temporary dbspaces are required for each buffer pool.
B. DBSPACETEMP dbspaces can be temporary or standard dbspaces.
C. If rootdbs is mirrored then all the temporary spaces must be mirrored.
D. If DBSPACETEMP is not configured then temporary space will never be used.
E. Temporary dbspaces can have different page sizes.
正解:B,E
質問 2:
Which communication protocol needs additional configuration besides onconfig and sqlhosts?
A. TLITCP
B. IPCSHM
C. SOCSSL
D. IPCSTR
正解:C
質問 3:
Which statement is FALSE?
A. A new index can be created compressed.
B. Attached indexes cannot be compressed.
C. A compressed index cannot be uncompressed.
D. A compressed index can be uncompressed.
正解:D
質問 4:
Which approach is always valid when migrating data across differing hardware and operating system architectures?
A. Set up HDR primary and secondary between source and target.
B. dbexport source system then dbimport into target.
C. onunload the source to tape and onload the tape to the target.
D. ontape backup from source then restore backup onto target.
正解:B
質問 5:
How can you ensure to hold the an update lock until the end of a transaction when fetching rows from a cursor?
A. Use the 'Cursor Stability' isolation level along the WITH HOLD clause.
B. Use the SET TRANSACTION command to with SERIALIZABLE clause.
C. Use the RETAIN UPDATE LOCKS clause with isolation level.
D. Use the 'Committed Read' isolation level.
正解:C
質問 6:
What command unlocks the storage catalogs when using the Primary Storage Manager?
A. onpsm -C unlock
B. onmode -C unlock
C. onbar -d unlock
D. onsmsync -c unlock
正解:A
平田** -
このC2090-619問題集は使いこなせるのであれば私が一番おすすめする問題集になり