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

Which two are SQL features? (Choose two.)

• A.providing variable definition capabilities
• B.processing sets of data
• C.providing graphical capabilities
• D.providing update capabilities for data in external files
• E.providing database transaction control

Which statement is true about Data Manipulation Language (DML)?

• A.DML automatically disables foreign ley constraints when modifying primary key values in the parent table.
• B.Each DML statement forms a transaction by default.
• C.DML disables foreign key constraints when deleting primary key values in the parent table, only when the ON DELETE CASCADE option is set for the foreign key constraint.
• D.A transaction can consist of one or more DML statements.

Which two are the minimal requirements for a self-join? (Choose two.)

• A.Outer joins must not be used in the query.
• B.The table used for the self-join must have two different alias names in the query.
• C.There must be a condition on which the self-join is performed.
• D.No other condition except the self-join may be specified.
• E.Only equijoin conditions may be used in the query.

A non-correlated subquery can be defined as __________. (Choose the best answer.)

• A.A set of sequential queries, all of which must return values from the same table.
• B.A set of sequential queries, all of which must always return a single value.
• C.A SELECT statement that can be embedded in a clause of another SELECT statement only.
• D.A set of one or more sequential queries in which generally the result of the inner query is used as the search value in the outer query.

Examine the command to create the BOOKStable.

The BOOK_IDvalue 101does not exist in the table.
Examine the SQL statement:

Which statement is true?

• A.It executes successfully only if NULL is explicitly specified in the INSERT statement.
• B.It executes successfully only if the PUBLISHER_ID column name is added to the columns list and is explicitly specified in the INSERT statement.
  NULL
• C.It executes successfully only if the PUBLISHER_ID column name is added to the columns list in the statement.
  INSERT
• D.It executes successfully and the row is inserted with a rule PUBLISHER_ID.