1z1-071無料問題集「Oracle Database SQL」

質問 1

Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)

（A）The names of columns selected in each SELECT statement must be identical

（B）The number of columns selected in each SELECT statement must be identical

（C）Duplicates are eliminated automatically by the UNION ALL operator

（D）The output is sorted by the UNION ALL operator

（E）NULLS are not ignored during duplicate checking

正解：B、E 解答を投票する

質問 2

You want to display 5 percent of the rows from the sales table for products with the lowestAMOUNT_SOLD and also want to include the rows that have the sameAMOUNT_SOLDeven if this causes the output to exceed 5 percent of the rows.
Which query willprovide the required result?

（A）SELECT prod_ id, cust_id, amount_sold
FROM sales
ORDER BY araount_sold
FETCH FIRST 5 PERCENT ROWS WITH TIES ONLY;

（B）SELECT prod_id, cust_id, amount_sold
FROM sales
ORDER BY amount_sold
FETCH FIRST 5 PERCENT ROWS ONLY WITH TIES;

（C）SELECT prod_id, cust_id, amount_sold
FROM sales
ORDER BY amount_sold
FETCH FIRST 5 PERCENT ROWS WITH TIES;

（D）SELECT prod_id, cust_id, amount_sold
FROM sales
ORDER BY amount__sold
FETCH FIRST 5 PERCENT ROWS ONLY;

正解：B 解答を投票する

質問 3

View the Exhibit and examine the structure of the EMPLOYEES and JOB_HISTORY tables.

Examine this query which must select the employee IDs of all the employees who have held the job SA_MAN at any time during their employment.
SELECT EMPLOYEE_ID
FROM EMPLOYEES
WHERE JOB_ID = 'SA_MAN'
-------------------------------------
SELECT EMPLOYEE_ID
FROM JOB_HISTORY
WHERE JOB_ID = 'SA_MAN';
Choose two correct SET operators which would cause the query to return the desired result.

（A）UNION ALL

（B）UNION

（C）MINUS

（D）INTERSECT

正解：A、B 解答を投票する

質問 4

Examine the data in the INVOICEStable:

Examine the data in the CURRENCIEStable:

Which query returns the currencies in CURRENCIESthat are not present in INVOICES?

（A）

（B）

（C）

（D）

正解：B 解答を投票する

質問 5

A subquery is called a single-row subquery when _______.

（A）The inner query returns a single value to the outer query.

（B）The inner query uses an aggregating function and returns one or more values.

（C）There is only one subquery in the outer query and the inner query returns one or more values

（D）The inner query returns one or more values and the outer query returns a single value.

正解：A 解答を投票する

質問 6

Which two statements are true regarding constraints?

（A）A constraint can be disabled even if the constraint column contains data.

（B）All constraints can be defined at the column level and at the table level.

（C）A foreign key column cannot contain null values.

（D）A constraint is enforced only for INSERT operation on the table.

（E）A column with the UNIQUE constraint can contain null values.

正解：A、E 解答を投票する

質問 7

Which three statements are true regarding the usage of the WITH clause in complex correlated subqueries? (Choose three.)

（A）The query name in the WITH clause is visible to other query blocks in the WITH clause as well as to the main query block

（B）It can be used only with the SELECT clause.

（C）The WITH clause can hold more than one query.

（D）If the query block name and the table name are the same, then the table name takes precedence.

正解：A、B、C 解答を投票する

質問 8

Which two statements are true about a self join? (Choose two.)

（A）It can be an inner join.

（B）The join key column must have an index.

（C）It can be a left outer join.

（D）It must be an equijoin.

（E）It must be a full outer join.

正解：A、B 解答を投票する

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

質問 9

Examine this SQL statement:

Which two are true? (Choose two.)

（A）The subquery is executed for every row in the EMPLOYEES table.

（B）The subquery is not a correlated subquery.

（C）All existing rows in the EMPLOYEES table are deleted.

（D）The DELETE statement executes successfully even if the subquery selects multiple rows.

（E）The subquery is executed before the DELETE statement is executed.

正解：A、E 解答を投票する

質問 10

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 AS Name, cust_credit_limit + 1000 "New Credit Limit" FROM customers;

（B）SELECT cust_last_name AS "Name", cust_credit_limit + 1000 AS "New Credit Limit" FROM customers;

（C）SELECT INITCAP (cust_last_name) "Name", cust_credit_limit + 1000 INITCAP ("NEW CREDIT LIMIT") FROM customers;

（D）SELECT cust_last_name AS Name, cust_credit_limit + 1000 AS New Credit Limit FROM customers;

正解：B 解答を投票する

質問 11

Which three statements are true reading subqueries? (Choose three.)

（A）A Main query can have many subqueries.

（B）The subquery and main query can retrieve data from different tables.

（C）A subquery can have more than one main query.

（D）The subquery and main query must retrieve date from the same table.

（E）Multiple columns or expressions can be compared between the subquery and main query.

（F）Only one column or expression can be compared between the subquery and main query.

正解：A、B、E 解答を投票する

質問 12

Examine the description of the EMPLOYEES table:

Which two queries return rows for employees whose manager works in a different department?
(Choose two.)

（A）

（B）

（C）

（D）

（E）

正解：D、E 解答を投票する

質問 13

Which three privileges can be restricted to a subset of columns in a table? (Choose three.)

（A）DELETE

（B）ALTER

（C）INDEX

（D）SELECT

（E）INSERT

（F）REFERENCES

（G）UPDATE

正解：A、D、G 解答を投票する

質問 14

Table HR.EMPLOYEEScontains a row where the EMPLOYEE_IDis 109.
User ALICEhas no privileges to access HR.EMPLOYEES.
User ALICEstarts a session.
User HRstarts a session and successfully executes these statements:
GRANT DELETE ON employees TO alice;
UPDATE employees SET salary = 24000 WHERE employee_id = 109;
In her existing session ALICEthen executes:
DELETE FROM hr.employees WHERE employee_id = 109;
What is the result?

（A）The DELETE command will wait for HR'S transaction to end then return an error.

（B）The DELETE command will immediately return an error.

（C）The DELETE command will immediately delete the row.

（D）The DELETE command will wait for HR'S transaction to end then delete the row.

正解：C 解答を投票する

1z1-071 無料問題集「Oracle Database SQL」

弊社を連絡する

関連リンク

トップ試験