Which two are true?

Which three are true about privileges?

Which three statements about roles are true?

Which FOUR actions can you perform only with system privileges?

As the DBA, you execute this command:

GRANT CREATE VIEW TO A WITH ADMIN OPTION;

A then executes this command:

GRANT CREATE VIEW TO B WITH ADMIN OPTION;

B then executes this command:

GRANT CREATE VIEW TO C;

Which statement is true?

DROP TABLE scott.emp;

Which three statements are true?

SQL > DROP TABLE PROD;

Which three statements are true about the implication of this command?

Examine this description of the PROD table: 

Name NULL? TYPE

---------------------------

PROD_ID NOT NULL VARCHAR2(6) 

QUANTITY NUMBER(8,2)

PRICE NUMBER(10.2) 

EXPIRY_DATE DATE

Rows exist in this table with data in all the columns. You put the PROD table in read-only

mode.

Which three commands execute successfully on PROD?

Which three are true about dropping columns from a table?

Which two are true about constraints?

Examine these statements:

CREATE TABLE dept (

deptno NUMBER PRIMARY KEY, dname VARCHAR2 (10),

mgr NUMBER,

CONSTRAINT dept_fkey FOREIGN KEY (mgr) REFERENCES emp (empno)) ; CREATE TABLE emp(

empno NUMBER PRIMARY KEY, ename VARCHAR2 (10),

deptno NUMBER,

CONSTRAINT emp_fkey FOREIGN KEY (deptno) REFERENCES dept (deptno) DISABLE) ; ALTER TABLE emp MODIFY CONSTRAINT emp_fkey ENABLE ;

Which two are true?

Which two are true about using constraints?

Which three statements are true about views in an Oracle Database?