Information Retrival Techniques Set 10

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 10

Q1 | Point out the wrong statement.
  • the row_number function simply assigns sequential numbering to the records of a result-set or to the records within groups of a result-set
  • over clause is not required in all the ranking functions
  • sql server introduced four different ranking functions
  • all of the mentioned
Answer: over clause is not required in all the ranking functions
Explaination:
over clause is required in all the ranking functions and with that you specify the partitioning and ordering of records before the ranking functions are evaluated.
Q2 | Which of the following is the simplest ranking function?
  • rank
  • ntile
  • row_number
  • none of the mentioned
Answer: row_number
Explaination:
the row_number ranking function is the simplest of the ranking functions.its purpose in life is to provide consecutive numbering of the rows in the result set by the order selected in the over clause for each partition specified in the over clause.
Q3 | Which of the clause is not mandatory?
  • over clause
  • order by clause
  • partition by clause
  • all of the mentioned
Answer: partition by clause
Explaination:
partition by clause is not mandatory and if you don’t specify it all the records of the result-set will be considered as a part of single record group.
Q4 | Point out the wrong statement.
  • rank() returns the rank of each row in the result set of partitioned column
  • dense_rank() is same as rank() function. only difference is returns rank without gaps
  • ntile() distributes the columns in an ordered partition into a specified number of groups
  • row_number() returns the serial number of the row order by specified column
Answer: ntile() distributes the columns in an ordered partition into a specified number of groups
Explaination:
ntile divides the partitioned result set into specified number of groups in an order.
Q5 | Which of the function provides consecutive numbering except in the case of a tie?
  • rank
  • ntile
  • row_number
  • none of the mentioned
Answer: rank
Explaination:
rank function is used when you want all tied rows to have the same ranking.
Q6 | Which of the following will not raise error if not used?
  • over clause
  • order by clause
  • partition by clause
  • all of the mentioned
Answer: partition by clause
Explaination:
partition by clause is not mandatory and when you specify a column/set of columns with partition by clause then it will divide the result-set into record groups/partitions.
Q7 | Which of the following error message will be displayed if ORDER CLAUSE is not mentioned in ROW NUMBER function?
  • “the ranking function “row_number” must have an order by clause.”
  • “the ranking function “row_number” must have an over by clause.”
  • “the ranking function “row_number” must have an partition by clause.”
  • all of the mentioned
Answer: “the ranking function “row_number” must have an order by clause.”
Explaination:
order by clause is not optional clause in row number function.
Q8 | Which of the following functions are similar?
  • rank and ntile
  • rank and dense_rank
  • dense_rank and ntile
  • none of the mentioned
Answer: rank and dense_rank
Explaination:
dense_rank() is same as rank() function. only difference is returns rank without gaps.
Q9 | Which of the following function is used when you want all tied rows to have the same ranking?
  • rank
  • ntile
  • row_number
  • none of the mentioned
Answer: rank
Explaination:
the numbers assigned by rank are not necessarily consecutive.
Q10 | TOPIC 4.8 LEARNING TO RANK
  • place the user in control
  • reduce the user’s memory load
  • make the interface consistent
  • all of the mentioned
Answer: all of the mentioned
Explaination:
these golden rules actually form the basis for a set of user interface design principles that guide this important software design activity.
Q11 | Which of the following is not a design principle that allow the user to maintain control?
  • provide for flexible interaction
  • allow user interaction to be interrupt-able and undo-able
  • show technical internals from the casual user
  • design for direct interaction with objects that appear on the screen
Answer: show technical internals from the casual user
Explaination:
the user interface should move the user into the virtual world of the application.
Q12 | Which of the following is not a user interface design process?
  • user, task, and environment analysis and modeling
  • interface design
  • knowledgeable, frequent users
  • interface validation
Answer: knowledgeable, frequent users
Explaination:
these are the end user for whom the product is being built.
Q13 | Which of the following option is not considered by the Interface design?
  • the design of interfaces between software components
  • the design of interfaces between the software and human producers and consumers of information
  • the design of the interface between two computers
  • all of the mentioned
