How many rows will be inserted into the MYTAB table?
A table named MYTAB was created as follows:
How many rows will be inserted into the MYTAB table?
Which policy is used by the Configuration Analysis Tool?
Which policy is used by the Configuration Analysis Tool?
Which statement about Insert-Time-Clustered (ITC) is correct?
Which statement about Insert-Time-Clustered (ITC) is correct?
what measure can be taken in the Configuration Utility to check for bottlenecks in the fabric?
A company’s IBM Tivoli Storage Productivity Center V4.2 (TPC) environment consists of: A TPC
server managing 4 native APIs and 2 CIMOM devices. 10 Storage Resource Agents of various
operating system platforms. Backup is performed on a two tape library. All devices are split
between two McData and Brocade fabrics. If the backup runs at 2:00 a.m., what measure can be
taken in the Configuration Utility to check for bottlenecks in the fabric?
Which clause must be used with the CREATE TABLE statement to define this table?
A DBA wants to create a table named SALES that has the following characteristics: ?effective data
clustering and management of space utilization ?rows in the table should be clustered based on
when they are added to the table Which clause must be used with the CREATE TABLE statement
to define this table?
What are two ways to make this discovery in IBM Tivoli Storage Productivity Center V4.2 (TPC)?
A company has DS8000,DS4800 storage attached to three file servers and four application
servers. It is mandated from their business perspective that the file servers must be used only for
storing documents, spreadsheets, and presentations and restrict all other types of data. It has
been observed that some users have been storing music files on these servers. What are two
ways to make this discovery in IBM Tivoli Storage Productivity Center V4.2 (TPC)? (Choose two.)
What must be done to convert a populated base table to a multidimensional clustering (MDC) table?
What must be done to convert a populated base table to a multidimensional clustering (MDC)
table?
Which IBM Tivoli Storage Productivity Center V4.2 system report shows when files were last accessed?
Which IBM Tivoli Storage Productivity Center V4.2 system report shows when files were last
accessed?
Which command(s) should be used to drop database partition 10 from a database named MYDB?
Which command(s) should be used to drop database partition 10 from a database named MYDB?
what is the default data server port?
While running the IBM Tivoli Storage Productivity Center V4.2 installation using a custom
installation method, what is the default data server port?