1Z1-051 試験問題を無料オンラインアクセス
| 試験コード: | 1Z1-051 |
| 試験名称: | Oracle Database: SQL Fundamentals I |
| 認定資格: | Oracle |
| 無料問題数: | 254 |
| 更新日: | 2026-11-07 |
Evaluate the SQL statement:
TRUNCATE TABLE DEPT;
Which three are true about the SQL statement? (Choose three.)
View the Exhibit and examine the structure of the SALES table.
The following query is written to retrieve all those product IDs from the SALES table that have more than 55000 sold and have been ordered more than 10 times.
Which statement is true regarding this SQL statement?
Evaluate the following SQL statements:
Exhibit:
Exhibit:
The above command fails when executed. What could be the reason?
Examine the structure and data in the PRIC E_LIST table: Name Null? Type
PROD_D NOT NULL NUMBER(3)
PROD_PRICE VARCHAR2(10)
PROD_ID PROD PRICE
100 $234.55
101 $6,509.75
102 $1,234
in the same format as the PROD_PRICE. Which SQL statement would give the required result?