最新的Oracle 1z1-071免費考試真題

問題1

View the exhibit and examine the data in the PROJ_TASK_DETAILS table. (Choose the best answer.)

The PROJ_TASK_DETAILS table stores information about project tasks and the relation between them.
The BASED_ON column indicates dependencies between tasks.
Some tasks do not depend on the completion of other tasks.
You must generate a report listing all task IDs, the task ID of any task upon which it depends and the name of the employee in charge of the task upon which it depends.
Which query would give the required result?

A. SELECT p.task_id, p.based_on, d.task_in_charge
FROM proj_task_details p LEFT OUTER JOIN proj_task_details d ON (p.based_on = d.task_id);

B. SELECT p.task_id, p.based_on, d.task_in_charge
FROM proj_task_details p FULL OUTER JOIN proj_task_details d ON (p.based_on = d.task_id);

C. SELECT p.task_id, p.based_on, d.task_in_charge
FROM proj_task_details p JOIN proj_task_details d
ON (p.based_on = d.task_id);

D. SELECT p.task_id, p.based_on, d.task_in_charge
FROM proj_task_details p JOIN proj_task_details d
ON (p.task_id = d.task_id);

正確答案: A

問題2

Examine these two queries and their output:
SELECT deptno, dname FROM dept;

SELECT emame, job, deptno FROM emp ORDER BY deptno;

Now examine this query:

How many rows will be displayed?

A. 3

B. 12

C. 64

D. 6

正確答案: D

問題3

Examine the description of the SALES1 table:

SALES2is a table with the same description as SALES1.
Some sales data is duplicated in both tables.
You want to display the rows from the SALES1table which are not present in the SALES2 table.
Which set operator generates the required output?

A. INTERSECT

B. UNION

C. MINUS

D. SUBTRACT

E. UNION ALL

正確答案: C

問題4

Examine this partial statement:

Which is true?

A. Both the query and the subquery can select any number of rows.

B. The query can select only zero rows or one row, but the subquery can select any number of rows.

C. The query can select any number of rows, but the subquery can select only zero rows or one row.

D. Both the query and the subquery can select only zero rows or one row.

正確答案: B

說明：（僅 Fast2test 成員可見）

問題5

Examine the structure of the PROGRAMS table:

Which two SQL statements would execute successfully?

A. SELECT NVL (MONTHS_BETWEEN (start_date, end_date), `Ongoing') FROM programs;

B. SELECT TO_DATE (NVL (SYSDATE-END_DATE, SYSDATE)) FROM programs;

C. SELECT NVL (TO_CHAR (MONTHS_BETWEEN (start-date, end_date)), `Ongoing') FROM programs

D. SELECT NVL (ADD_MONTHS (END_DATE,1) SYSDATE) FROM programs;

正確答案: C,D

說明：（僅 Fast2test 成員可見）

問題6

Which two statements are true regarding a SAVEPOINT? (Choose two.)

A. A SAVEPOINT does not issue a COMMIT

B. Rolling back to a SAVEPOINT can undo a TRUNCATE statement

C. Rolling back to a SAVEPOINT can undo a DELETE statement

D. Only one SAVEPOINT may be issued in a transaction

E. Rolling back to a SAVEPOINT can undo a CREATE INDEX statement

正確答案: A,C

問題7

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

You must display product names from the PRODUCTS table that belong to the 'Software/other' category with minimum prices as either $2000 or $4000 and with no unit of measure.
You issue this query:

Which statement is true?

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

B. It executes successfully but returns no result.

C. It generates an error because the condition specified for the PROD_CATEGORY column is not valid.

D. It executes successfully and returns the required result.

正確答案: B

問題8

Which three arithmetic operations can be performed on a column by using a SQL function that is built into Oracle database? (Choose three.)

A. Finding the quotient

B. Subtraction

C. Raising to a power

D. Finding the lowest value

E. Addition

正確答案: C,D,E

最新的Oracle Database SQL - 1z1-071免費考試真題

聯系我們

站內鏈接

最新更新