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

On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:
$> sqlldr hr/hr@pdb table=employees
Which two statements are true regarding the command?

• A.It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.
• B.It fails because no SQL *Loader control file location is specified.
• C.It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.
• D.It fails because no SQL *Loader data file location is specified.

Which three statements/commands would cause a transaction to end? (Choose three.)

• A.SAVEPOINT
• B.SELECT
• C.ROLLBACK
• D.CREATE
• E.COMMIT

Examine the structure of the EMP_DEPT_VU view:

Which SQL statement produces an error?

• A.SELECT department_id, SUM(salary) FROM emp_dept_vu GROUP BY department_id;
• B.SELECT job_id, SUM(salary) FROM emp_dept_vu WHERE department_id IN (10, 20) GROUP BY job_id HAVING SUM(salary) > 20000;
• C.SELECT department_id, job_id, AVG(salary) FROM emp_dept_vu GROUP BY
  department_id, job_id;
• D.SELECT *FROM emp_dept_vu;
• E.None of the statements produce an error; all are valid.

Which is the valid CREATE [TABLE statement?

• A.CREATE TABLE emp9$# (emp_no NUMBER(4));
• B.CREATE TABLE emp*123 (emp_no NUMBER(4));
• C.CREATE TABLE emp9$# (emp_no NUMBER(4). date DATE);
• D.CREATE TABLE 9emp$# (emp_no NUMBER(4));

See the Exhibit and examine the structure of ORD table:
Exhibit:

Evaluate the following SQL statements that are executed in a user session in the specified order:
CREATE SEQUENCE ord_seq;
SELECT ord_seq.nextval
FROM dual;
INSERT INTO ord
VALUES (ord_seq.CURRVAL, '25-jan-2007, 101);
UPDATE ord
SET ord_no= ord_seq.NEXTVAL
WHERE cust_id =101;
What would be the outcome of the above statements?

• A.The CREATE SEQUENCE command would not execute because the minimum value and maximum value for the sequence have not been specified.
• B.All the statements would execute successfully and the ORD_NO column would contain the value 2 for the CUST_ID 101.
• C.All the statements would execute successfully and the ORD_NO column would have the value 20 for the CUST_ID 101 because the default CACHE value is 20.
• D.The CREATE SEQUENCE command would not execute because the starting value of the sequence and the increment value have not been specified.