Download Calicut University M.Com Latest 2020 IT Applications in Commerce Question Bank

Download UOC (University of Calicut) M.Com (Master of Commerce) IT Applications in Commerce Question Bank (Important Questions)

This post was last modified on 26 December 2019

Download Document

This download link is referred from the post: Calicut University M.Com 2020 Important Questions (Question Bank) || (University of Calicut)

FirstRanker.com

IT APPLICATION IN COMMERCE

Which of the following is NOT an objective of MIS?
1. Facilitate the decisions-making process
2. Provide requisite information at each level of management
3. Support decision-making
4. Recruit people for system
In MIS system design, the sources of information may be categorized as ............ and ............
1. Internal, external
2. Personal, organizational
3. Useful, unuseful
4. Constructive, destructive
What among the following are the primary characteristics that information must process?
1. i) Relevance
2. ii) Availability
3. iii) Timeliness
4. iv) Accuracy
1. Only i, ii, and iii
2. Only ii, iii and iv
3. Only i, iii and iv
4. All i, ii, iii, and iv
Which of the following models are developed on the principles of business management, accounting and econometrics?
1. Behavioral model
2. Management science models
3. Operations research models
4. Policy making models
An ............ is a set of processes and procedures that transform data into information and knowledge.
1. Information system
2. Knowledge system
3. Database system
4. Computer system
A system is called ............ when the inputs, process and the outputs are known with certainty.
1. Probablistics
2. Deterministic
3. Open
4. Close
Which of the following steps is/are the implementation plans involved in MIS?
1. i) Preparing organizational plans
2. ii) Planning of work flow
3. iii) Training of personnel
4. iv) Development of software
5. v) Acquiring computer hardware
1. i, ii and iii only
2. i, ii, iii and iv only
3. i, ii, iv and v only
4. All i, ii, iii, iv and v
Which of the following is included in the Office automation systems?
1. i) Word processing
2. ii) Electronic mail
3. iii) Voice mail
4. iv) Electronic calendaring
5. v) Audio conferencing
1. i, ii, iii and v only
2. i, ii, iii and iv only
3. i, ii, iv and v only
4. All i, ii, iii, iv and v
In a typical ............ network, application processing is shared between clients and one more servers.
1. Client server computing
2. Cloud computing
3. Mobile computing
4. Data computing
The ............ is defined as a set of activities performed across the organization creating as output of value to the customer.
1. Development process
2. Business process
3. Quality process
4. Customer focus
The different types of decisions while decision making in MIS are
1. i) Programmed decisions
2. ii) Programmable decisions
3. iii) Semi Programmed decisions
4. iv) Non Programmed decisions
1. Only i, ii, and iii
2. Only ii, iii and iv
3. Only i, iii and iv
4. All i, ii, iii, and iv
Which of the following statements are the disadvantages of Expert System?
1. i) They cannot handle inconsistent knowledge
2. ii) They cannot apply judgement and intuition recognized as important ingredients of problem solving.
1. Only i
2. Only ii
3. Both i and ii
4. None
Which of the following system ensures that proper stock of each items are maintained in an organization?
1. Human resource information system
2. An inventory control system
3. Manufacturing information system
4. Marketing information system
Which of the following is a program that models the pattern recognition capabilities of the human brain.
1. An expert system
2. Artificial Intelligence
3. Neutral network
4. Development engine
Which of the following are the main software components of DSS?
1. i) database management system (DBMS)
2. ii) model management system
3. iii) support tools
4. iv) internet
1. Only i, ii, and iii
2. Only ii, iii and iv
3. Only i, iii and iv
4. All i, ii, iii, and iv
Which of the following are the inputs of Marketing Information System?
1. i) Marketing research data
2. ii) Marketing intelligence data
3. iii) External environment data
4. iv) Strategic plan
1. Only i, ii, and iii
2. Only ii, iii and iv
3. Only i, iii and iv
4. All i, ii, iii, and iv
............ is the process of defining the current problem, determining why a new system is needed, identifying the objectives of the proposed system.
1. Feasibility analysis
2. System Analysis
3. System definition
4. System requirements
The accounting system is ............ whereas the demand forecasting system is ............
1. Deterministic, probabilistic
2. Probabilistic, deterministic
3. Open, close
4. Close, open
How many ways you can save a document?
1. 3
2. 4
3. 2
4. 1
Except for the ...... function, a formula with a logical function shows the word "TRUE" or "FALSE" as a result
1. IF
2. AND
3. OR
4. NOT
Macros are "run" or executed from the ...... menu.
1. Insert
2. Format
3. Tools
4. Data
Each excel file is called a workbook because
1. It can contain text and data
2. It can be modified
3. It can contain many sheets including worksheets and chart sheets
4. You have to work hard to create it
How are data organized in a spreadsheet?
1. Lines and spaces
2. Layers and planes
3. Rows and columns
4. Height and width
Which function calculates your monthly mortgage payment?
1. PMT (payments)
2. NPER (number of periods)
3. PV (present value)
4. All of above
What term refers to a specific set of values saved with the workbook?
1. Range
2. Scenario
3. Trend line
4. What-if analysis
A features that displays only the data in column (s) according to specified criteria
1. Formula
2. Sorting
3. Filtering
4. Pivot
Material Requirement Planning(MRP) utilizes software applications for scheduling
1. Sales management.
2. Production processes.
3. Marketing techniques.
4. Human resource management
ERP package will handle business functionalities.
1. One.
2. Two.
3. Three.
4. All
An enterprise is a group of people with .
1. Common goal.
2. Separate goal for each department.
3. Multiple goals.
4. Two or more goals
ERP package will handle business functionalities.
1. One.
2. Two.
3. Three.
4. All.
The most important step of ERP implementation is phase.
1. Installing.
2. Training.
3. Gap analysis.
4. Testing.
The data warehouse archives contain of significant, continuing interest and value to the enterprise.
1. New data.
2. Current data.
3. Old data.
4. Meta data.
over see the day-to-day operations of respective functional areas during ERP implementation.
1. Consultant.
2. Package vendor.
3. End users.
4. Functional managers.
Data mining is a powerful new technology to from large databases.
1. Extraction of hidden predictive information.
2. Generating reports.
3. Retrieving data.
4. Show result.
The total number of rows in a workbook.
1. 98000
2. 105000
3. 1048576
4. 1048570
The language used in application programs to request data from the DBMS is referred to as the
1. DML
2. DDL
3. VDL
4. SDL
The DBMS language component which can be embedded in a program is
1. The data definition language (DDL)
2. The data manipulation language(DML)
3. The database administrator(DBA)
4. A query language.
Which one of the following statement is false?
1. The data dictionary is normally maintained by the database administrator.
2. Data elements in the database can be modified by changing the data dictionary.
3. The data dictionary contains the name and description of each data element.
4. The data dictionary is a tool used exclusively by the database administrator.
An advantage of the database management approach is
1. Data is dependent on programs.
2. Data redundancy increase.
3. Data is integrated and can be accessed by multiple programs.
4. None of the above.
Which type of database stores data in two - dimensional tables?
1. Network
2. Hierarchical
3. Table
4. Relational
The DBMS language component which can be embedded in a program is
1. The data definition language (DDL).
2. The data manipulation language (DML).
3. The database administrator (DBA).
4. A query language.
A relational database developer refers to a record as
1. A criteria.
2. A relation.
3. A tuple.
4. An attribute.
Architecture of the database can be viewed as
1. Two levels.
2. Four levels.
3. Three levels.
4. One level.
....... keyword is used to find the number of values in a column.
1. TOTAL
2. COUNT
3. ADD
4. SUM
An advantage of the database management approach is
1. Data is dependent on programs
2. Data redundancy increases
3. Data is integrated and can be accessed by multiple programs
4. None of the above
The collection of information stored in a database at a particular moment is called as
1. Schema
2. Instance of the database
3. Data domain
4. Independence
Data independence means
1. Data is defined separately and not included in programs.
2. Programs are not dependent on the physical attributes of data
3. Programs are not dependent on the logical attributes of data
4. Both B and C
A is used to define overall design of the database
1. Schema
2. Application program
3. Data definition language
4. Code
Key to represent relationship between tables is called
1. Primary key
2. Secondary key
3. Foreign key
4. None of the above
A computer program that contains expertise in a particular domain is called an:
1. Intelligent planner
2. Automatic processor
3. Expert system
4. Operational symbolizer

Answers:

D) Recruit people for system
A) Internal, external