Online Access Free A2090-544 Exam Questions

A table named TAB_A was created with the COMPRESS YES option specified and populated with 100,000 rows. If a DBA wants to create an index on table TAB_A, which statement is true?

• A.In order for the index to be compressed, it must be enabled for compression by specifying the COMPRESS YES option with the CREATE INDEX statement that is used to create it.
• B.The index will automatically be compressed since the table it is associated with is compressed; the ALTER INDEX command does not have to be executed.
• C.The index will automatically be enabled for compression because the associated table is compressed; however, the index will not be compressed until it is REORGed.
• D.In order for the index to be compressed, it must be enabled for compression by specifying the COMPRESS YES option in the CREATE INDEX statement used to create it; however, the index will not be compressed until the ALTER INDEX command is used to create an index compression dictionary.

What steps, in the correct order, are performed by the SQL and XQuery compilers to generate executable code for non-federated queries?

• A.parse query; rewrite query; check semantics; pushdown predicates; execute access plan
• B.check semantics; parse query; rewrite query; build access plan
• C.parse query; check semantics; rewrite query; build access plan
• D.check semantics; parse query; build access plan; pushdown predicates; execute access plan

What is the minimum authority required to execute the RUNSTATS command against a table?

• A.SYSMON
• B.SECADM
• C.SQLADM
• D.DATAACCESS

Which command will back up a database named SAMPLE to a TSM server using two concurrent TSM client sessions?

• A.BACKUP DATABASE sample USE TSM OPEN 4 SERVERS WITH 2 BUFFERS
• B.BACKUP DATABASE sample USE TSM OPEN 2 SESSIONS WITH 4 BUFFERS
• C.BACKUP DATABASE sample USE TSM OPEN 2 SERVERS WITH 4 BUFFERS
• D.BACKUP DATABASE sample USE TSM OPEN 4 SESSIONS WITH 2 BUFFERS

Which database manager configuration parameter is used to set an instance-wide soft limit on the total amount of memory that can be consumed by private sorts, within that instance, at any given time?

• A.SHEAPTHRES
• B.SORTHEAP
• C.SHEAPTHRES_SHR
• D.SORTHEAP_SHR