SAD MCQ SET

SAD Multiple Choice Question Material
[1] Data by itself is not useful unless
(A) => It is massive
(B) => It is processed to obtain information
(C) => It is collected from divert source
Answer =>> It is processed to obtain information
[2] for taking decisions data must be
(A) => Very accurate
(B) => Massive
(C) => Processed correctly
Answer =>> Processed correctly
[3] Strategic information is needed for
(A) => Day to Day operations
(B) => Meet government requirements
(C) => Long range planning
Answer =>> Long range planning
[4] Strategic information is required by
(A) => Middle managers
(B) => Line managers
(C) => Top managers
Answer =>> Top managers
[5] Tactical information is needed for
(A) => Day to Day operations
(B) => Short range planning
(C) => Meet government requirements
Answer =>> Short range planning
[6] Tactical information is required by
(A) => Middle managers
(B) => Line managers
(C) => Top managers
Answer =>> Middle managers
[7] Operational information is needed for
(A) => Day to Day operations
(B) => Meet government requirements
(C) => Long range planning
Answer =>> Day to Day operations
[8] Operational information is required by
(A) => Middle managers
(B) => Line managers
(C) => Top managers
Answer =>> Line managers
[9] Statutory information is needed for
(A) => Day to Day operations
(B) => Meet government requirements
(C) => Long range planning
Answer =>> Meet government requirements
[10] In motor car manufacturing the following type of information is strategic
(A) => Decision on introducing a new model
(B) => Scheduling production
(C) => Assessing competitor car
Answer =>> Decision on introducing a new model
[11] In motor car manufacturing, the following type of information is tactical
(A) => Decision on introducing a new model
(B) => Scheduling productionB. Scheduling production
(C) => Assessing competitor car
Answer =>> Assessing competitor car
[12] A computer based information system is needed because
(A) => The size of organization have become large and data is massive
(B) => Computers are available
(C) => Difficult to get clerks to process data.
Answer =>> The size of organization have become large and data is massive
[13] Organizations are divided into departments because
(A) => It is convenient to do so
(B) => Each department can be assigned a specific functional responsibility
(C) => It provides opportunities for promotions
Answer =>> Each department can be assigned a specific functional responsibility
[14] Organizations have hierarchical structures because
(A) => It is convenient to do so
(B) => It is done by every organizations
(C) => Specific responsibilities can be assigned for each level
Answer =>> Specific responsibilities can be assigned for each level
[15] Which of the following function is most likely in an insurance company
(A) => Training
(B) => Giving loans
(C) => Bill of material
Answer =>> Bill of material
[16] Which of the following functions is most likely in a university
(A) => Admissions
(B) => Accounting
(C) => Conducting examinations
Answer =>> Conducting examinations
[17] Every record stored in a master file has a key field because
(A) => It is the most important field
(B) => It acts as a unique identification of records
(C) => It is the key to the database
Answer =>> It acts as a unique identification of records
[18] The primary storage medium for storing archival data is
(A) => Floppy disc
(B) => Magnetic disk
(C) => Magnetic tape
Answer =>> Magnetic tape
[19] Master files are normally stored in
(A) => A hard disk
(B) => A tape
(C) => CD-ROM
Answer =>> A hard disk
[20] Master file is a file containing
(A) => All master records
(B) => All record relevant to the application
(C) => A collection of data items
Answer =>> All record relevant to the application
[21] Edit program is required to
(A) => Authenticate data entered by an operator
(B) => Format correctly input data
(C) => Detect errors in input data
Answer =>> Detect errors in input data
[22] Data rejected by edit program are
(A) => Corrected and re-entered
(B) => Removed from processing
(C) => Collected for later use
Answer =>> Corrected and re-entered
[23] Online transaction processing is used because
(A) => It is efficient
(B) => Disk is used for storing files
(C) => It can handle random queries
Answer =>> It can handle random queries
[24] A management information system is one which
(A) => Is required by all managers of the organizations
(B) => Processed data to yield information of value in tactical management
(C) => Provides operational information
Answer =>> Processed data to yield information of value in tactical management
[25] Data mining is used to aid in
(A) => Operational management
(B) => Analyzing past decision made by managers
(C) => Detecting patterns in operational data
Answer =>> Detecting patterns in operational data
[26] Data mining requires
(A) => Large quantities of operational data stored over a period of time
(B) => Lots of tactical data
(C) => Several tape drives to store archival data
Answer =>> Large quantities of operational data stored over a period of time
[27] Decision support system are used for
(A) => Management decision making
(B) => Providing tactical information to management
(C) => Providing strategic information to management
Answer =>> Providing strategic information to management
[28] Decision support system are used by
(A) => Line managers
(B) => Top-level managers
(C) => Middle level managers
Answer =>> Top-level managers
[29] Decision support systems are essential for
(A) => Day-to-Day operations of an organizations
(B) => Providing statutory information
(C) => Top level strategic decision making
Answer =>> Top level strategic decision making
[30] A data dictionary has consolidate list of data contained in
(A) => Data flows
(B) => Data inputs
(C) => Data outputs
Answer =>> Data flows
[31] By metadata we mean
(A) => Very large data
(B) => Data about data
(C) => Data dictionary
Answer =>> Data about data
[32] A data dictionary is usually developed
(A) => At requirement specification phase
(B) => During feasibility analysis
(C) => When DFD is developed
Answer =>> When DFD is developed
[33] A data dictionary has information about
(A) => Every data element in a data flow
(B) => Only key data element in a data flow
(C) => Only important data element in a data flow
Answer =>> Every data element in a data flow
[34] A data element in a data dictionary may have
(A) => Only integer value
(B) => Only value
(C) => Only real value
Answer =>> Only value
[35] It is necessary to carefully design data input to a computer based system because
(A) => It is good to be careful
(B) => The volume of data handled is large
(C) => The volume of data handled is small
Answer =>> The volume of data handled is large
[36] Error occurs more often when
(A) => Data is entered by users
(B) => Data is entered by operators
(C) => When data is hand written by users and entered by operators
Answer =>> When data is hand written by users and entered by operators
[37] In online data entry it is possible to
(A) => Give immediate feedback if incorrect data is entered
(B) => Eliminate all errors
(C) => Save data entry operators time
Answer =>> Give immediate feedback if incorrect data is entered
[38] In interactive data input a menu is used to
(A) => Enter new data
(B) => Add/Delete data
(C) => Select one out of many alternatives often by a mouse click
Answer =>> Select one out of many alternatives often by a mouse click
[39] Data inputs which requires coding are
(A) => Fields with specify prices
(B) => Key fields
(C) => Name field such as product name
Answer =>> Key fields
[40] By the term ‘meaningful code’ we understand that the code
(A) => Conveys information on item being coded
(B) => Is of small length
(C) => Can add new item easily
Answer =>> Conveys information on item being coded
[41] Errors in codes are detected by
(A) => Proper design of code
(B) => Introducing redundant digits
(C) => Making the code concise
Answer =>> Introducing redundant digits
[42] Requirement specification is carried out
(A) => After requirements are determined
(B) => Before requirements are determined
(C) => Simultaneously with requirement determinations
Answer =>> After requirements are determined
[43] The role of a system analyst drawing up a requirements specification is similar to
(A) => Architect designing a building
(B) => A structural engineer designing a building
(C) => A contractor constructing a building
Answer =>> Architect designing a building
[44] System test plan is specified
(A) => When the final specifications are drawn up
(B) => During feasibility study
(C) => During the requirement specifications stage
Answer =>> When the final specifications are drawn up
[45] System design is carried out
(A) => As soon as system requirements are determined
(B) => Whenever a system analyst feels it is urgent
(C) => After final system specifications are approved by the organizations
Answer =>> After final system specifications are approved by the organizations
[46] The primary objective of system design is to
(A) => Design the programs, databases and test plan
(B) => Design only user interfaces
(C) => Implement the system
Answer =>> Design the programs, databases and test plan
[47] Systems are modified whenever
(A) => User’s requirement changes
(B) => New computers are introduced in the market
(C) => New software tools become available in the market
Answer =>> User’s requirement changes
[48] To easily modify the existing system it is necessary to
(A) => Use good software tool
(B) => Use the best hardware available
(C) => Design the system which can be changed at low cost
Answer =>> Design the system which can be changed at low cost
[49] The primary responsibility of a system analyst is to
(A) => Specify an information system which meets the requirements of an organization
(B) => Write programs to meet specification
(C) => Maintain the system
Answer =>> Specify an information system which meets the requirements of an organization
[50] The most important attribute of system analyst is
(A) => Excellent programming skill
(B) => Very good hardware designing skill
(C) => C. Very good technical management skill
Answer =>> C. Very good technical management skill
[51] What are the different views to display a table
(A) => Datasheet View
(B) => Design View
(C) => All of Above
Answer =>> All of Above
[52] Which of the following creates a Drop Down List of values to choose From
(A) => OLE Object
(B) => Hyperlink
(C) => Lookup Wizard
Answer =>> Lookup Wizard
[53] The command center for access file that appears when you create or open the ms-access database file
(A) => Database Window
(B) => Query Window
(C) => Design view Window
Answer =>> Database Window
[54] The third stage in designing a database is when we analyze our tables more closely and creates a ______________between tables
(A) => Relationship
(B) => Join
(C) => Query
Answer =>> Relationship
[55] In a database table, The category of information is called
(A) => Tuple
(B) => Field
(C) => Record
Answer =>> Field
[56] This key uniquely identifies each record
(A) => Primary key
(B) => Key Record
(C) => Unique Key
Answer =>> Primary key
[57] It is an Association established between common
(A) => Line
(B) => Relationship
(C) => Primary key
Answer =>> Relationship
[58] This is the stage in database design where one gathers and list all the necessary fields for the database project.
(A) => Data Definition
(B) => Data Refinement
(C) => Establishing Relationship
Answer =>> Data Definition
[59] A database language concerned with the definition of the whole database structure and schema is______
(A) => DCL
(B) => DML
(C) => DDL
Answer =>> DDL
[60] Which of the field has width 8 Bytes ?
(A) => Memo
(B) => Number
(C) => Date/Time
Answer =>> Date/Time
[61] Following is not a database model
(A) => Network Database Model
(B) => Relational Database Model
(C) => None
Answer =>> None
[62] Microsoft Access is a
(A) => RDBMS
(B) => OODBMS
(C) => ORDBMS
Answer =>> RDBMS
[63] DCL provides commands to perform actions like
(A) => Change the structure of table
(B) => Insert Update or delete records and data values
(C) => Authorizing access and other control over database
Answer =>> Authorizing access and other control over database
[64] The database language that allows you to access or maintain data in a database
(A) => DCL
(B) => DML
(C) => DDL
Answer =>> DCL
[65] What is the maximum length a text field can be ?
(A) => 120
(B) => 255
(C) => 265
Answer =>> 255
[66] Which of the following is not a database object ?
(A) => Tables
(B) => Queries
(C) => Relationship
Answer =>> Relationship
[67] A _______enables you to view data from a table based on a specific criteria
(A) => Form
(B) => Query
(C) => Macro
Answer =>> Query
[68] What are the columns in a Microsoft access table called ?
(A) => Rows
(B) => Records
(C) => Fields
Answer =>> Fields
[69] Which of the following is not a type of Microsoft access database object ?
(A) => Table
(B) => Forms
(C) => Worksheets
Answer =>> Worksheets
[70] Which of the following database object hold data ?
(A) => Forms
(B) => Reports
(C) => Tables
Answer =>> Tables
[71] Which of the following store command to retrieve data from database ?
(A) => Forms
(B) => Queries
(C) => Reports
Answer =>> Queries
[72] Which of the following database object produces the final result to present ?
(A) => Forms
(B) => Reports
(C) => Queries
Answer =>> Reports
[73] Which of the following is a method to create a new table in ms-access ?
(A) => Create table in design view
(B) => Create table using wizard
(C) => All of Above
Answer =>> All of Above
[74] To create a new table, in which method you don’t need to specify the field type and size ?
(A) => Create table in design view
(B) => Create table using wizard
(C) => Create table by entering data
Answer =>> Create table by entering data
[75] When creating a new table which method can be used to choose fields from standard databases and tables ?
(A) => Create table in design view
(B) => Create table using wizard
(C) => Create table by entering data
Answer =>> Create table using wizard
[76] In table design view, which key can be used to switch between the field names and properties panel ?
(A) => F3
(B) => F4
(C) => F6
Answer =>> F6
[77] In table design view, what are the first columns of buttons used for ?
(A) => Indicate primary key
(B) => Indicate current row
(C) => Both of Above
Answer =>> Both of Above
[78] The default and maximum size of text field in access
(A) => 50 and 255 characters
(B) => 8 and 1 GB
(C) => 266 characters and 64000 characters
Answer =>> 50 and 255 characters
[79] The size of Yes No field is always
(A) => 1 Bit
(B) => 1 Byte
(C) => 1 Character
Answer =>> 1 Bit
[80] Which of the following is not a field type in access ?
(A) => Lookup wizard
(B) => Hyperlink
(C) => OLE object
Answer =>> Lookup wizard
[81] The size of a field with a number data type can not be
(A) => 2
(B) => 4
(C) => 16
Answer =>> 16
[82] Which field type will you select when creating a new table if you require to enter a long text in that field ?
(A) => Text
(B) => Memo
(C) => Currency
Answer =>> Memo
[83] Which field type can store photos ?
(A) => Hyperlink
(B) => OLE
(C) => Access table can’t store photos
Answer =>> OLE
[84] When entering field name, how many character you can type in maximum ?
(A) => 60
(B) => 64
(C) => 68
Answer =>> 64
[85] How can you define a field so that when entering data for that field it will display **** instead of actual typed text
(A) => Input mask
(B) => Validation rule
(C) => Ime mode
Answer =>> Ime mode
[86] A small button with 3 dots usually displayed at the right of field properties box
(A) => Make button
(B) => Expression button
(C) => Build button
Answer =>> Build button
[87] To sort records in a table
(A) => A. Open table, click on the field on which the sorting is to be done. Then click sort button on database toolbar.
(B) => Open table, click sort button on database toolbar, choose field based on which to sort, click OK
(C) => Click the field heading to sort it Ascending or Descending
Answer =>> A. Open table, click on the field on which the sorting is to be done. Then click sort button on database toolbar.
[88] Queries in access can be used as
(A) => View, change and analyze data in different ways
(B) => A. A source of records for forms and reports
(C) => Both A and B
Answer =>> Both A and B
[89] To create queries in access
(A) => A. You can drag and drop fields on query builders.
(B) => A. You can type the SQL command in SQL view.
(C) => All of above
Answer =>> All of above
[90] Query design window has two parts. The upper part shows
(A) => Name of field , filed type and size
(B) => Tables with fields and relationship between tables
(C) => Criteria
Answer =>> Tables with fields and relationship between tables
[91] What does the show check box in query design window indicate
(A) => A. It indicates whether the field is to be used or not.
(B) => It indicates whether the field is to be displayed in query result or not.
(C) => It indicates whether the field names to be displayed in query result or not.
Answer =>> It indicates whether the field is to be displayed in query result or not.
[92] To tables can be linked with relationship so that the data integrity can be enforced. Where can you find relationship command
(A) => File menu
(B) => View menu
(C) => Tools menu
Answer =>> Tools menu
[93] Which of the following is not a type of relationship that can be applied in access database
(A) => One to One
(B) => One to Many
(C) => D. All of Above can be applied.
Answer =>> D. All of Above can be applied.
[94] While creating relationship, when you drag a field of a field to drop into another table, the mouse pointer changes into
(A) => A doctor’s sign
(B) => Thin + sign
(C) => Outline rectangle
Answer =>> Outline rectangle
[95] What do you mean by one to many relationship between Student and Class table ?
(A) => One student can have many classes
(B) => One class may have many students
(C) => Many classes may have many students
Answer =>> One student can have many classes
[96] In One-to-Many relationship, the table in ‘one’ side is called______ and on ‘many’ side is called______
(A) => Child, Parent
(B) => Parent, Child
(C) => Brother, Sister
Answer =>> Parent, Child
[97] We can remove a relationship defined between two tables by
(A) => From edit menu choose relationship
(B) => Select the relationship line and press delete.
(C) => C. Choose delete option from relationship menu
Answer =>> Select the relationship line and press delete.
[98] If you need to edit a relationship
(A) => Right click the relationship line and choose edit relationship.
(B) => Double click the relationship line.
(C) => Both of Above
Answer =>> Both of Above
[99] If you write criteria values vertically (one in a row) it will mean
(A) => OR conditions
(B) => AND conditions
(C) => NOT conditions
Answer =>> OR conditions