⟩ Who in vented super computer?
Dr. Vijay bhatkar
Dr. Vijay bhatkar
Which of the following extenders allows data to be presented in a three?dimensional format? A.DB2 AVI Extender B.DB2 XML Extender C.DB2 Text Extender D.DB2 Spatial Extender
Suppose a customer is attempting to determine what failed during the last boot sequence of the Linux partition. Which of the following can be used to determine the error condition? A /var/log/messages B /proc/startup C /usr/sbin/log D /etc/boot
Explain Which of the following is required for the DB2 optimizer to consider a hash join strategy? A. Equijion predicates B. Optimization level 1 or above C. Registry variable DB_ANTIJOIN=YES D. SORTHEAP large enough to contain the tables being joined
Explain What is database administration NOT concerned with? A. indexing B. creating tables C. accessing data D. application building
Explain If there is a lock on an adjacent key, an insert will fail if the isolation level is set to what? A. committed read B. repeatable read C. share read D. indexed read
Suppose a System z customer has a new CIO. The CIO is concerned about continuing operations and recovery following a catastrophe. Which of the following addresses this issue? A. GDPS B. TAM C. DR D. WASS
In which two situations would you use a round robin fragmentation strategy? A. When all fragments must be second B. To create uneven data distributions C. When queries perform sequential scans and you have little information about the data being stored. D. When tables are accessed with a high degree of selectivity
Which two of the following table space attributes can be changes after the table space has been created? A. Page size B. Extent size C. Transfer rate D. Table space type E. Table space name
Which of the following tools can be used to identify inefficient SQL statements without executing them? A.QMF B.Task Center C.Visual Explain D.Development Center
What is a chunk when using raw devices? A. a contiguous unit of disk space B. a dynamic unit of disk space C. a location in shared memory D. a data table