What is true about this set of statements? CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)); ROLLBACK; DESCRIBE DEPT;

In Oracle "view" consists of:

You need to give the MANAGER role the ability to select from, insert into, and modify existing rows in the STUDENT_GRADES table. Anyone given this MANAGER role should be able to pass those privileges on to others. Which statement accomplishes this?

Which /SQL*Plus feature can be used to replace values in the WHERE clause?

Which of these statement is NOT true?

Which data dictionary table should you query to view the object privileges granted to the user on specific columns?

Which of these is NOT an Oracle "database option?"

What will happen if PL/SQL variables occur in SQL statements and have the same name as a table column

How would you display a listing of the sums of employee salaries for those employees not making a commission, for each job type, including only those sums greater than 2500?

Which of the following actions are performed by the MINUS operator?

The "materialized view" in Oracle stores: