Oracle 1Z0-051 問題集

質問 1：
Which four are attributes of single row functions? (Choose four.)
A. accept only one argument and return only one value
B. return one result per row
C. act on each row returned
D. cannot be nested
E. accept arguments which can be a column or an expression
F. manipulate data items
正解：B,C,E,F
解説: (Topexam メンバーにのみ表示されます)

質問 2：
View the Exhibit and examine the structure of the SALES table.
The following query is written to retrieve all those product IDs from the SALES table that have more than 55000 sold and have been ordered more than 10 times.

Which statement is true regarding this SQL statement?
A. It produces an error because COUNT(*) should be only in the HAVING clause and not in the WHERE clause.
B. It executes successfully and generates the required result.
C. It produces an error because COUNT(*) should be specified in the SELECT clause also.
D. It executes successfully but produces no result because COUNT(prod_id) should be used instead of COUNT(*).
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 3：
The EMPLOYEES table contains these columns:
EMPLOYEE_ID NUMBER(4)
ENAME VARCHAR2 (25)
JOB_ID VARCHAR2(10)
Which SQL statement will return the ENAME, length of the ENAME, and the numeric position of the letter "a" in the ENAME column, for those employees whose ENAME ends with a the letter "n"?
A. SELECT ENAME, LENGTH(ENAME), INSTR(ENAME, ,-1,1) FROM EMPLOYEES WHERE SUBSTR(ENAME, -1, 1) = 'n';
B. SELECT ENAME, LENGTH(ENAME), INSTR(ENAME, 'a') FROM EMPLOYEES WHERE SUBSTR(ENAME, -1, 1) = 'n';
C. SELECT ENAME, LENGTH(ENAME), SUBSTR(ENAME, -1,1) FROM EMPLOYEES WHERE INSTR(ENAME, 1, 1) = 'n';
D. SELECT ENAME, LENGTH(ENAME), SUBSTR(ENAME, -1,1) FROM EMPLOYEES WHERE INSTR(ENAME, -1, 1) = 'n';
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 4：
What is true about the WITH GRANT OPTION clause?
A. It is used to grant an object privilege on a foreign key column.
B. It allows a grantee DBA privileges.
C. It allows the grantee to grant object privileges to other users and roles.
D. It is required syntax for object privileges.
E. It allows privileges on specified columns of tables.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which three tasks can be performed using SQL functions built into Oracle Database? (Choose three.)
A. Combining more than two columns or expressions into a single column in the output
B. Finding the number of characters in an expression
C. Displaying a date in a nondefault format
D. Substituting a character string in a text expression with a specified string
正解：B,C,D

質問 6：
What is true about updates through a view?
A. When you update a view group functions are automatically computed.
B. You cannot update a view with group functions.
C. When you update a view the constraints on the views always override the constraints on
the underlying tables.
D. When you update a view only the constraints on the underlying table will be in effect.
正解：B

質問 7：
You issue the following command to drop the PRODUCTS table:
SQL>DROP TABLE products;
What is the implication of this command? (Choose all that apply.)
A. The pending transaction in the session is committed
B. All data along with the table structure is deleted
C. All indexes on the table will remain but they are invalidated
D. All views and synonyms will remain but they are invalidated
E. All data in the table are deleted but the table structure will remain
正解：A,B,D