Oracle Mock Test

ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;

ALTER TABLE customers MODIFY CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;

ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn NOT NULL;

ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn IS NOT NULL;

ALTER TABLE customers MODIFY name CONSTRAINT cust_name_nn NOT NULL;

ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name NOT NULL;

The value displayed in the CALC_VALUE column will be lower.

The value displayed in the CALC_VALUE column will be higher.

There will be no difference in the value displayed in the CALC_VALUE column.

An error will be reported.

The underlying tables must have data.

You need SELECT privileges on the view.

The underlying tables must be in the same schema.

You need SELECT privileges only on the underlying tables.

SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA\_%' ESCAPE '\';

SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_';

SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_' ESCAPE "\";

SELECT employee_id, last_name, job_id FROM employees WHERE job_id = '%SA_';

An error is returned.

You are prompted to enter a new value.

A report is produced that matches the first report produced.

You are asked whether you want a new value or if you want to run the report based on the previous value.

You have no rows in the table.

You have an employee with the name of James.

You cannot roll back to the same savepoint more than once.

Your last update fails to update any rows because employee ID 180 was already deleted.

SELECT dear customer, customer_name, FROM customers;

SELECT "Dear Customer", customer_name || ',' FROM customers;

SELECT 'Dear Customer ' || customer_name ',' FROM customers;

SELECT 'Dear Customer ' || customer_name || ',' FROM customers;

SELECT "Dear Customer " || customer_name || "," FROM customers;

SELECT 'Dear Customer ' || customer_name || ',' || FROM customers;

SELECT TO_CHAR(SYSDATE,'yyyy') FROM dual;

SELECT TO_DATE(SYSDATE,'yyyy') FROM dual;

SELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY') FROM dual;

SELECT DECODE(SUBSTR(SYSDATE, 8), 'year') FROM dual;

SELECT TO_CHAR(SUBSTR(SYSDATE, 8,2),'yyyy') FROM dual;

INSERT

UPDATE

SELECT

DESCRIBE

DELETE

RENAME

SELECT category, SUM(price * quantity) TOTAL, location FROM inventory WHERE price > 100.00 GROUP BY category;

SELECT category, location, SUM(price) FROM inventory WHERE price > 100.00 GROUP BY category, location;

SELECT category, SUM(price * quantity) TOTAL, location FROM inventory WHERE price > 100.00;

SELECT category, SUM(price * quantity) TOTAL, location FROM inventory WHERE price > 100.00 GROUP BY category, location;

ORDER BY SALARY > 5000

GROUP BY SALARY > 5000

HAVING SALARY > 5000

WHERE SALARY > 5000

SELECT SUBSTR( ‘HelloWorld’,1) FROM dual;

SELECT INITCAP(TRIM (‘HelloWorld’, 1,1)) FROM dual;

SELECT LOWER(SUBSTR(‘HellowWorld’, 1, 1) FROM dual;

SELECT LOWER(SUBSTR(‘HelloWorld’, 2, 1) FROM dual;

SELECT LOWER(TRIM (‘H’ FROM ‘HelloWorld’)) FROM dual;