Free 1Z0-182 sample questions

Correct answer: `SNAPSHOT COPY`

The `SNAPSHOT COPY` clause allows for the creation of a PDB clone while the source PDB remains online in read-write mode. This is possible if the underlying storage system supports storage snapshots. If snapshots are not supported, the source PDB must be in read-only mode for the duration of the clone. The other options are not valid clauses for this purpose.

Correct answer: `DIRECT=TRUE`

The `DIRECT=TRUE` option enables a direct path load in SQL*Loader. This method bypasses much of the SQL command processing and the database buffer cache, writing formatted data blocks directly to the datafiles. This is significantly faster for large data loads than the default conventional path load, which uses standard `INSERT` statements.

Correct answer: False

The statement is false. Temporary undo, which is generated for temporary tables, is stored in the temporary tablespace, not in a dedicated temporary undo tablespace. This improves performance by reducing the amount of redo generated for temporary data modifications.

Correct answers: Set the `RESUMABLE_TIMEOUT` initialization parameter.; Issue the `ALTER SESSION ENABLE RESUMABLE;` command within the session.

Correct answer: `SEGMENT SPACE MANAGEMENT AUTO`

The requirement describes the behavior of Automatic Segment Space Management (ASSM), which is enabled by creating the table in a tablespace with `SEGMENT SPACE MANAGEMENT AUTO`. ASSM uses bitmaps to manage free space, allowing space from `DELETE` operations to be reused much more efficiently and immediately without relying on the legacy `PCTUSED` parameter. In ASSM tablespaces, `PCTUSED` is ignored. Setting `PCTFREE 0` would pack blocks tightly but wouldn't guarantee immediate reuse of deleted space.

Correct answer: Data Files

Data files are the physical files on disk that store the actual data of all logical structures such as tables and indexes. Control files contain metadata about the database structure. Redo log files record all changes made to the database for recovery purposes. Parameter files store initialization parameters for the instance.

Correct answer: Easy Connect

The Easy Connect naming method allows clients to connect to an Oracle database without any configuration files. The connection string is provided directly in the format `hostname:port/service_name`. This is ideal for simple environments or when avoiding client-side configuration files like `tnsnames.ora` is a priority. Local Naming requires `tnsnames.ora`, and Directory Naming uses an LDAP directory.

Correct answers: Enable or disable archive log mode.; Perform a full database recovery.

Correct answer: Issue a `ROLLBACK` command.

Since the transaction has not been committed, the changes only exist in the current session's transaction state and are recorded in the undo segments. Issuing a `ROLLBACK` command will use the information in the undo segments to reverse the changes and end the transaction. This is the simplest and most efficient method for uncommitted changes. Flashback and RMAN are used for committed changes or more severe data corruption.

Correct answer: A local user, created while connected to the application's PDB.

In a multitenant environment, a local user is a user that exists only within a specific PDB. This is the correct choice for managing an application that should be isolated to its PDB. A common user (whose name must start with C## or c##) is created in the root container (CDB$ROOT) and exists across all PDBs, which violates the isolation requirement. Application common users are for application containers, and external users are for directory-based authentication.