Well-structured Std 11 Computer Textbook MCQ Answers and Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System can serve as a valuable review tool before computer exams.
GSEB Std 11 Computer Chapter 9 MCQ Introduction to Database Management System
Question 1.
In the current state of affairs with the arrival and reach of which technology the whole information is stored and managed by electronic method ?
(A) Micro science
(B) Rocket
(C) Digital
(D) Internet
Answer:
(C) Digital
Question 2.
In present technology almost all data is stored and manage ……………. .
(A) electronically
(B) handwritten
(C) mechanical
(D) data base
Answer:
(A) electronically
Question 3.
Day to Day transactions in small medium and large enterprises are recorded in system termed as ……………. .
(A) technology system
(B) data base system
(C) procedure system
(D) information system
Answer:
(D) information system
Question 4.
In following option, which option is an example of information system ?
(A) Search engine, reservation system
(B) Online banking, online text filling
(C) Stock trading system
(D) All of these
Answer:
(D) All of these
Question 5.
Which of the following option is true for the information system ?
(1) Users of information system are growing multifold.
(2) All of us directly or indirectly act as users of one or other information systems.
(3) Information systems today has also become a strong helping had in taking decisions.
(A) 1, 2, 3 – true
(B) 1,2, 3 – false
(C) 1,2- true, 3 – false
(D) 1,2- false, 3 – true
Answer:
(A) 1, 2, 3 – true
Question 6.
It is obvious that the perfect decision depends on the ………………. of information available.
(A) process
(B) accuracy
(C) importance
(D) progress
Answer:
(B) accuracy
Question 7.
What is information ?
(A) Input
(B) Processing
(C) Output
(D) Input/output
Answer:
(C) Output
Question 8.
Information is the output generated through processing of which ?
(A) Data
(B) Table
(C) Field
(D) Column
Answer:
(A) Data
Question 9.
The word ………………. are used interchangeably.
(A) data and column
(B) data and information
(C) data and row
(D) data and data base
Answer:
(B) data and information
Question 10.
“Raw information or Numbers” are used for ……………… .
(A) variable
(B) field
(C) data
(D) information
Answer:
(C) data
Question 11.
What is data ?
(A) Facts, figure
(B) Details related to people, places
(C) Things, events
(D) All of these
Answer:
(D) All of these
Question 12.
Data is in which form ?
(A) Oral
(B) Written
(C) Computerized and non-computerized
(D) All of these
Answer:
(D) All of these
Question 13.
Who is not much useful in its original form ?
(A) Data
(B) Information
(C) Both (A) and (B)
(D) None of these
Answer:
(A) Data
Question 14.
Who must be processed in a proper way to make information useful and meaningful ?
(A) Field
(B) Data
(C) Data base
(D) Table
Answer:
(B) Data
Question 15.
Data must be processed in a proper way to generate the useful and meaningful …………….. .
(A) information
(B) data base
(C) table
(D) field
Answer:
(A) information
Question 16.
Looking to the importance of ……………… for decision making process many business houses consider it as important asset of the business.
(A) data
(B) data base
(C) information
(D) table
Answer:
(C) information
Question 17.
Who can be describe as the required result obtained from processing of the data ?
(A) Data base
(B) Information
(C) Entity
(D) Datamodel
Answer:
(B) Information
Question 18.
Processed data is called ………………. .
(A) datamodel
(B) data base
(C) information
(D) entity
Answer:
(C) information
Question 19.
Who is important as it forms the function for decision making ?
(A) Data
(B) Data base
(C) Entity
(D) Information
Answer:
(D) Information
Question 20.
In following option which option is example of data base ?
(A) Name, address, diary containing phone no
(B) Attendance record of every students
(C) Telephone directory
(D) All of these
Answer:
(D) All of these
Question 21.
In following option, which option is example of record ?
(A) Indian gov. is issuing unique identity no. to each citizen under Adhar project.
(B) Passport office maintains details of the issued passport.
(C) Doctors maintain medical history of each patient.
(D) All of these
Answer:
(D) All of these
Question 22.
Who is a collection of related data items stored in an organized manner ?
(A) Data
(B) Data base
(C) Information
(D) Datamodel
Answer:
(B) Data base
Question 23.
In the definition of data base, which words are very important ?
(A) Related, organized
(B) Related, logical
(C) Organized, stored
(D) Organized, retrieve
Answer:
(A) Related, organized
Question 24.
Which type of arrangement of things always makes it easier for searching when required ?
(A) Related
(B) Physical
(C) Logical
(D) Relevant
Answer:
(C) Logical
Question 25.
Data base are designed according to whom ?
(A) Data
(B) User
(C) Rules
(D) Place
Answer:
(C) Rules
Question 26.
The underlying structure of data base is known as ……………. .
(A) data
(B) datamodel
(C) DBMS
(D) information
Answer:
(B) datamodel
Question 27.
Who is storing and retrieving data ?
(A) Data
(B) Datamodel
(C) DBMS
(D) Information
Answer:
(B) Datamodel
Question 28.
Datamodel describes way of …………….. .
(A) storing
(B) retrieving
(C) both (A) and (B)
(D) none of these
Answer:
(C) both (A) and (B)
Question 29.
From the following which is the type of datamodel ?
(A) Hierarchical
(B) Network
(C) Relational
(D) All of these
Answer:
(D) All of these
Question 30.
In DBMS chapter, we are discussing …………….. models.
(A) network
(B) relational
(C) hierarchical
(D) productive
Answer:
(B) relational
Question 31.
To work with computerized data base one has to first define and create a …………….. .
(A) data
(B) information
(C) data base
(D) datamodel
Answer:
(C) data base
Question 32.
For data base which basic tasks are expected to be performed regularly with as much as possible ?
(A) Adding data into database as and when transaction takes place.
(B) Editing the content of the database with the corrections required as and when noticed.
(C) Removing unnecessary data from the database if any.
(D) All of these
Answer:
(D) All of these
Question 33.
For data base which basic tasks are expected to be performed regularly with as much as possible ?
(A) Organizing the data base in a proper manner
(B) Retrieval of data as per user’s requirement.
(C) Securing data stored in data base
(D) All of these
Answer:
(D) All of these
Question 34.
For data base following basic tasks are expected to be performed regularly with as much as possible.
(A) Maintaining the backup of data base
(B) Allowing multiple users to access database simultaneously.
(C) Allowing data to be stored in multiple languages/places.
(D) All of these
Answer:
(D) All of these
Question 35.
All of the tasks related to the data base handling is known as ……………. .
(A) datamodel
(B) data base management
(C) data base
(D) datasource
Answer:
(B) data base management
Question 36.
All the tasks related to the data base handling which software is required ?
(A) Datamodel
(B) Data base model
(C) DBMS
(D) Relational management system
Answer:
(C) DBMS
Question 37.
What is the full form of DBMS ?
(A) Data Base Management System
(B) Data Base Management Solution
(C) Data Base Management Section
(D) Data Base Management Source
Answer:
(A) Data Base Management System
Question 38.
Which type of system you define as a DBMS ?
(A) Efficient storage
(B) Maintenance
(C) Retrieval of data
(D) All of these
Answer:
(D) All of these
Question 39.
Who makes data base practical and more usable ?
(A) Datamodel
(B) DBMS
(C) Data base management model
(D) Data base management source
Answer:
(B) DBMS
Question 40.
A data base is useless if there is no ……………. associated with it for accessing its data.
(A) DMBS
(B) ORACLE
(C) DBMS
(D) SQL
Answer:
(C) DBMS
Question 41.
From the following which option is an example of DBMS software ?
(A) Oracle, Ingress
(B) DB2, MS-Access
(C) MYSQL, SQL Server
(D) All of these
Answer:
(D) All of these
Question 42.
From the following which is not open source DBMS ?
(A) Oracle
(B) Ingress
(C) Base
(D) MYSQL
Answer:
(A) Oracle
Question 43.
From the following, which is open source DBMS ?
(A) MYSQL
(B) Base
(C) Ingress
(D) All of these
Answer:
(D) All of these
Question 44.
Which type of software base is ?
(A) DBMS
(B) Presentation
(C) Spreadsheet
(D) Word Processor
Answer:
(A) DBMS
Question 45.
Base is the part of …………….. officesuite.
(A) MS Office
(B) Open Office
(C) Data Office
(D) Base Office
Answer:
(B) Open Office
Question 46.
Which type of data base ‘base’ is ?
(A) Open Source
(B) Proprietary
(C) Both (A) and (B)
(D) None of these
Answer:
(A) Open Source
Question 47.
Base’, is based on which datamodel ?
(A) Network
(B) Relational
(C) Hierarchical
(D) Product base
Answer:
(B) Relational
Question 48.
Which type of system base is ?
(A) Spread sheet
(B) Presentation
(C) RDBMS
(D) Word Processor
Answer:
(C) RDBMS
Question 49.
What is the full form of RDBMS ?
(A) Relational Data base Management System
(B) Resources Data base Management System
(C) Real Data base Management System
(D) Remote Data base Management System
Answer:
(A) Relational Data base Management System
Question 50.
Base has a versatile way to organize information and store it in ……………… .
(A) table
(B) form
(C) report
(D) query
Answer:
(A) table
Question 51.
Which model is the organization of data into collections of two-dimensional tables ?
(A) Hierarchical
(B) Relational
(C) Network
(D) Product base
Answer:
(B) Relational
Question 52.
The organization of data into collections of two-dimensional tables are called …………… .
(A) row
(B) column
(C) both (A) and (B)
(D) relations
Answer:
(D) relations
Question 53.
Relational model is designed by ……………. .
(A) E. F. Codd
(B) F. E. Code
(C) I. E. Code
(D) I. F. Code
Answer:
(A) E. F. Codd
Question 54.
Relational model designed by E. F. Codd is based on the theory of ……………… .
(A) sets and relations of science
(B) sets and relations of mathematics
(C) sets and relations of binary
(D) sets and relations of data base
Answer:
(B) sets and relations of mathematics
Question 55.
RDBMS is based on which model ?
(A) Hierarchical
(B) Relational
(C) Network
(D) Product base
Answer:
(B) Relational
Question 56.
A DBMS is based on relational model called ……………… .
(A) DBMS
(B) DBSM
(C) RDBMS
(D) RDBSM
Answer:
(C) RDBMS
Question 57.
Which is the most successful data model ?
(A) Hierarchical
(B) Relational
(C) Network
(D) Product base
Answer:
(B) Relational
Question 58.
Relational model is successful because of its …………… .
(A) simplicity
(B) versatility
(C) design
(D) decision power
Answer:
(A) simplicity
Question 59.
……………… model is easy to understand the data relationship and very easy to manipulate.
(A) Hierarchical
(B) Relational
(C) Network
(D) All of these
Answer:
(B) Relational
Question 60.
Base is a collection of ……………… .
(A) related data objects
(B) related data applications
(C) related field objects
(D) related entity objects
Answer:
(A) related data objects
Question 61.
From the following which data object is based on base ?
(A) Table
(B) Query
(C) Form and reports
(D) All of these
Answer:
(D) All of these
Question 62.
In base table, form, query and report are known as …………… .
(A) data entity
(B) data object
(C) data application
(D) data modules
Answer:
(B) data object
Question 63.
In database icon displays …………… object.
(A) tables
(B) forms
(C) reports
(D) queries
Answer:
(A) tables
Question 64.
In database icon displays …………… object.
(A) tables
(B) forms
(C) reports
(D) queries
Answer:
(D) queries
Question 65.
In database icon displays …………… object.
(A) tables
(B) forms
(C) reports
(D) queries
Answer:
(B) forms
Question 66.
In database icon displays …………… object.
(A) tables
(B) forms
(C) reports
(D) queries
Answer:
(C) reports
Question 67.
What is the important factor to store data in base data base ?
(A) Table
(B) Form
(C) Report
(D) Query
Answer:
(A) Table
Question 68.
Tables are organized in the form of …………….. .
(A) column and field
(B) column and row
(C) row and attribute
(D) row and entity
Answer:
(B) column and row
Question 69.
What is column ?
(A) Column
(B) Row
(C) Entity
(D) Attribute
Answer:
(A) Column
Question 70.
What is row ?
(A) Column
(B) Row
(C) Entity
(D) Attribute
Answer:
(B) Row
Question 71.
Which thing does the database designer has to put in mind while making table ?
(A) Which information is to be stored
(B) Column titles
(C) Decide entities in data base
(D) All of these
Answer:
(D) All of these
Question 72.
………….. are real world objects about which information is to be stored in data base.
(A) Attribute
(B) Field
(C) Entity
(D) Record
Answer:
(C) Entity
Question 73.
Entities are real world ………….. .
(A) table
(B) object
(C) record
(D) field
Answer:
(B) object
Question 74.
Information of objects are to be stored in ……………… .
(A) data base
(B) system
(C) field
(D) attribute
Answer:
(A) data base
Question 75.
Each entity generally has collection of ……………. .
(A) attribute
(B) data base
(C) object
(D) row
Answer:
(A) attribute
Question 76.
Attributes of an entity are represented in the form of ……………… .
(A) row
(B) column
(C) cell
(D) any one
Answer:
(B) column
Question 77.
Which option displays a name of field ?
Rno | Name | City |
1 | Tejas Thakkar | Ahmedabad |
(A) Rno, Name, City
(B) 1, Tejas Thakkar, Ahmedabad
(C) Both (A) and (B)
(D) None of these
Answer:
(A) Rno, Name, City
Question 78.
Which option displays a record in a table ?
Rno | Name | City |
1 | Tejas Thakkar | Ahmedabad |
(A) Rno, Name, City
(B) 1, Tejas Thakkar, Ahmedabad
(C) Both (A) and (B)
(D) None of these
Answer:
(B) 1, Tejas Thakkar, Ahmedabad
Question 79.
Attributes of an entity are also termed as …………… .
(A) field
(B) record
(C) table
(D) data base
Answer:
(A) field
Question 80.
Collection of all fields forms a …………… .
(A) column
(B) record
(C) entity
(D) attribute
Answer:
(B) record
Question 81.
Which work is needed to do in table ?
(A) Entering new record
(B) Editing or deleting existing data
(C) See the record in table
(D) All of these
Answer:
(D) All of these
Question 82.
Which is an example of object ?
(A) Field
(B) Row
(C) Form
(D) Frame
Answer:
(C) Form
Question 83.
Which facility is provided by form ?
(A) Entering data in table
(B) Editing data
(C) Deleting data
(D) All of these
Answer:
(D) All of these
Question 84.
Form consists of which widgets ?
(A) Format
(B) Slide
(C) Radio button and list box
(D) All of these
Answer:
(D) All of these
Question 85.
…………….. help In providing easy and systematic way to populate table with data.
(A) Table
(B) Widgets
(C) Data base
(D) Query
Answer:
(B) Widgets
Question 86.
A questions asked within the data base environment is known as …………….. .
(A) query
(B) entity
(C) attribute
(D) information
Answer:
(A) query
Question 87.
……………. displays subset of data contained in various tables at a data base.
(A) Form
(B) Report
(C) Query
(D) Macro
Answer:
(C) Query
Question 88.
On whom you will process to get information ?
(A) Data
(B) Data base
(C) Table
(D) Field
Answer:
(A) Data
Question 89.
Which facility is given in Base for attractive output ?
(A) table
(B) form
(C) query
(D) report
Answer:
(D) report
Question 90.
The presentation of information in an organized and readable format as per the uses requirement is known as ……………. .
(A) report
(B) query
(C) form
(D) table
Answer:
(A) report
Question 91.
…………….. can help in taking decisions by management in organizations.
(A) Query
(B) Table
(C) Report
(D) Form
Answer:
(C) Report
Question 92.
How many steps are available for creating data base ?
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(C) 4
Question 93.
Which option is display to create a data base ?
(A) Decide entity and than decide attribute
(B) Decide data type regarding field
(C) Decide key-field for table
(D) All of these
Answer:
(D) All of these
Question 94.
Which is the first step for preparing a data base ?
(A) Decide data type according to the field
(B) Decide key-field for table
(C) Decide entity of table design
(D) Decide attribute for entity
Answer:
(C) Decide entity of table design
Question 95.
Which is the second step for preparing a data base ?
(A) Decide data type according to the field
(B) Decide key-field for table
(C) Decide entity of table design
(D) Decide attribute for entity
Answer:
(D) Decide attribute for entity
Question 96.
Which is the third step for preparing a data base ?
(A) Decide data type according to the field
(B) Decide key-field for table
(C) Decide entity of table design
(D) Decide attribute for entity
Answer:
(A) Decide data type according to the field
Question 97.
Which is the fourth step for preparing a data base ?
(A) Decide data type according to the field
(B) Decide key-field for table
(C) Decide entity of table design
(D) Decide attribute for entity
Answer:
(B) Decide key-field for table
Question 98.
Product, Suppliers, Employees and Customers are known as ………….. in data base.
(A) entity
(B) form
(C) field
(D) key-field
Answer:
(A) entity
Question 99.
In which step you are decided to design entity and table in data base ?
(A) 1
(B) 2
(C) 3
(D) 4
Answer:
(A) 1
Question 100.
Entities can be defined as any ……………. .
(A) person
(B) thing
(C) place
(D) all of these
Answer:
(D) all of these
Question 101.
How many table design you should made for each entity ?
(A) Only one
(B) Fix
(C) Separate
(D) Any one of these
Answer:
(C) Separate
Question 102.
In which step of data base the attribute for entity is decided ?
(A) 1
(B) 2
(C) 3
(D) 4
Answer:
(B) 2
Question 103.
Attributes can be defined as characteristics of an ……………… .
(A) table
(B) key-field
(C) entity
(D) form
Answer:
(C) entity
Question 104.
Which option is used for name in data base ?
(A) Logical name
(B) Physical name
(C) Both (A) and (B)
(D) None of these
Answer:
(C) Both (A) and (B)
Question 105.
The name actually used in the internal structure of our tables is called as …………….. .
(A) logical name
(B) physical name
(C) both (A) and (B)
(D) none of these
Answer:
(B) physical name
Question 106.
……………. names are used at the time of desiging the data model.
(A) Logical name
(B) Physical name
(C) Both (A) and (B)
(D) None of these
Answer:
(A) Logical name
Question 107.
What is First Name in data base ?
(A) Field name
(B) Data entity
(C) Both (A) and (B)
(D) None of these
Answer:
(C) Both (A) and (B)
Question 108.
In the data base application would only accept ……………. .
(A) FName
(B) first_name
(C) FIRST NAME
(D) all of these
Answer:
(D) all of these
Question 109.
Start all attributes name with ……………. in data base.
(A) letter
(B) number
(C) underscore
(D) any one
Answer:
(A) letter
Question 110.
In data base subsequent characters use either ……………… .
(A) letter
(B) number
(C) underscore
(D) all of these
Answer:
(D) all of these
Question 111.
In data base, do not use ……………….. between word of attribute.
(A) space
(B) underscore
(C) both (A) and (B)
(D) none of these
Answer:
(A) space
Question 112.
In data base, use a …………….. between word of attributes.
(A) space
(B) underscore
(C) both (A) and (B)
(D) none of these
Answer:
(B) underscore
Question 113.
In data base, do not use special character except …………… .
(A) underscore (_)
(B) dash (-)
(C) hash (#)
(D) question mark ( ? )
Answer:
(A) underscore (_)
Question 114.
Use …………… if needed, to keep the length of attribute name short in data base.
(A) meaningful form
(B) short form
(C) abbreviations
(D) long form
Answer:
(C) abbreviations
Question 115.
Which option is used for camel back ?
(A) FIRSTNAME
(B) FirstName
(C) firstname
(D) fIRSTnAME
Answer:
(B) FirstName
Question 116.
In camel back each word in field name starts with ………….. .
(A) capital
(B) small
(C) (A) or (B)
(D) symbol
Answer:
(A) capital
Question 117.
In which step of data base data type is decided ?
(A) 1
(B) 2
(C) 3
(D) 4
Answer:
(C) 3
Question 118.
We need to decide data type of each field while …………… .
(A) before creating table
(B) designing the table
(C) after creating table
(D) any one
Answer:
(B) designing the table
Question 119.
……………. is a way to define storage structure of the field.
(A) Field Name
(B) Data Type
(C) Description
(D) Field Properties
Answer:
(B) Data Type
Question 120.
How many types are there of storing data in computer ?
(A) 2
(B) 4
(C) 6
(D) different way (many)
Answer:
(D) different way (many)
Question 121.
Base data type be presented with a …………… of options asking as to choose the kind of attribute want to store.
(A) drop down menu
(B) check box
(C) radio button
(D) list box
Answer:
(A) drop down menu
Question 122.
The choice of data type will affect the performance of the ……………. .
(A) object
(B) data base
(C) entity
(D) attribute
Answer:
(B) data base
Question 123.
Data type available in base can be divided in …………….. category.
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(B) 3
Question 124.
How many data types are available in base ?
(A) 14
(B) 17
(C) 21
(D) 27
Answer:
(C) 21
Question 125.
Which of the following option display a type of data type ?
(A) Alphanumeric type
(B) Calendar type
(C) Binary type
(D) All of these
Answer:
(D) All of these
Question 126.
To enter which type of information data type is used ?
(A) Letter
(B) Number
(C) Special character
(D) all of these
Answer:
(D) all of these
Question 127.
In base, how many data type are there in alphanumeric type ?
(A) 4
(B) 6
(C) 8
(D) 12
Answer:
(A) 4
Question 128.
Which of the following option display data type of alphanumeric type ?
(A) Text (fix) [CHAR], Text [VARCHAR]
(B) Text [VARCHAR_IGNORECASE]
(C) Memo [LONGVARCHAR]
(D) All of these
Answer:
(D) All of these
Question 129.
Which type of information is available in Address field ?
(A) Alphabets
(B) Special character
(C) Number
(D) Any one of these
Answer:
(D) Any one of these
Question 130.
Which type is suitable for Address field ?
(A) Alphanumeric type
(B) Calendar type
(C) Binary type
(D) All of these
Answer:
(A) Alphanumeric type
Question 131.
Which data type is suitable for Address field ?
(A) Text (fix) [CHAR]
(B) Text [VARCHAR]
(C) Text [INTGER]
(D) Any one of these
Answer:
(B) Text [VARCHAR]
Question 132.
The name of …………… to be allocated to varchar data type depends on the number of character entered by the user.
(A) field
(B) data
(C) size
(D) bytes
Answer:
(D) bytes
Question 133.
Which form is used for memo data type ?
(A) Char
(B) VarChar
(C) Long VarChar
(D) VarChar IgnoreCase
Answer:
(C) Long VarChar
Question 134.
Maximum storage capacity of memo data type is ……………. .
(A) 1 GB
(B) 2 GB
(C) 3 GB
(D) 4 GB
Answer:
(B) 2 GB
Question 135.
Which data type is used for stores up to the maximum length of number indicated by user ?
(A) Memo
(B) Number
(C) Currency
(D) Text
Answer:
(A) Memo
Question 136.
Memo data type accepts ………….. character.
(A) UTF-4
(B) UTF-8
(C) UTF-16
(D) UTF-24
Answer:
(B) UTF-8
Question 137.
What is the full form of UTF ?
(A) Unicode Transformation Format
(B) Unicode Transaction Format
(C) Unicode Timeline Format
(D) Unicode Transform Format
Answer:
(A) Unicode Transformation Format
Question 138.
Which type of data type is used for storing exactly the length specified by user ?
(A) Text [VARCHAR]
(B) Text [VARCHAR_IGNORECASE]
(C) Text (fix) [CHAR]
(D) Memo [LONGVARCHAR]
Answer:
(C) Text (fix) [CHAR]
Question 139.
Which of the following data type is used for spaces for shorties strings ?
(A) Text [VARCHAR]
(B) Text [VARCHARJGNORECASE]
(C) Text (fix) [CHAR]
(D) All of these
Answer:
(C) Text (fix) [CHAR]
Question 140.
Maximum storage capacity of Text (fix) [CHAR] data type is …………… .
(A) 1 GB
(B) 2 GB
(C) 3 GB
(D) 4 GB
Answer:
(B) 2 GB
Question 141.
Text (fix) [CHAR] data type accept which type of character ?
(A) UTF-4
(B) UTF-8
(C) UTF-16
(D) UTF-24
Answer:
(B) UTF-8
Question 142.
Which type of data type is used for storing up to the specified length ?
(A) Text [VARCHAR]
(B) Text (fix) [CHAR]
(C) Memo [LONGVARCHAR]
(D) All of these
Answer:
(A) Text [VARCHAR]
Question 143.
Which data type does not add empty space ?
(A) Text [VARCHAR]
(B) Memo [LONGVARCHAR]
(C) Both (A) and (B)
(D) Text (fix) [CHAR]
Answer:
(C) Both (A) and (B)
Question 144.
Maximum storage capacity of Text [VARCHAR] data type is …………….. .
(A) 1 GB
(B) 2 GB
(C) 3 GB
(D) 4 GB
Answer:
(B) 2 GB
Question 145.
Which data type is use for storing up to the specified length ?
(A) Text [VARCHAR_IGNORECASE]
(B) Text (fix) [CHAR]
(C) Memo [LONGVARCHAR]
(D) Both (A) and (B)
Answer:
(A) Text [VARCHAR_IGNORECASE]
Question 146.
Which of the following data type comparison are not case sensitive and stores capital as you type them ?
(A) Text (fix) [CHAR]
(B) Text [VARCHAR]
(C) Text [VARCHAR_IGNORECASE]
(D) All of these
Answer:
(C) Text [VARCHAR_IGNORECASE]
Question 147.
Maximum storage capacity of Text [VARCHAR_IGNORECASE] data type is …………….. .
(A) 1 GB
(B) 2 GB
(C) 3 GB
(D) 4 GB
Answer:
(B) 2 GB
Question 148.
Which data type is used to store descriptive data ?
(A) Text (fix) [CHAR]
(B) Text [VARCHAR]
(C) Text [VARCHAR_IGNORECASE]
(D) Memo [LONGVARCHAR]
Answer:
(D) Memo [LONGVARCHAR]
Question 149.
In the following data type more than ……………. characters are there then memo data type is used.
(A) 64
(B) 124
(C) 255
(D) 64000
Answer:
(C) 255
Question 150.
Memo data type allows us to store text data up to ………….. characters.
(A) 64
(B) 124
(C) 255
(D) 64000
Answer:
(D) 64000
Question 151.
…………….. is efficient when the fields are used for searching and it is unsure that whether user will enter searching text in lower case or upper case.
(A) Text (fix) [CHAR]
(B) Text [VARCHAR]
(C) Text [VARCHAR_IGNORECASE]
(D) Memo [LONGVARCHAR]
Answer:
(C) Text [VARCHAR_IGNORECASE]
Question 152.
First name or last name of person can be stored in …………….. .
(A) Text (fix) [CHAR]
(B) Text [VARCHAR]
(C) Text [VARCHAR_IGNORECASE]
(D) Memo [LONGVARCHAR]
Answer:
(C) Text [VARCHAR_IGNORECASE]
Question 153.
How many types are there for storing alphanumeric character ?
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(B) 3
Question 154.
Which type is useful for storing alphanumeric character ?
(A) ASCII
(B) Unicode
(C) UTF
(D) All of these
Answer:
(D) All of these
Question 155.
What is the full form of ASCII ?
(A) American Standard Code for Information Interchange
(B) American Standard Code for Interchange Information
(C) American Standard Code for International Interchange
(D) American Standard Code for Information Interchange
Answer:
(A) American Standard Code for Information Interchange
Question 156.
ASCH code needs only ………………. byte to store a character.
(A) 1
(B) 4
(C) 8
(D) 16
Answer:
(A) 1
Question 157.
In ASCII code the no. of possible character that can be stored is only …………….. .
(A) 24
(B) 34
(C) 256
(D) 64000
Answer:
(C) 256
Question 158.
Which type of character set Gujarati and Hindi are ?
(A) Extra character set
(B) Executable character set
(C) Average character set
(D) Extended character set
Answer:
(D) Extended character set
Question 159.
Which of the following code uses more bytes per character ?
(A) ASCII
(B) Unicode
(C) Both (A) and (B)
(D) None of these
Answer:
(B) Unicode
Question 160.
Base stores alphanumeric characters using ………….. .
(A) ASCII
(B) Unicode
(C) UTF-8
(D) All of these
Answer:
(C) UTF-8
Question 161.
UTF-8 is compatible with both ………….. .
(A) ASCII
(B) Unicode
(C) Both (A) and (B)
(D) None of these
Answer:
(C) Both (A) and (B)
Question 162.
Base use …………….. bytes for each character according to internal calculations.
(A) zero
(B) one
(C) one or more
(D) all of these
Answer:
(C) one or more
Question 163.
How much bytes are used by field is decided by whom ?
(A) Users
(B) Administrator
(C) Software
(D) All of these
Answer:
(C) Software
Question 164.
…………… type is used to store numerical information.
(A) Alphabetic type
(B) Numeric type
(C) Binary type
(D) Calendar type
Answer:
(B) Numeric type
Question 165.
…………….. type is used to store numerical information like marks of a student, salary of employee, quantity on hand or balance in the bank account of person.
(A) Alphabetic type
(B) Numeric type
(C) Binary type
(D) Calendar type
Answer:
(B) Numeric type
Question 166.
Numeric data type attributes are described by the …………….. .
(A) binary value
(B) signed
(C) unsigned
(D) all of these
Answer:
(D) all of these
Question 167.
How many numeric types are data type available in data type in Base ?
(A) 4
(B) 8
(C) 10
(D) 14
Answer:
(C) 10
Question 168.
From the following which option generates a numeric data type ?
(A) Integer, Small Integer, Big Integer, Tyny Integer
(B) Number, Decimal, Real, Float, Double
(C) Yes/No (Boolean)
(D) All of these
Answer:
(D) All of these
Question 169.
……………. no. consumes the least memory.
(A) Tyny Integer
(B) Small Integer
(C) Yes/No (Boolean)
(D) Decimal
Answer:
(C) Yes/No (Boolean)
Question 170.
How many bit uses boolean number ?
(A) 1
(B) 2
(C) 4
(D) 8
Answer:
(A) 1
Question 171.
………….. can be stored as yes/no type of data.
(A) Tyny Integer
(B) Small Integer
(C) Yes/No (Boolean)
(D) Decimal
Answer:
(C) Yes/No (Boolean)
Question 172.
……………. number stores numbers that have decimal places.
(A) Boolean numbers
(B) Floating point numbers
(C) Integer point numbers
(D) Small integer numbers
Answer:
(B) Floating point numbers
Question 173.
Which data type use maximum memory ?
(A) Boolean numbers
(B) Floating point numbers
(C) Integer point numbers
(D) Small integer numbers
Answer:
(B) Floating point numbers
Question 174.
…………….. are the only ones that can perform divisions with good accuracy.
(A) Boolean numbers
(B) Floating point numbers
(C) Integer point numbers
(D) Small integer numbers
Answer:
(B) Floating point numbers
Question 175.
How much range of Yes/No [Boolean] type data type ?
(A) 1 Bit
(B) 1 Byte
(C) 2 Bytes
(D) 4 Bytes
Answer:
(A) 1 Bit
Question 176.
What is the range of Yes/No [Boolean] type data type ?
(A) 0 and 1
(B) 0 to 255
(C) -32768 to 32768
(D) -2.14 × 109 to 2.14 × 109
Answer:
(A) 0 and 1
Question 177.
How much size does Tiny Integer [TINYINT] data type consists ?
(A) 1 Bit
(B) 1 Byte
(C) 2 Byte
(D) 4 Byte
Answer:
(B) 1 Byte
Question 178.
What is the range of Tiny Integer [TINYINT] type of data type ?
(A) 0 and 1
(B) 0 to 255
(C) -32768 to 32768
(D) -2.14 × 109 to 2.14 × 109
Answer:
(B) 0 to 255
Question 179.
How much size does Small Integer [SMALLINT] type of data type consist ?
(A) 1 Bit
(B) 1 Byte
(C) 2 Byte
(D) 4 Byte
Answer:
(C) 2 Byte
Question 180.
What is the range of Small Integer [SMALLINT] type of data type ?
(A) 0 and 1
(B) 0 to 255
(C) -32768 to 32768
(D) -2.14 × 109 to 2.14 × 109
Answer:
(C) -32768 to 32768
Question 181.
How much size does Integer [INTEGER] type of data type consists ?
(A) 1 Bit
(B) 1 Byte
(C) 2 Bytes
(D) 4 Bytes
Answer:
(A) 1 Bit
Question 182.
Does Integer [INTEGER] type of data type consist of signed or not ?
(A) Yes
(B) No
(C) (A) or (B)
(D) Can’t say
Answer:
(A) Yes
Question 183.
What is the range of Integer [INTEGER] type of data type ?
(A) 0 and 1
(B) 0 to 255
(C) -32768 to 32768
(D) -2.14 × 109 to 2.14 × 109
Answer:
(D) -2.14 × 109 to 2.14 × 109
Question 184.
How much size does Biglnt [BIGING] type of data type consist ?
(A) 2 Byte
(B) 4 Byte
(C) 8 Byte
(D) Unlimited
Answer:
(C) 8 Byte
Question 185.
What is the range of BigInt[BIGING] type of
data type ?
(A) -2.14 × 109 to 2.14 × 109
(B) -2.3 × 1018 to 2.3 × 1018
(C) 5.10 × 10-324 to 1.79 × 10308
(D) Unlimited
Answer:
(B) -2.3 × 1018 to 2.3 × 1018
Question 186.
What is the size of Number [NUMERIC] type of data type ?
(A) 2 Bytes
(B) 4 Bytes
(C) 8 Bytes
(D) Unlimited
Answer:
(D) Unlimited
Question 187.
What is the range of Number [NUMERIC] type of data type ?
(A) -2.14 × 109 to 2.14 × 109
(B) -2.3 × 1018 to 2.3 × 1018
(C) -5.10 × 10-324 to 1.79 × 10308
(D) Unlimited
Answer:
(D) Unlimited
Question 188.
How much size does Decimal [DECIMAL] type of data type consists ?
(A) 2 Bytes
(B) 4 Bytes
(C) 8 Bytes
(D) Unlimited
Answer:
(D) Unlimited
Question 189.
What is the range of Decimal [DECIMAL] type of data type ?
(A) -2.14 × 109 to 2.14 × 109
(B) -2.3 × 1018 to 2.3 × 1018
(C) 5.10 × 10-324 to 1.79 × 10308
(D) Unlimited
Answer:
(D) Unlimited
Question 190.
How much size does Real [REAL] type of data type consist ?
(A) 2 Bytes
(B) 4 Bytes
(C) 8 Bytes
(D) Unlimited
Answer:
(B) 4 Bytes
Question 191.
Which is the range of Real [REAL] type of data type ?
(A) -2.14 × 109 to 2.14 × 109
(B) -2.3 × 1018 to 2.3 × 1018
(C) 5.10 × 10-324 to 1.79 × 10308
(D) Unlimited
Answer:
(C) 5.10 × 10-324 to 1.79 × 10308
Question 192.
How many data types are there in calendar in Base ?
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(B) 3
Question 193.
Which option display calendar type data type ?
(A) Date [DATE]
(B) Time [TIME]
(C) Date[TIMESTAMP]
(D) All of these
Answer:
(D) All of these
Question 194.
Which type of data type is used for date type of information ?
(A) Date [DATE]
(B) Time [TIME]
(C) Date [TIMESTAMP]
(D) All of these
Answer:
(A) Date [DATE]
Question 195.
Which type of data type is used for time type of information ?
(A) Date [DATE]
(B) Time [TIME]
(C) Date [TIMESTAMP]
(D) All of these
Answer:
(B) Time [TIME]
Question 196.
……………. type of attribute is used for recording of both time and date.
(A) Date [DATE]
(B) Time [TIME]
(C) Date [TIMESTAMP]
(D) All of these
Answer:
(C) Date [TIMESTAMP]
Question 197.
Which type of information is stored in calendar type of data type ?
(A) Year, month, day
(B) Hour, minute, second
(C) Both (A) and (B)
(D) None of these
Answer:
(C) Both (A) and (B)
Question 198.
Date type attributes allows storing year, month and day as it is stored in ……………. .
(A) base
(B) system
(C) application
(D) administrator
Answer:
(B) system
Question 199.
Generally date type attributes in base are stored in …………… form.
(A) mm/dd/yy
(B) yy/mm/dd
(C) dd/mm/yy
(D) dd/yy/mm
Answer:
(A) mm/dd/yy
Question 200.
Time type attribute in base are stored in …………… form.
(A) hh:ss:mm
(B) mm:ss:hh
(C) hh:mm:ss
(D) ss:mm:hh
Answer:
(C) hh:mm:ss
Question 201.
……………. type of attribute is used for recording of both time and day of an event.
(A) Date [DATE]
(B) Date [TIMESTAMP]
(C) Time [TIME]
(D) All of these
Answer:
(B) Date [TIMESTAMP]
Question 202.
Which type of data type is used for joining date and birthdate ?
(A) Date [DATE]
(B) Date [TIMESTAMP]
(C) Time [TIME]
(D) All of these
Answer:
(A) Date [DATE]
Question 203.
Which type of data type is used for InTime and OutTime ?
(A) Date [DATE]
(B) Date [TIMESTAMP]
(C) Time [TIME]
(D) All of these
Answer:
(C) Time [TIME]
Question 204.
How many data types are available in binary type in base ?
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(B) 3
Question 205.
Which option display a data type of binary type ?
(A) Image [LONGVARBINARY]
(B) Binary [VARBINARY]
(C) Binary (fix) [BINARY]
(D) All of these
Answer:
(D) All of these
Question 206.
Which data type is used for storing digital images and sound ?
(A) Image [LONGVARBINARY]
(B) Binary [VARBINARY]
(C) Binary (fix) [BINARY]
(D) All of these
Answer:
(A) Image [LONGVARBINARY]
Question 207.
How much is the storage capacity of Image [LONGVARBINARY], Binary [VARBINARY], Binary (fix) [BINARY] data type ?
(A) 1 GB
(B) 2 GB
(C) 3 GB
(D) 4 GB
Answer:
(B) 2 GB
Question 208.
……………. attributes can store any information that comes as a long string of zeros and ones.
(A) Alphanumeric type
(B) Numeric type
(C) Binary type
(D) Calendar type
Answer:
(C) Binary type
Question 209.
Which forms are distinguished by the computer ?
(A) Analog picture, digital sound
(B) Digital picture, analog sound
(C) Digital picture, digital sound
(D) Analog picture, analog sound
Answer:
(C) Digital picture, digital sound
Question 210.
Which type of file are image and sound they are distinguished by ?
(A) Initial zero and one
(B) Middle zero and one
(C) Ending zero and one
(D) Any one of these
Answer:
(A) Initial zero and one
Question 211.
Which is the fourth step of making data base ?
(A) Decide data type of field
(B) Decide a key-field of the table
(C) Entity (table design) decide
(D) Decide entity for attribute
Answer:
(B) Decide a key-field of the table
Question 212.
In which step of data base does the key-field of the table is decided ?
(A) 1
(B) 2
(C) 3
(D) 4
Answer:
(D) 4
Question 213.
…………… can identify each record of a table uniquely.
(A) Master field
(B) Data base field
(C) Key-field
(D) Model field
Answer:
(C) Key-field
Question 214.
Each table should contain at least ……………. type of field.
(A) extra ordinary
(B) infinite
(C) unique
(D) all of these
Answer:
(D) all of these
Question 215.
What is the reason to keep a field extra-ordinary/unique in table ?
(A) Identify data base uniquely
(B) Identify table uniquely
(C) Identify record uniquely
(D) Identify field uniquely
Answer:
(C) Identify record uniquely
Question 216.
In terms of data base or combination of fields capable of identifying each record uniquely is known as …………… .
(A) primary key
(B) master key
(C) unique key
(D) data base key
Answer:
(A) primary key
Question 217.
Primary key values can not contain …………….. .
(A) null value
(B) duplicate
(C) both (A) and (B)
(D) none of these
Answer:
(C) both (A) and (B)
Question 218.
Particular attribute may or may not contain any values are known as ……………….. .
(A) not value
(B) null value
(C) none value
(D) no value
Answer:
(B) null value
Question 219.
What is null value ?
(A) Unknown value
(B) Absent value
(C) Missing value
(D) All of these
Answer:
(D) All of these
Question 220.
How many reasons are available for null value in attribute ?
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(A) 2
Question 221.
Which option displayed reason of having null value in attributes ?
(A) User does not know its price
(B) Attribute does not consists of any value
(C) Both (A) and (B)
(D) None of these
Answer:
(C) Both (A) and (B)
Question 222.
A table can not have primary key more than ……………. .
(A) one
(B) two
(C) more than one
(D) unlimited
Answer:
(A) one
Question 223.
The combination of more than one field can serve as primary key, which is known as …………….. .
(A) master primary key
(B) data base primary key
(C) composite primary key
(D) joint primary key
Answer:
(C) composite primary key
Question 224.
To start Base select ……………. .
(A) Application → Office → Base
(B) Application → OpenOffice → Base
(C) Application → Office → OpenOffice.org 3.2 Base
(D) Application → OpenOffice → OpenOffice.org 3.2 Base
Answer:
(C) Application → Office → OpenOffice.org 3.2 Base
Question 225.
How many steps you can see while you start base → opening screen data base window ?
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(A) 2
Question 226.
Which option display step for creating a data base ?
(A) Select data base
(B) Save and Proceed
(C) Both (A) and (B)
(D) None of these
Answer:
(C) Both (A) and (B)
Question 227.
Which option is shown in Data base Wizard→ Select data base ?
(A) Create a new data base
(B) Open an existing data base file
(C) Both (A) and (B)
(D) None of these
Answer:
(C) Both (A) and (B)
Question 228.
Which process you can do in step of Data base Wizard → Save and Proceed ?
(A) To register data base
(B) To open data base in editing mode
(C) To create a table with the help of table wizard
(D) All of these
Answer:
(D) All of these
Question 229.
Base is given to register data base on which site ?
(A) www.OpenOffice.com
(B) www.OpenOffice.org
(C) www.OpenOffice.in
(D) www.OpenOffice.edu
Answer:
(B) www.OpenOffice.org
Question 230.
What is the website of OpenOffice ?
(A) www.OpenOffice.com
(B) www.OpenOffice.org
(C) www.OpenOffice.in
(D) www.OpenOffice.edu
Answer:
(B) www.OpenOffice.org
Question 231.
If you don’t want to become a data base universal, which option can you select in Save and Proceed ?
(A) No, do not register the data base
(B) No, do not register the data base for me
(C) No, do not register the data base for public
(D) No, do not register the data base for us
Answer:
(A) No, do not register the data base
Question 232.
How many option are there in data base of Base for creating a table ?
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(A) 2
Question 233.
In the following option, which option is shown for creating table in Base → Data base Wizard ?
(A) Design View
(B) Table Wizard
(C) Both (A) and (B)
(D) None of these
Answer:
(C) Both (A) and (B)
Question 234.
If you want to save the data base in save dialog box, which name is shown as default ?
(A) Table Data base
(B) New data base
(C) Master data base
(D) Data basel
Answer:
(B) New data base
Question 235.
Which the default extension of base for data base file ?
(A) .odb
(B) .odt
(C) .odp
(D) .odg
Answer:
(A) .odb
Question 236.
How many steps are available for creating a table using Table Wizard ?
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(C) 4
Question 237.
In the following, which option display a step for creating a table using Table Wizard ?
(A) Select fields
(B) Set types and formats, Set primary key
(C) Create table
(D) All of these
Answer:
(D) All of these
Question 238.
Which is the first step for creating a table using Table Wizard ?
(A) Select fields
(B) Set primary key
(C) Create table
(D) Set types and formats
Answer:
(A) Select fields
Question 239.
In to how many categories does different types of tables are divided in table wizard ?
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(A) 2
Question 240.
Which option displays the category of different tables in table wizard ?
(A) Personal, Company
(B) Personal, Private
(C) Business, Personal
(D) Business, Private
Answer:
(C) Business, Personal
Question 241.
Which of the following table is shown in business category of table wizard ?
(A) Tasks, Assets, Expenses, Contacts
(B) Invoices, Payments, Products
(C) Customers, Employees, Suppliers
(D) All of these
Answer:
(D) All of these
Question 242.
Which of the following table is shown in personal category of table wizard ?
(A) Plants, Library, CDCollection, DVDCollection
(B) Recipes, Author, Accounts, Address
(C) Categories, Investment, Photograph
(D) All of these
Answer:
(D) All of these
Question 243.
Click on …………….. button to select all the field that are visible under available field list.
Answer:
Question 244.
Fields in available alternatively one can hold the control key and select only the desired fields one by one one the selection is done click button.
(A) Ctrl
(B) Alt
(C) Shift
(D) Tab
Answer:
(A) Ctrl
Question 245.
If you click on finish button in table wizard table is open in which view ?
(A) Design View
(B) Data type View
(C) Data View
(D) Data base View
Answer:
(C) Data View
Question 246.
How many objects are seen in main data base ?
(A) 3
(B) 4
(C) 5
(D) 6
Answer:
(B) 4
Question 247.
Which object is shown in main window of data base ?
(A) Tables, Queries
(B) Forms, Reports
(C) Macros, Moduls
(D) Both (A) and (B)
Answer:
(D) Both (A) and (B)
Question 248.
Data base object are shown in which side of data base main window ?
(A) Left side
(B) Right side
(C) Up side
(D) Down side
Answer:
(A) Left side
Question 249.
Which object is selected as default in base ?
(A) Forms
(B) Tables
(C) Queries
(D) Reports
Answer:
(B) Tables
Question 250.
If you want to see or edit details of table, then on which option will you click on …………….. .
(A) Edit
(B) Format
(C) Display
(D) View
Answer:
(A) Edit
Question 251.
Right click on table select edit option table will open in which view ?
(A) Data view
(B) Data base view
(C) Design view
(D) Editable view
Answer:
(C) Design view
Question 252.
How many variables are associated with variables to define ‘Field’ of ‘Design View1 in table ?
(A) 3
(B) 4
(C) 5
(D) 6
Answer:
(B) 4
Question 253.
Which option display a for define field in table design view ?
(A) Field Name, Field View
(B) Description
(C) Field Property
(D) All of these
Answer:
(D) All of these
Question 254.
Which option is given field name a facility in design view of table ?
(A) Field Name
(B) Description
(C) Field Type
(D) Field Property
Answer:
(A) Field Name
Question 255.
Which option gives facility of field data type in design view table ?
(A) Field Name
(B) Description
(C) Field Type
(D) Field Property
Answer:
(C) Field Type
Question 256.
Which option gives facility to write description for field in table design view ?
(A) Field Name
(B) Description
(C) Field Type
(D) Field Property
Answer:
(B) Description
Question 257.
Which option gives facility to control and validation on field in table design view ?
(A) Field Name
(B) Description
(C) Field Type
(D) Field Property
Answer:
(D) Field Property
Question 258.
Which option is optional in design view of table wizard ?
(A) Field Name
(B) Description
(C) Field Type
(D) All of these
Answer:
(B) Description
Question 259.
Which option of table wizard in Design View is helpful in understanding the purpose of field and of users ?
(A) Description
(B) Field Name
(C) Field Type
(D) Field Property
Answer:
(A) Description
Question 260.
If you want to delete or move the object in Base right-click the object icon and click on ……………. option.
(A) Remove
(B) Erase
(C) Delete
(D) Cancel
Answer:
(C) Delete
Question 261.
To create a table its easy in …………….. .
(A) table Wizard
(B) design view
(C) both (A) and (B)
(D) none of these
Answer:
(B) design view
Question 262.
How many option is given in main window to create table in task pen ?
(A) 2
(B) 3
(C) 4
(D) 5
Answer:
(A) 2
Question 263.
In the following, which option is useful to create a table ?
(A) Create Table in Design View
(B) Use Wizard to Create Table
(C) Both (A) and (B)
(D) None of these
Answer:
(C) Both (A) and (B)
Question 264.
How many column are there in design view of table ?
(A) 3
(B) 4
(C) 5
(D) 6
Answer:
(A) 3
Question 265.
Which column is shown from design view of table ?
(A) Field Name
(B) Field Type
(C) Description
(D) All of these
Answer:
(D) All of these
Question 266.
Which part is shown in middle of the window in design view of table ?
(A) Field Name
(B) Field Type
(C) Field Properties
(D) Description
Answer:
(C) Field Properties
Question 267.
Select the primary key option and symbol which is like a key will be displayed in ……………….. column.
(A) first
(B) second
(C) third
(D) fourth
Answer:
(A) first
Question 268.
Which option displays primary key ?
Answer:
Question 269.
What will be done after creating a structure of table ?
(A) Editing in table
(B) Store table
(C) Organize table
(D) Check table
Answer:
(B) Store table
Question 270.
Which option displays the save tool button in base ?
Answer:
Question 271.
Table which is made by design view is called …………….. in base.
(A) data base table
(B) user table
(C) composite table
(D) master table
Answer:
(D) master table