Top 350+ Solved Information Retrival Techniques MCQ Questions Answer
Q. Which of the following is used to access large objects from a database ?
a. setblob()
b. getblob()
c. getclob()
d. all of the mentioned
Q. Which of the following is not a source used in Mid Infrared Spectrophotometer?
a. nernst glower
b. high pressure mercury arc lamp
c. globar
d. nichrome wire
Q. Which of the following is the wave number of near infrared spectrometer?
a. 4000 – 200 cm-1
b. 200 – 10 cm-1
c. 12500 – 4000 cm-1
d. 50 – 1000 cm-1
Q. Which of the following options are correct in terms of wavelength for the different types of IR spectrometer?
a. near ir: 0.8 – 2.5 mm
b. mid ir: 0.8 – 2.5 mm
c. far ir: 2.5 – 50 mm
d. mid ir: 50 – 100 mm
Q. Which of the following is not a composition of Nernst glower or Nernst filament?
a. oxides of zirconium
b. oxides of barium
c. oxides of yitrium
d. oxides of thorium
Q. What is the composition of Globar rod which is used as a source in Mid IR spectroscopy?
a. silicon carbide
b. silver chloride
c. silicon dioxide
d. silver carbide
Q. Bolometer, a type of detector, is also known as
a. resistance temperature detector (rtd)
b. thermistor
c. thermocouple
d. golay cell
Q. Which of the following is not a technique for preparing solid samples in IR spectroscopy?
a. solids run in solution
b. mull technique
c. solid films
d. thin films
Q. Which of the following is not used as pyroelectric material used in pyroelectric transducers in Infrared spectroscopy?
a. triglycine sulphate
b. deutrated triglycine sulphate
c. some polymers
d. tetraglycine sulphate
Q. Which of the following is the simplest ranking function?
a. rank
b. ntile
c. row_number
d. none of the mentioned
Q. Which of the clause is not mandatory?
a. over clause
b. order by clause
c. partition by clause
d. all of the mentioned
Q. Point out the wrong statement.
a. rank() returns the rank of each row in the result set of partitioned column
b. dense_rank() is same as rank() function. only difference is returns rank without gaps
c. ntile() distributes the columns in an ordered partition into a specified number of groups
d. row_number() returns the serial number of the row order by specified column
Q. Which of the function provides consecutive numbering except in the case of a tie?
a. rank
b. ntile
c. row_number
d. none of the mentioned
Q. Which of the following will not raise error if not used?
a. over clause
b. order by clause
c. partition by clause
d. all of the mentioned
Q. Which of the following error message will be displayed if ORDER CLAUSE is not mentioned in ROW NUMBER function?
a. “the ranking function “row_number” must have an order by clause.”
b. “the ranking function “row_number” must have an over by clause.”
c. “the ranking function “row_number” must have an partition by clause.”
d. all of the mentioned