1z0-061問題集、Oracle実際の試験問題

質問 1

You need to display the date 11-Oct-2007 in words as 'Eleventh of October, Two Thousand Seven'.
Which SQL statement would give the required result?

A. SELECT TO_CHAR(TO_DATE('11-oct-2007'), 'fmDdthsp "of" Month, Year') FROM DUAL;

B. SELECT TO_DATE(TO_CHAR('11-oct-2007', 'fmDdspth ''of'' Month, Year')) FROM DUAL;

C. SELECT TO_CHAR(TO_DATE('11-oct-2007'), 'fmDdspth of month, year') FROM DUAL;

D. SELECT TO_CHAR('11-oct-2007', 'fmDdspth "of" Month, Year') FROM DUAL;

正解: A

解説: (PassTest メンバーにのみ表示されます)

質問 2

You work as a database administrator at ABC.com. You study the exhibit carefully and examine the structure of CUSTOMRS AND SALES tables.

Evaluate the following SQL statement:
Exhibit:

Which statement is true regarding the execution of the above UPDATE statement?

A. It would not execute because two tables cannot be used in a single UPDATE statement

B. It would not execute because the SELECT statement cannot be used in place of the table name

C. It would execute and restrict modifications to only the column specified in the SELECT statement

D. It would not execute because a sub query cannot be used in the WHERE clause of an UPDATE statement

正解: C

質問 3

View the Exhibit and examine the data in the products table.

You need to display product names from the products table that belong to the
'software/other' category with minimum prices as either S2000 or S4000 and no unit of measure.
You issue the following query:

Which statement is true regarding the above query?

A. It executes successfully but returns no result.

B. It generates an error because the condition specified for the prod category column is not valid.

C. It executes successfully and returns the required result.

D. It generates an error because the condition specified for PROD_UNIT_OF_MEASURE is not valid.

正解: A

質問 4

View the Exhibit and examine the data in the employees table:

You want to display all the employee names and their corresponding manager names.
Evaluate the following query:

Which join option can be used in the blank in the above query to get the required output?

A. INNER JOIN

B. FULL OUTER JOIN

C. RIGHT OUTER JOIN

D. LEFT OUTER JOIN

正解: D

質問 5

Examine the structure of the products table:

You want to display the names of the products that have the highest total value for UNIT_PRICE * QTY_IN_HAND.
Which SQL statement gives the required output?

A. Option A

B. Option C

C. Option B

D. Option D

正解: A

質問 6

What are distinguishing characteristics of a public synonym rather than a private synonym?
(Choose two.)

A. Public synonyms can be accessed by name without a schema name qualifier.

B. Public synonyms are always visible to all users.

C. Public synonyms can be selected from without needing any permissions.

D. Public synonyms can have the same names as tables or views.

正解: A,D

解説: (PassTest メンバーにのみ表示されます)

質問 7

Which two statements are true regarding the USING clause in table joins? (Choose two.)

A. It can be used to join tables that have columns with the same name and compatible data types.

B. It can be used to restrict the number of columns used in a NATURAL join.

C. It can be used to access data from tables through equijoins as well as nonequijoins.

D. It can be used to join a maximum of three tables.

正解: A,B

解説: (PassTest メンバーにのみ表示されます)

質問 8

Examine the structure of the TRANSACTIONS table:
Name Null Type
TRANS_ID NOT NULL NUMBER (3)
CUST_NAME VARCHAR2(30)
TRANS_DATE DATE
TRANS_AMT NUMBER(10, 2)
You want to display the transaction date and specify whether it is a weekday or weekend.
Evaluate the following two queries:

Which statement is true regarding the above queries?

A. Both give wrong results.

B. Only the second query gives the correct result.

C. Both give the correct result.

D. Only the first query gives the correct result.

正解: D

解説: (PassTest メンバーにのみ表示されます)

質問 9

Which SQL statements would display the value 1890.55 as $1, 890.55? (Choose three.)

A. SELECT TO_CHAR(1890.55, '$99, 999D99')FROM DUAL;

B. SELECT TO_CHAR(1890.55, '$99G999D00')FROM DUAL;

C. SELECT TO_CHAR(1890.55, '$0G000D00')FROM DUAL;

D. SELECT TO_CHAR(1890.55, '$9, 999V99')FROM DUAL;

E. SELECT TO_CHAR(1890.55, '$99G999D99')FROM DUAL;

正解: B,C,E

質問 10

Evaluate the following query:

What would be the outcome of the above query?

A. It produces an error because the data types are not matching.

B. It executes successfully and displays the literal "{'s start date was \} * for each row in the output.

C. It executes successfully and introduces an 's at the end of each PROMO_NAME in the output.

D. It produces an error because flower braces have been used.

正解: C

解説: (PassTest メンバーにのみ表示されます)

Oracle Database 12c: SQL Fundamentals - 1z0-061 模擬練習