1z1-061試験無料問題集（340題）「Oracle Database 12c: SQL Fundamentals 認定」

出題：1

Examine the types and examples of relationships that follow:
1 . One-to-one a) Teacher to students
2 . One-to-many b) Employees to Manager
3 . Many-to-one c) Person to SSN
4 . Many-to-many d) Customers to products
Which option indicates the correctly matched relationships?

A. 1-a, 2-b, 3-c, and 4-d

B. 1-c, 2-a, 3-b, and 4-d

C. 1-d, 2-b, 3-a, and 4-c

D. 1-c, 2-d, 3-a, and 4-b

正解：B 解答を投票する

出題：2

Evaluate the following SQL statements:
Exhibit:

Which is the correct output of the above query?

A. +00-300, +00-650, +00 11:12:10.123457

B. +25-00, +00-650, +00 11:12:10.123457

C. +00-300, +54-02, +00 11:12:10.123457

D. +25-00, +54-02, +00 11:12:10.123457

正解：D 解答を投票する

出題：3

View the Exhibit and examine the structure of the CUSTOMERS table.

Evaluate the query statement:

What would be the outcome of the above statement?

A. It produces an error because the condition on CUST_LAST_NAME is invalid.

B. It executes successfully only if the CUST_CREDIT_LIMIT column does not contain any null values.

C. It executes successfully.

D. It produces an error because the AND operator cannot be used to combine multiple BETWEEN clauses.

正解：C 解答を投票する

出題：4

Which statement describes the ROWID data type?

A. Binary data stored in an external file, up to 4 gigabytes.

B. A hexadecimal string representing the unique address of a row in its table.

C. Raw binary data of variable length up to 2 gigabytes.

D. Binary data up to 4 gigabytes.

E. Character data up to 4 gigabytes.

正解：B 解答を投票する

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

出題：5

The ORDERS TABLE belongs to the user OE. OE has granted the SELECT privilege on the ORDERS table to the user HR.
Which statement would create a synonym ORD so that HR can execute the following query successfully?
SELECT * FROM ord;

A. CREATE PUBLIC SYNONYM ord FOR oe.orders; This command is issued by the database administrator.

B. CREATE PUBLIC SYNONYM ord FOR orders; This command is issued by OE.

C. CREATE SYNONYM ord FOR oe.orders; This command is issued by the database administrator.

D. CREATE SYNONYM ord FOR orders; This command is issued by OE.

正解：A 解答を投票する

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

出題：6

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

There is only one customer with the CUST_LAST_NAME column having value Roberts.
Which INSERT statement should be used to add a row into the ORDERS table for the customer whose CUST_LAST_NAME is Roberts and CREDIT_LIMIT is 600?

A. INSERT INTO ordersVALUES (1, '10-mar-2007', 'direct',(SELECT customer_idFROM customersWHERE cust_last_name='Roberts' ANDcredit_limit=600), 1000);

B. INSERT INTO(SELECT o.order_id, o.order_date, o.order_mode, c.customer_id, o.order_totalFROM orders o, customers cWHERE o.customer_id = c.customer_idAND c.cust_last_name='Roberts' ANDc.credit_limit=600 )VALUES (1, '10-mar-2007', 'direct', (SELECT customer_idFROM customersWHERE cust_last_name='Roberts' ANDcredit_limit=600), 1000);

C. INSERT INTO orders (order_id, order_date, order_mode,(SELECT customer_idFROM customersWHERE cust_last_name='Roberts' ANDcredit_limit=600), order_total)VALUES(1, '10-mar-2007', 'direct', &customer_id, 1000);

D. INSERT INTO orders (order_id, order_date, order_mode,(SELECT customer_idFROM customersWHERE cust_last_name='Roberts' ANDcredit_limit=600), order_total)VALUES(1, '10-mar-2007', 'direct', &&customer_id, 1000);

正解：A 解答を投票する

出題：7

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

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

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

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

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

正解：A,B,D 解答を投票する

出題：8

Evaluate this SQL statement:
SELECT e.emp_name, d.dept_name
FROM employees e
JOIN departments d
USING (department_id)
WHERE d.department_id NOT IN (10, 40)
ORDER BY dept_name;
The statement fails when executed. Which change fixes the error?

