Online Access Free 1Z0-082 Practice Test

Which three statements are true about Deferred Segment Creation in Oracle databases?

• A.It is supported for SYS-owned tables contained in locally managed tablespaces.
• B.Sessions may dynamically switch back and forth from deferred to immediate segment creation.
• C.Indexes inherit the deferred or immediate segment creation attribute from their parent table
• D.It Is supported for Index Organized Tables (IOTs) contained in locally managed tablespaces.
• E.It Is the default behavior for tables and indexes.

Examine this description of the books table containing 100 rows:

Now examine this sequence of statements Issued In a new session;

Examine this description of the books table containing 100 rows:
Which three statements are true?

• A.The second rollback command restores the 100 rows that were in the table originally.
• B.The first rollback command leaves the inserted row locked.
• C.The second rollback command rolls back the rollback to savepoint a command.
• D.The second rollback command restores the row that was inserted.
• E.The first rollback command restores the 100 rows that were in the table originally.
• F.The first rollback command leaves the table's 100 original rows locked.
• G.The first RollBack command restores the row that was inserted.

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-03-06T12:15:17.183438+05:30
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.)

• A.Set AUTOEXTEND ON for data files in DATA
• B.Grant UNLIMITED TABLESPACE to U1
• C.Increase U1's quota sufficiently in DATA
• D.Drop other U1 objects in DATA
• E.Add a data file to DATA
• F.Set DEFERRED_SEGMENT_CREATION to TRUE

Which two statements are true about segment types in an Oracle Database?

• A.Cluster segments may contain data from multiple tables.
• B.Temporary segments are only stored in a temporary tablespace.
• C.Index segments always have two or more extents.
• D.Table segments always have two or more extents.
• E.Undo segments are only stored in an undo tablespace.

Examine the description of the employees table:

Which query requires explicit data type conversion?

• A.SELECT join_date FROM employees WHERE join_date > '10-02-2018';
• B.SELECT join_date I I ' ' II salary FROM employees;
• C.SELECT join_date + '20' FROM employees; SELECT salary * '120.50' FROM employees;
• D.SELECT SUBSTR<join_date, 1, 2) - 10 FROM employees;