Viele Kandidaten unterschätzen, wie tief die Oracle Database SQL Expert Prüfung in die praktische Anwendung einsteigt. Mit den Übungstests von ITZert arbeiten Sie die 264 Praxisfragen zur 1Z0-047 systematisch durch und erkennen Wissenslücken frühzeitig.

Oracle 1Z0-047 Prüfungsübersicht:

Zertifizierungsanbieter:	Oracle
Prüfungsname:	Oracle Database SQL Expert
Prüfungsnummer:	1Z0-047
Verwandte Zertifizierungen:	Oracle Database SQL Fundamentals I (1Z0-051)
Mindestpunktzahl:	Nicht öffentlich bekannt (Oracle veröffentlicht keine genauen Bestehensgrenzen)
Prüfungsdauer:	120 Minuten
Gültigkeitsdauer des Zertifikats:	in der Regel 3 Jahre (je nach Oracle-Richtlinie)
Anzahl der Fragen:	70
Prüfungsgebühr:	ca. 195 USD (je nach Region unterschiedlich)
Verfügbare Sprachen:	Deutsch, Japanisch, Spanisch, Englisch
Prüfungsformat:	Mehrfachauswahl, Einfachauswahl
Beispielfragen:
Prüfungsmethode:	Vor Ort bei Pearson VUE oder als Online-Prüfung mit Aufsicht
Voraussetzungen:	Keine formelle Voraussetzung, aber Kenntnisse der SQL-Grundlagen werden empfohlen
Offizielle Syllabus-URL:	https://www.oracle.com/education/certification/

Oracle 1Z0-047 Prüfungsthemen:

Oracle Database SQL Expert: Die wichtigsten Fragen im Überblick

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

Frage #1

View the Exhibit and examine the data in the LOCATIONS table.
Evaluate the following SOL statement: SELECT street_address FROM locations WHERE REGEXP_INSTR(street_address,'[^[: alpha:]] ') = 1;
Which statement is true regarding the output of this SOL statement?

A. It would display all the street addresses where the first character is a special character.
B. It would display all the street addresses where the first character is not a letter of the alphabet.
C. It would display all the street addresses that do not have a substring 'alpha1.
D. It would display all the street addresses where the first character is a letter of the alphabet.

Frage #2

View the Exhibit and examine the structure of the ORDERS table. The ORDER_ID column is the
PRIMARY KEY in the ORDERS table.
Evaluate the following CREATE TABLE command:
CREATE TABLE new_orders(ord_id, ord_date DEFAULT SYSDATE, cus_id) AS SELECT order_id.order_date,customer_id
FROM orders;
Which statement is true regarding the above command?

A. The NEW_IDRDERS table would not get created because the column names in the CREATE TABLE command and the SELECT clause do not match.
B. The NEW_IDRDERS table would get created and all the constraints defined on the specified columns in the ORDERS table would be passed to the new table.
C. The NEW_IDRDERS table would get created and only the NOT NULL constraint defined on the specified columns would be passed to the new table.
D. The NEW_IDRDERS table would not get created because the DEFAULT value cannot be specified in the column definition.

Frage #3

View the Exhibit and examine the structure of the ORDERS table.
The ORDERS table belongs to the user OE. HR is another user in the database.
Evaluate the commands issued by users OE and HR in the following order:
Statement 1 by user OE: GRANT SELECT,
UPDATE(customer_id, order_total)
ON orders
TOhr;
Statement 1 by user HR: SELECT * FROM oe.orders;
Statement 2 by user HR: UPDATE oe.orders
SET order_totah 10000;
Which statement is true regarding the above commands?

A. Statement 1 by user OE would not work because the statement has to be issued by the DB
B. Statement 1 by user HR would not work because SELECT and UPDATE privileges have been granted only on CUSTOMER_ID and ORDER_TOTAL columns.
C. There are no errors in the statements issued by OE and HR; all the statements would execute successfully.
D. Statement 2 by user HR would not work because the grant is only for SELECT in a subquery of update.

Frage #4

Which two statements are true regarding the GROUP BY clause in a SQL statement? (Choose two.)

A. The GROUP BY clause is mandatory if you are using an aggregate function in the SELECT clause.
B. Using the WHERE clause after the GROUP BY clause excludes the rows after creating groups.
C. If the SELECT clause has an aggregate function, then those individual columns without an aggregate function in the SELECT clause should be included in the GROUP BY clause.
D. Using the WHERE clause before the GROUP BY clause excludes the rows before creating groups.
E. You can use column alias in the GROUP BY clause.

Frage #5

Evaluate the following CREATE SEQUENCE statement:
CREATE SEQUENCE seql START WITH 100
INCREMENT BY 10 MAXVALUE 200 CYCLE NOCACHE;
The sequence SEQ1 has generated numbers up to the maximum limit of 200. You issue the
following SQL statement:
SELECT seql.nextval FROM dual;
What is displayed by the SELECT statement?

A. 10
B. 100
C. 1
D. an error

Fragen und Antworten: