← Back to exam page

Free 98-364 – Database Fundamentals Practice Test Question

Free demo downloads

Loading demo links...

Showing 7–9 of 15 questions

Question 7

Which of the following commands are used to terminate a transaction? Each correct answer represents a complete solution. (Choose all that apply.)

Select all that apply, then click Submit answer.

  • ○

    TRUNCATE
  • ○

    DELETE
  • ○

    ROLLBACK
  • ○

    COMMIT
Question 8

Which of the following are DML commands? Each correct answer represents a complete solution. (Choose all that apply.)

Select all that apply, then click Submit answer.

  • ○

    SELECT INTO
  • ○

    DELETE
  • ○

    UPDATE
  • ○

    ALTER
  • ○

    SELECT
  • ○

    INSERT
Question 9

Which of the following are the correct statements of using the Flashback Query feature in Oracle? Each correct answer represents a complete solution. (Choose all that apply.)

Select all that apply, then click Submit answer.

  • ○

    CREATE TABLE AS SELECT AS OF
  • ○

    SELECT AS OF
  • ○

    CREATE TABLE AS SELECT
  • ○

    INSERT INTO (SELECT)