1z1-061 무료 덤프문제 온라인 액세스

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

You need to generate a report that displays the IDs of all products in the costs table whose unit price is at least 25% more than the unit cost. The details should be displayed in the descending order of 25% of the unit cost.
You issue the following query:

Which statement is true regarding the above query?

• A.It produces an error because the expression in the ORDER by clause should also be specified in the SELECT clause.
• B.It produces an error because an expression cannot be used in the order by clause.
• C.It produces an error because the DESC option cannot be used with an expression in the order by clause.
• D.It executes and produces the required result.

View the Exhibit and examine the data in the PROMO_CATEGORY and PROMO_COST columns of the PROMOTIONS table.

Evaluate the following two queries:
SQL>SELECT DISTINCT promo_category to_char(promo_cost)"code" FROM promotions ORDER BY code; SQL>SELECT DISTINCT promo_category promo_cost "code" FROM promotions ORDER BY 1; Which statement is true regarding the execution of the above queries?

• A.Only the first query executes successfully.
• B.Only the second query executes successfully.
• C.Both queries execute successfully and give the same result.
• D.Both queries execute successfully but give different results.

See the Exhibit and examine the structure of ORD table:
Exhibit:

Evaluate the following SQL statements that are executed in a user session in the specified order:
CREATE SEQUENCE ord_seq;
SELECT ord_seq.nextval
FROM dual;
INSERT INTO ord
VALUES (ord_seq.CURRVAL, '25-jan-2007, 101);
UPDATE ord
SET ord_no= ord_seq.NEXTVAL
WHERE cust_id =101;
What would be the outcome of the above statements?

• A.All the statements would execute successfully and the ORD_NO column would contain the value 2 for the CUST_ID 101.
• B.The CREATE SEQUENCE command would not execute because the starting value of the sequence and the increment value have not been specified.
• C.All the statements would execute successfully and the ORD_NO column would have the value 20 for the CUST_ID 101 because the default CACHE value is 20.
• D.The CREATE SEQUENCE command would not execute because the minimum value and maximum value for the sequence have not been specified.

The STUDENT_GRADES table has these columns:
STUDENT_ID. NUMBER(12)
SEMESTER_END. DATE
GPA. NUMBER(4, 3)
The registrar has asked for a report on the average grade point average (GPA), sorted from the highest grade point average to each semester, starting from the earliest date.
Which statement accomplish this?

• A.SELECT student_id, semester_end, gpaFROM student_gradesORDER BY gpa DESC, semester_end DESC;
• B.SELECT student_id, semester_end, gpaFROM student_gradesORDER BY
  semester_end DESC, gpa DESC;
• C.SELECT student_id, semester_end, gpaFROM student_gradesORDER BY
  semester_end, gpa ASC
• D.SELECT student_id, semester_end, gpaFROM student_gradesORDER BY gpa DESC, semester_end ASC;
• E.SELECT student_id, semester_end, gpaFROM student_gradesORDER BY
  semester_end, gpa DESC
• F.SELECT student_id, semester_end, gpaFROM student_gradesORDER BY gpa DESC, semester_end ASC;

You need to calculate the number of days from 1st January 2007 till date . Dates are stored in the default format of dd-mon-rr. Which two SQL statements would give the required output? (Choose two.)

• A.SELECT SYSDATE - TOJDATE('01-JANUARY-2007') FROM DUAL:
• B.SELECT SYSDATE - '01-JAN-2007' FROM DUAL:
• C.SELECT TO_CHAR(SYSDATE. 'DD-MON-YYYY') - '01-JAN-2007' FROM DUAL:
• D.SELECT TO_DATE(SYSDATE. *DD/MONTH/YYYY') - '01/JANUARY/2007' FROM DUAL:
• E.SELECT SYSDATE - TOJDATE(X)1/JANUARY/2007") FROM DUAL: