Became a Gold Member and access 40+ Technology Courses...
Live Help (Start Chat)
Interview Questions and Answer
Options:
a. 8kb
b. 6kb
c. 7kb
d. 10kb
Reveal Answer
Options:
a. 180 pages
b. 248 pages
c. 140 pages
d. 128 pages
Reveal Answer
Options:
a. Each page begins with a 196-byte header that is used to store system information about the page.
b. page header has information about the page number, page type, the amount of free space on the page, and the allocation unit ID of the object that owns the page.
c. Every time data changes in the table, all the indexes need to be updated
d. Use of indexes fastens Data modification operations, such as insert, update, delete.
Reveal Answer
Options:
a. Basic tree structure
b. Balance tree structure
c. Business tree structure
d. Binary tree structure
Reveal Answer
Options:
a. Heap structures
b. Non cluster index
c. Cluster index
d. None
Reveal Answer
Options:
a. Root node
b. Intermediate nodes
c. Leaf nodes
d. Heap
Reveal Answer
Options:
a. More than one cluster indexes can be created
b. When indexes are created the b-tree structure for each index occupies disk space
c. Columns other than the non cluster key can also be included in the leaf node of the non cluster index
d. Creating many indexes fastens the DML actions
Reveal Answer
Options:
a. Clustered
b. Unique
c. Spatial
d. Filtered
e. All the above
Reveal Answer
Options:
a. Heap in an unordered table
b. The rows are inserted in either ascending or descending order
c. Heap is made entirely of data pages .
d. B-tree is created for heap
Reveal Answer
Options:
a. The percentage of space on each leaf level data page to be reserved as free space for future growth
b. The percentage of space on each leaf level data page to be filled with data
c. The fill factor is not related to indexes or data pages so it does not effect the occupancy or free space of the data pages
d. None of the above
Reveal Answer
Options:
a. 20 percent of each leaf -level page will be left empty
b. 80 percent of each leaf -level page will be left empty
c. 20 percent of each leaf -level page will be occupied with data
d. 80 percent of each leaf -level page will be occupied with data
Reveal Answer
Bestdotnet google plus