Information Retrival Techniques Set 8

Computer Science Engineering (CSE)

Practice Mode Previous Next
On This Page

This set of Information Retrival Techniques Multiple Choice Questions & Answers (MCQs) focuses on Information Retrival Techniques Set 8

Q1 | In ordered indices the file containing the records is sequentially ordered, a                         is an index whose search key also defines the sequential order of the file.
  • clustered index
  • structured index
  • unstructured index
  • nonclustered index
Answer: clustered index
Explaination:
clustering index are also called primary indices; the term primary index may appear to denote an index on a primary key, but
Q2 | Indices whose search key specifies an order different from the sequential order of the file are called                        indices.
  • nonclustered
  • secondary
  • all of the mentioned
  • none of the mentioned
Answer: all of the mentioned
Explaination:
nonclustering index is also called secondary indices.
Q3 | An                           consists of a search-key value and pointers to one or more records with that value as their search-key value.
  • index entry
  • index hash
  • index cluster
  • index map
Answer: index entry
Explaination:
the pointer to a record consists of the identifier of a disk block and an offset within the disk block to identify the record within the block.
Q4 | In a                 clustering index, the index record contains the search-key value and a pointer to the first data record with that search- key value and the rest of the records will be in the sequential pointers.
  • dense
  • sparse
  • straight
  • continuous
Answer: dense
Explaination:
in a dense nonclustering index, the index must store a list of pointers to all records with the same search-key value.
Q5 | Incase the indices values are larger, index is created for these values of the index. This is called
  • pointed index
  • sequential index
  • multilevel index
  • multiple index
Answer: multilevel index
Explaination:
indices with two or more levels are called multilevel indices.
Q6 | A search key containing more than one attribute is referred to as a                     search key.
  • simple
  • composite
  • compound
  • secondary
Answer: composite
Explaination:
the structure of the index is the same as that of any other index, the only difference being that the search key is not a single attribute, but rather is a list of attributes.
Q7 | In B+ tree the node which points to another node is called
  • leaf node
  • external node
  • final node
  • internal node
Answer: internal node
Explaination:
nonleaf nodes are also referred to as internal nodes.
Q8 | appears for only some of the search-key values.
  • dense
  • sparse
  • straight
  • continuous
Answer: dense
Explaination:
sparse indices can be used only if
Q9 | return index;
  • o(nlogn)
  • o(logn)
  • o(n)
  • o(1)
Answer: o(n)
Explaination:
worst case is when the desired
Q10 | }
  • requires more space
  • greater time complexities compared to other searching algorithms
  • not easy to understand
  • not easy to implement
Answer: greater time complexities compared to other searching algorithms
Explaination:
the complexity of linear search as the name suggests is o(n) which is much
Q11 | OLAP stands for
  • online analytical processing
  • online analysis processing
  • online transaction processing
  • online aggregate processing
Answer: online analytical processing
Explaination:
olap is the manipulation of information to support decision making.
Q12 |                data.
  • multidimensional
  • singledimensional
  • measured
  • dimensional
Answer: multidimensional
Explaination:
given a relation used for data analysis, we can identify some of its attributes
Q13 | The generalization of cross-tab which is represented visually is                           which is also called as data cube.
  • two dimensional cube
  • multidimensional cube
  • n-dimensional cube
  • cuboid
Answer: two dimensional cube
Explaination:
each cell in the cube is identified for the values for the three dimensional attributes.
Q14 | The process of viewing the cross-tab (Single dimensional) with a fixed value of one attribute is
  • slicing
  • dicing
  • pivoting
  • both slicing and dicing
Answer: slicing
Explaination:
the slice operation selects one particular dimension from a given cube and provides a new sub-cube. dice selects two or more dimensions from a given cube and provides a new sub-cube.
Q15 | The operation of moving from finer- granularity data to a coarser granularity (by means of aggregation) is called a                  
  • rollup
  • drill down
  • dicing
  • pivoting
Answer: rollup
Explaination:
the opposite operation—that of moving fromcoarser-granularity data to finer- granularity data—is called a drill down.
Q16 | In SQL the cross-tabs are created using
  • slice
  • dice
  • pivot
  • all of the mentioned
Answer: slice
Explaination:
pivot (sum(quantity) for color in (’dark’,’pastel’,’white’)).
Q17 | This can be achieved by using which of the following ?
  • group by rollup
  • group by cubic
  • group by
  • none of the mentioned
Answer: none of the mentioned
Explaination:
‘group by cube’ is used .
Q18 | What do data warehouses support?
  • olap
  • oltp
  • olap and oltp
  • operational databases
Answer: olap
Explaination:
none. 9.
Q19 | How many grouping is possible in this rollup?
  • 8
  • 4
  • 2
  • 1
Answer: 4
Explaination:
{ (item name, color, clothes size), (item name, color), (item name), () }.
Q20 | Which one of the following is the right syntax for DECODE?
  • decode (search, expression, result [, search, result]… [, default])
  • decode (expression, result [, search, result]… [, default], search)
  • decode (search, result [, search, result]… [, default], expression)
  • decode (expression, search, result [, search, result]… [, default])
Answer: decode (expression, search, result [, search, result]… [, default])
Explaination:
none.
Q21 | A piece of icon or image on a web page associated with another webpage is called
  • url
  • hyperlink
  • plugin
  • extension
Answer: hyperlink
Explaination:
urls are locators for resources present on the world wide web. a plugin provides extra functionality to the webpage. an extension provides modification allowance for the core functionality of a webpage. hyperlink is piece of icon or image on a web page associated with another webpage.
Q22 | Dynamic web page              
  • is same every time whenever it displays
  • generates on demand by a program or a request from browser
  • both is same every time whenever it displays and generates on demand by a program or a request from browser
  • is different always in a predefined order
Answer: generates on demand by a program or a request from browser
Explaination:
a dynamic web page provides different content every time the user opens it based on some events like new additions or time of the day. languages such as javascript are used to respond to client-side events while languages such as php as used to respond to server-side events.
Q23 | What is a web browser?
  • a program that can display a web page
  • a program used to view html documents
  • it enables user to access the resources of internet
  • all of the mentioned
Answer: all of the mentioned
Explaination:
a web browser is an application program that is used to access the world wide web resources, applications and websites. some examples of web browsers are google chrome, internet explorer and safari.
Q24 | Common gateway interface is used to
  • generate executable files from web content by web server
  • generate web pages
  • stream videos
  • download media files
Answer: generate executable files from web content by web server
Explaination:
cgi is an interface through servers can run execute console-based executable files on a web server that generates dynamic web pages. a cgi script executes only when a request is made. the script then generates html.
Q25 | URL stands for                  
  • unique reference label
  • uniform reference label
  • uniform resource locator
  • unique resource locator
Answer: uniform resource locator
Explaination:
the uniform resource locator is a locator for the resource to be located by http on the world wide web. the url is derived from the uniform resource identifier.
Previous Next