1Z0-047最も有効な質問と解答で勉強

仕事や学業の合間にOracle Database SQL Expertの合格を目指す方にとって、限られた時間をどう使うかが最大の課題です。Tech4Examの1Z0-047練習問題は、要点を押さえた264問の問題集で、短い準備期間でも効率よく実力を磨けます。

Oracle 1Z0-047 試験概要:

Oracle 1Z0-047 試験シラバストピック:

Oracle Database SQL Expertに関するよくあるご質問

Oracle Database SQL Expert 認定 1Z0-047 試験問題：

問題 #1

View the Exhibit and examine the descriptions of the EMPLOYEES and DEPARTMENTS tables.
The following SQL statement was executed:
SELECT e.department_id, e.job_id, d.location_id, sum(e.salary) total,
GROUPING(e. department_id) GRP_DEPT,
GROUPING(e.job_id) GRPJOB,
GROUPING(d. location_id) GRP_LOC
FROM employees e JOIN departments d
ON e.department_id = d.department_id
GROUP BY ROLLUP (e.department_id, e.job_id, d.location_id);
View the Exhibit2 and examine the output of the command.
Which two statements are true regarding the output? (Choose two.)

A. The value 1 in GRPJOB and GRP_LOC means that JOB_ID and LOCATION_ID columns are not taken into account to generate the subtotal.
B. The value 1 in GRPJOB and GRP_LOC means that the NULL value in JOBJD and LOCATIONJD columns are taken into account to generate the subtotal.
C. The value 1 in GRP_LOC means that the LOCATION_ID column is taken into account to generate the subtotal.
D. The value 0 in GRP_DEPT, GRPJOB, and GRP_LOC means that DEPARTMENT_ID, JOB_ID, and LOCATION_ID columns are taken into account to generate the subtotal

問題 #2

View the Exhibit and examine the description of the PRODUCT_INFORMATION table.
Which SQL statement would retrieve from the table the number of products having LIST_PRICE
as NULL?

A. SELECT COUNT(DISTINCT list_price)
FROM product_information
WHERE list_price IS NULL;
B. SELECT COUNT(list_price)
FROM product_information
WHERE list_price = NULL;
C. SELECT COUNT(NVL(list_price, 0))
FROM product_information
WHERE list_price IS NULL;
D. SELECT COUNT(list_price)
FROM product_information
WHERE list_price IS NULL;

問題 #3

Given below are the SQL statements executed in a user session:
CREATE TABLE product
(pcode NUMBER(2),
pnameVARCHAR2(10));
INSERT INTO product VALUES(1, 'pen');
INSERT INTO product VALUES (2,'pencil);
SAVEPOINT a;
UPDATE product SET pcode = 10 WHERE pcode = 1;
SAVEPOINT b;
DELETE FROM product WHERE pcode = 2;
COMMIT;
DELETE FROM product WHERE pcode=10;
ROLLBACK TO SAVEPOINT a;
Which statement describes the consequences?

A. Only the second DELETE statement would be rolled back.
B. No SQL statement would be rolled back.
C. Both the DELETE statements and the UPDATE statement would be rolled back.
D. Both the DELETE statements would be rolled back.

問題 #4

View the Exhibit and examine the description of EMPLOYEES and DEPARTMENTS tables. You want to display the EMPLOYEE_ID, LAST_NAME, and SALARY for the employees who get the maximum salary in their respective departments. The following SQL statement was written: WITH SELECT employee_id, last_name, salary FROM employees
WHERE (department_id, salary) = ANY (SELECT*
FROM dept_max)
dept_max as (SELECT d.department_id, max(salary)
FROM departments d JOIN employees j
ON (d. department_id = j. department_id)
GROUP BY d. department_id);
Which statement is true regarding the execution and the output of this statement?

A. The statement would not execute because the main query block uses the query name before it is even created.
B. The statement would not execute because the = ANY comparison operator is used instead of=.
C. The statement would not execute because the comma is missing between the main query block and the query name.
D. The statement would execute and give the desired results.

問題 #5

Which statement correctly differentiates a system privilege from an object privilege?

A. A system privilege is the right to perform specific activities in a database whereas an object privilege is a right to perform activities on a specific object in the database.
B. System privileges can be granted only by the DBA whereas object privileges can be granted by DBAs or the owner of the object.
C. System privileges give the rights to only create user schemas whereas object privileges give rights to manipulate objects in a schema.
D. Users require system privileges to gain access to the database whereas they require object privileges to create objects in the database.

解説：