1z0-071 무료 덤프문제 온라인 액세스

You execute these commands:
CREATE TABLE customers (customer id INTEGER, customer name VARCHAR2 (20)); INSERT INTO customers VALUES (1,'Custmoer1 '); SAVEPOINT post insert; INSERT INTO customers VALUES (2, 'Customer2 ');
<TODO>
SELECTCOUNT (*) FROM customers;
Which two, used independently, can replace <TODO> so the query retums 1?

• A.COMMIT;
• B.ROLIBACK TO SAVEPOINT post_ insert;
• C.ROLLEBACK TO post_ insert;
• D.ROLLBACK;
• E.CONOIT TO SAVEPOINT post_ insert;

Choose the best answer.
Examine the description of the EMPLOYEES table:

Which query is valid?

• A.SELECT depe_id,join_date,SUM(salary) FROM employees GROUP BY dept_id:
• B.SELECT dept_id,MAX(AVG(salary)) FROM employees GROUP BY dept_id;
• C.SELECT dept_id, join_date,SUM(salary) FROM employees GROUP BY dept_id, join_date;
• D.SELECT dept_id,AVG(MAX(salary)) FROM employees GROUP BY dapt_id;

Examine thee statements which execute successfully:
CREATE USER finance IDENTIFIED BY pwfin;
CREATE USER fin manager IDENTIETED BY pwmgr;
CREATE USER fin. Clerk IDENTIFIED BY pwclerk;
GRANT CREATE SESSON 20 finance, fin clerk;
GRANT SELECT ON scott. Emp To finance WITH GRANT OPTION;
CONNECT finance/pwfin
GRANT SELECT ON scott. emp To fin_ _clerk;
Which two are true?

• A.User FINANCE can grant CREATE SESSION to user FIN MANAGER.
• B.Revoking SELECT on SCOTT. EMP from user FINANCE will also revoke the privilege from user FIN_ CLERK.
• C.Dropping user FINANCE will automatically revoke SELECT on SCOTT. EMP from user FIN _ CLERK
• D.User FINANCE is unable to grant ALL on SCOTT.ENP to FIN MANAGER.
• E.User FIN CLERK can grant SELECT on SCORT, ENP to user FIN MANAGER.

Which two are true about virtual columns?

• A.They can be referenced in the set clause of an update statement as the name of the column To be updated.
• B.They can be referenced in the column expression of another virtxial column.
• C.They can be referenced In the where clause of an update or debete statement.
• D.They cannot have a data type explicitly specified.
• E.They can be indexed.

Examine the description of the EMPLOYEES table:

NLS_DATE FORMAT is DD-MON-RR.
Which two queries will execute successfully?

• A.SELECT AVG(MAX(salary)) FROM employees GROUP BY salary;
• B.SELECT dept_ id, AVG(MAX(salary)) FROM employees GROUP BY dept_id, salary;
• C.SELECT dept_ iD, sum(salary) FROM employees WHERE hire_date > '01-JAN-9' GROUP BY dept_id;
• D.SELECT dept_ id, AVG (MAX(salary)) FROM employees GROUP By dept_id HAVING hire_date> ' O1-JAN-19';
• E.SELECT dept id, MAX (SUM(salary)) FROM employees GROUP BY dept_id;