Latest Oracle 1z0-061 Actual Free Exam Questions & Community Discussion, Page 2

Question #14

What is true regarding sub queries?

A. The outer query always sorts the results of the inner query

B. The outer query must return a value to the outer query

C. The inner query returns a value to the outer query

D. The inner query always sorts the results of the outer query

E. The inner query must always return a value or the outer query will give an error

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #15

In which three situations does a transaction complete?

A. When a PL/SQL anonymous block is executed

B. When a data definition language (DDL) statement is executed

C. When a ROLLBACK command is executed

D. When a TRUNCATE statement is executed after the pending transaction

E. When a DELETE statement is executed

Discussion 0

Correct Answer: B,C,D Vote an answer

Question #16

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

Evaluate the following SQL statement:
UPDATE (SELECT prod_id, cust_id, quantity_sold, time_id
FROM sales)
SET time_id = '22-MAR-2007'
WHERE cust_id = (SELECT cust_id
FROM customers
WHERE cust_last_name = 'Roberts' AND
credit_limit = 600);
Which statement is true regarding the execution of the above UPDATE statement?

A. It would execute and restrict modifications to only the columns specified in the SELECT statement.

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

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

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

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #17

Which two partitioned table maintenance operations support asynchronous Global Index Maintenance in Oracle database 12c?

A. ALTER TABLE MOVE PARTITION

B. ALTER TABLE DROP PARTITION

C. ALTER TABLE ADD PARTITION

D. ALTER TABLE TRUNCATE PARTITION

E. ALTER TABLE SPLIT PARTITION

F. ALTER TABLE MERGE PARTITION

Discussion 0

Correct Answer: B,D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #18

Top N analysis requires _____ and _____. (Choose two.)

A. only an inline view

B. an inline view and an outer query

C. an ORDER BY clause

D. a GROUP BY clause

E. the use of rowid

Discussion 0

Correct Answer: B,C Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #19

Study this view creation statement:
create view dept30 as select department_id,employee_id,last_name from employees where department_id=30 with check option; What might make the following statement fail? (Choose the best answer.) update dept30 set department_id=10 where employee_id=114;

A. The WITH CHECK OPTION will reject any statement that changes the
DEPARTMENT_ID.

B. Unless specified otherwise, views will be created as WITH READ ONLY.

C. The view is too complex to allow DML operations.

D. The statement will succeed.

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #20

You work as a database administrator at ABC.com. You study the exhibit carefully.
Exhibit:

Evaluate the following query:
Exhibit:

The above query produces an error on execution. What is the reason for the error?

A. The alias MIDPOINT should be enclosed within double quotation marks for the CUST_CREDIT_LIMIT/2 expression

B. An alias cannot be used in an expression

C. The alias NAME should not be enclosed within double quotation marks

D. The MIDPOINT +100 expression gives an error because CUST_CREDIT_LIMIT contains NULL values

Discussion 0

Correct Answer: B Vote an answer

Question #21

View the Exhibit and examine the structure of the PROMOSTIONS table:
Exhibit:

Which two SQL statements are valid? (Choose two.)

A. SELECT promo_id, DECODE (NULLIF(promo_cost, 10000),NULL, promo_cost*.25,
'N/A') "Catcost"FROM promotions;

B. SELECT promo_id, DECODE (promo_cost, >10000, 'High',<10000, 'Low')
"Range"FROM promotions;

C. SELECT promo_id, DECODE (NVL(promo_cost, 0), promo_cost,promo_cost * 0.25,
100) "Discount"FROM promotions;

D. SELECT promo_id, DECODE (promo_cost, 10000,DECODE(promo_category, 'G1', promo_cost *.25, NULL),NULL) "Catcost"FROM promotions;

Discussion 0

Correct Answer: C,D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #22

The CUSTOMERS table has these columns:
The CUSTOMER_ID column is the primary key for the table.
You need to determine how dispersed your customer base is.
Which expression finds the number of different countries represented in the CUSTOMERS table?

A. COUNT(UPPER(country_address))

B. COUNT(DIFF(UPPER(country_address)))

C. COUNT DISTINCT UPPER(country_address)

D. COUNT(DISTINCT (UPPER(country_address)))

E. COUNT(UNIQUE(UPPER(country_address)))

Discussion 0

Correct Answer: D Vote an answer

Question #23

Examine the structure of the PROMOTIONS table:

The management wants to see a report of unique promotion costs in each promotion category.
Which query would achieve the required result?

A. SELECT DISTINCT promo_cost, DISTINCT promo_category FROM promotions;

B. SELECT DISTINCT promo_cost, promo_category FROM promotions;

C. SELECT promo_category, DISTINCT promo_cost FROM promotions;

D. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;

Discussion 0

Correct Answer: D Vote an answer

Question #24

Examine the data in the CUST_NAME column of the customers table.

You need to display customers' second names where the second name starts with "Mc" or
"MC."
Which query gives the required output?

A. Option B

B. Option D

C. Option C

D. Option A

Discussion 0

Correct Answer: A Vote an answer

Question #25

Which statement is true regarding sub queries?

A. The NOT IN operator is equivalent to IS NULL with single- row subqueries.

B. The LIKE operator cannot be used with single- row subqueries.

C. =ANY and =ALL operators have the same functionality in multiple- row subqueries.

D. The NOT operator can be used with IN, ANY, and ALL operators in multiple- row subqueries.

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #26

You need to write a SQL statement that returns employee name, salary, department ID, and maximum salary earned in the department of the employee for all employees who earn less than the maximum salary in their department.
Which statement accomplishes this task?

A. SELECT a.emp_name, a.sal, a.dept_id, b.maxsal FROM employees a, (SELECT dept_id, MAX(sal) maxsal FROM employees GROUP BY dept_id) b WHERE a.dept_id = b.dept_id AND a.sal < b.maxsal;

B. SELECT a.emp_name, a.sal, b.dept_id, MAX(sal) FROM employees a, departments b WHERE a.dept_id = b.dept_id AND a.sal < MAX(sal) GROUP BY b.dept_id;

C. SELECT emp_name, sal, dept_id, maxsal FROM employees, (SELECT dept_id, MAX(sal) maxsal FROM employees GROUP BY dept_id) WHERE a.sal < maxsal;

D. SELECT a.emp_name, a.sal, a.dept_id, b.maxsal FROM employees a WHERE a.sal < (SELECT MAX(sal) maxsal FROM employees b GROUP BY dept_id);

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Oracle 1z0-061 Actual Free Exam Questions & Community Discussion

Download Free Oracle 1z0-061 Demo