A. replace the condition"d.department_id NOT IN (10, 40)"in the WHERE clause with"d.department_id <> 10 AND d.department_id <> 40"

B. prefix the column in the ORDER BY clause with the table alias

C. remove the table alias from the SELECT clause

D. prefix the column in the USING clause with the table alias

E. remove the table alias prefix from the WHERE clause

F. remove the ORDER BY clause

正解：B,C 解答を投票する

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

出題：9

View the Exhibit and examine the structure of the PROMOTIONS, SALES, and CUSTOMER tables.
You need to generate a report showing the promo name along with the customer name for all products that were sold during their promo campaign and before 30th October 2007.
You issue the following query:

Which statement is true regarding the above query?

A. It produces an error because the join order of the tables is incorrect.

B. It executes successfully and gives the required result.

C. It produces an error because equijoin and nonequijoin conditions cannot be used in the same SELECT statement.

D. It executes successfully but does not give the required result.

正解：D 解答を投票する

出題：10

View the exhibit and examine the description for the SALES and CHANNELS tables.

You issued the following SQL statement to insert a row in the SALES table:
INSERT INTO sales VALUES
(23, 2300, SYSDATE, (SELECT channel_id
FROM channels
WHERE channel_desc='Direct Sales'), 12, 1, 500);
Which statement is true regarding the execution of the above statement?

A. The statement will fail because subquery cannot be used in the VALUES clause.

B. The statement will fail because the VALUES clause is not required with subquery.

C. The statement will fail because subquery in the VALUES clause is not enclosed with in single quotation marks.

D. The statement will execute and the new row will be inserted in the SALES table.

正解：D 解答を投票する

出題：11

Evaluate the following query:
SQL> SELECT TRUNC(ROUND(156.00, -1), -1)
FROM DUAL;
What would be the outcome?

A. 200

B. 150

C. 16

D. 100

E. 160

正解：E 解答を投票する

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

出題：12

The PRODUCTS table has the following structure:

Evaluate the following two SQL statements:

Which statement is true regarding the outcome?

A. Only the second SQL statement executes successfully.

B. Both the statements execute and give the same results.

C. Both the statements execute and give different results.

D. Only the first SQL statement executes successfully.

正解：C 解答を投票する

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

出題：13

Which three tasks can be performed using SQL functions built into Oracle Database?

A. Finding the number of characters in an expression

B. Combining more than two columns or expressions into a single column in the output

C. Displaying a date in a nondefault format

D. Substituting a character string in a text expression with a specified string

正解：A,C,D 解答を投票する

出題：14

Which is an iSQL*Plus command?

A. UPDATE

B. SELECT

C. DESCRIBE

D. RENAME

E. DELETE

F. INSERT

正解：C 解答を投票する

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

出題：15

Which statement is true regarding synonyms?

A. A public synonym and a private synonym can exist with the same name for the same table

B. Synonyms are used to reference only those tables that are owned by another user

C. The DROP SYNONYM statement removes the synonym and the table on which the synonym has been created becomes invalid

D. Synonyms can be created only for a table

正解：A 解答を投票する

出題：16

Examine the data in the ORD_ITEMS table:
ORD_NO ITEM_NO QTY
-------------------------------------------
1 111 10
1 222 20
1 333 30
2 333 30
2 444 40
3 111 40
Evaluate the following query:
SQL>SELECT item_no, AVG(qty)
FROM ord_items
HAVING AVG(qty) > MIN(qty) * 2
GROUP BY item_no;
Which statement is true regarding the outcome of the above query?

A. It displays the item nos with their average quantity where the average quantity is more than double the overall minimum quantity of all the items in the table.

B. It displays the item nos with their average quantity where the average quantity is more than double the minimum quantity of that item in the table.

C. It gives an error because all the aggregate functions used in the HAVING clause must be specified in the SELECT list.

D. It gives an error because the HAVING clause should be specified after the GROUP BY clause.

正解：B 解答を投票する

1z1-061試験無料問題集「Oracle Database 12c: SQL Fundamentals 認定」