View Count: 0
Duration: 15 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 24 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 19 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 14 mins
Accessed date:
Not Yet Viewed
Post your comment / feedback here
 
 

Be the first one to comment about this video

Sorry!For this module there is no Sample Code.
Sorry!For this module there is no Assignments.
Question No: 1 of 20
The size of data page in sql server is 
Options:
  1. 8kb
  2. 6kb
  3. 7kb
  4. 10kb
View Answer/Explanation:
a
Explanation:

Question No: 2 of 20
How many pages does sql server database have per megabyte? 
Options:
  1. 180 pages
  2. 248 pages
  3. 140 pages
  4. 128 pages
View Answer/Explanation:
d
Explanation:

Question No: 3 of 20
Which statements are true regarding data pages 
Options:
  1. Each page begins with a 196-byte header that is used to store system information about the page.
  2. 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.
  3. Every time data changes in the table, all the indexes need to be updated
  4. Use of indexes fastens Data modification operations, such as insert, update, delete.
View Answer/Explanation:
b c
Explanation:

Question No: 4 of 20
What does 'B-tree structure' mean? 
Options:
  1. Basic tree structure
  2. Balance tree structure
  3. Business tree structure
  4. Binary tree structure
View Answer/Explanation:
b
Explanation:

Question No: 5 of 20
In which of these structures are the data pages put in the leaf node? 
Options:
  1. Heap structures
  2. Non cluster index
  3. Cluster index
  4. None
View Answer/Explanation:
b
Explanation:

Question No: 6 of 20
If there is only one non cluster index and no cluster index then the index will refer to 
Options:
  1. Heap
  2. Non cluster index
  3. Clustered index
  4. None
View Answer/Explanation:
a
Explanation:

Question No: 7 of 20
In heap the data pages are linked to each other and the rows are inserted in a particular order based on a key. 
Options:
  1. TRUE
  2. FALSE
View Answer/Explanation:
b
Explanation:

Question No: 8 of 20
In cluster index the data pages are in the 
Options:
  1. Root node
  2. Intermediate nodes
  3. Leaf nodes
  4. Heap
View Answer/Explanation:
c
Explanation:

Question No: 9 of 20
Cluster index can be on only one column. It is not allowed on composite columns. 
Options:
  1. TRUE
  2. FALSE
View Answer/Explanation:
b
Explanation:

Question No: 10 of 20
By default Cluster index is formed on column where _________________ constraint is given. 
Options:
  1. Unique
  2. Check
  3. Primary Key
  4. Foreign key
View Answer/Explanation:
c
Explanation:

  1