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

You are currently located in Singapore and have connected to a remote database in Chicago. You issue the following command:
Exhibit:

PROMOTIONS is the public synonym for the public database link for the PROMOTIONS table.
What is the outcome?

• A.An error because the ROUND function specified is invalid
• B.Number of days since the promo started based on the current Chicago data and time
• C.An error because the WHERE condition specified is invalid
• D.Number of days since the promo started based on the current Singapore data and time.

You need to display the date ll-oct-2007 in words as "Eleventh of October, Two Thousand Seven'. Which SQL statement would give the required result?

• A.SELECT TO_CHAR(TO_DATE('ll-oct-2007'X 'miDdspth of month, year') FROM DUAL;
• B.SELECT TO_CHAR('ll-oct-2007'. 'miDdspth "of Month. Year') FROM DUAL:
• C.SELECT TO_CHAR(TO_DATE('ll-oct-2007'), 'miDdthsp "of* Month. Year') FROM DUAL;
• D.SELECT TO_DATE(TO_CHAR('ll-oct-20077fiiiDdspth "of" Month. Year')) FROM DUAL:

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

• A.SELECT
• B.DELETE
• C.INSERT
• D.RENAME
• E.DESCRIBE
• F.UPDATE

SELECT student_id, gpa FROM student_grades WHERE gpa > &&value;
You run the statement once, and when prompted you enter a value of 2.0. A report is produced. What happens when you run the statement a second time?

• A.You are asked whether you want a new value or if you want to run the report based on the previous value.
• B.An error is returned.
• C.A report is produced that matches the first report produced.
• D.You are prompted to enter a new value.

Evaluate the following SQL commands:

The command to create a table fails. Identify the reason for the SQL statement failure?
(Choose all that apply.)

• A.You cannot use ORD_NO and ITEM_NO columns as a composite primary key because ORD NO is also the FOREIGN KEY.
• B.You cannot use the NEXTVAL sequence value as a DEFAULT value for a column.
• C.You cannot use SYSDATE in the condition of a CHECK constraint.
• D.You cannot use the BETWEEN clause in the condition of a CHECK constraint.