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

Evaluate the following SQL commands:

The command to create a table fails. Identify the reason for the SQL statement failure.

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

Which two statements are true about the DUAL table? (Choose two.)

• A.It can display multiple rows but only a single column.
• B.It can display multiple rows and columns.
• C.It can be accessed by any user who has the SELECT privilege in any schema.
• D.It consists of a single row and single column of VARCHAR2 data type.
• E.It can be used to display only constants or pseudo columns.
• F.It can be accessed only by the SYS user.

Examine the structure of the PROGRAMS table:

Which two SQL statements would execute successfully?

• A.SELECT NVL (MONTHS_BETWEEN (start_date, end_date), `Ongoing') FROM programs;
• B.SELECT NVL (TO_CHAR (MONTHS_BETWEEN (start-date, end_date)), `Ongoing') FROM programs
• C.SELECT TO_DATE (NVL (SYSDATE-END_DATE, SYSDATE)) FROM programs;
• D.SELECT NVL (ADD_MONTHS (END_DATE,1) SYSDATE) FROM programs;

Which statements are correct regarding indexes? (Choose all that apply.)

• A.Indexes should be created on columns that are frequently referenced as part of an expression.
• B.A non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a unique index.
• C.For each DML operation performed, the corresponding indexes are automatically updated.
• D.When a table is dropped, the corresponding indexes are automatically dropped.

Which two statements are true about conditional INSERT ALL? (Choose two.)

• A.Each row returned by the subquery can be inserted into only a single target table.
• B.Each WHEN condition is tested for each row returned by the subquery.
• C.The total number of rows inserted is always equal to the number of rows returned by the subquery.
• D.A single WHEN condition can be used for multiple INTO clauses.
• E.It cannot have an ELSE clause.