Oracle 1z0-071 問題集

質問 1：
Which two statements will convert the string Hello world to ello wozid?
A. SELECT SUBSTR('Hello world', 2) FROM DUAL;
B. SELECT INITCAP(TRIM('H' FROM 'Hello World')) FROM DUAL;
C. SELECT LOWER (SUBSTR('Hello World, 2, 1)) FROM DUAL;
D. SELECT LOWER (SUBSTR('Hello World', 2)) FROM DUAL;
E. SELECT LOWER(TRIM('H' FROM 'Hello World')) FROM DUAL;
正解：A,D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
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 メンバーにのみ表示されます)

質問 3：
A session's NLS_DATE_FORMAT is set to DD Mon YYYY .
Which two queries return the value 1 Jan 2019?
A. SELECT to_date(' 2019-01-01 ', 'YYYY -MM-DD' ) FROM DUAL;
B. SELECT TO_ DATE('2019-01-01') FROM DUAL;
C. SELECT DATE '2019-01-01' FROM DUAL ;
D. SELECT TO_CHAR('2019-01-01') FROM DUAL; 2019-01-01
E. SELECT '2019-01-01' FROM DUAL ; 2019-01-01
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Examine this statement:

Which two things must be changed for it to execute successfully?
A. One of the LONG columns must be changed to a VARCHAR2 or CLOB.
B. The foreign key constraint on DEPT_ID must be defined at the table level instead of the column level.
C. The word CONSTRAINT in the foreign key constraint on DEPT_ID must be changed to FOREIGN KEY.
D. The primary key constraint on BMP_ID must have a name.
E. The NOT NULL constraint on ENAME must be defined at the column level instead of the table level.
正解：A,E
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which two statements are true about * _TABLES views?
A. You must have ANY TABLE system privileges, or be granted object privileges on the table, to view a table in USER_TABLES.
B. USER TABLES displays all tables owned by the current user.
C. You must have ANY TABLE system privileges, or be granted object privileges on the table, to view a table in ALL_TABLES.
D. You must have ANY TABLE system privileges, or be granted object privilges on the table, to viewa tabl e in DBA TABLES.
E. ALL TABLES displays all tables owned by the current user.
F. All users can query DBA_TABLES successfully.
正解：B,E
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Examine the description products table:

Examine the description of the new_projects table;

Which two queries execute successfully?
A.

B.

C.

D.

E.

正解：D,E
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Which is the default column or columns for sorting output from compound queries using SET operators such as INTERSECT in a SQL statement?
A. The first VARCHAR2 column in the first SELECT of the compound query
B. The first NUMBER or VARCHAR2 column in the last SELECTof the compound query
C. The first column in the first SELECT of the compound query
D. The first column in the last SELECT of the compound query
E. The first NUMBER column in the first SELECT of the compound query
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 8：
You execute this query:
SELECT TO CHAR (NEXT_DAY(LAST_DAY(SYSDATE),'MON' ),' dd"Monday for" fmMonth rrr') FROM DUAL; What is the result?
A. It returns the date for the first Monday of the next month.
B. It executes successfully but does not return any result.
C. It generates an error.
D. It returns the date for the last Monday of the current month.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 9：
Examine this statement:
SELECT last name
FROM employees
ORDER BY CASE WHEN salary = (SELECT MAX(salary) FROM employees)
THEN 'A'
ELSE last_ name
END ,last_name DESC;
Which two statements are true?
A. All remaining employee names will appear in an unspecified order.
B. All remaining employee names will appear in descending order.
C. The names of employees earning the maximum salary will appear first In ascending order.
D. The names of employees earning the maximum salary will appear first in descending order.
E. The names of employees earning the maximum salary will appear first in an unspecified order.
F. All remaining employee names will appear in ascending order.
正解：B,C
解説: (Topexam メンバーにのみ表示されます)