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

MAKE TABLE

Answer

BUILD TABLE

Answer

NEW TABLE

Question 2

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

Accepted Answer

To generate unique numeric values automatically

Answer

To store binary data

Answer

To define referential integrity

Answer

To cache query results

Question 3

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

Accepted Answer

View

Answer

Trigger

Answer

Sequence

Answer

Index

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 fires row-level triggers; DELETE does not

Answer

TRUNCATE is DML; DELETE is DDL

Answer

TRUNCATE requires a WHERE clause

Question 5

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

Accepted Answer

CREATE TABLE

Answer

CREATE ANY TABLE

Answer

ALTER TABLE

Answer

INSERT ANY TABLE

Question 6

What is a synonym in Oracle Database?

Accepted Answer

An alias for another schema object

Answer

A backup copy of a table

Answer

A type of index

Answer

A stored procedure template