Examine the structure of the ORDERS table: (Choose the best answer.)
You want to find the total value of all the orders for each year and issue this command:
SQL> SELECT TO_CHAR(order_date,'rr'), SUM(order_total) FROM orders
GROUP BY TO_CHAR(order_date, 'yyyy');
Which statement is true regarding the result?

• A.It returns an error because the TO_CHAR function is not valid.
• B.It executes successfully but gives the correct output.
• C.It executes successfully but does not give the correct output.
• D.It return an error because the datatype conversion in the SELECT list does not match the data type conversion in the GROUP BY clause.

Comment: *

Name: *

Email: *

Verification: *

Examine this description of the PRODUCTS table:

You successfully execute this command:

Which two statements execute without errors?

• A.Option A
• B.Option B
• C.Option D
• D.Option C

Comment: *

Name: *

Email: *

Verification: *

Which two are true about scalar subquery expressions? (Choose two.)

• A.They can return at most one row.
• B.You must enclose them in parentheses.
• C.You can use them as a default value for a column.
• D.You cannot correlate them with a table in the parent statement.
• E.They can return two columns.

Comment: *

Name: *

Email: *

Verification: *

Examine these statements executed in a single Oracle session:

Which three statements are true? (Choose three.)

• A.There is no row containing pen.
• B.The code for penis 1.
• C.There is no row containing pencil.
• D.The code for penis 10.
• E.The code for fountain penis 3.
• F.There is no row containing fountain pen.

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) DEFAULT CONSTRAINT p_nn NOT NULL;
  ALTER TABLE EMPLOYEES
• B.ADD SALARY NUMBER(8,2) NOT NULL;
• 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: *