Examine the structure of the PROGRAMStable:

Which two SQL statements would execute successfully?
SELECT NVL(ADD_MONTHS(END_DATE,1)SYSDATE)

• A.FROM programs;
  SELECT TO_DATE(NVL(SYSDATE-END_DATE,SYSDATE))
• B.FROM programs;
  SELECT NVL(TO_CHAR(MONTHS_BETWEEN(start-date,end_date)),'Ongoing')
• C.FROM programs;
• D.FROM programs;
  SELECT NVL(MONTHS_BETWEEN(start_date,end_date),'Ongoing')

Comment: *

Name: *

Email: *

Verification: *

Which statement is true regarding the INTERSECT operator?

• A.The names of columns in all SELECT statements must be identical.
• B.It ignores NULL values.
• C.Reversing the order of the intersected tables alters the result.
• D.The number of columns and data types must be identical for all SELECT statements in the query.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the data in the PRODUCTStable.

Which statement would add a column called PRICE, which cannot contain NULL?
ALTER TABLE products

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

Comment: *

Name: *

Email: *

Verification: *

Evaluate the following query:

What would be the outcome of the above query?

• A.It produces an error because flower braces have been used.
• B.It executes successfully and displays the literal " {'s start date was \> "for each row in the output.
• C.It executes successfully and introduces an 'sat the end of each promo_namein the output.
• D.It produces an error because the data types are not matching.

Comment: *

Name: *

Email: *

Verification: *

What is true about non-equijoin statement performance?

• A.The join syntax used makes no difference to performance.
• B.The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.
• C.Table aliases can improve performance.
• D.The BETWEEN condition always performs less well than using the >= and <= conditions.
• E.The BETWEEN condition always performs better than using the >= and <= conditions.

Comment: *

Name: *

Email: *

Verification: *