Oracle 1Z0-182 Quiz 1 Topic 1 Questions 1-5

Question: 1

Which two statements are true about the UNLIMITED TABLESPACE system privilege and space quota?

AIt allows a user to have unlimited space in any tablespace in the database.

BIt is overridden by a space quota specified for the user.

CIt allows a user to have unlimited space only in their default permanent tablespace.

DIt allows a role to have unlimited space in any tablespace in the database.

EBy default, users have no quota on their default permanent tablespace.

Show Answer

Question: 2

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

AIt is supported for Index Organized Tables (IOTs) contained in locally managed tablespaces.

BIt is supported for SYS-owned tables contained in locally managed tablespaces.

CIt is the default behavior for tables and indexes.

DIndexes inherit the DEFERRED or IMMEDIATE segment creation attribute from their parent table.

ESessions may dynamically switch back and forth from DEFERRED to IMMEDIATE segment creation.

Show Answer

Question: 3

Which four statements are true about the Oracle Server architecture?

AA person or program can have more than one session with an instance by logging in with different users.

BThe buffer cache and the redo log buffer are held in the large pool.

CA session represents the state of a user's login to an instance.

DEach server process or background process has their own Program Global Area (PGA).

EA connection represents the state of a user's login to an instance.

FA person or program can have more than one session with an instance by logging in with the same user.

Show Answer

Question: 4

Script abc.sql must be executed to perform a certain task. User HR with password HR exists in the target database and the account is unlocked. The TNSNAMES.ORA file is up to date. Examine this command attempted by the user: $ sqlplus hr/hr@orcl @abc. What will happen and why?

AThe command succeeds and HR will be connected to the orcl database and after logging out to the abc database.

BThe command fails because the script must refer to the full path name.

CThe command fails and reports an error because @ is used twice.

DThe command succeeds and HR will be connected to the orcl database instance, and the abc script will be executed.

EThe command succeeds and HR will be connected to the orcl database instance, and the abc script will be executed.

Show Answer

Question: 5

Which two are benefits of external tables?

AThey support DELETEs, which transparently deletes records in the file system as if they were table rows.

BThey can be queried while the database is in the MOUNT state like dynamic performance views.

CThey support UPDATEs, which transparently updates records in the file system as if they were table rows.

DThey can be queried, transformed, and joined with other tables without having to load the data first.

EThe results of a complex join or aggregating function or both can be unloaded to a file for transportation to other systems.

Show Answer

Oracle 1Z0-182 Quiz:1 Topic:1 Questions:1-5