GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System

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

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System

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

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System

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

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System

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

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System

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

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System

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

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database 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

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System

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

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database 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

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System

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 GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System 1 icon displays …………… object.
(A) tables
(B) forms
(C) reports
(D) queries
Answer:
(A) tables

Question 64.
In database GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System 2 icon displays …………… object.
(A) tables
(B) forms
(C) reports
(D) queries
Answer:
(D) queries

Question 65.
In database GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System 3 icon displays …………… object.
(A) tables
(B) forms
(C) reports
(D) queries
Answer:
(B) forms

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System

Question 66.
In database GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System 4 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

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System

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

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System

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

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System

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

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System

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

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System

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

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System

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 (_)

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System

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)

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System

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

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System

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

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System

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)

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System

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

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System

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

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System

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

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System

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)

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System

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

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System

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

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System

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]

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System

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]

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System

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

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System

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

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System

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

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System

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

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System

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

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System

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.
GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System 5
Answer:
GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System 6

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 GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System 7 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

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System

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

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System

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

GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System

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 ?
GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System 8
Answer:
GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System 9

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 ?
GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System 8
Answer:
GSEB Std 11 Computer MCQ Answers Ch 9 Introduction to Database Management System 10

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

Leave a Comment

Your email address will not be published. Required fields are marked *