What clause is in the ALTER TABLE command is used to reorganize a table? - The MOVE clause is used to reorganize a table. You can specify new tablespace and storage parameters. Queries are allowed on the table, but no DML operations are allowed during the move

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

ORACLE

DETAILS

Question: What clause is in the ALTER TABLE command is used to reorganize a table?

Answer: The MOVE clause is used to reorganize a table. You can specify new tablespace and storage parameters. Queries are allowed on the table, but no DML operations are allowed during the move

Category	Oracle Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.2) By 8273 users
Added on	7/7/2010
Views	68988
Rate it!

Question: What clause is in the ALTER TABLE command is used to reorganize a table?

Answer:

The MOVE clause is used to reorganize a table. You can specify new tablespace and storage parameters. Queries are allowed on the table, but no DML operations are allowed during the move Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	Which keyword is not valid of the BUFFER_POOL parameter of the STORAGE clause?	View Answer
	When validating a constraint, why would you specify the EXCEPTIONS clause?	View Answer
	A table is created with an INITRANS value of 2. Which value would you choose for INITRANS of an index created on this table?	View Answer
	Fill in the blank: The parameter MAXTRANS specifies the maximum number of concurrent transactions per ___________________.	View Answer
	How does Oracle determine the extent sizes for a temporary segment? A. From the initialization parameters B. From the tables involved in the sort operation C. Using the default storage parameters for the tablespace D. The database block size	View Answer
	Which of the following statements may require a temporary segment? a. CREATE TABLE b. CREATE INDEX c. UPDATE d. CREATE TABLESPACE	View Answer
	Which two initialization parameters are used by ORACLE to determine the number of rollback segments required for an instance? a. ROLLBACK_SEGMENTS b. TRANSACTIONS c. TRANSACTIONS_PER_ROLLBACK_SEGMENT d. PROCESSES	View Answer
	What can cause the Snapshot too old error?	View Answer
	What is row migration?	View Answer
	Which data dictionary view can be queried to see the OPTIMAL value for a rollback segment? A. DBA_ROLLBACK_SEGS B. V$ROLLSTAT C. DBA_SEGMENTS D. V$ROLLNAME	View Answer
	What is the default value of PCTFREE?	View Answer
	How can you fix the MAXEXTENTS reached error for a rollback segment?	View Answer
	What type of rollback segment is used if a tablespace containing an active transactions taken offline?	View Answer
	When does Oracle stop adding rows to a block?	View Answer
	Which portion of the data block stores information about the table having rows in this block?	View Answer
	What is the minimum number of extents a rollback segment can have?	View Answer
	Which data dictionary view would you query to see the free extents in a tablespace?	View Answer
	6. Choose the statement used to manually de-allocate the extents used by a rollback segment. A. ALTER ROLLBACK SEGMENT R01 DEALLOCATE; B. ALTER ROLLBACK SEGMENT RO1 DROP EXTENTS; C. ALTER ROLLBACK SEGMENT RO1 SHRINK; D. ALTER ROLLBACK SEGMENT RO1 SIZE 10K.	View Answer
	5. Which storage parameter is applicable only to rollback segments? A. PCTINCREASE B. MAXEXTENTS C. TRANASACTIONS D. None of the above.	View Answer
	What happens if you create a rollback segment in the same tablespace where application data is stored? Choose the best answer. A. The tablespace will be fragmented. B. Performance improves, because when changes are made, undo information can be written to the same tablespace. C. There should be a minimum of two data files associated with the tablespaces when rollback segments are created. D. None of the above is true.	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All Oracle Interview Questions & Answers - Exam Mode / Learning Mode