1Z0-082 Exam Question 21

Examine this command:

Which two statements are true? (Choose two.)
  • 1Z0-082 Exam Question 22

    Which two actions can you perform using DBCA for an existing database?
  • 1Z0-082 Exam Question 23

    Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.
    Only the EMPLOYEE_ID column is indexed.
    Rows exist for employees 100 and 200.
    Examine this statement:

    Which two statements are true? (Choose two.)
  • 1Z0-082 Exam Question 24

    A script abc.sql must be executed to perform a job.
    A database user HR, who is defined in this database, executes this command:
    $ sqlplus hr/hr@orcl @abc.sql
    What will happen upon execution?
  • 1Z0-082 Exam Question 25

    Examine the description of the BOOKS table:

    The table has 100 rows.
    Examine this sequence of statements issued in a new session:
    INSERT INTO books VALUES ('ADV112', 'Adventures of Tom Sawyer', NULL, NULL); SAVEPOINT a; DELETE FROM books; ROLLBACK TO SAVEPOINT a; ROLLBACK; Which two statements are true? (Choose two.)