Examine this SELECT statement and view the Exhibit to see its output:

SELECT constraints_name, constraints_type, search_condition, r_constraints_name, delete_rule, status, FROM user_constraints WHERE table_name = 'ORDERS'; Which two statements are true about the output? (Choose two.)

• A.In the second column, 'c' indicates a check constraint.
• B.The STATUS column indicates whether the table is currently in use.
• C.The DELETE_RULE column indicates the desired state of related rows in the child table when the corresponding row is deleted from the parent table.
• D.The R_CONSTRAINT_NAME column contains an alternative name for the constraint.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibits and examine the structure of the COSTSand PROMOTIONStables.
You want to display PROD_IDSwhose promotion cost is less than the highest cost PROD_IDin a promotion time interval.
Examine this SQL statements:

What will be the result?
Exhibit 1.

Exhibit 2.

• A.It executes successfully but does not give the required result
• B.It executes successfully and gives the required result
• C.It gives an error because the GROUP BYclause is not valid
• D.It gives an error because the ALLkeyword is not valid

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of ORDERS and ORDER_ITEMS tables.
ORDER_ID is the primary key in the ORDERS table. It is also the foreign key in the ORDER_ITEMS table wherein it is created with the ON DELETE CASCADE option.
Which DELETE statement would execute successfully?

• A.DELETE orders o, order_items IWHERE o.order_id = i.order_id;
• B.DELETEFROM ordersWHERE (SELECT order_idFROM order_items);
• C.DELETE order_idFROM ordersWHERE order_total < 1000;
• D.DELETE ordersWHERE order_total < 1000;

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true regarding the DELETE and TRUNCATE commands?

• A.DELETE and TRUNCATE can be used for tables that are parents for a child table that has a referential integrity constraint having an ON DELETE rule.
• B.DELETE can be used to remove rows only for tables that are parents for a child table that has a referential integrity constraint referring to the parent.
• C.DELETE can be used to remove rows from only one table in one statement.
• D.DELETE can be used to remove data from specific columns as well as complete rows.
• E.DELETE can be used to remove rows from multiple tables in one statement.

Comment: *

Name: *

Email: *

Verification: *

Which two are SQL features?

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

Comment: *

Name: *

Email: *

Verification: *