Answer: the design of the interface between two computers
Explaination:
none
Q14 | What incorporates data, architectural, interface, and procedural representations of the software?
  • design model
  • user’s model
  • mental image
  • system image
Answer: design model
Explaination:
the requirements specification may establish certain constraints that help to define the user of the system, but the interface design is often only incidental to the design model.
Q15 | What establishes the profile of end-users of the system?
  • design model
  • user’s model
  • mental image
  • system image
Answer: user’s model
Explaination:
to build an effective user
Q16 | What combines the outward manifestation of the computer-based system , coupled with all supporting information that describe system syntax and semantics?
  • mental image
  • interface design
  • system image
  • interface validation
Answer: system image
Explaination:
when the system image and the system perception are coincident, users generally feel comfortable with the software and use it effectively.
Q17 | A Rendering engine is not responsible for
  • parsing the markup content (html)
  • parsing style information (css, xsl, and so on)
  • generating a visual presentation of the formatted content including media files referenced
  • parsing style information (css only)
Answer: parsing style information (css only)
Explaination:
a rendering engine is a software that draws text and images on the screen. the engine draws structured text from a document (html, xml) and formats it properly based on the given style declarations (css, xsl, etc). the primary job of a browser engine is to transform html documents and other resources of a web page into an interactive visual representation on a user’s device.
Q18 | Firefox uses                    rendering engine.
  • webkit
  • gecko
  • trident
  • presto
Answer: gecko
Explaination:
gecko is a web browser engine
Q19 | What is the use of “defer” attribute?
  • it defers rendering of html page
  • it defers script execution until the page has been rendered
  • it defers rendering of css attributes
  • it is only for internal scripts
Answer: it defers script execution until the page has been rendered
Explaination:
the defer attribute is a boolean attribute. the script is executed after the page has finished parsing. the defer attribute is used if and only if there is src attribute. defer is for external not internal scripts.
Q20 | Which of the following statements is false?
  • async and defer attributes of script tag execute before the domcontentloaded event
  • defer executes each script sequentially
  • async executes each script when it is ready
  • all older browsers supports async attribute
Answer: all older browsers supports async attribute
Explaination:
in async attribute, the script is executed asynchronously with the rest of the page (the script will be executed while the page continues the parsing). defer, the boolean attribute is set to indicate to a browser that the script is meant to be executed after the document has been parsed, but before firing
Q21 | Which of the following is used to read a HTML page and render it?
  • web browser
  • web server
  • web matrix
  • web network
Answer: web browser
Explaination:
a web browser (commonly referred to as a browser) is a software application for retrieving, presenting and traversing information resources on the world wide web. a web server process, store and display output to client as per their request. web matrix is a discontinued cloud-connected website builder and html editor for windows.
Q22 | Which of the following is the first web browser?
  • nexus
  • netscape navigator
  • internet explorer
  • mosaic
Answer: nexus
Explaination:
the first web browser was invented in 1990 called world wide web which was later renamed to nexus. in 1995, a graphical web browser named internet explorer was developed. the netscape is a web browser produced by netscape communications. ncsa mosaic, or mosaic, is the web browser which in turn popularized world wide web.
Q23 | Who created the first web browser
  • tim berners lee
  • jacobs, lan
  • marc andeersen
  • mozilla foundation
Answer: tim berners lee
Explaination:
sir timothy john “tim” berners- lee, also known as timbl, is an english computer scientist, best known as the inventor of the world wide web. he made a proposal for an information management system in march 1989, and he implemented the first successful communication between a hypertext transfer protocol (http) client and server via the
Q24 | The open source software version of netscape is                    
  • chrome
  • mozilla
  • internet explorer
  • erwise
Answer: mozilla
Explaination:
on february 23, 1998, netscape communications corporation created a project called mozilla to co-ordinate the development of the mozilla application suite, the open source version of netscape’s internet software, netscape communicator.
Q25 | What is the main task of a problem-solving agent?
  • solve the given problem and reach to goal
  • to find out which sequence of action will get it to the goal state
  • all of the mentioned
  • none of the mentioned
Answer: all of the mentioned
Explaination:
the problem-solving agents are one of the goal-based agents.
Previous Next