Oracle Database 23ai SQL Associate 1Z1-171 Prüfungsfragen mit Lösungen:
1. What is the primary purpose of granting privileges in Oracle Database?
A) To increase query performance
B) To define the structure of database tables
C) To create new tables and indexes
D) To control user access to database objects and operations
2. Which SQLPlus command displays defined substitution variable values?
A) DEFINE
B) SHOW
C) LIST
D) VERIFY
3. What does the COMMIT statement do in SQL?
A) Discards all pending changes in the transaction
B) Saves all pending changes to the database permanently
C) Rolls back changes to a previous state
D) Begins a new transaction
4. What is the output of the following query?
SELECT CURRENT_DATE FROM dual;
A) The current date in the database time zone
B) The current date and time in UTC
C) The current date and time in the database time zone
D) The current date in the session time zone
5. What will the following SQL query return?
SELECT TRUNC(15.678, 2) AS truncated_value FROM dual;
A) 15.67
B) 15.68
C) 15.678
D) 15.6
Fragen und Antworten:
| 1. Frage Antwort: D | 2. Frage Antwort: A | 3. Frage Antwort: B | 4. Frage Antwort: D | 5. Frage Antwort: A |
1423 Kundenbewertungen
