1Z0-171 Exam Question 36

Which of the following SET operators combines results from two queries and removes duplicates?
  • 1Z0-171 Exam Question 37

    Which of the following data dictionary views provides information about constraints on tables?
  • 1Z0-171 Exam Question 38

    Which SQLPlus command displays defined substitution variable values?
  • 1Z0-171 Exam Question 39

    Which SQL function calculates the number of months between two dates?
    Response:
  • 1Z0-171 Exam Question 40

    What will the following SQL query do?
    UPDATE employees
    SET salary = salary * 1.1
    WHERE department_id = 10;