CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions
Our Services
Get 9,000 Interview Questions & Answers in an eBook.




Get it now !!
Send your Resume to 6000 Companies

Search Interview Questions

Question: A table is created with an INITRANS value of 2. Which value would you choose for INITRANS of an index created on this table?

Answer: Since index blocks hold more entries per block than table data blocks hold, you should provide a higher value of INITRANS to the index than the table.



Category Oracle Interview Questions & Answers - Exam Mode / Learning Mode
Rating (0.6) By 532 users
Added on 7/7/2010
Views 5112
Rate it!
Question: A table is created with an INITRANS value of 2. Which value would you choose for INITRANS of an index created on this table?
Answer:

Since index blocks hold more entries per block than table data blocks hold, you should provide a higher value of INITRANS to the index than the table. 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.

Post your answer here

Inform me about updated answers to this question.
Related Questions
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
Which parameter specifies the number of transaction slots in a data block?
View Answer
When a table is updated, where is the before image information (which can be used for undoing the changes) stored?
View Answer
Place the following logical storage structures in order-from the smallest logical storage unit to the largest.
A. Segment
B. Block
C. Tablespace
D. Extent
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




India News Network
Latest 20 Questions
Payment of time- barred debt is: (a) Valid (b) Void (c) Illegal (d) Voidable
Consideration is defined in the Indian Contract Act,1872 in: (a) Section 2(f) (b) Section 2(e) (c) Section 2(g) (d) Section 2(d)
Which of the following is not an exception to the rule, "No consideration, No contract": (a) Natural love and affection (b) Compensation for involuntary services (c) Completed gift (d) Agency
Consideration must move at the desire of: (a) The promisor (b) The promisee (c) The promisor or any other party (d) Both the promisor and the promisee
An offer which is open for acceptance over a period of time is: (a) Cross Offer (b) Counter Offer (c) Standing Offer (d) Implied Offer
Specific offer can be communicated to__________ (a) All the parties of contract (b) General public in universe (c) Specific person (d) None of the above
_________ amounts to rejection of the original offer. (a) Cross offer (b) Special offer (c) Standing offer (d) Counter offer
A advertises to sell his old car by advertising in a newspaper. This offer is caleed: (a) General Offer (b) Special Offer (c) Continuing Offer (d) None of the above
In case a counter offer is made, the original offer stands: (a) Rejected (b) Accepted automatically (c) Accepted subject to certain modifications and variations (d) None of the above
In case of unenforceable contract having some technical defect, parties (a) Can sue upon it (b) Cannot sue upon it (c) Should consider it to be illegal (d) None of the above
If entire specified goods is perished before entering into contract of sale, the contract is (a) Valid (b) Void (c) Voidable (d) Cancelled
______________ contracts are also caled contracts with executed consideration. (a) Unilateral (b) Completed (c) Bilateral (d) Executory
A offers B to supply books @ Rs 100 each but B accepts the same with condition of 10% discount. This is a case of (a) Counter Offer (b) Cross Offer (c) Specific Offer (d) General Offer
_____________ is a game of chance. (a) Conditional Contract (b) Contingent Contract (c) Wagering Contract (d) Quasi Contract
There is no binding contract in case of _______ as one's offer cannot be constructed as acceptance (a) Cross Offer (b) Standing Offer (c) Counter Offer (d) Special Offer
An offer is made with an intention to have negotiation from other party. This type of offer is: (a) Invitation to offer (b) Valid offer (c) Voidable (d) None of the above
When an offer is made to the world at large, it is ____________ offer. (a) Counter (b) Special (c) General (d) None of the above
Implied contract even if not in writing or express words is perfectly _______________ if all the conditions are satisfied:- (a) Void (b) Voidable (c) Valid (d) Illegal
A specific offer can be accepted by ___________. (a) Any person (b) Any friend to offeror (c) The person to whom it is made (d) Any friend of offeree
An agreement toput a fire on a person's car is a ______: (a) Legal (b) Voidable (c) Valid (d) Illegal
Cache = 0.65625 Seconds