1Z0-082 Managing Schemas and Database Objects 1 — Questions and Answers
Question 1: Which SQL statement is used to create a new table in an Oracle schema?
- CREATE TABLE (Correct answer)
- MAKE TABLE
- BUILD TABLE
- NEW TABLE
Correct answer: CREATE TABLE
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?
- To store binary data
- To generate unique numeric values automatically (Correct answer)
- To define referential integrity
- To cache query results
Correct answer: To generate unique numeric values automatically
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?
- Trigger
- Sequence
- View (Correct answer)
- Index
Correct answer: View
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?
- TRUNCATE fires row-level triggers; DELETE does not
- TRUNCATE is DML; DELETE is DDL
- TRUNCATE removes all rows quickly without generating undo and cannot be rolled back (Correct answer)
- TRUNCATE requires a WHERE clause
Correct answer: TRUNCATE removes all rows quickly without generating undo and cannot be rolled back
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?
- CREATE ANY TABLE
- CREATE TABLE (Correct answer)
- ALTER TABLE
- INSERT ANY TABLE
Correct answer: CREATE TABLE
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.
Question 6: What is a synonym in Oracle Database?
- A backup copy of a table
- An alias for another schema object (Correct answer)
- A type of index
- A stored procedure template
Correct answer: An alias for another schema object
A synonym is an alias that points to another database object such as a table, view, or procedure, simplifying object references across schemas.
1Z0-082 Managing Schemas and Database Objects 1
Which SQL statement is used to create a new table in an Oracle schema?