View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables.

Which INSERT statement should be used to add a row into the ORDERS table for the customer whose CUST LAST NAME is Roberts and CREDIT LIMIT is 600?

• A.INSERT INTO orders (order_id,order_date,order_mode,
  (SELECT customer_id
  FROM customers
  WHERE cust_last_name='Roberts' AND
  credit_limit=600) .order_total)
  VALUES(1 ,'10-mar-2007', 'direct', &&customer_id, 1000);
• B.INSERT INTO orders
  VALUES (1,'10-mar-2007', 'direct',
  (SELECT customer_id
  FROM customers
  WHERE cust_last_name='Roberts' AND
  credit_limit=600), 1000);
• C.INSERT INTO(SELECT o.order_id, o.order_date.o.orde_mode.c.customer_id, o.order_total FROM orders o, customers c WHERE o.customer_id = c.customer_id AND c.cust_last_name='Roberts'ANDc. Credit_limit=600) VALUES (1,'10-mar-2007', 'direct',(SELECT customer_id FROM customers WHERE cust_last_name='Roberts' AND Credit_limit=600), 1000);
• D.INSERT INTO orders (order_id.order_date.order_mode,
  (SELECT customer_id
  FROM customers
  WHERE cust_last_name='Roberts' AND
  credit _limit=600) .order_total)
  VALUES(1 ,'IO-mar-2007', 'direct', &customer_id, 1000);

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about defining relations between tables in a relational database?

• A.Every foreign key value must refer to a matching primary or unique key value.
• B.Every primary or unique key value must refer to a matching foreign key value.
• C.Unique key columns allow null values.
• D.Foreign key columns allow null values.
• E.Primary key columns allow null values.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the PRODUCTS table.

You must display the category with the maximum number of items.
You issue this query:

What is the result?

• A.It generate an error because the subquery does not have a GROUP BY clause.
• B.It generates an error because = is not valid and should be replaced by the IN operator.
• C.It executes successfully and gives the correct output.
• D.It executes successfully but does not give the correct output.

Comment: *

Name: *

Email: *

Verification: *

Examine these statements:

Which two are true?

• A.The DEPTNO column in the EMP table will be able to contain null values.
• B.All three statements execute successfully in the order shown.
• C.Both foreign key constraint definition must be removed from the CREATE statements, and be added with ALTER TABLE statements once both tables are created, for the two CREATE TABLE statements to execute successfully in the order shown.
• D.The create TABLE EMP statement must precede the create table DEPT statement for all three statements to execute successfully.
• E.The MGR column In the DEPT table will not be able to contain null values.
• F.The DEPT_FKEY constraint definition must be removed from the CREATE TABLE DEPT statement. and the added with an D. ALTER statement once both tables are created, for the two CREATE TABLE statements to execute successfully in the order shown.

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the CUSTOMERStable:

For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.
Which query should be used?

• A.
• B.
• C.
• D.
• E.

Comment: *

Name: *

Email: *

Verification: *