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

Question #1

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 executes successfully but does not give the required result.

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 produces an error because the join order of the tables is incorrect.

Discussion 0

Correct Answer: A Vote an answer

Question #2

You work as a database administrator at ABC.com. You study the exhibit carefully and examine the structure of CUSTOMRS AND SALES tables.

Evaluate the following SQL statement:
Exhibit:

Which statement is true regarding the execution of the above UPDATE statement?

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

B. It would execute and restrict modifications to only the column specified in the SELECT statement

C. It would not execute because a sub query cannot be used in the WHERE clause of an UPDATE statement

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

Discussion 0

Correct Answer: B Vote an answer

Question #3

Which statement adds a constraint that ensures the CUSTOMER_NAME column of the CUSTOMERS table holds a value?

A. ALTER TABLE customers MODIFY CONSTRAINT cust_name_nn CHECK
customer_name IS NOT NULL;

B. ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn IS NOT NULL;

C. ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name NOT NULL;

D. ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn
NOT NULL;

E. ALTER TABLE customers MODIFY name CONSTRAINT cust_name_nn NOT NULL;

F. ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;

Discussion 0

Correct Answer: D Vote an answer

Question #4

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

Evaluate the following SQL statement:

Which statement is true regarding the outcome of the above query?

A. It produces an error because SUBQUERIES cannot be used with the case expression.

B. It shows COST_REMARK for all the promos in the table.

C. It produces an error because the SUBQUERY gives an error.

D. It shows COST_REMARK for all the promos in the promo category 'TV'

Discussion 0

Correct Answer: B Vote an answer

Question #5

Which are iSQL*Plus commands? (Choose all that apply.)

A. RENAME

B. DESCRIBE

C. DELETE

D. SELECT

E. UPDATE

F. INSERT

Discussion 0

Correct Answer: B Vote an answer

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

Question #6

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

You have to generate a report that displays the promo name and start date for all promos that started after the last promo in the 'INTERNET' category.
Which query would give you the required output?

A. SELECT promo_name, promo_begin_date FROM promotionsWHERE
promo_begin_date > ALL (SELECT promo_begin_dateFROM promotionsWHERE
promo_category = 'INTERNET');

B. SELECT promo_name, promo_begin_date FROM promotionsWHERE
promo_begin_date IN (SELECT promo_begin_dateFROM promotionsWHERE
promo_category='INTERNET');

C. SELECT promo_name, promo_begin_date FROM promotionsWHERE
promo_begin_date > ALL (SELECT MAX(promo_begin_date) FROM promotions
)ANDpromo_category = 'INTERNET';

D. SELECT promo_name, promo_begin_date FROM promotionsWHERE
promo_begin_date > ANY (SELECT promo_begin_dateFROM promotionsWHERE
promo_category = 'INTERNET');

Discussion 0

Correct Answer: A Vote an answer

Question #7

Which SQL statement returns a numeric value?

A. SELECT sysdate-hire_date FROM EMP;

B. SELECT ADD_MONTHS(MAX(hire_Date), 6) FROM EMP;

C. SELECT TO_NUMBER(hire_date + 7) FROM EMP;

D. SELECT ROUND(hire_date) FROM EMP;

Discussion 0

Correct Answer: A Vote an answer

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

Question #8

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

C. Only the second query executes successfully and gives the correct result.

D. Both execute successfully and give correct results.

E. Only the second query executes successfully but gives a wrong result.

Discussion 0

Correct Answer: B Vote an answer

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

Question #9

Which statement is true regarding the COALESCE function?

A. It returns the highest NOT NULL value in the list for all rows.

B. It requires that all expressions in the list must be of the same data type.

C. It can have a maximum of five expressions in a list.

D. It requires that at least one of the expressions in the list must have a NOT NULL value.

Discussion 0

Correct Answer: B Vote an answer

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

Question #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 execute and the new row will be inserted in the SALES table.

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

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

Discussion 0

Correct Answer: B Vote an answer

Question #11

Examine the structure of the EMPLOYEES table:

Which INSERT statement is valid?

A. INSERT INTO employees(employee_id, first_name, last_name, Hire_date)VALUES (
1 000, 'John', 'Smith', To_date('01/01/01'));

B. INSERT INTO employees(employee_id, first_name, last_name, hire_date)VALUES (
1 000, 'John', 'Smith', '01 January 01');

C. INSERT INTO employees (employee_id, first_name, last_name, hire_date)VALUES (
1 000, 'John', 'Smith', '01/01/01');

D. INSERT INTO employees(employee_id, first_name, last_name, hire_date)VALUES (
1 000, 'John', 'Smith', 01-Jan-01);

Discussion 0

Correct Answer: D Vote an answer

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

Question #12

There is a simple view SCOTT.DEPT_VIEW on the table SCOTT.DEPT.
This insert fails with an error:
SQL> insert into dept_view values('SUPPORT','OXFORD'); insert into dept_view values('SUPPORT','OXFORD')
* ERROR at line 1:
ORA-01400: cannot insert NULL into ("SCOTT"."DEPT"."DEPTNO")
What might be the problem?

A. The INSERT violates a constraint on the detail table.

B. The INSERT violates a constraint on the view.

C. The view was created as WITH READ ONLY.

D. The view was created as WITH CHECK OPTION.

Discussion 0

Correct Answer: A Vote an answer

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

Question #13

Examine the structure of the orders table:

You want to find the total value of all the orders for each year and issue the following command:

Which statement is true regarding the outcome?

A. It gives an error because the TO_CHAR function is not valid.

B. It gives an error because the data type conversion in the SELECT list does not match the data type conversion in the GROUP BY clause.

C. It executes successfully but does not give the correct output.

D. It executes successfully and gives the correct output.

Discussion 0

Correct Answer: B 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