View the Exhibit and examine the structure of the PORDUCT_INFORMATION table. (Choose the best answer.)

PRODUCT_ID column is the primary key.
You create an index using this command:
SQL > CREATE INDEX upper_name_idx
ON product_information(UPPER(product_name));
No other indexes exist on the PRODUCT_INFORMATION table.
Which query would use the UPPER_NAME_IDX index?

• A.SELECT product_id
  FROM product_information
  WHERE UPPER(product_name) IN ('LASERPRO', 'CABLE');
• B.SELECT UPPER(product_name)
  FROM product_information;
• C.SELECT product_id, UPPER(product_name)
  FROM product_information
  WHERE UPPER(product_name) = 'LASERPRO' OR list_price > 1000;
• D.SELECT UPPER(product_name)
  FROM product_information
  WHERE product_id = 2254;

Comment: *

Name: *

Email: *

Verification: *

Examine these statements:
CREATE TABLE alter_test (c1 VARCHAR2(10), c2 NUMBER(10));
INSERT INTO alter_test VALUES ('123', 123);
COMMIT;
Which is true ahout modifyIng the columns in AITER_TEST?

• A.c2 can be changed to VARCHAR2(10) but c1 cannot be changed to NUMBER (10).
• B.c1 can be changed to VARCHAR2(5) and c2 can be changed to NUMBER (12,2).
• C.c1 can be changed to NUMBER(10) but c2 cannot be changed to VARCHAN2 (10).
• D.c2 can be changed to NUMBER(5) but c1 cannot be changed to VARCHAN2 (5).
• E.c1 can be changed to NUMBER(10) and c2 can be changed to VARCHAN2 (10).

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the CUSTOMERStable.

CUSTOMER_VUis a view based on CUSTOMERS_BR1 table which has the same structure as CUSTOMERStable.
CUSTOMERSneed to be updated to reflect the latest information about the customers.
What is the error in the following MERGEstatement?

• A.The WHEREclause cannot be used with INSERT.
• B.The INTOclause is misplaced in the command.
• C.CUSTOMER_VUcannot be used as a data source.
• D.The CUSTOMER_IDcolumn cannot be updated.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the EMP table which is not partitioned and not an index-organized table. (Choose two.)

Evaluate this SQL statement:
ALTER TABLE emp
DROP COLUMN first_name;
Which two statements are true?

• A.The drop of the FIRST_NAME column can be rolled back provided the SET UNUSED option is added to the SQL statement.
• B.The FIRST_NAME column can be dropped even if it is part of a composite PRIMARY KEY provided the CASCADE option is added to the SQL statement.
• C.The FIRST_NAME column would be dropped provided it does not contain any data.
• D.The FIRST_NAME column would be dropped provided at least one column remains in the table.

Comment: *

Name: *

Email: *

Verification: *

Sales data of a company is stored in two tables, SALES1and SALES2, with some data being duplicated across the tables. You want to display the results from the SALES1table, which are not present in the SALES2table.

Which set operator generates the required output?

• A.INTERSECT
• B.UNION
• C.PLUS
• D.MINUS
• E.SUBTRACT

Comment: *

Name: *

Email: *

Verification: *