RelationalDBDesign
Technology
Search
SiteMap
RedhatLinuxSys
Seomining
Advanced Oracle Tuning
Advanced SQL
Backup Recovery Options
Basic SQL
DB Admin Features
DB Creation Architecture
Extended DB Features
Managing DB Objects
Managing Connectivity
Network Configuration
Oracle BU Features
Oracle DB Recovery
Network Administration
Oracle Network Topology
Oracle SQL Extensions
Oracle SQL Tuning
8i PL/SQL Programming
Performance Tuning
PL/SQL Stored Objects
PL/SQL Programming
Relational DB Analysis
Relational DB Design
Tech Interview Questions
Tuning Oracle Instance
Managing DB Objects
Oracle Space Management
Managing Oracle Tables
Managing Oracle Constraints
Oracle Indexes
Altering and dropping tables - Quiz
Each question is worth one point. Select the best answer for each question.
1.
Which action cannot be done using the
ALTER TABLE
command?
Please select the best answer.
A.
Add a column to a table
B.
Drop a column from a table
C.
Rename a table
D.
Change the storage characteristics of a table
2.
When you
DROP
a table, you actually delete:
Please select the best answer.
A.
Just the table structure
B.
The table structure and the data it contains
C.
Just the data contained in the table
D.
The table structure, the data the table contains, and the indexes, constraints, and triggers associated with the table
3.
How does dropping a table affect other database objects?
Please select the best answer.
A.
Dropping a table never affects other database objects.
B.
Dropping a table can affect other database objects.
C.
Dropping a table can affect other database objects, but Oracle lets you know in advance.
D.
You cannot drop a table in Oracle 8.
Score =
Correct answers:
Explanation
