Question 61

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.)
  • Question 62

    In one of your databases, you create a user, HR, and then execute this command:
    GRANT CREATE SESSION TO hr WITH ADMIN OPTION;
    Which three actions can HR perform? (Choose three.)
  • Question 63

    Which two statements are true about the PMON background process? (Choose two.)
  • Question 64

    You execute this command:

    Sufficient storage is available in filesystem /u01.
    Which two statements are true about the BIG_TBStablespace? (Choose two.)
  • Question 65

    Your database instance is started with a PFILE.
    Examine these parameters:

    You want to increase the size of the buffer cache.
    Free memory is available to increase the size of the buffer cache.
    You execute the command:
    SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
    What is the outcome?