1Z0-007 試験問題を無料オンラインアクセス

STUDENT_ID NUMBER(12)
SEMESTER_END DATE
GPA NUMBER(4,3)
Which statement finds the highest grade point average (GPA) per semester?

• A.SELECT (gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;
• B.SELECT MAX(gpa) GROUP BY semester_end WHERE gpa IS NOT NULL FROM student_grades;
• C.SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL GROUP BY semester_end;
• D.SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL;
• E.SELECT MAX(gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;

You need to calculate the total of all salaries in the accounting department. Which group function should you use?

• A.SUM
• B.TOTAL
• C.COUNT
• D.LARGEST
• E.MIN
• F.MAX

Which SQL statement displays the date March 19, 2001 in a format that appears as "Nineteenth of March 2001 12:00:00 AM"?

• A.SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth "of" Month YYYY HH:MI:SS AM') NEW_DATE FROM dual;
• B.SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth "of" Month YYYY fmHH:MI:SS AM') NEW_DATE FROM dual;
• C.SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY), 'fmDdspth "of" Month YYYYfmtHH:HI:SS AM') NEW_DATE FROM dual;
• D.SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'Ddspth "of" Month YYYY fmHH:MI:SS AM') NEW_DATE FROM dual;

You would like to display the system date in the format "Monday, 01 June, 2001".
Which SELECT statement should you use?

• A.SELECT TO_CHAR(SYSDATE, 'FMDay, DD Month, YYYY') FROM dual;
• B.SELECT TO_DATE(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;
• C.SELECT TO_DATE(SYSDATE, 'FMDAY, DD Month, YYYY') FROM dual;
• D.SELECT TO_CHAR(SYSDATE, 'FMDD, DY Month, 'YYYY') FROM dual;
• E.SELECT TO_CHAR(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;

Which two are attributes of iSQL*Plus? (Choose two)

• A./SQL*Plus commands are used to manipulate data in tables.
• B./SQL*Plus is the Oracle proprietary interface for executing SQL statements.
• C./SQL*Plus commands are accessed from a browser.
• D./SQL*Plus commands manipulate table definitions in the database.
• E./SQL*Plus commands cannot be abbreviated.