Tag: databases

Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"? A. SELECT TO_CHAR(SYSDATE,'yyyy') FROM dual; B. SELECT TO_DATE(SYSDATE,'yyyy') FROM dual; C. SELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY') FROM dual; D. SELECT DECODE(SUBSTR(SYSDATE, 8), 'year') FROM dual; E. SELECT TO_CHAR(SUBSTR(SYSDATE, 8,2),'yyyy') FROM dual;

Which are iSQL*Plus commands? A. INSERT B. UPDATE C. SELECT D. DESCRIBE E. DELETE F. RENAME

Which standalone utility is used to Preformat the Active Log

Which standalone utility is used to modify the BSDS(BootStrap DataSet)?

Which standalone utility can be used to list System and Utility timestamps, Contents of Quiesce history record, active Log datasets available etc.

Which standalone Utility verifies the Integrity of DB2 directory and Catalog

Which Utility is used to estimate space savings to be achieved by DB2 Data compression in tablespaces?

Which standalone utility can be used to move data between subsystems by translating OBID, PSID and DBID?

Which standalone utility used to format the contents of the recovery log for display?