Which statement will execute successfully?

• A.SELECT 3 FROM DUAL
  UNION
  SELECT 4 FROM DUAL
  ORDER BY 3 ;
• B.SELECT 1 FROM DUAL
  UNION
  SELECT 2 FROM DUAL
  ORDER BY 1, 2;
• C.SELECT 1, 2 FROM DUAL
  UNION
  SELECT 3, 4 FROM DUAL
  ORDER BY 1, 2;
• D.SELECT 1, 2 FROM DUAL
  UNION
  SELECT 3, 4 FROM DUAL
  ORDER BY 3, 4;

Comment: *

Name: *

Email: *

Verification: *

Examine the SQL statement used to create the TRANSACTION table.
SQL > CREATE TABLE transaction
(trn_id char(2) primary key,
Start_date date DEFAULT SYSDATE,
End_date date NOT NULL);
The value 'A1' does not exist for trn_id in this table.
Which SQL statement successfully inserts a row into the table with the default value for START_DATE?

• A.INSERT INTO transaction (trn_id, start_date, end_date) VALUES ('A1', , '10-DEC-2014')
• B.INSERT INTO transaction (trn_id, end_date) VALUES ('A1', '10-DEC-2014')
• C.INSERT INTO transaction VALUES ('A1', DEFAULT, TO_DATE(DEFAULT+10))
• D.INSERT INTO transaction VALUES ('A1', DEFAULT, TO_DATE('SYSDATE+10'))

Comment: *

Name: *

Email: *

Verification: *

You execute the SQL statement:
SQL> CREATE TABLE citizens
(citizen_id CHAR (10) PRIMARY KEY,
last_name VARCHAR2 (50) NOT NULL,
first_name VARCHAR2 (50),
address VARCHAR2 (100),
city VARCHAR2 (30) DEFAULT 'SEATTLE' NOT NULL,
CONSTRAINT cnames CHECK (first_name<>last_name) );
What is the outcome?

• A.It fails because the NOT NULL and DEFAULT options cannot be combined for the same column.
• B.It fails because the condition for the CANAMES constraint is not valid.
• C.It succeeds and an index is crated for CITIZEN_ID.
• D.It succeeds and CITY can contain only 'SEATTLE' or null for all rows.

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

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the SALESand PRODUCTStables. (Choose two.)

In the SALEStable, PROD_ID is the foreign key referencing PROD_ID in the PRODUCTS table. You must list each product ID and the number of times it has been sold.
Examine this query which is missing a JOINoperator:

Which two JOINoperations can be used to obtain the required output? (Choose two.) FULL OUTER JOIN

• A.
• B.JOIN
• C.RIGHT OUTER JOIN
• D.LEFT OUTER JOIN

Comment: *

Name: *

Email: *

Verification: *