Oracle 1z0-061 問題集

質問 1：
Which two statements are true about WHERE and HAVING clauses? (Choose two)
A. A HAVING clause can be used to restrict both rows and groups.
B. A HAVING clause can be used to restrict groups only.
C. A HAVING clause CANNOT be used in sub queries.
D. A WHERE clause can be used to restrict both rows and groups.
E. A WHERE clause can be used to restrict rows only.
F. A WHERE clause CANNOT be used in a query of the query uses a HAVING clause.
正解：B,E
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which statement adds a constraint that ensures the CUSTOMER_NAME column of the CUSTOMERS table holds a value?
A. ALTER TABLE customers MODIFY name CONSTRAINT cust_name_nn NOT NULL;
B. ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn
NOT NULL;
C. ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name NOT NULL;
D. ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn IS NOT NULL;
E. ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;
F. ALTER TABLE customers MODIFY CONSTRAINT cust_name_nn CHECK
customer_name IS NOT NULL;
正解：B

質問 3：
Which statement adds a column called salary to the employees table having 100 rows, which cannot contain null?

A. Option A
B. Option C
C. Option D
D. Option B
正解：B

質問 4：
Which SQL statement returns a numeric value?
A. SELECT TO_NUMBER(hire_date + 7) FROM EMP;
B. SELECT sysdate-hire_date FROM EMP;
C. SELECT ROUND(hire_date) FROM EMP;
D. SELECT ADD_MONTHS(MAX(hire_Date), 6) FROM EMP;
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:

Which DELETE statement is valid?
A. DELETE * FROM employeesWHERE employee_id=(SELECT employee_id FROM
new_employees);
B. DELETE FROM employeesWHERE employee_id IN (SELECT employee_id . FROM new_employees . WHERE name = 'Carrey');
C. DELETE * FROM employeesWHERE employee_id IN (SELECT employee_id . FROM new_employees . WHERE name = 'Carrey');
D. DELETE FROM employeesWHERE employee_id = (SELECT employee_id FROM
employees);
正解：B

質問 6：
Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:
EMPLOYEES
EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25)
HIRE_DATE DATE
NEW_EMPLOYEES
EMPLOYEE_ID NUMBER Primary Key
NAME VARCHAR2(60)
Which MERGE statement is valid?
A. MERGE new_employees c FROM employees e ON (c.employee_id = e.employee_id) WHEN MATCHED THEN UPDATE SET c.name = e.first_name ||', '|| e.last_name WHEN NOT MATCHED THEN INSERT INTO new_employees VALUES (e.employee_id, e.first_name ||', '||e.last_name);
B. MERGE INTO new_employees c USING employees e ON (c.employee_id
e.employee_id) WHEN MATCHED THEN UPDATE SET c.name = e.first_name ||', '|| e.last_name WHEN NOT MATCHED THEN INSERT VALUES (e.employee_id, e.first_name ||', '||e.last_name);
C. MERGE INTO new_employees c USING employees e ON (c.employee_id
e.employee_id) WHEN EXISTS THEN UPDATE SET c.name = e.first_name ||', '|| e.last_name WHEN NOT MATCHED THEN INSERT VALUES(e.employee_id, e.first_name ||', '||e.last_name);
D. MERGE new_employees c USING employees e ON (c.employee_id = e.employee_id) WHEN EXISTS THEN UPDATE SET c.name = e.first_name ||', '|| e.last_name WHEN NOT MATCHED THEN INSERT VALUES (e.employee_id, e.first_name ||', '||e.last_name);
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 7：
You are currently located in Singapore and have connected to a remote database in Chicago.
You issue the following command:
Exhibit:

PROMOTIONS is the public synonym for the public database link for the PROMOTIONS table.
What is the outcome?
A. An error because the WHERE condition specified is invalid
B. Number of days since the promo started based on the current Chicago data and time
C. An error because the ROUND function specified is invalid
D. Number of days since the promo started based on the current Singapore data and time.
正解：B