C.Each module is responsible for caching the data in that module
Explain Which two types of fragmentation are allowed in a CREATE TABLE statement? A. disk striping B. dbspace C. indexing D. round robin E. mirroring F. tblspace G. sorting H. expression
Explain Which two solutions, once installed and configured, can be used to move workloads without disruption? (Choose two) A. XIV partitions B. XIV Data Mover (XDM) C. SAN Volume Controller D. XIV Data Migration Function E. Tivoli Storage Productivity Center for Replication V4
What is a requirement to connect a V6R1 IBM i host to an XIV Storage System? A. XIV firmware V10.0.8 B. Host Attachment Kit V1.0.1 C. SAN Volume Controller (SVC)V4.2 D. Virtual I/O Server (VIOS) V2.1.1
Suppose A customer has ordered a 10 module XIV System. How many interface modules are active in this configuration?
Which statement correctly changes the next extent size? A. ALTER TABLE customer MODIFY NEXT SIZE 300 B. ALTER TABLE customer MODIFY NEXT EXTENT SIZE 300 C. ALTER TABLE customer MODIFY EXTENT SIZE 300 D. ALTER TABLE customer NEXT SIZE 300
Suppose an installed z/OS customer also has Power6 Servers. They are investigating consolidation of both types of servers to z/OS. Which of the following will establish the capacity for a new z/OS server? A. AD Tools B. Estimate the AIX load and add to CP3000 results. C. CP3000 D. Run AIX in a z/OS LPAR to establish the loadWArialTimes New RomanZ
Explain With database logging, where are transaction records first placed? A. in a temporary database table B. in the logical log buffer C. in the primary chunk D. in the physical buffer
Explain the Given following DDL statement CREATE TABLE RMW TABEL46″ 11″ INTEGER D11″ DECIMAL (1′0)NOT NULL D12″ DECIMAL (1′0) NOT NULL S7″ SMALLINT C8″ CHAR(1) WITH DEFAULT) organize by ( (D12″ ;D11″)) How many indexes will be created? A. 1 B. 2 C. 3 D. 4
When Disk space for a table is allocated in one or more units called what? A. tblspaces B. extents C. blobs D. chunks
Suppose an application bound with isolation level Uncommitted Read updates a row. Which of the following is true regarding the locking of this row? A.No row lock is acquired when the row is updated. B.The row lock is released when the cursor accessing the row is closed. C.The row lock is released when the application issues a COMMIT statement. D.The row lock is released when the cursor accessing the row is moved to the next row.
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
