Oracle 1z0-061 問題集

質問 1：
View the Exhibit and examine the structure of the PROMOTIONS table.
Exhibit:

Which two SQL statements would execute successfully? (Choose two.)
A. UPDATE promotionsSET promo_cost = promo_cost+ 100WHERE promo_end_date > TO_DATE(SUBSTR('01-JAN-2000', 8));
B. SELECT promo_begin_dateFROM promotionsWHERE
TO_CHAR(promo_begin_date,'mon dd yy')='jul 01 98';
C. UPDATE promotionsSET promo_cost = promo_cost+ 100WHERE
TO_CHAR(promo_end_date,'yyyy') > '2000';
D. SELECT TO_CHAR(promo_begin_date,'dd/month')FROM promotionsWHERE
promo_begin_date IN (TO_DATE('JUN 01 98'), TO_DATE('JUL 01 98'));
正解：B,C

質問 2：
Which three statements are true about the ALTER TABLE .... DROP COLUMN ....
command?
A. A column can be dropped only if another column exists in the table.
B. A parent key column in the table cannot be dropped.
C. The column in a composite PRIMARY KEY with the CASCADE option can be dropped.
D. A dropped column can be rolled back.
E. A column can be dropped only if it does not contain any data.
正解：A,B,C

質問 3：
Evaluate the SQL statement:
SELECT ROUND(45.953, -1), TRUNC(45.936, 2)
FROM dual;
Which values are displayed?
A. 50 and 45.93
B. 46 and 45.93
C. 46 and 45
D. 45.95 and 45.93
E. 45 and 45.93
F. 50 and 45.9
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 4：
You need to create a table named ORDERS that contain four columns:
1 . AN ORDER_ID column of number data type
2 . A CUSTOMER_ID column of number data type
3 . AN ORDER_STATUS column that contains a character data type
4 . A DATE_ORDERED column to contain the date the order was placed.
When a row is inserted into the table, if no value is provided when the order was placed, today's date should be used instead.
Which statement accomplishes this?
A. CREATE OR REPLACE TABLE orders (order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);
B. CREATE TABLE orders (order_id NUMBER (10), customer_id NUMBER (8),
order_status NUMBER (10), date_ordered DATE DEFAULT SYSDATE);
C. CREATE TABLE orders (order_id NUMBER (10), customer_id NUMBER (8),
order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);
D. CREATE TABLE orders (order_id NUMBER (10), customer_id NUMBER (8),
order_status NUMBER (10), date_ordered DATE = SYSDATE);
E. CREATE OR REPLACE TABLE orders (order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);
F. CREATE TABLE orders (order_id NUMBER (10), customer_id NUMBER (8),
order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
View the Exhibit and examine the structure of the PRODUCTS table.

Which two tasks would require subqueries? (Choose two.)
A. Display the minimum list price for each product status.
B. Display all products whose minimum list price is more than the average list price of products and have the status 'orderable'.
C. Display all suppliers whose list price is less than 1000.
D. Display the total number of products supplied by supplier 102 and have product status as 'obsolete'.
E. Display the number of products whose list price is more than the average list price.
正解：B,E

質問 6：
Which statements are true regarding the WHERE and HAVING clauses in a SELECT statement? (Choose two.)
A. The HAVING clause can be used with aggregate functions in subqueries.
B. The WHERE clause can be used to exclude rows before dividing them into groups.
C. The WHERE clause can be used to exclude rows after dividing them into groups.
D. The aggregate functions and columns used in the HAVING clause must be specified in the SELECT list of the query.
E. The WHERE and HAVING clauses can be used in the same statement only if they are applied to different columns in the table.
正解：A,B

質問 7：
You need to extract details of those products in the SALES table where the PROD_ID column contains the string '_D123'. Which WHERE clause could be used in the SELECT statement to get the required output?
A. WHERE prod_id LIKE '%\_D123%' ESCAPE '\'
B. WHERE prod_id LIKE '%_D123%' ESCAPE '_'
C. WHERE prod_id LIKE '%\_D123%' ESCAPE '\_'
D. WHERE prod_id LIKE '%_D123%' ESCAPE '%_'
正解：A
解説: (Topexam メンバーにのみ表示されます)