1Z0-047 무료 덤프문제 온라인 액세스

View the Exhibit and examine the details of the EMPLOYEES table.
Evaluate the following SQL statement:
SELECT phone_number,
REGEXP_REPLACE(phone_number,'([[: digit: ]]{3})\.([[: digit: ]]{3})\.([[: digit: ]]{4})', ,(\1)\2-\3')
"PHONE NUMBER"
FROM employees;
The query was written to format the PHONE_NUMBER for the employees. Which option would
be the correct format in the output?

• A.xxx-(xxx)-xxxx
• B.(xxx) xxxxxxx
• C.(xxx) xxx-xxxx
• D.xxx-xxx-xxxx

View the Exhibit and examine the structure of ORD and ORD_ITEMS tables.
In the ORD table, the PRIMARY KEY is ORD_NO and in the ORD_ITEMS tables the composite PRIMARY KEY is (ORD_NO, ITEM_NO).
Which two CREATE INDEX statements are valid? (Choose two.)

• A.CREATE INDEX ord_idx
  ON ord_items(item_no);
• B.CREATE INDEX ord_idx
  ON ord,ord_items(ord_no, ord_date,qty);
• C.CREATE INDEX ord_idx
  ON ord(ord_no);
• D.CREATE INDEX ord_idx
  ON ord_items(ord_no);

View the Exhibit and examine the structure of the EMP table which is not partitioned and not an
index-organized table.
Evaluate the following SQL statement:
ALTER TABLE emp DROP COLUMN first_name;
Which two statements are true regarding the above command? (Choose two.)

• A.The FIRST_NAME column would be dropped provided at least one or more columns remain in the table.
• B.The FIRST_NAME column can be rolled back provided the SET UNUSED option is added to the above SQL statement.
• C.The FIRST_NAME column can be dropped even if it is part of a composite PRIMARY KEY provided the CASCADE option is used.
• D.The FIRST_NAME column would be dropped provided it does not contain any data.

View the Exhibit and examine the description for EMPLOYEES and DEPARTMENTS tables.
Evaluate the following SQL statement:
SELECT e.department_id, e.job_id, d.location_id, sum(e. salary) total FROM employees e JOIN departments d ON e.department_id = d.department_id GROUP BY CUBE (e.department_id, e.job_id, d.location_id);
Which two statements are true regarding the output of this command? (Choose two.)

• A.The output would display the total salary for all the departments.
• B.The output would display the total salary for all the JOB_IDs in a department.
• C.The output would display only the grand total of the salary for all JOB_IDs in a LOCATION_ID.
• D.The output would display the grand total of the salary for only the groups specified in the GROUP BY clause.

SCOTT is a user in the database.
Evaluate the commands issued by the DBA:
1 - CREATE ROLE mgr;
2 - GRANT CREATE TABLE, SELECT
ON oe. orders
TO mgr;
3 - GRANT mgr, create table TO SCOTT;
Which statement is true regarding the execution of the above commands?

• A.Statement 3 would not execute because role and system privileges cannot be granted together in a single GRANT statement.
• B.Statement 1 would not execute because the WITH GRANT option is missing.
• C.Statement 2 would not execute because system privileges and object privileges cannot be granted together in a single GRANT command.
• D.Statement 1 would not execute because the IDENTIFIED BY <password> clause is missing.