View the Exhibit and examine the structure of the PROMOTION table.
You have to generate a report that displays the promo named start data for all promos that started after that last promo in the 'INTTERNET' category.

• A.SELECT promo_neme, promo_being_date FROM promotions
  WHERE promo_being_date > All (SELECT promo_beinjg-date
  FROM promotions
  WHERE promo_category ='INTERNET' );
• B.Select promo_name, promo_being_date FROM promoptions
  WHERE promo_being_data > ANY (SELCT promo_being-date
  FROM promotions
  WHERE promo_category = 'INTERNET'
• C.SELECT promo-name, promo-being _date FROM promotions
  Where promo_being_data >ALL (SELECT MAX (promo_being-date)
  FROM promotions ) AND
  Promo-category ='INTERNET';
• D.SELECT promo-name, promo-being_date FROM promotion
  WHERE promo-being-date IN (SELECT promo_biing_date
  FROM promotions
  WHERE promo_category='INTYERNET');

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about defining relations between tables in a relational database? (Choose three.)

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

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the ORDERS table. The ORDER_ID column is the PRIMARY KEY in the ORDERS table.

Evaluate the following CREATE TABLE command:
CREATE TABLE new_orders(ord_id, ord_date DEFAULT SYSDATE, cus_id)
AS
SELECT order_id.order_date,customer_id
FROM orders;
Which statement is true regarding the above command?

• A.The NEW_ODRDERS table would not get created because the DEFAULT value cannot be specified in the column definition.
• B.The NEW_ODRDERS table would not get created because the column names in the CREATE TABLE command and the SELECT clause do not match.
• C.The NEW_ODRDERS table would get created and all the constraints defined on the specified columns in the ORDERS table would be passed to the new table.
• D.The NEW_ODRDERS table would get created and only the NOT NULL constraint defined on the specified columns would be passed to the new table.

Comment: *

Name: *

Email: *

Verification: *

Examine this description of the EMP table:

You execute this query:
SELECT deptno AS "departments", SUM (sal) AS "salary"
FROM emp
GROUP | BY 1
HAVING SUM (sal)> 3 000;
What is the result?

• A.all departments and a sum of the salaries of employees with a salary greater than 3000
• B.an error
• C.only departments where the total salary is greater than 3000, returned in no particular order
• D.only departments where the total salary is greater than 3000, ordered by department

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the structure in ORDERSand ORDER_ITEMStables.

You need to create a view that displays the ORDER_ID, ORDER_DATE, and the total number of items in each order.
Which CREATEVIEWstatement would create the views successfully?

• A.CREATE OR REPLACE VIEW ord_vu
  AS SELECT o.order_id, o.order_date, COUNT (i.line_item_id)
  " NO OF ITEMS"
  FROM orders o JOIN order_items i
  ON (o.order_id = i.order_id)
  GROUP BY o.order_id, o.order_date;
• B.CREATE OR REPLACE VIEW ord_vu (order_id, order_date)
  AS SELECT o.order_id, o.order_date, COUNT (i.line_item_id)
  " NO OF ITEMS"
  FROM orders o JOIN order_items i
  ON (o.order_id = i.order_id)
  GROUP BY o.order_id, o.order_date;
• C.CREATE OR REPLACE VIEW ord_vu
  AS SELECT o.order_id, o.order_date, COUNT (i.line_item_id) ||
  "NO OF ITEMS"
  FROM orders o JOIN order_items i
  ON (o.order_id = i.order_id)
  WHITH CHECK OPTION;
• D.CREATE OR REPLACE VIEW ord_vu
  AS SELECT o.order_id, o.order_date, COUNT (i.line_item_id)
  FROM orders o JOIN order_items i
  ON (o.order_id = i.order_id)
  GROUP BY o.order_id, o.order_date;

Comment: *

Name: *

Email: *

Verification: *