Oracle 1Z0-051 問題集

質問 1：
View the Exhibit for the structure of the STUDENT and FACULTY tables.

You need to display the faculty name followed by the number of students handled by the faculty at the base location. Examine the following two SQL statements:

Which statement is true regarding the outcome?
A. Both statements 1 and 2 execute successfully and give the same required result.
B. Only statement 1 executes successfully and gives the required result.
C. Only statement 2 executes successfully and gives the required result.
D. Both statements 1 and 2 execute successfully and give different results.
正解：A

質問 2：
The following data exists in the PRODUCTS table: PROD_ID PROD_LIST_PRICE
123456 152525.99
You issue the following query:
SQL> SELECT RPAD(( ROUND(prod_list_price)), 10,'*')
FROM products
WHERE prod_id = 123456;
What would be the outcome?
A. 152526****
B. **152525.99
C. 152525**
D. an error message
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which two are true about aggregate functions? (Choose two.)
A. You can pass column names, expressions, constants, or functions as parameter to an aggregate function.
B. You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.
C. You cannot group the rows of a table by more than one column while using aggregate functions.
D. You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.
E. You can use aggregate functions in any clause of a SELECT statement.
F. You can use aggregate functions on a table, only by grouping the whole table as one single group.
正解：A,E

質問 4：
Examine the structure of the EMPLOYEES table:
EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25)
Which three statements insert a row into the table? (Choose three.)
A. INSERT INTO employees (employee_id) VALUES (1000);
B. INSERT INTO employees VALUES ( NULL, 'John', 'Smith');
C. INSERT INTO employees (first_name, last_name, employee_id) VALUES ( 1000, 'John', 'Smith');
D. INSERT INTO employees( first_name, last_name) VALUES( 'John', 'Smith');
E. INSERT INTO employees VALUES ( 1000, 'John', NULL);
F. INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'John', ' ');
正解：A,E,F
解説: (Topexam メンバーにのみ表示されます)

質問 5：
You need to produce a report where each customer's credit limit has been incremented by $1000.
In the output, the customer's last name should have the heading Name and the incremented credit limit should be labeled New Credit Limit.
The column headings should have only the first letter of each word in uppercase .
Which statement would accomplish this requirement?
A. SELECT cust_last_name Name, cust_credit_limit + 1000
"New Credit Limit"
FROM customers;
B. SELECT INITCAP(cust_last_name) "Name", cust_credit_limit + 1000 INITCAP("NEW
CREDIT LIMIT")
FROM customers;
C. SELECT cust_last_name AS Name, cust_credit_limit + 1000
AS New Credit Limit
FROM customers;
D. SELECT cust_last_name AS "Name", cust_credit_limit + 1000
AS "New Credit Limit"
FROM customers;
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
View the Exhibit and examine the structure of CUSTOMERS table. Evaluate the following query:

Which statement is true regarding the above query?

A. It produces an error because the condition on the CUST_CITY column is not valid.
B. It produces an error because the condition on the CUST_FIRST_NAME column is not valid.
C. It executes successfully.
D. It produces an error because conditions on the CUST_CREDIT_LIMIT column are not valid.
正解：C

質問 7：
Examine the structure of the SHIPMENTS table:

You want to generate a report that displays the PO_ID and the penalty amount to be paid if
the
SHIPMENT_DATE is later than one month from the PO_DATE. The penalty is $20 per day.
Evaluate the following two queries:

Which statement is true regarding the above commands?
A. Only the first query executes successfully but gives a wrong result.
B. Only the second query executes successfully and gives the correct result.
C. Only the first query executes successfully and gives the correct result.
D. Only the second query executes successfully but gives a wrong result.
E. Both execute successfully and give correct results.
正解：C
解説: (Topexam メンバーにのみ表示されます)