valid ways to invoke this function from the DB2 Command Line Processor?(Choose two.) A. SELECT lastname, e_degree(edlevel) AS degree FROM employee B. SELECT * FROM e_degree(SMALLINT(18)) C. VALUES e_degree(18) D. VALUES e_degree(SMALLINT(18)) E. SELECT * FROM TABLE(e_degree(SMALLINT(18)) 42
Answer: A, D QUESTION: 96 A database developer using Data Studio needs to view sample data in a table. Which view should be used? A. Database Explorer B. Data Project Explorer C. Data Output D. Properties Answer: A QUESTION: 97 Which two actions are supported by Data Studio inthe SQL procedure lifecycle? (Choose two.) A. Create global temporary tables to use in the SQL procedure. B. Debug the SQL procedure. C. Deploy the SQL procedure. D. Use auto complete SQL statements. E. Create user-define types in the SQL procedure. Answer: B, C QUESTION: 98 Click the Exhibit button. ***MISSING EXHIBIT*** BEGIN ATOMIC DECLARE fullname CHAR(40); FOR vl AS SELECT firstnme, midinit, lastname FROM employee DO SET fullname = lastname CONCAT ',' CONCAT firstnme CONCAT ' ' CONCAT midinit; INSERT INTOtnames VALUES (fullname); END FOR END Which statement correctly describes the result of the FOR loop shown in the exhibit? A. FULLNAME is set to the last name of the employee, followed by a comma, the first name, a blank space, and the middle initial. Only the last value for FULLNAME is inserted into table TNAMES. B. FULLNAME is set to the last name of the employee, followed by a comma, the first name, a blank space, and the middle initial. Only the first value for FULLNAME is inserted into
You've reached the end of your free preview.
Want to read all 6 pages?
- Fall '20
- A. FULLNAME