Data Entry, Query and Reporting MCQ

Test your knowledge with important Data Entry, Query and Reporting MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30+ more Data Entry, Query and Reporting MCQs on Bissoy. Bissoy App

• Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = ‘VA’;
  ক

  SELECT NAME IN CUSTOMER WHERE STATE IN (‘VA’);

  খ

  SELECT NAME IN CUSTOMER WHERE STATE = ‘VA’;

  গ

  SELECT NAME IN CUSTOMER WHERE STATE = ‘V’;

  ঘ

  SELECT NAME FROM CUSTOMER WHERE STATE IN (‘VA’);
• The benefits of a standard relational language include which of the following ?
  ক

  Reduced training costs

  খ

  Increased dependence on a single vendor

  গ

  Applications are not needed

  ঘ

  All of the Mentioned
• The wildcard in a WHERE clause is useful when?
  ক

  An exact match is necessary in a SELECT statement

  খ

  An exact match is not possible in a SELECT statement

  গ

  An exact match is necessary in a CREATE statement

  ঘ

  An exact match is not possible in a CREATE statement
• Each answer below shows example data from a table. Which answer is an example of the general-purpose remarks column problem?
  ক

  Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row

  খ

  Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column

  গ

  Three rows have the values Brown, NULL, and Blue in the same column

  ঘ

  One row has the value “He is interested in a Silver Porsche from the years 1978-1988” in a column
• Business Intelligence (BI) reporting systems cannot do which of the following operations?
  ক

  Filter data

  খ

  Group data

  গ

  Modify data

  ঘ

  Both filter and group data
• A report generated by a reporting system is delivered to the appropriate users via a user-accessed Web site. This system uses which of the following report modes?
  ক

  Push

  খ

  Pull

  গ

  RFM

  ঘ

  OLAP
• The “curse of dimensionality” relates to which problem of using operational data for BI reporting?
  ক

  Dirty data

  খ

  Inconsistent data

  গ

  Too much data

  ঘ

  Non-integrated data
• A BI reporting system does not _____________
  ক

  Create meaningful information

  খ

  Deliver information to users on a timely basis

  গ

  Use statistical procedures to predict future events

  ঘ

  Use disparate data sources