최신 1Z0-082 무료덤프 - Oracle Database Administration I

A. after successfully executing a truncate statement followed by a DML statement

B. after successfully executing a commit or rollback followed by a select statement

C. after successfully executing a commit or rollback followed by a DML statement

D. after successfully executing a DML statement following a failed DML statement

E. after successfully executing a create table statement followed by a create index statement

F. after successfully executing a create table as select statement followed by a select for update statement

A. DML modifies Oracle database objects and only generates UNDO

B. DML modifies Oracle database objects and only generates REDO

C. The generation of UNDO generates REDO

D. The generation of REDO generates UNDO

E. DML modifies Oracle database objects and generates UNDO and REDO

A. Undo segments can extend when a transaction fills the last extent of the undo segment

B. Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment

C. An undo segment may be used by multiple transactions simultaneously

D. Undo segments have a minimum of three extents

E. A single transaction may use multiple undo segments simultaneously

F. Undo segments must be stored in a BIGFILE tablespace

G. Undo segments must be stored in a SMALLFILE tablespace

A. The sales user must have a quota on the SALES_Q1 tablespace to hold the initial extends of all tables they plan to create in their schema

B. The sales user must have a quota on the SALES_Q1 tablespace to hold all the rows to be inserted into any table in their schema

C. The sales user must have been granted the CREATE SESSION privilege

D. The sales user must have a quota on the TEMP tablespace

E. The sales user must have been granted the CREATE TABLE privilege

F. The sales user must have their quota on the users tablespace removed

A. the ability to prevent a password from ever being reused

B. the number of hours for which an account is locked after the configured number of login attempts has been reached

C. the number of password changes required within a period of time before a password can be reused

D. the number of days for which an account may be inactive before it is locked

E. the maximum amount of CPU time allowed for a user's sessions before their account is locked

F. the maximum number of sessions permitted for a user before the account is locked

G. the number of days for which an account is locked after the configured number of login attempts has been reached

A. A SAVEPOINT does not issue a COMMIT

B. Rolling back to a SAVEPOINT can undo a CREATE INDEX statement

C. Rolling back to a SAVEPOINT can undo a DELETE statement

D. Rolling back to a SAVEPOINT can undo a TRUNCATE statement

E. Only one SAVEPOINT may be issued in a transaction

A. A segment might have only one extent

B. A smallfile tablespace might be bigger than a bigfile tablespace

C. All tablespaces may have one or more data files

D. Segments can span multiple tablespaces

E. A segment can span multiple data files in some tablespaces

F. A segment's blocks can be of different sizes

G. The extents of a segment must always reside in the same datafile

A. The value is changed for the current instance and in the PFILE

B. The value is changed only in the PFILE and takes effect at the next instance startup

C. Change is applied to the current instance, but does not persist after instance restart

D. It fails because the SCOPE clause is missing

A. A SQL statement may have multiple single row subquery blocks.

B. They can be used in the having clause.

C. They can be used in the where clause.

D. They must be placed on the left side of the comparison operator or condition.

E. They must be placed on the right side of the comparison operator or condition.

F. They must return a row to prevent errors in the SQL statement.

A. in the temporary tablespace

B. in the SYSAUX tablespace

C. in the SGA

D. in the undo tablespace

E. in the PGA