Answered step by step
Verified Expert Solution
Question
1 Approved Answer
QUESTION 1 Automatic segment space management on th tablespace causes which of the following table attribtes in that tablespace to be ignored? A . The
QUESTION
Automatic segment space management on th tablespace causes which of the following table attribtes in that tablespace to be ignored?
A
The whole storage clause
B
NEXT and PCTINCREASE
C
BUFFERPOOL and FREEPOOL
D
PCTFREE and PCTUSED
points
QUESTION
Choose the statement that is not resumable.
A
ALTER TABLE SPLIT PARTITION
B
SELECT
C
INSERT INTO SELECT
D
CREATE TABLESPACE
points
QUESTION
How would you drop a tablespace if the tablespace were not empty?
A
Rename all the objects in the tablespace, and then drop the tablespace.
B
Remove the data files belonging to the tablespace from the disk.
C
Use ALTER DATABASE DROP CASCADE;
D
Use DROP TABLESPACE INCLUDING CONTENTS;
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started