C9050-548 Dumps C9050-548 Braindumps C9050-548 Real Questions C9050-548 Practice Test C9050-548 Actual Questions IBM C9050-548 IBM IMS DBA https://killexams.com/pass4sure/exam-detail/C9050-548 A. The SQL SELECT statement allows the DBA to create table structures and pre- populate those table structures with database metadata. B. The SQL SELECT statement is used to return rows of data from your database table or tables. C. The SQL SELECT statement is used to return the status of the health of the database in the health DB2 health center application. D. The SQL SELECT statement is not used in DB2 because DB2 is a hierarchical database. Answer: B QUESTION: 78 When configuring an Optim Directory, which of the following DBMS types are supported? A. DB2, Oracle, Sybase ASE, SQL Server, and IDMS B. DB2, Oracle, Sybase ASE, SQL Server, and Informix C. DB2, Oracle, SQL Server, IMS and IDMS D. Only DB2 and Oracle Answer: B QUESTION: 79 What is the DB2 journal? A. The DB2 journal is a free newsletter that is published monthly to subscribers and that has articles of interest to DBAs. B. The DB2 journal is a feature that allows for commands in a transaction to be rolled back. All commands that have been executed in a particular transaction can be undone using the DB2journal. C. The DB2 journal is a GUI that displays historical information about tasks, database actions and operations, control center actions, messages, and alerts in your DB2 database. D. DB2 does not have a journal. Answer: D QUESTION: 80 What are private buffer pools are used for? A. KSDSs B. DEDBs C. HALDBs D. OSAM datasets Answer: B QUESTION: 81 Reorganization of which two database implementations will require that the associated secondary index be rebuilt? (Choose two.) A. HDAM with a secondary index that uses Direct pointers. B. HIDAM with a secondary index that uses Direct pointers. C. PHDAM with a secondary index that uses Direct pointers. D. HDAM with a secondary index that uses Symbolic pointers. E. HIDAM with a secondary index that uses Symbolic pointers. Answer: A, B QUESTION: 82 Which one of the following options is FALSE about DB2's Multi-Temperature Data Storage capability? A. You can use storage groups to implement multi-temperature data management in DB2. B. Multi-temperature data management reduces the total cost of ownership by allowing efficient deployment of storage hardware with minimal administrative overhead. C. Multi-temperature data management integrates with DB2's Workload Manager feature to let you prioritize your workloads based on the data being accessed. D. Multi-temperature data management best practices recommend that cold data should be stored in faster devices in order to maximize overall system performance. Answer: D QUESTION: 83 What are DB2 access plans? A. An access plan is the result of the planning phase for the installation of the DB2 product. It takes into account who will access the database and which permissions they will have. B. An access plan is part of the security audit that is performed by the DBA, with assistance from the network administrator, to list who will have access to database from the point of view of the operating system. C. An access plan is a plan that is created for each table, describing which users or queries will have access to the data that is contained in that particular table. D. An access plan is one that specifies an order of operations for accessing data in a SQL query. It lets you view statistics for selected tables, indexes, or columns; properties for operators; global information, such as table space and function statistics; and configuration parameters relevant to optimization. Answer: D QUESTION: 84 Which DB2 licensing type is based on the number of users allowed to access the data server? A. PVU (Processor Value Unit) licensing B. Sub-capacity licensing C. Authorized User (AU) licensing D. Per Server licensing Answer: C QUESTION: 85 What happens when an unqualified GN call is issued after a GB status code (end of database) is received? A. The GB status code is repeated. B. The first segment in the database is retrieved. C. A GE status code (segment not found) is returned. D. The last segment successfully retrieved is returned in the IOArea. Answer: B 6$03/( 48(67,216 7KHVH TXHVWLRQV DUH IRU GHPR SXUSRVH RQO\ )XOO YHUVLRQ LV XS WR GDWH DQG FRQWDLQV DFWXDO TXHVWLRQV DQG DQVZHUV .LOOH[DPV FRP LV DQ RQOLQH SODWIRUP WKDW RIIHUV D ZLGH UDQJH RI VHUYLFHV UHODWHG WR FHUWLILFDWLRQ H[DP SUHSDUDWLRQ 7KH SODWIRUP SURYLGHV DFWXDO TXHVWLRQV H[DP GXPSV DQG SUDFWLFH WHVWV WR KHOS LQGLYLGXDOV SUHSDUH IRU YDULRXV FHUWLILFDWLRQ H[DPV ZLWK FRQILGHQFH +HUH DUH VRPH NH\ IHDWXUHV DQG VHUYLFHV RIIHUHG E\ .LOOH[DPV FRP $FWXDO ([DP 4XHVWLRQV .LOOH[DPV FRP SURYLGHV DFWXDO H[DP TXHVWLRQV WKDW DUH H[SHULHQFHG LQ WHVW FHQWHUV 7KHVH TXHVWLRQV DUH XSGDWHG UHJXODUO\ WR HQVXUH WKH\ DUH XS WR GDWH DQG UHOHYDQW WR WKH ODWHVW H[DP V\OODEXV %\ VWXG\LQJ WKHVH DFWXDO TXHVWLRQV FDQGLGDWHV FDQ IDPLOLDUL]H WKHPVHOYHV ZLWK WKH FRQWHQW DQG IRUPDW RI WKH UHDO H[DP ([DP 'XPSV .LOOH[DPV FRP RIIHUV H[DP GXPSV LQ 3') IRUPDW 7KHVH GXPSV FRQWDLQ D FRPSUHKHQVLYH FROOHFWLRQ RI TXHVWLRQV DQG DQVZHUV WKDW FRYHU WKH H[DP WRSLFV %\ XVLQJ WKHVH GXPSV FDQGLGDWHV FDQ HQKDQFH WKHLU NQRZOHGJH DQG LPSURYH WKHLU FKDQFHV RI VXFFHVV LQ WKH FHUWLILFDWLRQ H[DP 3UDFWLFH 7HVWV .LOOH[DPV FRP SURYLGHV SUDFWLFH WHVWV WKURXJK WKHLU GHVNWRS 9&( H[DP VLPXODWRU DQG RQOLQH WHVW HQJLQH 7KHVH SUDFWLFH WHVWV VLPXODWH WKH UHDO H[DP HQYLURQPHQW DQG KHOS FDQGLGDWHV DVVHVV WKHLU UHDGLQHVV IRU WKH DFWXDO H[DP 7KH SUDFWLFH WHVWV FRYHU D ZLGH UDQJH RI TXHVWLRQV DQG HQDEOH FDQGLGDWHV WR LGHQWLI\ WKHLU VWUHQJWKV DQG ZHDNQHVVHV *XDUDQWHHG 6XFFHVV .LOOH[DPV FRP RIIHUV D VXFFHVV JXDUDQWHH ZLWK WKHLU H[DP GXPSV 7KH\ FODLP WKDW E\ XVLQJ WKHLU PDWHULDOV FDQGLGDWHV ZLOO SDVV WKHLU H[DPV RQ WKH ILUVW DWWHPSW RU WKH\ ZLOO UHIXQG WKH SXUFKDVH SULFH 7KLV JXDUDQWHH SURYLGHV DVVXUDQFH DQG FRQILGHQFH WR LQGLYLGXDOV SUHSDULQJ IRU FHUWLILFDWLRQ H[DPV 8SGDWHG &RQWHQW .LOOH[DPV FRP UHJXODUO\ XSGDWHV LWV TXHVWLRQ EDQN DQG H[DP GXPSV WR HQVXUH WKDW WKH\ DUH FXUUHQW DQG UHIOHFW WKH ODWHVW FKDQJHV LQ WKH H[DP V\OODEXV 7KLV KHOSV FDQGLGDWHV VWD\ XS WR GDWH ZLWK WKH H[DP FRQWHQW DQG LQFUHDVHV WKHLU FKDQFHV RI VXFFHVV 7HFKQLFDO 6XSSRUW .LOOH[DPV FRP SURYLGHV IUHH [ WHFKQLFDO VXSSRUW WR DVVLVW FDQGLGDWHV ZLWK DQ\ TXHULHV RU LVVXHV WKH\ PD\ HQFRXQWHU ZKLOH XVLQJ WKHLU VHUYLFHV 7KHLU FHUWLILHG H[SHUWV DUH DYDLODEOH WR SURYLGH JXLGDQFH DQG KHOS FDQGLGDWHV WKURXJKRXW WKHLU H[DP SUHSDUDWLRQ MRXUQH\ 'PS .PSF FYBNT WJTJU IUUQT LJMMFYBNT DPN WFOEPST FYBN MJTU .LOO \RXU H[DP DW )LUVW $WWHPSW *XDUDQWHHG