1Z0-082 Managing Schemas and Database Objects 2

Question 1

Which data dictionary view shows all tables accessible to the current user, including those in other schemas?

Accepted Answer

ALL_TABLES

Answer

ALL_TABLES shows all tables that the current user has privileges to access, including their own and those granted by other schemas.

Question 2

What is the primary purpose of a database trigger in Oracle?

Accepted Answer

To automatically execute PL/SQL code in response to a DML or DDL event

Answer

A trigger is a stored PL/SQL block that fires automatically when a specified DML (INSERT, UPDATE, DELETE) or DDL event occurs on a table or schema.

Question 3

Which DDL command is used to modify an existing column's data type or add a new column to a table?

Accepted Answer

ALTER TABLE

Answer

The ALTER TABLE statement is used to modify existing table structure, including adding, modifying, or dropping columns and constraints.

Question 4

What is a materialized view in Oracle Database?

Accepted Answer

A physical copy of query results stored as a table and refreshable on demand or schedule

Answer

A materialized view physically stores the results of a query and can be refreshed either on demand or automatically on a schedule to reflect source data changes.

Question 5

When a table is dropped using the DROP TABLE command in Oracle, where does it go by default?

Accepted Answer

It is moved to the Recycle Bin

Answer

By default in Oracle 10g and later, dropped tables are moved to the Recycle Bin and can be recovered using the FLASHBACK TABLE ... TO BEFORE DROP statement.

1Z0-082 - Oracle Database Administration I Practice Test

1Z0-082 - Oracle Database Administration I Practice Test

1Z0-082 Managing Schemas and Database Objects 2