Examine this query which executes successfully;
Select job,deptno from emp
Union all
Select job,deptno from jobs_history;
What will be the result?

• A.It will return rows common to both select statements.
• B.It will return rows that are not common to both select statements.
• C.It will return rows from both select statements after eliminating duplicate rows.
• D.It will return rows both select statements including duplicate rows.

Comment: *

Name: *

Email: *

Verification: *

View the exhibit for the structure of the STUDENTand FACULTYtables.

You need to display the faculty name followed by the number of students handled by the faculty at the base location.
Examine the following two SQL statements:
Statement 1
SQL>SELECT faculty_name, COUNT(student_id)
FROM student JOIN faculty
USING (faculty_id, location_id)
GROUP BY faculty_name;
Statement 2
SQL>SELECT faculty_name, COUNT(student_id)
FROM student NATURAL JOIN faculty
GROUP BY faculty_name;
Which statement is true regarding the outcome?

• A.Only statement 1 executes successfully and gives the required result.
• B.Both statements 1 and 2 execute successfully and give the same required result.
• C.Both statements 1 and 2 execute successfully and give different results.
• D.Only statement 2 executes successfully and gives the required result.

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the ORDERStable.

The ORDERStable contains data and all orders have been assigned a customer ID. Which statement would add a NOTNULLconstraint to the CUSTOMER_IDcolumn?
ALTER TABLE orders

• A.ADD CONSTRAINT orders_cust_id_nn NOT NULL (customer_id);
  ALTER TABLE orders
• B.ADD customer_id NUMBER(6)CONSTRAINT orders_cust_id_nn NOT NULL;
• C.MODIFY CONSTRAINT orders_cust_id_nn NOT NULL (customer_id);
  ALTER TABLE orders
• D.MODIFY customer_id CONSTRAINT orders_cust_nn NOT NULL (customer_id);
  ALTER TABLE orders

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTSand TIMEStables.

The PROD_IDcolumn is the foreign key in the SALEStable referencing the PRODUCTStable.
The CUST_IDand TIME_IDcolumns are also foreign keys in the SALEStable referencing the CUSTOMERS and TIMEStables, respectively.
Examine this command:
CREATE TABLE new_sales (prod_id, cust_id, order_date DEFAULT SYSDATE)
AS
SELECT prod_id, cust_id, time_id
FROM sales;
Which statement is true?

• A.The NEW_SALEStable would get created and all the NOTNULLconstraints defined on the selected columns from the SALES table would be created on the corresponding columns in the NEW_SALES table.
• B.The NEW_SALEStable would not get created because the DEFAULTvalue cannot be specified in the column definition.
• C.The NEW_SALEStable would get created and all the FOREIGNKEYconstraints defined on the selected columns from the SALES table would be created on the corresponding columns in the NEW_SALES table.
• D.The NEW_SALEStable would not get created because the column names in the CREATETABLE command and the SELECTclause do not match.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about multitable insert statements?

• A.The conditional insert all statement inserts rows into a single table by aggregating source rows.
• B.The unconditional insert all statement must have the same number of columns In both the source and target tables.
• C.The conditional insert first statement always Inserts a row Into a single table.
• D.They can transform a row from a source table Into multiple rows In a target table.
• E.They always use subqueries.

Comment: *

Name: *

Email: *

Verification: *