1z0-071 Exam Question 66

Which statement fails to execute successfully?
  • 1z0-071 Exam Question 67

    Which three actions can you perform by using the ALTER TABLE command?
  • 1z0-071 Exam Question 68

    Which three statements are true about the DESCRIBE command?
  • 1z0-071 Exam Question 69

    Examine this query:
    SELECT SUBSTR (SYSDATE,1,5) 'Result' FROM DUAL
    Which statement is true?
  • 1z0-071 Exam Question 70

    Examine these two queries and their output:
    SELECT deptno, dname FROM dept;

    SELECT ename, job, deptno FROM emp ORDER BY deptno;

    Now examine this query:
    SELECT ename, dname
    FROM emp CROSS JOIN dept WHERE job = 'MANAGER'
    AND dept.deptno IN (10, 20) ;