Statement 1: Insertion of record might require the change in position of the initial nodes.Statement 2: Deletion of records might require the change in position of the initial nodes.

tStatement 1 is true but statement 2 is false

tStatement 2 is true but statement 1 is false

Explore topic-wise MCQs in Rdbms.

This section includes 3 Mcqs, each offering curated multiple-choice questions to sharpen your Rdbms knowledge and support exam preparation. Choose a topic below to get started.

1.	___________ are the indices that store the values of some attributes along with the pointers to the recor.
A.	tBinary indices
B.	tCovering indices
C.	tKey indices
D.	tStatic indices
Answer» C. tKey indices

Discussion

2.	Insertion of a large number of entries at a time into an index is referred to as _______ of the index.
A.	tBulk loading
B.	tMass insertion
C.	tQuick insertion
D.	tQuick loading
Answer» B. tMass insertion

Discussion

3.	Statement 1: Insertion of record might require the change in position of the initial nodes. Statement 2: Deletion of records might require the change in position of the initial nodes.
A.	tBoth the statements are true
B.	tStatement 1 is true but statement 2 is false
C.	tStatement 2 is true but statement 1 is false
D.	tBoth the statements are false
Answer» B. tStatement 1 is true but statement 2 is false

Discussion

Explore topic-wise MCQs in Rdbms.

___________ are the indices that store the values of some attributes along with the pointers to the recor.

Insertion of a large number of entries at a time into an index is referred to as _______ of the index.

Statement 1: Insertion of record might require the change in position of the initial nodes.Statement 2: Deletion of records might require the change in position of the initial nodes.

Statement 1: Insertion of record might require the change in position of the initial nodes.
Statement 2: Deletion of records might require the change in position of the initial nodes.