Oracle 1z0-071 問題集

質問 1：
Which three statements about roles are true?
A. A single role can be assigned to multiple users.
B. A single user can be assigned multiple roles.
C. A role is a named group of related privileges that can only be assigned to a user.
D. Privileges are assigned to a role using the GRANT statement.
E. Roles are assigned to users using the ALTER USER statement.
F. Roles are assigned to roles using the ALTER ROLE statement.
G. Privileges are assigned to a role using the ALTER ROLE statement.
正解：A,B,D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Refer to the exhibit.

Which two queries will result in an error?
A. SELECT LAST_NAME,12 * SALARY AS ANNUAL_SALARY
FROM EMPLOYEES
WHERE 12 * SALARY > 100000
ORDER BY ANNUAL_SALARY;
B. SELECT LAST_NAME,12 * SALARY AS ANNUAL_SALARY
FROM EMPLOYEES
WHERE ANNUAL_SALARY > 100000
ORDER BY 12 * SALARY ;
C. SELECT LAST_NAME,12 * SALARY AS ANNUAL_SALARY
FROM EMPLOYEES
WHERE ANNUAL_SALARY > 100000
ORDER BY ANNUAL_SALARY;
D. SELECT LAST_NAME,12 * SALARY AS ANNUAL_SALARY
FROM EMPLOYEES
WHERE 12 * SALARY > 100000
ORDER BY 12 * SALARY;
E. SELECT FIRST_NAME LAST_NAME FROM EMPLOYEES;
F. SELECT FIRST_NAME,LAST_NAME FROM EMPLOYEES;
正解：B,E
解説: (Topexam メンバーにのみ表示されます)

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

質問 4：
Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database?
A. A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row
B. The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
C. The CURRENT_TIMESTAMP function returns data without time zone information
D. A TIMESTAMP data type column contains information about year, month, and day
E. The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
正解：A,B,E
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which two statements execute successfully?
A. SELECT TO_CHAR('2019-DEC-25 15:30", YY-MON-D HH24:M2', 'NLS_DATE LANGUAGE = AMERICAN') FROM DUAL;
B. SELECT TO _ CHAR (TO_ DATE ('2019-DEC-25 03:30','YYYY-MON-DD HH12:MI')) FROM DUAL
C. SELECT TO _DATE (TO_ CHAR ('2019-DEC-25 03:30', 'YYYY-MON-DD HH12:MI')) FROM DUAL;
D. SELECT TO_ DATE('2019-DEC-25 15:30', 'YYYY-MON-DD HH24:MI', 'NLS_ DATE_ LANGUAGE
=AMERICAN' ) FROM DUAL;
E. SELECT TO _ CHAR ('2019-DEC-25 15:30'.'YYYY-MON-DD HH24:MI')
FROM DUAL
正解：B,D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
which is true about the round,truncate and mod functions>?
A. TRUNC(MOD(25,3),-1) IS INVALID.
B. ROUND(MOD(25,3),-1) IS INVALID
C. ROUND(MOD(25,3),-1) AND TRUNC(MOD(25,3),-1) ARE BOTH VALID AND GIVE THE SAME RESULT.
D. ROUND(MOD(25,3),-1) AND TRUNC(MOD(25,3),-1) ARE BOTH VALID AND GIVE THE DIFFERENT RESULTS.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Which three are true about privileges?
A. Object privileges granted on a table automatically apply to all synonyms for that table.
B. A combination of object and system privileges can be granted to a role.
C. Only users with the GRANT ANY PRIVILEGE privilege can grant and revoke system privileges from other users.
D. Only users with the DBA role can create roles .
E. Schema owners can grant object privileges on objects in their schema to any other user or role.
F. All types of schema objects have associated object privileges .
正解：B,C,E
解説: (Topexam メンバーにのみ表示されます)

質問 8：
Examine this data in the EMPLOYERS table:

Which statement will execute successfully?
A. SELECT dept_id, MAX (Last_name), SUM (salary) FROM employees GROUP BY dept_id
B. SELECT dept_id, INSTR (last_name,'A'), SUM (salary) FROM employees GROUP BY dept_id
C. SELECT dept_id, STDDEV (last_name), SUM (salary) FROM employees GROUP BY dept_id
D. SELECT dept_id, LENGTH (last_name), SUM (salary) FROM employees GROUP BY dept_id
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 9：
Which statements are true regarding primary and foreign key constraints and the effect they can have on table data?
A. A table can have only one primary key but multiple foreign keys.
B. A table can have only one primary key and one foreign key.
C. The foreign key columns and parent table primary key columns must have the same names.
D. It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted.
E. It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted.
F. Primary key and foreign key constraints can be defined at both the column and table level.
G. Only the primary key can be defined the column and table level.
正解：A,E,F
解説: (Topexam メンバーにのみ表示されます)