Managing Schemas and Database Objects Flashcards
6 cards from real 1Z0-082 practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 Managing Schemas and Database Objects flashcards as text
Which SQL statement is used to create a new table in an Oracle schema?
Answer: CREATE TABLE
The CREATE TABLE statement is the standard DDL command used to define and create a new table in an Oracle schema.
What is the primary purpose of a sequence object in Oracle Database?
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.
Which Oracle object type stores a precompiled SQL SELECT statement and can be queried like a table?
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.
How does TRUNCATE TABLE differ from DELETE without a WHERE clause in Oracle?
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.
Which system privilege allows a user to create tables within their own schema?
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.
What is a synonym in Oracle Database?
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.