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)

IT APPLICATION
IN COMMERCE
l. Which of the following is NOT an objective of MIS?
A) Facilitate the decisions-making
process
B) Provide requisite information
at each rever of management
C) Support decision-makingD)
recruit people for system
2' In MIS system design, the sources of information
may be categorized
as...............
and
A) internal, externalB) personal,
organizational
C) usefu l, unusefu lD) constructive,
destructive
3' what among the following
are the primary characteristics
that information
must process?
i) Relevance
ii) Availability
iii) Timeliness
iv) Accuracy
A) Only i, ii, and iii
B) Only ii, iii and iv
C) Only i, iii and iv
D) All i, ii, iii, and iv
4' which of the following
models are developed on the principles
of business management,
accounting
and econometrics?
A) Behavioral
modelB) Management
science models
C) Operations research
modelsD)
policy
making models
5' An
"""""
is a set of processes
and procedures
that transform
data into information
and
knowledge.
A) information
systemB)
Knowledgq
systenl
C) Database systemD)
Computer
system
6' A system is called
"
when the inputs, process
and the outputs are known with cerlainty.
A) Probabl isticsB)
Deterministic
C) OpenD) Close
7. which of the foilowing
steps is/are the imprementation
prans invorved
in MIS?
i) Preparing
organizational
plansii)
planning
of work flow
iii) Training
of personneliv)
Development
of software
v) Acquiring
computer
hardware
A) i, iiand iiionly
B) i, ii, iiiand iv only
FirstRanker.com - FirstRanker's Choice
IT APPLICATION
IN COMMERCE
l. Which of the following is NOT an objective of MIS?
A) Facilitate the decisions-making
process
B) Provide requisite information
at each rever of management
C) Support decision-makingD)
recruit people for system
2' In MIS system design, the sources of information
may be categorized
as...............
and
A) internal, externalB) personal,
organizational
C) usefu l, unusefu lD) constructive,
destructive
3' what among the following
are the primary characteristics
that information
must process?
i) Relevance
ii) Availability
iii) Timeliness
iv) Accuracy
A) Only i, ii, and iii
B) Only ii, iii and iv
C) Only i, iii and iv
D) All i, ii, iii, and iv
4' which of the following
models are developed on the principles
of business management,
accounting
and econometrics?
A) Behavioral
modelB) Management
science models
C) Operations research
modelsD)
policy
making models
5' An
"""""
is a set of processes
and procedures
that transform
data into information
and
knowledge.
A) information
systemB)
Knowledgq
systenl
C) Database systemD)
Computer
system
6' A system is called
"
when the inputs, process
and the outputs are known with cerlainty.
A) Probabl isticsB)
Deterministic
C) OpenD) Close
7. which of the foilowing
steps is/are the imprementation
prans invorved
in MIS?
i) Preparing
organizational
plansii)
planning
of work flow
iii) Training
of personneliv)
Development
of software
v) Acquiring
computer
hardware
A) i, iiand iiionly
B) i, ii, iiiand iv only
C) i, ii, iv and v only
D) All i, ii, iii, iv and v
8. Which of the following is included in the Office automation systems?
i) Word processing
ii) Electronic mail
iii) Voice mailiv) Electronic calendaring
v) Audio conferencing
A) i, ii, iii and v only
B) i, ii, iii and iv only
C) i, ii, iv and v only
D) All i, ii, iii, iv and v
9. In a typical ..........:..... network, application processing is shared between clients and one more servers.
A) client server computingB) cloud computing
C) mobile computingD) data computing
I 0. The is defined as a set of activities performed across the organization creating as output
of value to the customer.
A) development processB) business process
C) quality processD) customer focus
I l.The different types of decisions while decision making in MIS are
i) Programmed decisions ii) Programmable decisions
iii) Semi Programmed decisions iv) Non
programmed
decisions
A) Only i, ii, and iii
B) Only ii, iiiand iv
C) Only i, iiiand iv
D) All i, ii, iii, and iv
12. which of the following statements are the disadvantages of Expert System?
i) They cannot handle inconsistent knowledge
ii) They cannot apply judgement
and intuition recognized as important ingredients of problem solving.
A) Only i
B) Only ii
C) Both i and ii
D) None
FirstRanker.com - FirstRanker's Choice
IT APPLICATION
IN COMMERCE
l. Which of the following is NOT an objective of MIS?
A) Facilitate the decisions-making
process
B) Provide requisite information
at each rever of management
C) Support decision-makingD)
recruit people for system
2' In MIS system design, the sources of information
may be categorized
as...............
and
A) internal, externalB) personal,
organizational
C) usefu l, unusefu lD) constructive,
destructive
3' what among the following
are the primary characteristics
that information
must process?
i) Relevance
ii) Availability
iii) Timeliness
iv) Accuracy
A) Only i, ii, and iii
B) Only ii, iii and iv
C) Only i, iii and iv
D) All i, ii, iii, and iv
4' which of the following
models are developed on the principles
of business management,
accounting
and econometrics?
A) Behavioral
modelB) Management
science models
C) Operations research
modelsD)
policy
making models
5' An
"""""
is a set of processes
and procedures
that transform
data into information
and
knowledge.
A) information
systemB)
Knowledgq
systenl
C) Database systemD)
Computer
system
6' A system is called
"
when the inputs, process
and the outputs are known with cerlainty.
A) Probabl isticsB)
Deterministic
C) OpenD) Close
7. which of the foilowing
steps is/are the imprementation
prans invorved
in MIS?
i) Preparing
organizational
plansii)
planning
of work flow
iii) Training
of personneliv)
Development
of software
v) Acquiring
computer
hardware
A) i, iiand iiionly
B) i, ii, iiiand iv only
C) i, ii, iv and v only
D) All i, ii, iii, iv and v
8. Which of the following is included in the Office automation systems?
i) Word processing
ii) Electronic mail
iii) Voice mailiv) Electronic calendaring
v) Audio conferencing
A) i, ii, iii and v only
B) i, ii, iii and iv only
C) i, ii, iv and v only
D) All i, ii, iii, iv and v
9. In a typical ..........:..... network, application processing is shared between clients and one more servers.
A) client server computingB) cloud computing
C) mobile computingD) data computing
I 0. The is defined as a set of activities performed across the organization creating as output
of value to the customer.
A) development processB) business process
C) quality processD) customer focus
I l.The different types of decisions while decision making in MIS are
i) Programmed decisions ii) Programmable decisions
iii) Semi Programmed decisions iv) Non
programmed
decisions
A) Only i, ii, and iii
B) Only ii, iiiand iv
C) Only i, iiiand iv
D) All i, ii, iii, and iv
12. which of the following statements are the disadvantages of Expert System?
i) They cannot handle inconsistent knowledge
ii) They cannot apply judgement
and intuition recognized as important ingredients of problem solving.
A) Only i
B) Only ii
C) Both i and ii
D) None
13. Which of the following system ensures that proper stock of each items are maintained in an
organization?
A) Human resource information system
B) An inventory control system
C) Manufacturing information system
D) Marketing information system
14. Which of the following is a program that models the pattern recognition capabilities of the human
brain.
A) An expert system
C) Neutral nefwork
15. Which of the following are the main software components of DSS?
A) Only i, ii, and iii
B) Only ii, iii and iv
C) Only i, iiiand iv
D) All i, ii, iii, and iv
I 6. Which of the following are the inputs of Marketing Information System?
i) database management system (DBMS)
iii) support tools
i) Marketing researih data
iii) External environment data
B) Artificial Intelligence
D) Development engine
ii) model management system
iv) internet
ii) Marketing intelligence data
iv) Strategic plan
A) Only i, ii, and iii
B) Only ii, iii and iv
C) Only i, iiiand iv
D) All i, ii, iii, and iv
17. ............,. is the process of defining the current problem, determining why a new system is
needed, identifying the objectives of the proposed system.
A) Feasibility analysis
B) System Analysis
C) System definition
D) System requirement
18. The accounting system is .................. whereas the demand forecasting system is .................
A) determ inistic, probabi listic B) probabi I istic, deterministic
-
r-
FirstRanker.com - FirstRanker's Choice
IT APPLICATION
IN COMMERCE
l. Which of the following is NOT an objective of MIS?
A) Facilitate the decisions-making
process
B) Provide requisite information
at each rever of management
C) Support decision-makingD)
recruit people for system
2' In MIS system design, the sources of information
may be categorized
as...............
and
A) internal, externalB) personal,
organizational
C) usefu l, unusefu lD) constructive,
destructive
3' what among the following
are the primary characteristics
that information
must process?
i) Relevance
ii) Availability
iii) Timeliness
iv) Accuracy
A) Only i, ii, and iii
B) Only ii, iii and iv
C) Only i, iii and iv
D) All i, ii, iii, and iv
4' which of the following
models are developed on the principles
of business management,
accounting
and econometrics?
A) Behavioral
modelB) Management
science models
C) Operations research
modelsD)
policy
making models
5' An
"""""
is a set of processes
and procedures
that transform
data into information
and
knowledge.
A) information
systemB)
Knowledgq
systenl
C) Database systemD)
Computer
system
6' A system is called
"
when the inputs, process
and the outputs are known with cerlainty.
A) Probabl isticsB)
Deterministic
C) OpenD) Close
7. which of the foilowing
steps is/are the imprementation
prans invorved
in MIS?
i) Preparing
organizational
plansii)
planning
of work flow
iii) Training
of personneliv)
Development
of software
v) Acquiring
computer
hardware
A) i, iiand iiionly
B) i, ii, iiiand iv only
C) i, ii, iv and v only
D) All i, ii, iii, iv and v
8. Which of the following is included in the Office automation systems?
i) Word processing
ii) Electronic mail
iii) Voice mailiv) Electronic calendaring
v) Audio conferencing
A) i, ii, iii and v only
B) i, ii, iii and iv only
C) i, ii, iv and v only
D) All i, ii, iii, iv and v
9. In a typical ..........:..... network, application processing is shared between clients and one more servers.
A) client server computingB) cloud computing
C) mobile computingD) data computing
I 0. The is defined as a set of activities performed across the organization creating as output
of value to the customer.
A) development processB) business process
C) quality processD) customer focus
I l.The different types of decisions while decision making in MIS are
i) Programmed decisions ii) Programmable decisions
iii) Semi Programmed decisions iv) Non
programmed
decisions
A) Only i, ii, and iii
B) Only ii, iiiand iv
C) Only i, iiiand iv
D) All i, ii, iii, and iv
12. which of the following statements are the disadvantages of Expert System?
i) They cannot handle inconsistent knowledge
ii) They cannot apply judgement
and intuition recognized as important ingredients of problem solving.
A) Only i
B) Only ii
C) Both i and ii
D) None
13. Which of the following system ensures that proper stock of each items are maintained in an
organization?
A) Human resource information system
B) An inventory control system
C) Manufacturing information system
D) Marketing information system
14. Which of the following is a program that models the pattern recognition capabilities of the human
brain.
A) An expert system
C) Neutral nefwork
15. Which of the following are the main software components of DSS?
A) Only i, ii, and iii
B) Only ii, iii and iv
C) Only i, iiiand iv
D) All i, ii, iii, and iv
I 6. Which of the following are the inputs of Marketing Information System?
i) database management system (DBMS)
iii) support tools
i) Marketing researih data
iii) External environment data
B) Artificial Intelligence
D) Development engine
ii) model management system
iv) internet
ii) Marketing intelligence data
iv) Strategic plan
A) Only i, ii, and iii
B) Only ii, iii and iv
C) Only i, iiiand iv
D) All i, ii, iii, and iv
17. ............,. is the process of defining the current problem, determining why a new system is
needed, identifying the objectives of the proposed system.
A) Feasibility analysis
B) System Analysis
C) System definition
D) System requirement
18. The accounting system is .................. whereas the demand forecasting system is .................
A) determ inistic, probabi listic B) probabi I istic, deterministic
-
r-
D) close, open C) open, close
l9.How many waysyou can save a document?
Al 3
Bl4
c)2
Dl I
20) Except forthe ...... function, a formula with a logical function shows the word "TRUE" or"FALSE"
as a result
a. IF
b. AND
c. OR
d. NOT
2l .Macros are "run'.' or executed from the ..... menu.
a. Insert
b. Frmat
c. Tools
d. Data
22.Each excel file is called a workbook because
a. It can contain text and data
b. It carr be modified
c. It can contain many sheets including worksheets and chart sheets
d. You have to work hard to create it
23.How are data organized in a spreadsheet?
a. Lines and spaces
b. Layers and planes
c. Rows and columns
d. Height and width
24.Which function calculates your monthly mortage payment?
a. PMT (payments)
b. NPER (number of periods)
c. PV (present value)
d. Allof above
25.What term refers to a specific set of values saved with the workbook?
a. Range
FirstRanker.com - FirstRanker's Choice
IT APPLICATION
IN COMMERCE
l. Which of the following is NOT an objective of MIS?
A) Facilitate the decisions-making
process
B) Provide requisite information
at each rever of management
C) Support decision-makingD)
recruit people for system
2' In MIS system design, the sources of information
may be categorized
as...............
and
A) internal, externalB) personal,
organizational
C) usefu l, unusefu lD) constructive,
destructive
3' what among the following
are the primary characteristics
that information
must process?
i) Relevance
ii) Availability
iii) Timeliness
iv) Accuracy
A) Only i, ii, and iii
B) Only ii, iii and iv
C) Only i, iii and iv
D) All i, ii, iii, and iv
4' which of the following
models are developed on the principles
of business management,
accounting
and econometrics?
A) Behavioral
modelB) Management
science models
C) Operations research
modelsD)
policy
making models
5' An
"""""
is a set of processes
and procedures
that transform
data into information
and
knowledge.
A) information
systemB)
Knowledgq
systenl
C) Database systemD)
Computer
system
6' A system is called
"
when the inputs, process
and the outputs are known with cerlainty.
A) Probabl isticsB)
Deterministic
C) OpenD) Close
7. which of the foilowing
steps is/are the imprementation
prans invorved
in MIS?
i) Preparing
organizational
plansii)
planning
of work flow
iii) Training
of personneliv)
Development
of software
v) Acquiring
computer
hardware
A) i, iiand iiionly
B) i, ii, iiiand iv only
C) i, ii, iv and v only
D) All i, ii, iii, iv and v
8. Which of the following is included in the Office automation systems?
i) Word processing
ii) Electronic mail
iii) Voice mailiv) Electronic calendaring
v) Audio conferencing
A) i, ii, iii and v only
B) i, ii, iii and iv only
C) i, ii, iv and v only
D) All i, ii, iii, iv and v
9. In a typical ..........:..... network, application processing is shared between clients and one more servers.
A) client server computingB) cloud computing
C) mobile computingD) data computing
I 0. The is defined as a set of activities performed across the organization creating as output
of value to the customer.
A) development processB) business process
C) quality processD) customer focus
I l.The different types of decisions while decision making in MIS are
i) Programmed decisions ii) Programmable decisions
iii) Semi Programmed decisions iv) Non
programmed
decisions
A) Only i, ii, and iii
B) Only ii, iiiand iv
C) Only i, iiiand iv
D) All i, ii, iii, and iv
12. which of the following statements are the disadvantages of Expert System?
i) They cannot handle inconsistent knowledge
ii) They cannot apply judgement
and intuition recognized as important ingredients of problem solving.
A) Only i
B) Only ii
C) Both i and ii
D) None
13. Which of the following system ensures that proper stock of each items are maintained in an
organization?
A) Human resource information system
B) An inventory control system
C) Manufacturing information system
D) Marketing information system
14. Which of the following is a program that models the pattern recognition capabilities of the human
brain.
A) An expert system
C) Neutral nefwork
15. Which of the following are the main software components of DSS?
A) Only i, ii, and iii
B) Only ii, iii and iv
C) Only i, iiiand iv
D) All i, ii, iii, and iv
I 6. Which of the following are the inputs of Marketing Information System?
i) database management system (DBMS)
iii) support tools
i) Marketing researih data
iii) External environment data
B) Artificial Intelligence
D) Development engine
ii) model management system
iv) internet
ii) Marketing intelligence data
iv) Strategic plan
A) Only i, ii, and iii
B) Only ii, iii and iv
C) Only i, iiiand iv
D) All i, ii, iii, and iv
17. ............,. is the process of defining the current problem, determining why a new system is
needed, identifying the objectives of the proposed system.
A) Feasibility analysis
B) System Analysis
C) System definition
D) System requirement
18. The accounting system is .................. whereas the demand forecasting system is .................
A) determ inistic, probabi listic B) probabi I istic, deterministic
-
r-
D) close, open C) open, close
l9.How many waysyou can save a document?
Al 3
Bl4
c)2
Dl I
20) Except forthe ...... function, a formula with a logical function shows the word "TRUE" or"FALSE"
as a result
a. IF
b. AND
c. OR
d. NOT
2l .Macros are "run'.' or executed from the ..... menu.
a. Insert
b. Frmat
c. Tools
d. Data
22.Each excel file is called a workbook because
a. It can contain text and data
b. It carr be modified
c. It can contain many sheets including worksheets and chart sheets
d. You have to work hard to create it
23.How are data organized in a spreadsheet?
a. Lines and spaces
b. Layers and planes
c. Rows and columns
d. Height and width
24.Which function calculates your monthly mortage payment?
a. PMT (payments)
b. NPER (number of periods)
c. PV (present value)
d. Allof above
25.What term refers to a specific set of values saved with the workbook?
a. Range
b. Scenario
c. Trend Iine
d. What-if analysis-
26.A features that displays only the data in column (s) according to specified criteria
A.FormulaB.Sorting
C.FilteringD.Pivot
27 .Material Requirement P lann ing(M RP) uti I izes software
applications for scheduling
-_.
A. sales management.
B. production processes.
C. marketing techniques.
D. human resource management
28.ERP package will handle business functionalities.
A. one. B. two. C. three. D. all
29. An enterprise is a group of people with_.
A. common goal.
B. separate goal for each department.
C. multiple goals.
D. two or more goals
30. ERP package will handle business functionalities.
A. one. B. two. C. three. D. all.
3 I .The most important step of ERP implementation is
_--
phase.
A. installing.B. training.C. gap analysis.D. testing.
32. The data warehouse archives contain of significant, continuing interest and value to the
enterprise.
A. new data.B. current data.C. old data.D. meta data.
33. over see the day-to-day operations of respective functional areas during ERP
implementation.
A. Consultant.B. Package vendor.C. End users.D. Functional managers.
34. Data mining is a powerful new technology to from large databases.
A. Extraction of hidden predictive information.
B. Generating reports.
C. Retrieving data.
D. Show result.
35. The total number of rows in a workbook.....
4.98000 8.105000 c. 1048576 D.1048570
36.The language used in application programs to request data from the DBMS is referred to as the a
FirstRanker.com - FirstRanker's Choice
IT APPLICATION
IN COMMERCE
l. Which of the following is NOT an objective of MIS?
A) Facilitate the decisions-making
process
B) Provide requisite information
at each rever of management
C) Support decision-makingD)
recruit people for system
2' In MIS system design, the sources of information
may be categorized
as...............
and
A) internal, externalB) personal,
organizational
C) usefu l, unusefu lD) constructive,
destructive
3' what among the following
are the primary characteristics
that information
must process?
i) Relevance
ii) Availability
iii) Timeliness
iv) Accuracy
A) Only i, ii, and iii
B) Only ii, iii and iv
C) Only i, iii and iv
D) All i, ii, iii, and iv
4' which of the following
models are developed on the principles
of business management,
accounting
and econometrics?
A) Behavioral
modelB) Management
science models
C) Operations research
modelsD)
policy
making models
5' An
"""""
is a set of processes
and procedures
that transform
data into information
and
knowledge.
A) information
systemB)
Knowledgq
systenl
C) Database systemD)
Computer
system
6' A system is called
"
when the inputs, process
and the outputs are known with cerlainty.
A) Probabl isticsB)
Deterministic
C) OpenD) Close
7. which of the foilowing
steps is/are the imprementation
prans invorved
in MIS?
i) Preparing
organizational
plansii)
planning
of work flow
iii) Training
of personneliv)
Development
of software
v) Acquiring
computer
hardware
A) i, iiand iiionly
B) i, ii, iiiand iv only
C) i, ii, iv and v only
D) All i, ii, iii, iv and v
8. Which of the following is included in the Office automation systems?
i) Word processing
ii) Electronic mail
iii) Voice mailiv) Electronic calendaring
v) Audio conferencing
A) i, ii, iii and v only
B) i, ii, iii and iv only
C) i, ii, iv and v only
D) All i, ii, iii, iv and v
9. In a typical ..........:..... network, application processing is shared between clients and one more servers.
A) client server computingB) cloud computing
C) mobile computingD) data computing
I 0. The is defined as a set of activities performed across the organization creating as output
of value to the customer.
A) development processB) business process
C) quality processD) customer focus
I l.The different types of decisions while decision making in MIS are
i) Programmed decisions ii) Programmable decisions
iii) Semi Programmed decisions iv) Non
programmed
decisions
A) Only i, ii, and iii
B) Only ii, iiiand iv
C) Only i, iiiand iv
D) All i, ii, iii, and iv
12. which of the following statements are the disadvantages of Expert System?
i) They cannot handle inconsistent knowledge
ii) They cannot apply judgement
and intuition recognized as important ingredients of problem solving.
A) Only i
B) Only ii
C) Both i and ii
D) None
13. Which of the following system ensures that proper stock of each items are maintained in an
organization?
A) Human resource information system
B) An inventory control system
C) Manufacturing information system
D) Marketing information system
14. Which of the following is a program that models the pattern recognition capabilities of the human
brain.
A) An expert system
C) Neutral nefwork
15. Which of the following are the main software components of DSS?
A) Only i, ii, and iii
B) Only ii, iii and iv
C) Only i, iiiand iv
D) All i, ii, iii, and iv
I 6. Which of the following are the inputs of Marketing Information System?
i) database management system (DBMS)
iii) support tools
i) Marketing researih data
iii) External environment data
B) Artificial Intelligence
D) Development engine
ii) model management system
iv) internet
ii) Marketing intelligence data
iv) Strategic plan
A) Only i, ii, and iii
B) Only ii, iii and iv
C) Only i, iiiand iv
D) All i, ii, iii, and iv
17. ............,. is the process of defining the current problem, determining why a new system is
needed, identifying the objectives of the proposed system.
A) Feasibility analysis
B) System Analysis
C) System definition
D) System requirement
18. The accounting system is .................. whereas the demand forecasting system is .................
A) determ inistic, probabi listic B) probabi I istic, deterministic
-
r-
D) close, open C) open, close
l9.How many waysyou can save a document?
Al 3
Bl4
c)2
Dl I
20) Except forthe ...... function, a formula with a logical function shows the word "TRUE" or"FALSE"
as a result
a. IF
b. AND
c. OR
d. NOT
2l .Macros are "run'.' or executed from the ..... menu.
a. Insert
b. Frmat
c. Tools
d. Data
22.Each excel file is called a workbook because
a. It can contain text and data
b. It carr be modified
c. It can contain many sheets including worksheets and chart sheets
d. You have to work hard to create it
23.How are data organized in a spreadsheet?
a. Lines and spaces
b. Layers and planes
c. Rows and columns
d. Height and width
24.Which function calculates your monthly mortage payment?
a. PMT (payments)
b. NPER (number of periods)
c. PV (present value)
d. Allof above
25.What term refers to a specific set of values saved with the workbook?
a. Range
b. Scenario
c. Trend Iine
d. What-if analysis-
26.A features that displays only the data in column (s) according to specified criteria
A.FormulaB.Sorting
C.FilteringD.Pivot
27 .Material Requirement P lann ing(M RP) uti I izes software
applications for scheduling
-_.
A. sales management.
B. production processes.
C. marketing techniques.
D. human resource management
28.ERP package will handle business functionalities.
A. one. B. two. C. three. D. all
29. An enterprise is a group of people with_.
A. common goal.
B. separate goal for each department.
C. multiple goals.
D. two or more goals
30. ERP package will handle business functionalities.
A. one. B. two. C. three. D. all.
3 I .The most important step of ERP implementation is
_--
phase.
A. installing.B. training.C. gap analysis.D. testing.
32. The data warehouse archives contain of significant, continuing interest and value to the
enterprise.
A. new data.B. current data.C. old data.D. meta data.
33. over see the day-to-day operations of respective functional areas during ERP
implementation.
A. Consultant.B. Package vendor.C. End users.D. Functional managers.
34. Data mining is a powerful new technology to from large databases.
A. Extraction of hidden predictive information.
B. Generating reports.
C. Retrieving data.
D. Show result.
35. The total number of rows in a workbook.....
4.98000 8.105000 c. 1048576 D.1048570
36.The language used in application programs to request data from the DBMS is referred to as the a
A.DML B.DDL C.VDL D.SDL
37.The DBMS language component which can be embedded in a program is
A.The data definition language (DDL)
B.The data manipulation language(DMl)
C.The database adm in istrato(DBA)
D.A query language.
38.Which one of the following statement is false?
A.The data dictionary is normally maintained by the database administrator.
B.Data elements in the database can be modified by changing the data dictionary.
C.The data dictionary contains the name and description of each data element.
D.The data dictionary is a tool used exclusively by the database adrninistrator.
39.An advantage of the database management approach is
A.Data is dependent on programs.
B.Data redundancy increase.
C.Data is integrated and can be accessed by multiple programs.
D.None of the abovb.
40.Which type of database stores data in two
-
dimensional tables?
A. Network
B. Hierarchical
C. Table
D. Relational
4lThe DBMS language component which can be embedded in a program is
(A) The data definition language (DDL).
(B) The data manipulation language (DML).
(C) The database adminishator (DBA).
(D) A query language.
42. A relational database developer refers to a record as
(A) a criteria
(B) a relation.
(C) a tuple.
(D) an aftribute.
43. Architecture of the database can be viewed as
(A) two levels.
(B) four levels.
FirstRanker.com - FirstRanker's Choice
IT APPLICATION
IN COMMERCE
l. Which of the following is NOT an objective of MIS?
A) Facilitate the decisions-making
process
B) Provide requisite information
at each rever of management
C) Support decision-makingD)
recruit people for system
2' In MIS system design, the sources of information
may be categorized
as...............
and
A) internal, externalB) personal,
organizational
C) usefu l, unusefu lD) constructive,
destructive
3' what among the following
are the primary characteristics
that information
must process?
i) Relevance
ii) Availability
iii) Timeliness
iv) Accuracy
A) Only i, ii, and iii
B) Only ii, iii and iv
C) Only i, iii and iv
D) All i, ii, iii, and iv
4' which of the following
models are developed on the principles
of business management,
accounting
and econometrics?
A) Behavioral
modelB) Management
science models
C) Operations research
modelsD)
policy
making models
5' An
"""""
is a set of processes
and procedures
that transform
data into information
and
knowledge.
A) information
systemB)
Knowledgq
systenl
C) Database systemD)
Computer
system
6' A system is called
"
when the inputs, process
and the outputs are known with cerlainty.
A) Probabl isticsB)
Deterministic
C) OpenD) Close
7. which of the foilowing
steps is/are the imprementation
prans invorved
in MIS?
i) Preparing
organizational
plansii)
planning
of work flow
iii) Training
of personneliv)
Development
of software
v) Acquiring
computer
hardware
A) i, iiand iiionly
B) i, ii, iiiand iv only
C) i, ii, iv and v only
D) All i, ii, iii, iv and v
8. Which of the following is included in the Office automation systems?
i) Word processing
ii) Electronic mail
iii) Voice mailiv) Electronic calendaring
v) Audio conferencing
A) i, ii, iii and v only
B) i, ii, iii and iv only
C) i, ii, iv and v only
D) All i, ii, iii, iv and v
9. In a typical ..........:..... network, application processing is shared between clients and one more servers.
A) client server computingB) cloud computing
C) mobile computingD) data computing
I 0. The is defined as a set of activities performed across the organization creating as output
of value to the customer.
A) development processB) business process
C) quality processD) customer focus
I l.The different types of decisions while decision making in MIS are
i) Programmed decisions ii) Programmable decisions
iii) Semi Programmed decisions iv) Non
programmed
decisions
A) Only i, ii, and iii
B) Only ii, iiiand iv
C) Only i, iiiand iv
D) All i, ii, iii, and iv
12. which of the following statements are the disadvantages of Expert System?
i) They cannot handle inconsistent knowledge
ii) They cannot apply judgement
and intuition recognized as important ingredients of problem solving.
A) Only i
B) Only ii
C) Both i and ii
D) None
13. Which of the following system ensures that proper stock of each items are maintained in an
organization?
A) Human resource information system
B) An inventory control system
C) Manufacturing information system
D) Marketing information system
14. Which of the following is a program that models the pattern recognition capabilities of the human
brain.
A) An expert system
C) Neutral nefwork
15. Which of the following are the main software components of DSS?
A) Only i, ii, and iii
B) Only ii, iii and iv
C) Only i, iiiand iv
D) All i, ii, iii, and iv
I 6. Which of the following are the inputs of Marketing Information System?
i) database management system (DBMS)
iii) support tools
i) Marketing researih data
iii) External environment data
B) Artificial Intelligence
D) Development engine
ii) model management system
iv) internet
ii) Marketing intelligence data
iv) Strategic plan
A) Only i, ii, and iii
B) Only ii, iii and iv
C) Only i, iiiand iv
D) All i, ii, iii, and iv
17. ............,. is the process of defining the current problem, determining why a new system is
needed, identifying the objectives of the proposed system.
A) Feasibility analysis
B) System Analysis
C) System definition
D) System requirement
18. The accounting system is .................. whereas the demand forecasting system is .................
A) determ inistic, probabi listic B) probabi I istic, deterministic
-
r-
D) close, open C) open, close
l9.How many waysyou can save a document?
Al 3
Bl4
c)2
Dl I
20) Except forthe ...... function, a formula with a logical function shows the word "TRUE" or"FALSE"
as a result
a. IF
b. AND
c. OR
d. NOT
2l .Macros are "run'.' or executed from the ..... menu.
a. Insert
b. Frmat
c. Tools
d. Data
22.Each excel file is called a workbook because
a. It can contain text and data
b. It carr be modified
c. It can contain many sheets including worksheets and chart sheets
d. You have to work hard to create it
23.How are data organized in a spreadsheet?
a. Lines and spaces
b. Layers and planes
c. Rows and columns
d. Height and width
24.Which function calculates your monthly mortage payment?
a. PMT (payments)
b. NPER (number of periods)
c. PV (present value)
d. Allof above
25.What term refers to a specific set of values saved with the workbook?
a. Range
b. Scenario
c. Trend Iine
d. What-if analysis-
26.A features that displays only the data in column (s) according to specified criteria
A.FormulaB.Sorting
C.FilteringD.Pivot
27 .Material Requirement P lann ing(M RP) uti I izes software
applications for scheduling
-_.
A. sales management.
B. production processes.
C. marketing techniques.
D. human resource management
28.ERP package will handle business functionalities.
A. one. B. two. C. three. D. all
29. An enterprise is a group of people with_.
A. common goal.
B. separate goal for each department.
C. multiple goals.
D. two or more goals
30. ERP package will handle business functionalities.
A. one. B. two. C. three. D. all.
3 I .The most important step of ERP implementation is
_--
phase.
A. installing.B. training.C. gap analysis.D. testing.
32. The data warehouse archives contain of significant, continuing interest and value to the
enterprise.
A. new data.B. current data.C. old data.D. meta data.
33. over see the day-to-day operations of respective functional areas during ERP
implementation.
A. Consultant.B. Package vendor.C. End users.D. Functional managers.
34. Data mining is a powerful new technology to from large databases.
A. Extraction of hidden predictive information.
B. Generating reports.
C. Retrieving data.
D. Show result.
35. The total number of rows in a workbook.....
4.98000 8.105000 c. 1048576 D.1048570
36.The language used in application programs to request data from the DBMS is referred to as the a
A.DML B.DDL C.VDL D.SDL
37.The DBMS language component which can be embedded in a program is
A.The data definition language (DDL)
B.The data manipulation language(DMl)
C.The database adm in istrato(DBA)
D.A query language.
38.Which one of the following statement is false?
A.The data dictionary is normally maintained by the database administrator.
B.Data elements in the database can be modified by changing the data dictionary.
C.The data dictionary contains the name and description of each data element.
D.The data dictionary is a tool used exclusively by the database adrninistrator.
39.An advantage of the database management approach is
A.Data is dependent on programs.
B.Data redundancy increase.
C.Data is integrated and can be accessed by multiple programs.
D.None of the abovb.
40.Which type of database stores data in two
-
dimensional tables?
A. Network
B. Hierarchical
C. Table
D. Relational
4lThe DBMS language component which can be embedded in a program is
(A) The data definition language (DDL).
(B) The data manipulation language (DML).
(C) The database adminishator (DBA).
(D) A query language.
42. A relational database developer refers to a record as
(A) a criteria
(B) a relation.
(C) a tuple.
(D) an aftribute.
43. Architecture of the database can be viewed as
(A) two levels.
(B) four levels.
(C) three levels.
(D) one level.
44........... keyword is used to find the nuntber of values in a colurnn.
A. TOTAL B. COUNT
C. ADD D. SUM
45. An advantage of the database management approach is
A. data is dependeni on programs
B. data redundancy increases
C. data is integrated and can be accessed by multiple programs
D. none ofthe above
46.The collection of information stored in a database at a parlicular moment is called as ......
A. schema
B. instance of the database
C. data domain
D. independence
47 . Data independence means
A. data is defined separately and not included in programs.
B. programs are not dependent on the physical attributes of data
C. programs are not dependent on the logical attributes of data
D. both B and C
48. A ......... is used to define overall design of the database
A. schema
B. application program
C. data definition language
D. code
49.Key to represent relationship between tables is called
A. primary key
B. secondary key
C. foreign key
D. none ofthe above
50. A computer program that contains expertise in a particular domain is called an:
A) intelligent planner
B) autornatic processor
C) expert system
FirstRanker.com - FirstRanker's Choice
IT APPLICATION
IN COMMERCE
l. Which of the following is NOT an objective of MIS?
A) Facilitate the decisions-making
process
B) Provide requisite information
at each rever of management
C) Support decision-makingD)
recruit people for system
2' In MIS system design, the sources of information
may be categorized
as...............
and
A) internal, externalB) personal,
organizational
C) usefu l, unusefu lD) constructive,
destructive
3' what among the following
are the primary characteristics
that information
must process?
i) Relevance
ii) Availability
iii) Timeliness
iv) Accuracy
A) Only i, ii, and iii
B) Only ii, iii and iv
C) Only i, iii and iv
D) All i, ii, iii, and iv
4' which of the following
models are developed on the principles
of business management,
accounting
and econometrics?
A) Behavioral
modelB) Management
science models
C) Operations research
modelsD)
policy
making models
5' An
"""""
is a set of processes
and procedures
that transform
data into information
and
knowledge.
A) information
systemB)
Knowledgq
systenl
C) Database systemD)
Computer
system
6' A system is called
"
when the inputs, process
and the outputs are known with cerlainty.
A) Probabl isticsB)
Deterministic
C) OpenD) Close
7. which of the foilowing
steps is/are the imprementation
prans invorved
in MIS?
i) Preparing
organizational
plansii)
planning
of work flow
iii) Training
of personneliv)
Development
of software
v) Acquiring
computer
hardware
A) i, iiand iiionly
B) i, ii, iiiand iv only
C) i, ii, iv and v only
D) All i, ii, iii, iv and v
8. Which of the following is included in the Office automation systems?
i) Word processing
ii) Electronic mail
iii) Voice mailiv) Electronic calendaring
v) Audio conferencing
A) i, ii, iii and v only
B) i, ii, iii and iv only
C) i, ii, iv and v only
D) All i, ii, iii, iv and v
9. In a typical ..........:..... network, application processing is shared between clients and one more servers.
A) client server computingB) cloud computing
C) mobile computingD) data computing
I 0. The is defined as a set of activities performed across the organization creating as output
of value to the customer.
A) development processB) business process
C) quality processD) customer focus
I l.The different types of decisions while decision making in MIS are
i) Programmed decisions ii) Programmable decisions
iii) Semi Programmed decisions iv) Non
programmed
decisions
A) Only i, ii, and iii
B) Only ii, iiiand iv
C) Only i, iiiand iv
D) All i, ii, iii, and iv
12. which of the following statements are the disadvantages of Expert System?
i) They cannot handle inconsistent knowledge
ii) They cannot apply judgement
and intuition recognized as important ingredients of problem solving.
A) Only i
B) Only ii
C) Both i and ii
D) None
13. Which of the following system ensures that proper stock of each items are maintained in an
organization?
A) Human resource information system
B) An inventory control system
C) Manufacturing information system
D) Marketing information system
14. Which of the following is a program that models the pattern recognition capabilities of the human
brain.
A) An expert system
C) Neutral nefwork
15. Which of the following are the main software components of DSS?
A) Only i, ii, and iii
B) Only ii, iii and iv
C) Only i, iiiand iv
D) All i, ii, iii, and iv
I 6. Which of the following are the inputs of Marketing Information System?
i) database management system (DBMS)
iii) support tools
i) Marketing researih data
iii) External environment data
B) Artificial Intelligence
D) Development engine
ii) model management system
iv) internet
ii) Marketing intelligence data
iv) Strategic plan
A) Only i, ii, and iii
B) Only ii, iii and iv
C) Only i, iiiand iv
D) All i, ii, iii, and iv
17. ............,. is the process of defining the current problem, determining why a new system is
needed, identifying the objectives of the proposed system.
A) Feasibility analysis
B) System Analysis
C) System definition
D) System requirement
18. The accounting system is .................. whereas the demand forecasting system is .................
A) determ inistic, probabi listic B) probabi I istic, deterministic
-
r-
D) close, open C) open, close
l9.How many waysyou can save a document?
Al 3
Bl4
c)2
Dl I
20) Except forthe ...... function, a formula with a logical function shows the word "TRUE" or"FALSE"
as a result
a. IF
b. AND
c. OR
d. NOT
2l .Macros are "run'.' or executed from the ..... menu.
a. Insert
b. Frmat
c. Tools
d. Data
22.Each excel file is called a workbook because
a. It can contain text and data
b. It carr be modified
c. It can contain many sheets including worksheets and chart sheets
d. You have to work hard to create it
23.How are data organized in a spreadsheet?
a. Lines and spaces
b. Layers and planes
c. Rows and columns
d. Height and width
24.Which function calculates your monthly mortage payment?
a. PMT (payments)
b. NPER (number of periods)
c. PV (present value)
d. Allof above
25.What term refers to a specific set of values saved with the workbook?
a. Range
b. Scenario
c. Trend Iine
d. What-if analysis-
26.A features that displays only the data in column (s) according to specified criteria
A.FormulaB.Sorting
C.FilteringD.Pivot
27 .Material Requirement P lann ing(M RP) uti I izes software
applications for scheduling
-_.
A. sales management.
B. production processes.
C. marketing techniques.
D. human resource management
28.ERP package will handle business functionalities.
A. one. B. two. C. three. D. all
29. An enterprise is a group of people with_.
A. common goal.
B. separate goal for each department.
C. multiple goals.
D. two or more goals
30. ERP package will handle business functionalities.
A. one. B. two. C. three. D. all.
3 I .The most important step of ERP implementation is
_--
phase.
A. installing.B. training.C. gap analysis.D. testing.
32. The data warehouse archives contain of significant, continuing interest and value to the
enterprise.
A. new data.B. current data.C. old data.D. meta data.
33. over see the day-to-day operations of respective functional areas during ERP
implementation.
A. Consultant.B. Package vendor.C. End users.D. Functional managers.
34. Data mining is a powerful new technology to from large databases.
A. Extraction of hidden predictive information.
B. Generating reports.
C. Retrieving data.
D. Show result.
35. The total number of rows in a workbook.....
4.98000 8.105000 c. 1048576 D.1048570
36.The language used in application programs to request data from the DBMS is referred to as the a
A.DML B.DDL C.VDL D.SDL
37.The DBMS language component which can be embedded in a program is
A.The data definition language (DDL)
B.The data manipulation language(DMl)
C.The database adm in istrato(DBA)
D.A query language.
38.Which one of the following statement is false?
A.The data dictionary is normally maintained by the database administrator.
B.Data elements in the database can be modified by changing the data dictionary.
C.The data dictionary contains the name and description of each data element.
D.The data dictionary is a tool used exclusively by the database adrninistrator.
39.An advantage of the database management approach is
A.Data is dependent on programs.
B.Data redundancy increase.
C.Data is integrated and can be accessed by multiple programs.
D.None of the abovb.
40.Which type of database stores data in two
-
dimensional tables?
A. Network
B. Hierarchical
C. Table
D. Relational
4lThe DBMS language component which can be embedded in a program is
(A) The data definition language (DDL).
(B) The data manipulation language (DML).
(C) The database adminishator (DBA).
(D) A query language.
42. A relational database developer refers to a record as
(A) a criteria
(B) a relation.
(C) a tuple.
(D) an aftribute.
43. Architecture of the database can be viewed as
(A) two levels.
(B) four levels.
(C) three levels.
(D) one level.
44........... keyword is used to find the nuntber of values in a colurnn.
A. TOTAL B. COUNT
C. ADD D. SUM
45. An advantage of the database management approach is
A. data is dependeni on programs
B. data redundancy increases
C. data is integrated and can be accessed by multiple programs
D. none ofthe above
46.The collection of information stored in a database at a parlicular moment is called as ......
A. schema
B. instance of the database
C. data domain
D. independence
47 . Data independence means
A. data is defined separately and not included in programs.
B. programs are not dependent on the physical attributes of data
C. programs are not dependent on the logical attributes of data
D. both B and C
48. A ......... is used to define overall design of the database
A. schema
B. application program
C. data definition language
D. code
49.Key to represent relationship between tables is called
A. primary key
B. secondary key
C. foreign key
D. none ofthe above
50. A computer program that contains expertise in a particular domain is called an:
A) intelligent planner
B) autornatic processor
C) expert system
D) operational symbolizer
Answers:
l. D) recruit people for system
2. A) internalr.external
3. A) Only i, ii, and iii
4. B) Management science models
5. A) information system
6. Ei) Deterministic
7. D) All i, ii, iii, iv and v
8. D) All i, ii, iii, iv and v
9. A) client server computing ,
10. B) bu.siness process
I L C) Only i, iiiand iv
12. C) Both iand ii
13. B) An inventory control system
14. C) Neutral network
15. A) Only i, ii, and iii
16. D) All i, ii, iii, and iv
17 . C) System definition
I 8. A) deterministic, probabilistic
19. A) 3
20. A) rF
2t. c) TooL
22. C
23. C
24. A
25. B
26. C
27. B
28. D
FirstRanker.com - FirstRanker's Choice
IT APPLICATION
IN COMMERCE
l. Which of the following is NOT an objective of MIS?
A) Facilitate the decisions-making
process
B) Provide requisite information
at each rever of management
C) Support decision-makingD)
recruit people for system
2' In MIS system design, the sources of information
may be categorized
as...............
and
A) internal, externalB) personal,
organizational
C) usefu l, unusefu lD) constructive,
destructive
3' what among the following
are the primary characteristics
that information
must process?
i) Relevance
ii) Availability
iii) Timeliness
iv) Accuracy
A) Only i, ii, and iii
B) Only ii, iii and iv
C) Only i, iii and iv
D) All i, ii, iii, and iv
4' which of the following
models are developed on the principles
of business management,
accounting
and econometrics?
A) Behavioral
modelB) Management
science models
C) Operations research
modelsD)
policy
making models
5' An
"""""
is a set of processes
and procedures
that transform
data into information
and
knowledge.
A) information
systemB)
Knowledgq
systenl
C) Database systemD)
Computer
system
6' A system is called
"
when the inputs, process
and the outputs are known with cerlainty.
A) Probabl isticsB)
Deterministic
C) OpenD) Close
7. which of the foilowing
steps is/are the imprementation
prans invorved
in MIS?
i) Preparing
organizational
plansii)
planning
of work flow
iii) Training
of personneliv)
Development
of software
v) Acquiring
computer
hardware
A) i, iiand iiionly
B) i, ii, iiiand iv only
C) i, ii, iv and v only
D) All i, ii, iii, iv and v
8. Which of the following is included in the Office automation systems?
i) Word processing
ii) Electronic mail
iii) Voice mailiv) Electronic calendaring
v) Audio conferencing
A) i, ii, iii and v only
B) i, ii, iii and iv only
C) i, ii, iv and v only
D) All i, ii, iii, iv and v
9. In a typical ..........:..... network, application processing is shared between clients and one more servers.
A) client server computingB) cloud computing
C) mobile computingD) data computing
I 0. The is defined as a set of activities performed across the organization creating as output
of value to the customer.
A) development processB) business process
C) quality processD) customer focus
I l.The different types of decisions while decision making in MIS are
i) Programmed decisions ii) Programmable decisions
iii) Semi Programmed decisions iv) Non
programmed
decisions
A) Only i, ii, and iii
B) Only ii, iiiand iv
C) Only i, iiiand iv
D) All i, ii, iii, and iv
12. which of the following statements are the disadvantages of Expert System?
i) They cannot handle inconsistent knowledge
ii) They cannot apply judgement
and intuition recognized as important ingredients of problem solving.
A) Only i
B) Only ii
C) Both i and ii
D) None
13. Which of the following system ensures that proper stock of each items are maintained in an
organization?
A) Human resource information system
B) An inventory control system
C) Manufacturing information system
D) Marketing information system
14. Which of the following is a program that models the pattern recognition capabilities of the human
brain.
A) An expert system
C) Neutral nefwork
15. Which of the following are the main software components of DSS?
A) Only i, ii, and iii
B) Only ii, iii and iv
C) Only i, iiiand iv
D) All i, ii, iii, and iv
I 6. Which of the following are the inputs of Marketing Information System?
i) database management system (DBMS)
iii) support tools
i) Marketing researih data
iii) External environment data
B) Artificial Intelligence
D) Development engine
ii) model management system
iv) internet
ii) Marketing intelligence data
iv) Strategic plan
A) Only i, ii, and iii
B) Only ii, iii and iv
C) Only i, iiiand iv
D) All i, ii, iii, and iv
17. ............,. is the process of defining the current problem, determining why a new system is
needed, identifying the objectives of the proposed system.
A) Feasibility analysis
B) System Analysis
C) System definition
D) System requirement
18. The accounting system is .................. whereas the demand forecasting system is .................
A) determ inistic, probabi listic B) probabi I istic, deterministic
-
r-
D) close, open C) open, close
l9.How many waysyou can save a document?
Al 3
Bl4
c)2
Dl I
20) Except forthe ...... function, a formula with a logical function shows the word "TRUE" or"FALSE"
as a result
a. IF
b. AND
c. OR
d. NOT
2l .Macros are "run'.' or executed from the ..... menu.
a. Insert
b. Frmat
c. Tools
d. Data
22.Each excel file is called a workbook because
a. It can contain text and data
b. It carr be modified
c. It can contain many sheets including worksheets and chart sheets
d. You have to work hard to create it
23.How are data organized in a spreadsheet?
a. Lines and spaces
b. Layers and planes
c. Rows and columns
d. Height and width
24.Which function calculates your monthly mortage payment?
a. PMT (payments)
b. NPER (number of periods)
c. PV (present value)
d. Allof above
25.What term refers to a specific set of values saved with the workbook?
a. Range
b. Scenario
c. Trend Iine
d. What-if analysis-
26.A features that displays only the data in column (s) according to specified criteria
A.FormulaB.Sorting
C.FilteringD.Pivot
27 .Material Requirement P lann ing(M RP) uti I izes software
applications for scheduling
-_.
A. sales management.
B. production processes.
C. marketing techniques.
D. human resource management
28.ERP package will handle business functionalities.
A. one. B. two. C. three. D. all
29. An enterprise is a group of people with_.
A. common goal.
B. separate goal for each department.
C. multiple goals.
D. two or more goals
30. ERP package will handle business functionalities.
A. one. B. two. C. three. D. all.
3 I .The most important step of ERP implementation is
_--
phase.
A. installing.B. training.C. gap analysis.D. testing.
32. The data warehouse archives contain of significant, continuing interest and value to the
enterprise.
A. new data.B. current data.C. old data.D. meta data.
33. over see the day-to-day operations of respective functional areas during ERP
implementation.
A. Consultant.B. Package vendor.C. End users.D. Functional managers.
34. Data mining is a powerful new technology to from large databases.
A. Extraction of hidden predictive information.
B. Generating reports.
C. Retrieving data.
D. Show result.
35. The total number of rows in a workbook.....
4.98000 8.105000 c. 1048576 D.1048570
36.The language used in application programs to request data from the DBMS is referred to as the a
A.DML B.DDL C.VDL D.SDL
37.The DBMS language component which can be embedded in a program is
A.The data definition language (DDL)
B.The data manipulation language(DMl)
C.The database adm in istrato(DBA)
D.A query language.
38.Which one of the following statement is false?
A.The data dictionary is normally maintained by the database administrator.
B.Data elements in the database can be modified by changing the data dictionary.
C.The data dictionary contains the name and description of each data element.
D.The data dictionary is a tool used exclusively by the database adrninistrator.
39.An advantage of the database management approach is
A.Data is dependent on programs.
B.Data redundancy increase.
C.Data is integrated and can be accessed by multiple programs.
D.None of the abovb.
40.Which type of database stores data in two
-
dimensional tables?
A. Network
B. Hierarchical
C. Table
D. Relational
4lThe DBMS language component which can be embedded in a program is
(A) The data definition language (DDL).
(B) The data manipulation language (DML).
(C) The database adminishator (DBA).
(D) A query language.
42. A relational database developer refers to a record as
(A) a criteria
(B) a relation.
(C) a tuple.
(D) an aftribute.
43. Architecture of the database can be viewed as
(A) two levels.
(B) four levels.
(C) three levels.
(D) one level.
44........... keyword is used to find the nuntber of values in a colurnn.
A. TOTAL B. COUNT
C. ADD D. SUM
45. An advantage of the database management approach is
A. data is dependeni on programs
B. data redundancy increases
C. data is integrated and can be accessed by multiple programs
D. none ofthe above
46.The collection of information stored in a database at a parlicular moment is called as ......
A. schema
B. instance of the database
C. data domain
D. independence
47 . Data independence means
A. data is defined separately and not included in programs.
B. programs are not dependent on the physical attributes of data
C. programs are not dependent on the logical attributes of data
D. both B and C
48. A ......... is used to define overall design of the database
A. schema
B. application program
C. data definition language
D. code
49.Key to represent relationship between tables is called
A. primary key
B. secondary key
C. foreign key
D. none ofthe above
50. A computer program that contains expertise in a particular domain is called an:
A) intelligent planner
B) autornatic processor
C) expert system
D) operational symbolizer
Answers:
l. D) recruit people for system
2. A) internalr.external
3. A) Only i, ii, and iii
4. B) Management science models
5. A) information system
6. Ei) Deterministic
7. D) All i, ii, iii, iv and v
8. D) All i, ii, iii, iv and v
9. A) client server computing ,
10. B) bu.siness process
I L C) Only i, iiiand iv
12. C) Both iand ii
13. B) An inventory control system
14. C) Neutral network
15. A) Only i, ii, and iii
16. D) All i, ii, iii, and iv
17 . C) System definition
I 8. A) deterministic, probabilistic
19. A) 3
20. A) rF
2t. c) TooL
22. C
23. C
24. A
25. B
26. C
27. B
28. D
29. A
30. D
31. c
32. C
33. D
34. A
3s. D
36. A
37. B
38. B
39. C
40. D
41. B
42. C
43. C
44. B
45. C
46. B
47. D
48. A
49. C
50. c
FirstRanker.com - FirstRanker's Choice