1Z0-082 Exam Question 16

Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)
  • 1Z0-082 Exam Question 17

    Examine these commands:

    Which two statements are true about the sqlldr execution? (Choose two.)
  • 1Z0-082 Exam Question 18

    Which three statements are true about inner and outer joins? (Choose three.)
  • 1Z0-082 Exam Question 19

    The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User U1 has a 1 MB quota in tablespace DATA.
    U1 executes this command:
    SQL> CREATE TABLE t1 AS
    (SELECT object_name, sharing, created
    FROM dba_objects);
    U1 complains that the command is taking too long to execute.
    In the alert log, the database administrator (DBA) finds this:
    2017/3/6 14:45:17
    statement in resumable session 'User U1(136), Session 1, Instance 1' was suspended due to ORA-01536: space quota exceeded for tablespace 'DATA' Which are three actions any one of which the DBA could take to resume the session? (Choose three.)
  • 1Z0-082 Exam Question 20

    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?