Information Retrival Techniques Set 3

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 3

Q1 | In 1-to-4 multiplexer, if C1 = 1 & C2 = 1, then the output will be                          
  • y0
  • y1
  • y2
  • y3
Answer: y3
Explaination:
it can be calculated from the figure shown below:
Q2 | How many select lines are required for a 1- to-8 demultiplexer?
  • 2
  • 3
  • 4
  • 5
Answer: 3
Explaination:
the formula for total no. of outputs is given by 2n, where n is the no. of select lines. in this case n = 3 since 23 = 8.
Q3 | How many AND gates are required for a 1- to-8 multiplexer?
  • 2
  • 6
  • 8
  • 5
Answer: 8
Explaination:
the number of and gates required will be equal to the number of outputs
Q4 | Which function is used to return a handle to the database?
  • preparedatabase()
  • showdoccount()
  • executesql()
  • opendatabase()
Answer: preparedatabase()
Explaination:
preparedatabase() function is used to return a handle to database. it is necessary to first create the database. showdoccount() shows the real work after creating the database. syntax of calling a javascript function is: function preparedatabase(ready, error).
Q5 | openDatabase() method does not take the argument in                      
  • database name
  • display name
  • database version
  • server name
Answer: server name
Explaination:
opendatabase() and opendatabasesync() methods takes the name of the database, version of the database, display name, estimated size in bytes of the data that is to be stored in the database. opendtabase() method works on workerutils and window, opendatabasesync() method works on workerutils.
Q6 | d) IC 74138
  • &
  • *
  • ^
  • ?
Answer: ?
Explaination:
‘?’ is used for the placeholder. binding of the ? placeholder is done at a literal
Q7 | Which feature is not used when SQL features are not being supported?
  • begin
  • end
  • commit
  • rollback
Answer: end
Explaination:
when sql feature is not supported then we use commit, begin, rollback sql features and are marked as bogus. user agent uses the statements that contain these three words in case of failure of the support of sql features.
Q8 | transaction() does not take the argument
  • callback
  • success callback
  • error callback
  • database name
Answer: database name
Explaination:
transction() and readtransaction() are the two methods that take three arguments
Q9 | Which method is used to verifythe version number?
  • changeversion()
  • readtransaction()
  • transaction()
  • executesql()
Answer: changeversion()
Explaination:
changeversion() method automatically verify version number and it also changes it like doing a schema update. when
Q10 | Which object is created for read-only transaction?
  • foo object
  • sqltransactionsync
  • databasesync object
  • sqltransaction
Answer: sqltransactionsync
Explaination:
for read-only transaction, we create the object sqltransactionsync. if the first argument is null then we throw sqlexception which is error code 0.
Q11 | insertId attribute returns                          
  • column id
  • row id
  • user’s id
  • database id
Answer: row id
Explaination:
insertid attribute returns the row id of the row of the inserted sqlresultset object’s sql statement that is inserted into the database. if multiple rows are inserted then the id of the last row will be returned. if there is no row then invalid_access_err exception will be raised.
Q12 | Which error is invoked when SQLTransactionCallback does not execute?
  • insertiid
  • rows
  • rowsaffected
  • length
Answer: rowsaffected
Explaination:
rowsaffected attribute returns the
Q13 | Which of the error is raised when the quantity of data is too much?
  • too_large_err
  • unknown_err
  • timeout_err
  • quota_err
Answer: too_large_err
Explaination:
when the quantity of the data returned from the database is very large then too_large_err is invoked. to minimize the data we can use sql “limit” i.e. modifier to reduce the size of the resultant set.
Q14 | What is the required argument to openDatabase?
  • version number
  • database name
  • size of a database
  • text description
Answer: version number
Explaination:
the required argument to opendatabase is version number. so it is mandatory that you should know the version number before we try to open the database. if we do not pass this argument then an exception is thrown.
Q15 | Which attribute is used for getting an individual row?
  • results.rows.item(i)
  • insertid
  • rowaffected
  • length
Answer: results.rows.item(i)
Explaination:
for getting individual row results.rows.item(i) is used, i denotes the index of the row. it will return the object representation of the row. insertid returns row id but in case of multiple rows, it returns the id of the last row.
Q16 | 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.
Q17 | Which of the following adds marginal sums to an existing table?
  • par()
  • prop.table()
  • addmargins()
  • quantile()
Answer: prop.table()
Explaination:
prop.table() computes proportions from a contingency table.
Q18 | Which of the following lists names of variables in a data.frame?
  • quantile()
  • names()
  • barchart()
  • par()
Answer: quantile()
Explaination:
names function is used to associate name with the value in the vector.
Q19 | Which of the following is tool for chi-square distributions?
  • pchisq()
  • chisq()
  • pnorm
  • barchart()
Answer: pnorm
Explaination:
pnorm() is tool for normal distributions.
Q20 | Which of the following groups values of a variable into larger bins?
  • cut
  • col.max(x)
  • stem
  • which.max(x)
Answer: cut
Explaination:
stem() is used to make a stemplot.
Q21 | Which of the following determine the least- squares regression line?
  • histo()
  • lm
  • barlm()
  • col.max(x)
Answer: lm
Explaination:
lm calls the lower level functions lm.fit.
Q22 | Which of the following is tool for checking normality?
  • qqline()
  • qline()
  • anova()
  • lm()
Answer: qqline()
Explaination:
qqnorm is another tool for checking normality.
Q23 | Which of the following is lattice command for producing boxplots?
  • plot()
  • bwplot()
  • xyplot()
  • barlm()
Answer: bwplot()
Explaination:
the function bwplot() makes box-and-whisker plots for numerical variables.
Q24 | Which of the following compute analysis of variance table for fitted model?
  • ecdf()
  • cum()
  • anova()
  • bwplot()
Answer: anova()
Explaination:
ecdf() builds empirical cumulative distribution function.
Q25 | Which of the following is used to find variance of all values?
  • var()
  • sd()
  • mean()
  • anova()
Answer: var()
Explaination:
sd() is used to calculate standard deviation.
Previous Next