1Z0-082 Exam Question 71

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.)
  • 1Z0-082 Exam Question 72

    Which two statements are true about single row functions? (Choose two.)
  • 1Z0-082 Exam Question 73

    In one of your databases, the user HR has the password HRMGR.
    You want to connect to a database instance whose listener listens on port 1531 by using this statement:
    CONNECT HR/HRMGR@orcl
    No name server is used.
    Which statement is true about ORCL?
  • 1Z0-082 Exam Question 74

    A database is configured to use automatic undo management with temporary undo enabled.
    An UPDATE is executed on a temporary table.
    Where is the UNDO stored?
  • 1Z0-082 Exam Question 75

    Which is true about security rules on a compute node?