Free Cheat-test Samples and Demo Questions Download
Adobe exams Adobe
Apple exams Apple
Avaya exams Avaya
Check Point exams Check Point
Cisco exams Cisco
Citrix exams Citrix
CIW exams CIW
CompTIA exams CompTIA
CWNP exams CWNP
EC-Council exams EC-Council
EMC exams EMC
Exin exams Exin
Fortinet exams Fortinet
GIAC exams GIAC
Hitachi exams Hitachi
HP exams HP
IBM exams IBM
Isaca exams Isaca
ISC exams ISC
ISEB exams ISEB
Juniper exams Juniper
LPI exams LPI
McAfee exams McAfee
Microsoft exams Microsoft
Oracle exams Oracle
PMI exams PMI
Riverbed exams Riverbed
SNIA exams SAP
Sun exams SAS
Symantec exams Symantec
VMware exams VMware
All certification exams

IBM C2090-311 Exam - Cheat-Test.com

Free C2090-311 Sample Questions:

Q: 1
Which statement regarding NOT ENFORCED unique constraints is true?
A. NOT ENFORCED unique constraints enforce uniqueness only for primary key columns.
B. The query optimizer will consider a NOT ENFORCED unique constraint when selecting the optimal data access plan.
C. Storage requirements for NOT ENFORCED unique constraints are identical to storage requirements for a unique index.
D. When attempting to insert data that does not conform to the NOT ENFORCED unique constraint, an error will be returned and the record will not be inserted.
Answer: A

Q: 2
Which type of compression is NOT provided as part of the DB2 Storage Optimization Feature?
A. Row compression
B. Index compression
C. Backup compression
D. Temporary table compression
Answer: C

Q: 3
What are the correct steps to capture EXPLAIN information for column-organized tables?
A. 1. Issue the query against column-organized tables
2. Execute the db2exfmt command
B. 1. Execute the command CURRENT EXPLAIN MODE YES
2. Issue the query against column-organized tables
3. Execute the db2exfmt command
C. 1. Set the ENABLE_COLUMN_TABLES registry variable to YES
2. Issue the query against column-organized tables
3. Execute the db2exfmt command
D. 1. Set the ENABLE_COLUMN_TABLES registry variable to YES
2. Execute the command CURRENT EXPLAIN MODE YES
3. Issue the query against column-organized tables
4. Execute the db2exfmt command
Answer: D

Q: 4
In which type of database are column-organized tables supported?
A. Partitioned databases.
B. DB2 pureScale databases.
C. Databases whose code set is Unicode.
D. Databases whose code set is Non-Unicode.
Answer: A


© 2014 Cheat-Test.com, All Rights Reserved