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 000-546 Exam - Cheat-Test.com

Free 000-546 Sample Questions:

Q: 1
When storing XML data in a DB2 database, which statement is valid?
A. A table with an XML column can be defined in a non-Unicode database.
B. A table with an XML column can only be defined in a Unicode database.
C. A table with an XML column can be defined in a non-Unicode database but the table containing the XML column will be stored in Unicode.
D. A table with an XML column can be defined in a non-Unicode database but the database must be converted to Unicode before the XML columns can be used.
Answer: A

Q: 2
Which of following is true when decomposing multiple XML documents?
A. It is possible to decompose multiple XML documents stored in a binary column or in an XML column.
B. It is not possible to decompose multiple XML documents stored in a binary column or in an XML column.
C. It is possible to decompose multiple XML documents stored in a binary column but not in an XML column.
D. It is possible to decompose multiple XML documents stored in a XML column but not in an binary column.
Answer: A

Q: 3
Which is true regarding collecting distribution statistics for XML data?
A. XML distribution statistics are collected for indexes over XML data of type VARCHAR.
B. XML distribution statistics are collected for indexes over XML data of type VARCHAR HASHED.
C. XML distribution statistics are collected when collecting index statistics during index creation.
D. XML distribution statistics are collected for partitioned indexes over XML data defined on a data partitioned table.
Answer: A

Q: 4
Index INDEX1 has been created as follows: CREATE INDEX index1 ON table_x (cola) Which of the following actions can be done through an ALTER INDEX statement?
A. Add a column to the index key.
B. Change the PCTFREE specification.
C. Make the COMPRESS attribute YES or NO.
D. Make this index the clustering index.
Answer: C

Q: 5
Which of the following SQL statements will return monitoring information of tables in the DB2USER schema that begin with the letter 'A'?
A. SELECT * FROM mon_get_table('DB2USER','A%',-2)
B. SELECT * FROM TABLE(mon_get_table('DB2USER','A%',-2))
C. SELECT * FROM mon_get_table('DB2USER',",-2) WHERE TABNAME LIKE 'A%'
D. SELECT * FROM TABLE(mon_get_table('DB2USER','',-2)) WHERE TABNAME LIKE 'A%'
Answer: D

Q: 6
A DBA wants to use XQuery on a XML document to determine the number of lock waits for a particular workload. Which of the following table functions should be used?
A. MON_GET_WORKLOAD
B. MON_GET_LOCKS
C. MON_GET_WORKLOAD_DETAILS
D. MON_GET_LOCKS_DETAILS
Answer: C

Q: 7
Which statements about Explain administration authority (EXPLAIN) are true?
A. EXPLAIN authority allows a user to explain query plans without gaining access to data for a specific database. SECADM can grant this authority and this authority can be granted to PUBLIC.
B. EXPLAIN authority allows a user to explain query plans by gaining limited access to data for a specific database. DBADM can grant this authority and this authority can be granted to PUBLIC.
C. EXPLAIN authority allows a user to explain query plans by gaining limited access to data for a specific database. SECADM can grant this authority and this authority cannot be granted to PUBLIC.
D. EXPLAIN authority allows a user to explain query plans without gaining access to data for a specific database. SECADM and DBADM can grant this authority and this authority cannot be granted to PUBLIC.
Answer: A

Q: 8
When a database is created who is granted SECADM by default?
A. The database creator.
B. Members of the SECADM_GROUP.
C. Members of the SYSADM_GROUP.
D. The database creator and members of the SYSADM_GROUP.
Answer: A


© 2014 Cheat-Test.com, All Rights Reserved