1Z0-082 Managing Schemas and Database Objects

Question 1

Which SQL statement is used to create a new table in an Oracle schema?

Accepted Answer

CREATE TABLE

Answer

The CREATE TABLE statement is the standard DDL command used to define and create a new table in an Oracle schema.

Question 2

What is the primary purpose of a sequence object in Oracle Database?

Accepted Answer

To generate unique numeric values automatically

Answer

A sequence is a schema object that automatically generates unique sequential integers, commonly used to populate primary key columns.

Question 3

Which Oracle object type stores a precompiled SQL SELECT statement and can be queried like a table?

Accepted Answer

View

Answer

A view stores a named SQL SELECT statement in the data dictionary and presents it as a virtual table that users can query.

Question 4

How does TRUNCATE TABLE differ from DELETE without a WHERE clause in Oracle?

Accepted Answer

TRUNCATE removes all rows quickly without generating undo and cannot be rolled back

Answer

TRUNCATE is a DDL operation that removes all rows instantly, generates minimal undo, and commits immediately, making it irreversible without Flashback.

Question 5

Which system privilege allows a user to create tables within their own schema?

Accepted Answer

CREATE TABLE

Answer

The CREATE TABLE system privilege grants a user the ability to create tables in their own schema only, unlike CREATE ANY TABLE which spans all schemas.

1Z0-082 - Oracle Database Administration I Practice Test

1Z0-082 - Oracle Database Administration I Practice Test

1Z0-082 Managing Schemas and Database Objects