1Z1-051問題集、Oracle実際の試験問題

質問 1

Which one is a system privilege?

A. CREATE TABLE

B. DELETE

C. EXECUTE

D. SELECT

E. ALTER TABLE

正解: A

質問 2

You are currently located in Singapore and have connected to a remote database in Chicago. You issue the following command:
Exhibit:

PROMOTIONS is the public synonym for the public database link for the PROMOTIONS table.
What is the outcome?

A. An error because the WHERE condition specified is invalid

B. Number of days since the promo started based on the current Singapore data and time.

C. Number of days since the promo started based on the current Chicago data and time

D. An error because the ROUND function specified is invalid

正解: C

質問 3

Evaluate the following SQL statements:
Exhibit:

Exhibit:

The above command fails when executed. What could be the reason?

A. SYSDATE cannot be used with the CHECK constraint

B. The BETWEEN clause cannot be used for the CHECK constraint

C. ORD_NO and ITEM_NO cannot be used as a composite primary key because ORD_NO is also the FOREIGN KEY

D. The CHECK constraint cannot be placed on columns having the DATE data type

正解: A

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

質問 4

Which statement is true regarding the UNION operator?

A. By default, the output is not sorted

B. NULL values are not ignored during duplicate checking

C. The number of columns selected in all SELECT statements need to be the same

D. Names of all columns must be identical across all SELECT statements

正解: B

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

質問 5

View the Exhibits and examine the structures of the PRODUCTS SALES and CUSTOMERS tables.

You need to generate a report that gives details of the customer's last name, name of the product, and the quantity sold for all customers in Tokyo'. Which two queries give the required result? (Choose two.)

A. SELECT c.cust_last_name, p.prod_name, s.quantity_sold
FROM products p JOIN sales s JOIN customers c
ON(p.prod_id=s.prod_id)
ON(s.cust_id=c.cust_id)
WHERE c.cust_city='Tokyo';

B. SELECT c.cust_last_name, p.prod_name, s.quantity_sold
FROM products p JOIN sales s
ON(p.prod_id=s.prod_id)
JOIN customers c
ON(s.cust_id=c.cust_id)
AND c.cust_city='Tokyo';

C. SELECT c.cust_id,c.cust_last_name,p.prod_id, p.prod_name, s.quantity_sold FROM products p
JOIN saless
USING(prod_id)
JOIN customers c
USING(cust_id)
WHERE c.cust_city='Tokyo';

D. SELECT c.cust_last_name,p.prod_name, s.quantity_sold FROM sales s JOIN products p USING(prod_id)
JOIN customers c
USING(cust_id)
WHERE c.cust_city='Tokyo';

正解: B,D

質問 6

Examine the structure of the CUSTOMERS table: CUSTNO is the PRIMARY KEY in the table. You want to find out if any customers' details have been entered more than once using different CUSTNO, by listing all the duplicate names.

Which two methods can you use to get the required result? (Choose two.)

A. full outer-join with self-join

B. right outer-join with self-join

C. left outer-join with self-join

D. self-join

E. subquery

正解: D,E

質問 7

The user Sue issues this SQL statement:
GRANT SELECT ON sue.EMP TO alice WITH GRANT OPTION;
The user Alice issues this SQL statement:
GRANT SELECT ON sue.EMP TO reena WITH GRANT OPTION;
The user Reena issues this SQL statement:
GRANT SELECT ON sue.EMP TO timber;
The user Sue issues this SQL statement:
REVOKE select on sue.EMP FROM alice;
For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?

A. Alice, Reena, and Timber

B. Alice only

C. Sue, Alice, Reena, and Timber

D. Alice and Reena

正解: A

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

質問 8

The PRODUCTS table has these columns:
PRODUCT_ID NUMBER(4)
PRODUCT_NAME VARCHAR2(45)
PRICE NUMBER(8,2)
Evaluate this SQL statement:
SELECT *
FROM PRODUCTS
ORDER BY price, product_name;
What is true about the SQL statement?

A. The results are sorted numerically and then alphabetically.

B. The results are sorted numerically.

C. The results are sorted alphabetically.

D. The results are not sorted.

正解: A

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

質問 9

Which tasks can be performed using SQL functions that are built into Oracle database? (Choose three.)

A. adding a number to a date for a resultant date value

B. comparing two expressions to check whether they are equal

C. finding the remainder of a division

D. checking whether a specified character exists in a given string

E. removing trailing, leading, and embedded characters from a character string

正解: B,C,D

質問 10

View the Exhibit and examine the structure of the ORDERS and CUSTOMERS tables.

Evaluate the following SQL command:
SQL> SELECT o.order_id, c.cust_name, o.order_total, c.credit_limit
FROM orders o JOIN customers c
USING (customer_id)
WHERE o.order_total > c.credit_limit
FOR UPDATE
ORDER BY o.order_id;
Which two statements are true regarding the outcome of the above query? (Choose two.)

A. The locks are released after a DML statement is executed on the locked rows.

B. The locks are released only when a COMMIT or ROLLBACK is issued.

C. It locks only the columns that satisfy the condition in both the tables.

D. It locks all the rows that satisfy the condition in the statement.

正解: B,D

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

質問 11

Which statements are correct regarding indexes? (Choose all that apply.)

A. A nondeferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a unique index.

B. For each data manipulation language (DML) operation performed, the corresponding indexes are automatically updated.

C. When a table is dropped, the corresponding indexes are automatically dropped

D. A FOREIGN KEY constraint on a column in a table automatically creates a non unique key

正解: A,B,C

質問 12

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. Both execute successfully and give correct results.

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. Only the second query executes successfully and gives the correct result.

正解: C

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

Oracle Database: SQL Fundamentals I - 1Z1-051 模擬練習