Die Oracle Database SQL Expert gilt im Jahr 2026 als anspruchsvoller Nachweis Ihres Fachwissens – und genau deshalb lohnt sich eine strukturierte Vorbereitung. Die 264 Praxisfragen von Fast2test wurden von erfahrenen Experten zusammengestellt und decken alle relevanten Themen der 1Z1-047 Prüfung ab.

Oracle 1Z1-047 Prüfungsübersicht:

Oracle 1Z1-047 Prüfungsthemen:

FAQ: Alles Wichtige zur Oracle 1Z1-047 Zertifizierungsprüfung

Oracle Database SQL Expert 1Z1-047 Prüfungsfragen mit Lösungen

Frage #1

You need to load information about new customers from the NEW_CUST table into the tables CUST and CUST_SPECIAL If a new customer has a credit limit greater than 10,000, then the details have to be inserted into CUST_SPECIAL All new customer details have to be inserted into the CUST table. Which technique should be used to load the data most efficiently?

A. the multitable INSERT command
B. the MERGE command
C. INSERT using WITH CHECK OPTION
D. external table

Frage #2

View the Exhibit and examine the description of the EMPLOYEES and DEPARTMENTS tables.
You want to display the LAST_NAME for the employees, LAST_NAME for the manager of the
employees, and the DEPARTMENT_NAME for the employees having 100 as MANAGER_ID.
The following SQL statement was written:
SELECT m.last_name "Manager", e.last_name "Employee", department_name "Department"
FROM employees m JOIN employees e
ON (m.employee_id = e.manager_id)
WHERE e.manager_id=100
JOIN departments d
ON (e.department_id = d.department_id);
Which statement is true regarding the output of this SQL statement?

A. The statement would not execute because the self join uses the ON clause instead of the USING clause.
B. The statement would not execute because the ON clause is written twice.
C. The statement would not execute because the WHERE clause is wrongly placed.
D. The statement would provide the desired results.

Frage #3

View the Exhibit and examine the data in the DEPARTMENTS tables.
Evaluate the following SQL statement:
SELECT department_id "DEPT_ID", department_name , 'b' FROM departments WHERE department_id=90 UNION SELECT department_id, department_name DEPT_NAME, 'a' FROM departments WHERE department_id=10 Which two ORDER BY clauses can be used to sort the output of the above statement? (Choose two.)

A. ORDER BY 'b';
B. ORDER BY 3;
C. ORDER BY DEPT NAME;
D. ORDER BY DEPT_ID;

Frage #4

View the Exhibit and examine the structure of the EMP table.
You executed the following command to add a primary key to the EMP table:
ALTER TABLE emp
ADD CONSTRAINT emp_id_pk PRIMARY KEY (emp_id)
USING INDEX emp_id_idx;
Which statement is true regarding the effect of the command?

A. The PRIMARY KEY is created and it would use an existing unique index.
B. The PRIMARY KEY would be created in a disabled state because it is using an existing index.
C. The PRIMARY KEY is created along with a new index.
D. The statement produces an error because the USING clause is permitted only in the CREATE TABLE command.

Frage #5

Which statement is true regarding the CUBE operator in the GROUP BY clause of a SQL statement?

A. It produces 2 n possible superaggregate combinations, if the n columns and expressions are specified in the GROUP BY clause.
B. It produces only aggregates for the groups specified in the GROUP BY clause.
C. It finds all the NULL values in the superaggregates for the groups specified in the GROUP BY clause.
D. It produces n+1 possible superaggregate combinations, if the n columns and expressions are specified in the GROUP BY clause.

Fragen und Antworten: