Oracle Exam 1Z0-771 Topic 3 Question 8 Discussion

Object Browser in SQL Workshop is a GUI for managing schema objects:

B . Browse database objects of the current schema: Displays tables, views, procedures, etc., in a tree view, allowing inspection of definitions (e.g., columns, constraints) and data previews.

D . Create a lookup table based on a column in the current table: From a table's column (e.g., DEPTNO), you can generate a lookup table (e.g., DEPT_LOOKUP) with unique values, automating reference table creation.

A . Restore dropped objects: Not supported; this requires DBA tools (e.g., FLASHBACK TABLE).

C . Create and run SQL scripts: This is a SQL Scripts feature, not Object Browser.

Practical tip: Use 'Create Lookup Table' to normalize data efficiently.