Which three statements are true about multiple-row subqueries?

• A.They can contain group functions and the GROUP BYclause, but not the HAVINGclause.
• B.They can contain group functions and GROUP BYand HAVINGclauses.
• C.They can contain a subquery within a subquery.
• D.They can return only one column but multiple rows.
• E.They can return multiple columns as well as rows.
• F.They cannot contain a subquery within a subquery.

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the transactions table:

Which two SQL statements execute successfully?

• A.SELECT customer_id AS 'CUSTOMER-ID',transaction_date AS DATE, amount+100 'DUES' from transactions;
• B.SELECT customer_id CUSTID, transaction_date TRANS_DATE,amount+100 DUES FROM transactions;
• C.SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount+100 DUES FROM transactions;
• D.SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount+100 "DUES" from transactions;
• E.SELECT customer id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount+100 "DUES AMOUNT" FROM transactions;

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the DUAL table?

• A.It can display multiple rows and columns.
• B.It can be used to display only constants or pseudo columns.
• C.It can be accessed only by the SYS user.
• D.It can display multiple rows but only a single column.
• E.It consists of a single row and single column of VARCHAR2 data type.
• F.It can be accessed by any user who has the SELECT privilege in any schema.

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the description of the DEPARTMENTS and EMPLOYEES tables.

You wrote this SQL statement to retrieve EMPLOYEE_ID, FIRST_NAME, and DEPARTMENT NAME, for all employees:
SELECT employee_id, first_name, department_name
FROM employees
NATURAL JOIN departments;
The desired output is not obtained after executing the above SQL statement. What could be the reason for this?

• A.The table prefix is missing for the column names in the SELECT clause.
• B.The NATURAL JOIN clause is missing the USING clause.
• C.The DEPARTMENTS table is not used before the EMPLOYEES table in the FROM clause.
• D.The EMPLOYEES and DEPARTMENTS tables have more than one column with the same column name and data type.

Comment: *

Name: *

Email: *

Verification: *

Which three privileges can be restricted to a subset of columns in a table? (Choose three.)

• A.INDEX
• B.UPDATE
• C.DELETE
• D.ALTER
• E.REFERENCES
• F.INSERT
• G.SELECT

Comment: *

Name: *

Email: *

Verification: *