51 the database feature that allows data analysis similar to statistical cross tabul 4307278

51 the database feature that allows data analysis similar to statistical cross tabul 4307278

51.The database feature that allows data analysis similar to statistical cross-tabulation is:

  1.                             query.
  2.                            OLAP.
  3.                             filtering.
  4.                            data mining.

52.The duties of the DBA fall into all of the following major areas except for:

  1.                             database planning.
  2.                            performance statistics processor.
  3.                             database implementation.
  4.                            database security.

53.The advantages of DBMSs include all of the following except for:

  1.                             reduce data redundancy.
  2.                            achieve data independence.
  3.                             improve security.
  4.                            reduce hardware costs.

54.Which of the following is a disadvantage of DBMSs?

  1.                             obtain a large hardware configuration
  2.                            data redundancy
  3.                             data dependence
  4.                            more security risks

55.Which of the following is not a major area for the database administrator?

  1.                             planning
  2.                            programming
  3.                             implementation
  4.                            security

56.The database administrator’s role of offering educational programs to database users and providing assistance when needed falls into which major area?

  1.                             planning
  2.                            implementation
  3.                             operation
  4.                            security

57.Which statement is false concerning database programmers?

  1.                             Database programmers are specialists.
  2.                            Database programmers often write code to strip and/or aggregate data from a database.
  3.                             The consequences of a programming error could be felt by a very large number of users.
  4.                            Database programmers are often hired as entry-level programmers.

58.Which statement is false concerning database end users?

  1.                             End users need to know how to code SQL statements.
  2.                            End users generate forms and reports.
  3.                             End users ask questions using query-by-example.
  4.                            There can be an increase in end-user errors because the database is easy to use.

59.Which of the following is not an advantage of using a database management system?

  1.                             Reduce data redundancy.
  2.                            Achieve data dependence.
  3.                             Retrieve data and information rapidly.
  4.                            Improve security.

60.Which of the following disadvantages of using a database management system becomes less important with each passing year?

  1.                             the amount of computer resources increases with more users
  2.                            obtaining a large hardware configuration
  3.                             obtaining expensive software

"Get 15% discount on your first 3 orders with us"
Use the following coupon
"FIRST15"

Order Now

Related Posts