Which three statements are true regarding the SQL WHERE and HAVING clauses?

• A.The HAVING clause is used to exclude one or more aggregated results after grouping data.
• B.The WHERE and HAVING clauses cannot be used together in a SQL statement.
• C.The HAVING clause conditions can have aggregating functions.
• D.The HAVING clause conditions can use aliases for the columns.
• E.The WHERE clause is used to exclude rows before grouping data.

Comment: *

Name: *

Email: *

Verification: *

Which three tasks can be performed using SQL functions built into Oracle Database? (Choose three.)

• A.displaying a date in a nondefault format
• B.combining more than two columns or expressions into a single column in the output
• C.finding the number of characters in an expression
• D.substituting a character string in a text expression with a specified string

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 view successfully?
CREATE OR REPLACE VIEW ord_vu

• A.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;
  CREATE OR REPLACE VIEW ord_vu (order_id, order_date)
• B.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;
  CREATE OR REPLACE VIEW ord_vu
• C.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;
  CREATE OR REPLACE VIEW ord_vu
• D.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
  WHITH CHECK OPTION;

Comment: *

Name: *

Email: *

Verification: *

Which statement adds a column called SALARYto the EMPLOYEEStable having 100 rows, which cannot contain null?
ALTER TABLE EMPLOYEES

• A.ADD SALARY NUMBER(8,2) NOT NULL;
• B.ADD SALARY NUMBER(8,2) DEFAULT CONSTRAINT p_nn NOT NULL;
  ALTER TABLE EMPLOYEES
• C.ADD SALARY NUMBER(8,2) DEFAULT NOT NULL;
  ALTER TABLE EMPLOYEES
• D.ADD SALARY NUMBER(8,2) DEFAULT 0 NOT NULL;
  ALTER TABLE EMPLOYEES

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the data in the EMPLOYEES table.
Exhibit

You want to generate a report showing the total compensation paid to each employee to date.
You issue the following query:

What is the outcome?

• A.It executes successfully but does not give the correct output.
• B.It generates an error because the concatenation operator can be used to combine only two items.
• C.It generates an error because the usage of the ROUNDfunction in the expression is not valid.
• D.It generates an error because the alias is not valid.
• E.IT executes successfully and gives the correct output.

Comment: *

Name: *

Email: *

Verification: *