Choose three. In which three situations will re-executing this query still return a row but with a different XID, indicating a new transaction has Started?

Choose two. Which two SELECT statements will return these results: CUSTOMER_NAME ------------------------- Mandy Mary

Choose two. Which two are true about constraints?

Choose three. Which three are true about privileges?

Choose two. Which two statements are true about dropping views?

Choose two. 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?

Choose three. Which three statements about roles are true?

Choose three. Which three actions can you perform only with system privileges?

Choose two. Which two statements are true about an Oracle database?

Choose three. Which three statements are true about external tables?

Choose two. Which two will execute successfully?

Choose two. Which two statements are true about the data dictionary?

Choose two. Which two are true about external tables that use the ORACLE_DATAPUMP access driver?

Choose two. Which two are true about using constraints?

Choose two. Which two queries can be used?