Which statement will return a comma-separated list of employee names in alphabetical order for each department in the EMP table?

• A.SELECT deptno,LISTAGG(ename, ' , ') WITHIN GROUP AS employee_list FROM emp GROUP BY deptno;
• B.SELECT deptno,LISTAGG(ename, ', ') WITHIN GROUP (GROUP BY deptno) AS employee_list FROM emp ORDER BY ename;
• C.SELECT deptno,LISTAGG(ename, ', ') WITHIN GROUP AS employee_list FROM emp GROUP BY deptno ORDER BY ename;
• D.SELECT deptno,LISTAGG(ename, ', ') WITHIN GROUP (ORDER BY ename) AS employee_list FROM emp GROUP BY deptno;

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the PRODUCT_INFORMATION table. (Choose the best answer.)

PRODUCT_ID column is the primary key.
You create an index using this command:
SQL > CREATE INDEX upper_name_idx
ON product_information(UPPER(product_name));
No other indexes exist on the PRODUCT_INFORMATION table.
Which query would use the UPPER_NAME_IDX index?

• A.SELECT product_id, UPPER(product_name)
  FROM product_information
  WHERE UPPER(product_name) = 'LASERPRO' OR list_price > 1000;
• B.SELECT UPPER(product_name)
  FROM product_information;
• C.SELECT UPPER(product_name)
  FROM product_information
  WHERE product_id = 2254;
• D.SELECT product_id
  FROM product_information
  WHERE UPPER(product_name) IN ('LASERPRO', 'CABLE');

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the PRODUCTStable

Which two tasks would require subqueries? (Choose two.)

• A.display the number of products whose PROD_LIST_PRICEis more than the average PROD_LIST_PRICE
• B.display all products whose PROD_MIN_PRICEis more than the average PROD_LIST_PRICEof all products, and whose status is orderable
• C.display suppliers whose PROD_LIST_PRICEis less than 1000
• D.display the total number of products supplied by supplier 102which have a product status as 'OBSOLETE'
• E.display the minimum PROD_LIST_PRICEfor each product status

Comment: *

Name: *

Email: *

Verification: *

Which statement adds a column called SALARYto the EMPLOYEEStable having 100 rows, which cannot contain null?

• A.ALTER TABLE EMPLOYEES
  ADD SALARY NUMBER(8,2) DEFAULT 0 NOT NULL;
• B.ALTER TABLE EMPLOYEES
  ADD SALARY NUMBER(8,2) DEFAULT NOT NULL;
• C.ALTER TABLE EMPLOYEES
  ADD SALARY NUMBER(8,2) DEFAULT CONSTRAINT p_nn NOT NULL;
• D.ALTER TABLE EMPLOYEES
  ADD SALARY NUMBER(8,2) NOT NULL;

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about an Oracle database? (Choose two.)

• A.A VARCHAR2column without data has a NULLvalue.
• B.A column definition can specify multiple data types.
• C.A NUMBERcolumn without data has a zero value.
• D.A table can have multiple primary keys.
• E.A table can have multiple foreign keys.

Comment: *

Name: *

Email: *

Verification: *