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?

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

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the DEPARTMENTS table.

You execute the following command:

Which two statements are true? (Choose two.)

• A.Views created in the DEPARTMENTStable that include the COUNTRYcolumn are automatically modified and remain valid.
• B.A new column, COUNTRY, can be added to the DEPARTMENTStable after executing the command.
• C.Unique key constraints defined on the COUNTRYcolumn are removed.
• D.Synonyms existing of the DEPARTMENTStable would have to be re-created.
• E.Indexes created on the COUNTRYcolumn exist until the DROP UNUSED COLUMNScommand is executed.

Comment: *

Name: *

Email: *

Verification: *

See the Exhibit and examine the structure of the PROMOTIONS table: Exhibit:

Using the PROMOTIONS table, you need to find out the average cost for all promos in the
range $0-2000 and $2000-5000 in category A.
You issue the following SQL statements:
Exhibit:

What would be the outcome?

• A.It generates an error because multiple conditions cannot be specified for the WHEN clause
• B.It executes successfully and gives the required result
• C.It generates an error because CASE cannot be used with group functions
• D.It generates an error because NULL cannot be specified as a return value

Comment: *

Name: *

Email: *

Verification: *

Examine this business rule:
Each student can work on multiple projects and earth project can have multiple students.
You must decide an Entity Relationship (ER) model for optional data storage and allow generating reports in this format:
STUDENT_ID FIRST_NAME LAST_NAME PROJECT_ID PROJECT_NAME PROJECT_TASK Which two statements are true?

• A.PROJECT_ID must be the primary key in the PROJECTS entity and foreign key in the STUDENTS entity.
• B.STUDENT_ID must be the primary key in the STUDENTS entity and foreign key in the PROJECTS entity.
• C.The ER must have a many-to-many relationship between the STUDENTS and PROJECTS entities that must be resolved into 1-to-many relationships.
• D.The ER must have a 1-to-many relationship between the STUDENTS and PROJECTS entities.
• E.An associative table must be created with a composite key of STUDENT_ID and PROJECT_ID, which is the foreign key linked to the STUDENTS and PROJECTS entities.

Comment: *

Name: *

Email: *

Verification: *

The first DROP operation is performed on PRODUCTS table using the following command:
DROP TABLE products PURGE;
Then you performed the FLASHBACK operation by using the following command:
FLASHBACK TABLE products TO BEFORE DROP;
Which statement describes the outcome of the FLASHBACK command?

• A.It recovers the table structure and data but not the related indexes.
• B.It recovers only the table structure.
• C.It recovers the table structure, data, and the indexes.
• D.It is not possible to recover the table structure, data, or the related indexes.

Comment: *

Name: *

Email: *

Verification: *