HP Exam Questions

How do you access the current data on the SQL/MP view $data.mycat.myview from mxci?

How do you access the current data on the SQL/MP view $data.mycat.myview from mxci? (Select
two.)

A.
SELECT * FROM $data.mycat.myview;

B.
CREATE VIEW cat.sch.myview AS SELECT ordernum, order_qty FROM $data.mycat.myview;
SELECT*FROM cat.sch.myview;

C.
CREATE SQLMP ALIAS cat.sch.myview $data.mycat.myview; SELECT * FROM cat.sch.myview

D.
CREATE TABLE cat.sch.myview LIKE &data.mycat.myview; INSERT INTO cat.sch.myview SELECT *
FROM $data.mycat.myview; SELECT * FROM cat.sch.myview;