Oracle 1z0-071 問題集

質問 1：
Examine the data in the CUST NAME column of the CUSTOMERS table:
CUST_NAME
------------------------------
Renske Ladwig
Jason Mallin
Samuel McCain
Allan MCEwen
Irene Mikkilineni
Julia Nayer
You want to display the CUST_NAME values where the last name starts with Mc or MC. Which two WHERE clauses give the required result?
A. WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,'') +1)) LIKE'Mc%'
B. WHERE SUBSTR(cust_name,INSTR(cust_name,'') +1) LIKE'Mc%' OR'MC%'
C. WHERE INITCAP (SUBSTR(cust_name, INSTR(cust_name,'') +1)) IN ('MC%','Mc%)
D. WHERE SUBSTR(cust_name, INSTR(cust_name,'') +1) LIKE'Mc%'
E. WHERE UPPER (SUBSTR(cust_name, INSTR(cust_name, '') +1)) LIKE UPPER('MC%')
正解：A,E
解説: (Topexam メンバーにのみ表示されます)

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

質問 3：
Which three statements are true about single row functions?
A. They can be used only in the where clause of a select statement.
B. The date type returned can be different from the data type of the argument.
C. The argument can be a column name, variable, literal or an expression.
D. They can accept only one argument.
E. They return a single result row per table.
F. They can be nested to any level.
正解：B,C,F
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which two will execute successfully?
A. SELECT NVL('DATE',200) FROM (SELECT NULL AS "DATE" FROM DUAL);
B. SELECT COALESCE(O,SYSDATE) TRCH DUAL;
C. SELECT NVL('DATE',SYSDATE) FROM DUAL;
D. SELECT COALESCE('DATE',SYSDATE) FROM (SELECT NULL AS "DATE" FROM DUAL) ;
E. SELECT COALESCR('DATE', SYSDATE) FROM DUAL;
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which two are true about granting object privileges on tables, views, and sequences?
A. INSERT can be granted only on tables and sequences.
B. DELETE can be granted on tables, views, and sequences.
C. REFERENCES can be grantrd only on tables.
D. ALTER can be granted only on tables and sequences.
E. SELECT can be granted on tables, views, and sequences.
正解：C,E
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Which two are true about granting privilege on objects?
A. The WITH GRANT OPTION clause can be used only by DBA users
B. A table owner must grant the REFERENCES privilege to allow other users to create FOREIGN KEY constraints using that table
C. An object privilege can be granted to other users only by the owner of that object
D. An object privilege can be granted to a role only by the owner of that object
E. The owner of an object acquires all object privilege on that object by default
正解：B,E
解説: (Topexam メンバーにのみ表示されます)

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

質問 8：
Which two statements will return the names of the three employees with the lowest salaries?
A. SELECT last_name,salary
FROM (SELECT * FROM employees ORDER BY salary)
B. SELECT last_name, salary
FROM employees
WHERE ROWNUM<=3
C. SELECT last_name,salary
FROM employees
ORDER BY salary
FETCH FIRST 3 ROWS ONLY;
D. SELECT last_name,salary
FROM employees
WHERE ROWNUM<=3
ORDER BY (SELECT salary FROM employees);
E. SELECT last_name,salary
FROM employees
FETCH FIRST 3 ROWS ONLY
ORDER BY salary;
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 9：
Examine this statement,which executes successfully:
In which order are the rows displayed?
A. sorted by AVGSAL
B. Sorted by MAXSAL
C. sorted by DEPARTMENT_NAME and MAXSAL
D. sorted by DEPARTMENT_NAME and AVGSAL
E. sorted by DEPARTMENT_NAME
正解：D
解説: (Topexam メンバーにのみ表示されます)