1z0-082 Free Practice Test

Which two statements are true about space-saving features in an Oracle Database? (Choose two.)

1. A. Private Temporary Tables (PTTS) store metadata in memory only
2. B. An index created with the UNUSABLE attribute has no segment
3. C. If they exist for a session, Private Temporary Tables (PTTs) are always dropped at the next COMMIT OR ROLLBACK statement
4. D. An index that is altered to be UNUSABLE will retain its segment
5. E. A table that is truncated will always have its segment removed

Correct Answer: BC

Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

1. A. A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
2. B. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
3. C. GLOBAL TEMPORARY TABLE space allocation occurs at session start.
4. D. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
5. E. A GLOBAL TEMPORARY TABLE’S definition is available to multiple sessions.
6. F. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.

Correct Answer: BCF

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.)

1. A. Add a data file to DATA
2. B. Drop other U1 objects in DATA
3. C. Increase U1’s quota sufficiently in DATA
4. D. Set DEFERRED_SEGMENT_CREATION to TRUE
5. E. Grant UNLIMITED TABLESPACE to U1
6. F. Set AUTOEXTEND ON for data files in DATA

Correct Answer: CDF

Which three statements are true regarding indexes? (Choose three.)

1. A. A UNIQUE index can be altered to be non-unique
2. B. A SELECT statement can access one or more indices without accessing any tables
3. C. A table belonging to one user can have an index that belongs to a different user
4. D. An update to a table can result in updates to any or all of the table’s indexes
5. E. When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped
6. F. An update to a table can result in no updates to any of the table’s indexes

Correct Answer: ADE

Examine this command and some partial output:

Why does the DB01.abc.com service show unknown status?

1. A. The service DB01.abc.com is dynamically registered
2. B. The LOCAL_LISTENER database parameter is not set to a service name that refers to LISTENER_1
3. C. The service DB01.abc.com is statically registered
4. D. The listener is not listening on the default port 1521
5. E. The SID_LIST_LISTENER section is not contained in the LISTENER.ORA file

Correct Answer: B