Oracle 1z0-071 問題集

質問 1：
Examine thee statements which execute successfully:
CREATE USER finance IDENTIFIED BY pwfin;
CREATE USER fin manager IDENTIETED BY pwmgr;
CREATE USER fin. Clerk IDENTIFIED BY pwclerk;
GRANT CREATE SESSON 20 finance, fin clerk;
GRANT SELECT ON scott. Emp To finance WITH GRANT OPTION;
CONNECT finance/pwfin
GRANT SELECT ON scott. emp To fin_ _clerk;
Which two are true?
A. Dropping user FINANCE will automatically revoke SELECT on SCOTT. EMP from user FIN _ CLERK
B. Revoking SELECT on SCOTT. EMP from user FINANCE will also revoke the privilege from user FIN_ CLERK.
C. User FINANCE is unable to grant ALL on SCOTT.ENP to FIN MANAGER.
D. User FIN CLERK can grant SELECT on SCORT, ENP to user FIN MANAGER.
E. User FINANCE can grant CREATE SESSION to user FIN MANAGER.
正解：A,B
解説: (Topexam メンバーにのみ表示されます)

質問 2：
In the PROMOTIONS table, the PROMO_BEGTN_DATE column is of data type DATE and the default date format is DD-MON-RR.
Which two statements are true about expressions using PROMO_BEGIN_DATE contained in a query?
A. TO_DATE(PROMO_BEGIN_DATE * 5) will return a date
B. PROMO_BEGIN_DATE-5 will return a date.
C. PROMO_BEGIN_DATE-SYSDATE will return an error.
D. TO_NUMBER(PROMO_BEGIN_DATE)-5 will return number
E. PROMO_BEGIN_DATE-SYSDATE will return a number.
正解：B,E
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which three statements are true about GLOBAL TEMPORARY TABLES?
A. A TRUNCATE command issued in a session causes all rows In a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
B. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
C. A GLOBAL TEMPORARY TABLE's definition is available to multiple sessions.
D. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.
E. GLOBAL TEMPORARY TABLE space allocation occurs at session start.
F. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
正解：A,C,F
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Refer to the exhibit.

Which three statements are true?
A. The COMMISSION column can contain negative values .
B. The DEPTNO column in the EMP table can contain NULLS .
C. The DNAME column has a unique constraint.
D. An index is created automatically in the MANAGER column.
E. The SALARY column must have a value .
F. The MANAGER column is a foreign key referencing the EMPNO column.
G. The DEPTNO column in the EMP table can contain the value 1.
正解：E,F,G
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which two are true about the MERGE statement?
A. The WHEN NOT MATCHED clause can be used to specify the inserts to be performed.
B. The WHEN MATCHED clause can be used to specify the inserts to be performed.
C. The WHEN NOT MATCHED clause can be used to specify the updates to be performed.
D. The WHEN NOT MATCHED clause can be used to specify the deletions to be performed.
E. The WHEN MATCHED clause can be used to specify the updates to be performed.
正解：A,E
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Which two statements are true about date/time functions in a session where NLS_DATE_PORMAT is set to DD-MON-YYYY SH24:MI:SS
A. SYSDATE can be queried only from the DUAL table.
B. CURRENT_TIMESTAMP returns the same date as CURRENT_DATE.
C. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of functional seconds.
D. SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server.
E. SYSDATE can be used in expressions only if the default date format is DD-MON-RR.
F. CURRENT_DATE returns the current date and time as per the session time zone
正解：D,F
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Examine this SQL statement:
SELECT cust_id, cus_last_name "Last Name"
FROM customers
WHERE country_id = 10
UNION
SELECT cust_id CUST_NO, cust_last_name
FROM customers
WHERE country_id = 30
Identify three ORDER BY clauses, any one of which can complete the query successfully.
A. ORDERBY 2, 1
B. ORDER BY "Last Name"
C. ORDER BY "CUST_NO"
D. ORDER BY CUST_NO
E. ORDER BY 2,cust_id
正解：A,B
解説: (Topexam メンバーにのみ表示されます)

質問 8：
Examine the description of the EMPLOYEES table:

Which two queries return rows for employees whose manager works in a different department?
A. SELECT emp. *
FROM employees emp
JOIN employees mgr
ON emp. manager_ id = mgr. employee_ id
AND emp. department_ id<> mgr.department_ id;
B. SELECT emp. *
FROM employees emp
WHERE manager_ id NOT IN (
SELECT mgr.employee_ id
FROM employees mgr
WHERE emp. department_ id < > mgr.department_ id
);
C. SELECT emp.*
FROM employees emp
WHERE NOT EXISTS (
SELECT NULL
FROM employees mgr
WHERE emp.manager id = mgr.employee_ id
AND emp.department_id<>mgr.department_id
);
D. SELECT emp. *
FROM employees emp
RIGHT JOIN employees mgr
ON emp.manager_ id = mgr. employee id
AND emp. department id <> mgr.department_ id
WHERE emp. employee_ id IS NOT NULL;
E. SELECT emp.*
FROM employees emp
LEFT JOIN employees mgr
ON emp.manager_ id = mgr.employee_ id
AND emp. department id < > mgr. department_ id;
正解：A,C
解説: (Topexam メンバーにのみ表示されます)

質問 9：
Examine this incomplete query:
SELECT DATA'2019-01-01'+<INTERVAL CLAUSE>
FROM DUAL;
Which three clauses can replace<INTERVAL CLAUSE>ti add 22 hours to the date?
A. INTERVAL'0 12'DAY TO HOUR
B. INTERVAL '12:00'
C. INTERVAL'720'MINUTE
D. INTERVAL'11:60'HOUR TO MINUTE
E. INTERVAL'12' HOUR
F. INTERVAL'0,5'DAY
正解：C,D,E
解説: (Topexam メンバーにのみ表示されます)