Home / 11th(ENG) - GSEB Board / Reading Mode

📖 Reading Mode: 11th(ENG) - GSEB Board

Chapter: Introduction to Database Management System • Total: 278 MCQs

MCQ 1 Information System

DBMS Stands for

A Database Management System
B Database Migration System
C Data Management System
D Direct Base Management System
MCQ 2 Information System

Which of following is a term used for “Raw facts or figures”?

A Information
B Variable
C Data
D Field
MCQ 3 Information System

Which of the following best describes customer in Database?

A Relationship
B Attribute
C Entity
D Data
MCQ 4 Information System

Processed data is known as

A Fact
B Prepared data
C Information
D Decision
MCQ 5 Information System

Which one of the following is not a database?

A MySQL
B Base
C SQL Server
D SpreadSheet
MCQ 6 Information System

Which of the following is not an Open source DBMS?

A MySQL
B Ingress
C Base
D Oracle
MCQ 7 Information System

The alphabet R in RDBMS stands for which of the following?

A Rotational
B Relational
C Random
D Ring
MCQ 8 Information System

What is the name of the database available as part of Open Office Suite?

A OfficeDB
B Base
C OpenDB
D Access
MCQ 9 Information System

Which of the following is the default extension of Base Database file?

A .bdf
B .odf
C .odb
D .dbf
MCQ 10 Information System

Which of the following is not an object maintained by Base?

A Tables
B Queries
C Charts
D Forms
MCQ 11 Information System

Which data type cannot be used to store numbers?

A Decimal
B Integer
C Text
D Date
MCQ 12 Information System

Which data type is used to store image in Base database?

A Binary
B Photo
C Long
D Huge
MCQ 13 Information System

Which of the following is false statement?

A Primary key cannot contain null values.
B Primary key cannot contain duplicate values.
C Primary key can be combination of more than one field
D Primary key is always numeric field
MCQ 14 Information System

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
MCQ 15 Information System

In present technology almost all data is stored and manage ?????. .

A electronically
B handwritten
C mechanical
D data base
MCQ 16 Information System

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
MCQ 17 Information System

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
MCQ 18 Information System

It is obvious that the perfect decision depends on the ??????. of information available.

A process
B accuracy
C importance
D progress
MCQ 19 Information System

What is information ?

A Input
B Processing
C Output
D Input/output
MCQ 20 Information System

Information is the output generated through processing of which ?

A Data
B Table
C Field
D Column
MCQ 21 Information System

The word ??????. are used interchangeably.

A data and column
B data and information
C data and row
D data and data base
MCQ 22 Information System

?Raw information or Numbers? are used for ?????? .

A variable
B field
C data
D information
MCQ 23 Information System

What is data ?

A Facts, figure
B Details related to people, places
C Things, events
D All of these
MCQ 24 Information System

Data is in which form ?

A Oral
B Written
C Computerized and non-computerized
D All of these
MCQ 25 Information System

Who is not much useful in its original form ?

A Data
B Information
C Both and
D None of these
MCQ 26 Information System

Who must be processed in a proper way to make information useful and meaningful ?

A Field
B Data
C Data base
D Table
MCQ 27 Information System

Data must be processed in a proper way to generate the useful and meaningful ?????.. .

A information
B data base
C table
D field
MCQ 28 Information System

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
MCQ 29 Information System

Who can be describe as the required result obtained from processing of the data ?

A Data base
B Information
C Entity
D Datamodel
MCQ 30 Information System

Processed data is called ??????. .

A datamodel
B data base
C information
D entity
MCQ 31 Information System

Who is important as it forms the function for decision making ?

A Data
B Data base
C Entity
D Information
MCQ 32 Information System

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
MCQ 33 Information System

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
MCQ 34 Information System

Who is a collection of related data items stored in an organized manner ?

A Data
B Data base
C Information
D Datamodel
MCQ 35 Information System

In the definition of data base, which words are very important ?

A Related, organized
B Related, logical
C Organized, stored
D Organized, retrieve
MCQ 36 Information System

Which type of arrangement of things always makes it easier for searching when required ?

A Related
B Physical
C Logical
D Relevant
MCQ 37 Information System

Data base are designed according to whom ?

A Data
B User
C Rules
D Place
MCQ 38 Information System

The underlying structure of data base is known as ?????. .

A data
B datamodel
C DBMS
D information
MCQ 39 Information System

Who is storing and retrieving data ?

A Data
B Datamodel
C DBMS
D Information
MCQ 40 Information System

Datamodel describes way of ?????.. .

A storing
B retrieving
C both and
D none of these
MCQ 41 Information System

From the following which is the type of datamodel ?

A Hierarchical
B Network
C Relational
D All of these
MCQ 42 Information System

In DBMS chapter, we are discussing ?????.. models.

A network
B relational
C hierarchical
D productive
MCQ 43 Information System

To work with computerized data base one has to first define and create a ?????.. .

A data
B information
C data base
D datamodel
MCQ 44 Information System

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
MCQ 45 Information System

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
MCQ 46 Information System

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
MCQ 47 Information System

All of the tasks related to the data base handling is known as ?????. .

A datamodel
B data base management
C data base
D datasource
MCQ 48 Information System

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
MCQ 49 Information System

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
MCQ 50 Information System

Which type of system you define as a DBMS ?

A Efficient storage
B Maintenance
C Retrieval of data
D All of these
MCQ 51 Information System

Who makes data base practical and more usable ?

A Datamodel
B DBMS
C Data base management model
D Data base management source
MCQ 52 Information System

A data base is useless if there is no ?????. associated with it for accessing its data.

A DMBS
B ORACLE
C DBMS
D SQL
MCQ 53 Information System

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
MCQ 54 Information System

From the following which is not open source DBMS ?

A Oracle
B Ingress
C Base
D MYSQL
MCQ 55 Information System

From the following, which is open source DBMS ?

A MYSQL
B Base
C Ingress
D All of these
MCQ 56 Information System

Which type of software base is ?

A DBMS
B Presentation
C Spreadsheet
D Word Processor
MCQ 57 Information System

Base is the part of ?????.. officesuite.

A MS Office
B Open Office
C Data Office
D Base Office
MCQ 58 Information System

Which type of data base ?base? is ?

A Open Source
B Proprietary
C Both and
D None of these
MCQ 59 Information System

Base?, is based on which datamodel ?

A Network
B Relational
C Hierarchical
D Product base
MCQ 60 Information System

Which type of system base is ?

A Spread sheet
B Presentation
C RDBMS
D Word Processor
MCQ 61 Information System

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
MCQ 62 Information System

Base has a versatile way to organize information and store it in ?????? .

A table
B form
C report
D query
MCQ 63 Information System

Which model is the organization of data into collections of two-dimensional tables ?

A Hierarchical
B Relational
C Network
D Product base
MCQ 64 Information System

The organization of data into collections of two-dimensional tables are called ????? .

A row
B column
C both and
D relations
MCQ 65 Information System

Relational model is designed by ?????. .

A E. F. Codd
B F. E. Code
C I. E. Code
D I. F. Code
MCQ 66 Information System

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
MCQ 67 Information System

RDBMS is based on which model ?

A Hierarchical
B Relational
C Network
D Product base
MCQ 68 Information System

A DBMS is based on relational model called ?????? .

A DBMS
B DBSM
C RDBMS
D RDBSM
MCQ 69 Information System

Which is the most successful data model ?

A Hierarchical
B Relational
C Network
D Product base
MCQ 70 Information System

Relational model is successful because of its ????? .

A simplicity
B versatility
C design
D decision power
MCQ 71 Information System

?????? model is easy to understand the data relationship and very easy to manipulate.

A Hierarchical
B Relational
C Network
D All of these
MCQ 72 Information System

Base is a collection of ?????? .

A related data objects
B related data applications
C related field objects
D related entity objects
MCQ 73 Information System

From the following which data object is based on base ?

A Table
B Query
C Form and reports
D All of these
MCQ 74 Information System

In base table, form, query and report are known as ????? .

A data entity
B data object
C data application
D data modules
MCQ 75 Information System

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
MCQ 76 Information System

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
MCQ 77 Information System

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
MCQ 78 Information System

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
MCQ 79 Information System

What is the important factor to store data in base data base ?

A Table
B Form
C Report
D Query
MCQ 80 Information System

Tables are organized in the form of ?????.. .

A column and field
B column and row
C row and attribute
D row and entity
MCQ 81 Information System

What is column ?

A Column
B Row
C Entity
D Attribute
MCQ 82 Information System

What is row ?

A Column
B Row
C Entity
D Attribute
MCQ 83 Information System

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
MCQ 84 Information System

????.. are real world objects about which information is to be stored in data base.

A Attribute
B Field
C Entity
D Record
MCQ 85 Information System

Entities are real world ????.. .

A table
B object
C record
D field
MCQ 86 Information System

Information of objects are to be stored in ?????? .

A data base
B system
C field
D attribute
MCQ 87 Information System

Each entity generally has collection of ?????. .

A attribute
B data base
C object
D row
MCQ 88 Information System

Attributes of an entity are represented in the form of ?????? .

A row
B column
C cell
D any one
MCQ 89 Information System

Attributes of an entity are also termed as ????? .

A field
B record
C table
D data base
MCQ 90 Information System

Collection of all fields forms a ????? .

A column
B record
C entity
D attribute
MCQ 91 Information System

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
MCQ 92 Information System

Which is an example of object ?

A Field
B Row
C Form
D Frame
MCQ 93 Information System

Which facility is provided by form ?

A Entering data in table
B Editing data
C Deleting data
D All of these
MCQ 94 Information System

Form consists of which widgets ?

A Format
B Slide
C Radio button and list box
D All of these
MCQ 95 Information System

?????.. help In providing easy and systematic way to populate table with data.

A Table
B Widgets
C Data base
D Query
MCQ 96 Information System

A questions asked within the data base environment is known as ?????.. .

A query
B entity
C attribute
D information
MCQ 97 Information System

?????. displays subset of data contained in various tables at a data base.

A Form
B Report
C Query
D Macro
MCQ 98 Information System

On whom you will process to get information ?

A Data
B Data base
C Table
D Field
MCQ 99 Information System

Which facility is given in Base for attractive output ?

A table
B form
C query
D report
MCQ 100 Information System

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
MCQ 101 Information System

?????.. can help in taking decisions by management in organizations.

A Query
B Table
C Report
D Form
MCQ 102 Information System

How many steps are available for creating data base ?

A 2
B 3
C 4
D 5
MCQ 103 Information System

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
MCQ 104 Information System

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
MCQ 105 Information System

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
MCQ 106 Information System

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
MCQ 107 Information System

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
MCQ 108 Information System

Product, Suppliers, Employees and Customers are known as ????.. in data base.

A entity
B form
C field
D key-field
MCQ 109 Information System

In which step you are decided to design entity and table in data base ?

A 1
B 2
C 3
D 4
MCQ 110 Information System

Entities can be defined as any ?????. .

A person
B thing
C place
D all of these
MCQ 111 Information System

How many table design you should made for each entity ?

A Only one
B Fix
C Separate
D Any one of these
MCQ 112 Information System

In which step of data base the attribute for entity is decided ?

A 1
B 2
C 3
D 4
MCQ 113 Information System

Attributes can be defined as characteristics of an ?????? .

A table
B key-field
C entity
D form
MCQ 114 Information System

Which option is used for name in data base ?

A Logical name
B Physical name
C Both and
D None of these
MCQ 115 Information System

The name actually used in the internal structure of our tables is called as ?????.. .

A logical name
B physical name
C both and
D none of these
MCQ 116 Information System

?????. names are used at the time of desiging the data model.

A Logical name
B Physical name
C Both and
D None of these
MCQ 117 Information System

What is First Name in data base ?

A Field name
B Data entity
C Both and
D None of these
MCQ 118 Information System

In the data base application would only accept ?????. .

A FName
B first_name
C FIRST NAME
D all of these
MCQ 119 Information System

Start all attributes name with ?????. in data base.

A letter
B number
C underscore
D any one
MCQ 120 Information System

In data base subsequent characters use either ?????? .

A letter
B number
C underscore
D all of these
MCQ 121 Information System

In data base, do not use ??????.. between word of attribute.

A space
B underscore
C both and
D none of these
MCQ 122 Information System

In data base, use a ?????.. between word of attributes.

A space
B underscore
C both and
D none of these
MCQ 123 Information System

In data base, do not use special character except ????? .

A underscore (_)
B dash (-)
C hash (#)
D question mark ( ? )
MCQ 124 Information System

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
MCQ 125 Information System

Which option is used for camel back ?

A FIRSTNAME
B FirstName
C firstname
D fIRSTnAME
MCQ 126 Information System

In camel back each word in field name starts with ????.. .

A capital
B small
C or
D symbol
MCQ 127 Information System

In which step of data base data type is decided ?

A 1
B 2
C 3
D 4
MCQ 128 Information System

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
MCQ 129 Information System

?????. is a way to define storage structure of the field.

A Field Name
B Data Type
C Description
D Field Properties
MCQ 130 Information System

How many types are there of storing data in computer ?

A 2
B 4
C 6
D different way (many)
MCQ 131 Information System

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
MCQ 132 Information System

The choice of data type will affect the performance of the ?????. .

A object
B data base
C entity
D attribute
MCQ 133 Information System

Data type available in base can be divided in ?????.. category.

A 2
B 3
C 4
D 5
MCQ 134 Information System

How many data types are available in base ?

A 14
B 17
C 21
D 27
MCQ 135 Information System

Which of the following option display a type of data type ?

A Alphanumeric type
B Calendar type
C Binary type
D All of these
MCQ 136 Information System

To enter which type of information data type is used ?

A Letter
B Number
C Special character
D all of these
MCQ 137 Information System

In base, how many data type are there in alphanumeric type ?

A 4
B 6
C 8
D 12
MCQ 138 Information System

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
MCQ 139 Information System

Which type of information is available in Address field ?

A Alphabets
B Special character
C Number
D Any one of these
MCQ 140 Information System

Which type is suitable for Address field ?

A Alphanumeric type
B Calendar type
C Binary type
D All of these
MCQ 141 Information System

Which data type is suitable for Address field ?

A Text (fix) [CHAR]
B Text [VARCHAR]
C Text [INTGER]
D Any one of these
MCQ 142 Information System

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
MCQ 143 Information System

Which form is used for memo data type ?

A Char
B VarChar
C Long VarChar
D VarChar IgnoreCase
MCQ 144 Information System

Maximum storage capacity of memo data type is ?????. .

A 1 GB
B 2 GB
C 3 GB
D 4 GB
MCQ 145 Information System

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
MCQ 146 Information System

Memo data type accepts ????.. character.

A UTF-4
B UTF-8
C UTF-16
D UTF-24
MCQ 147 Information System

What is the full form of UTF ?

A Unicode Transformation Format
B Unicode Transaction Format
C Unicode Timeline Format
D Unicode Transform Format
MCQ 148 Information System

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]
MCQ 149 Information System

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
MCQ 150 Information System

Maximum storage capacity of Text (fix) [CHAR] data type is ????? .

A 1 GB
B 2 GB
C 3 GB
D 4 GB
MCQ 151 Information System

Text (fix) [CHAR] data type accept which type of character ?

A UTF-4
B UTF-8
C UTF-16
D UTF-24
MCQ 152 Information System

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
MCQ 153 Information System

Which data type does not add empty space ?

A Text [VARCHAR]
B Memo [LONGVARCHAR]
C Both and
D Text (fix) [CHAR]
MCQ 154 Information System

Maximum storage capacity of Text [VARCHAR] data type is ?????.. .

A 1 GB
B 2 GB
C 3 GB
D 4 GB
MCQ 155 Information System

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 and
MCQ 156 Information System

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
MCQ 157 Information System

Maximum storage capacity of Text [VARCHAR_IGNORECASE] data type is ?????.. .

A 1 GB
B 2 GB
C 3 GB
D 4 GB
MCQ 158 Information System

Which data type is used to store descriptive data ?

A Text (fix) [CHAR]
B Text [VARCHAR]
C Text [VARCHAR_IGNORECASE]
D Memo [LONGVARCHAR]
MCQ 159 Information System

In the following data type more than ?????. characters are there then memo data type is used.

A 64
B 124
C 255
D 64000
MCQ 160 Information System

Memo data type allows us to store text data up to ????.. characters.

A 64
B 124
C 255
D 64000
MCQ 161 Information System

?????.. 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]
MCQ 162 Information System

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]
MCQ 163 Information System

How many types are there for storing alphanumeric character ?

A 2
B 3
C 4
D 5
MCQ 164 Information System

Which type is useful for storing alphanumeric character ?

A ASCII
B Unicode
C UTF
D All of these
MCQ 165 Information System

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
MCQ 166 Information System

ASCH code needs only ??????. byte to store a character.

A 1
B 4
C 8
D 16
MCQ 167 Information System

In ASCII code the no. of possible character that can be stored is only ?????.. .

A 24
B 34
C 256
D 64000
MCQ 168 Information System

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
MCQ 169 Information System

Which of the following code uses more bytes per character ?

A ASCII
B Unicode
C Both and
D None of these
MCQ 170 Information System

Base stores alphanumeric characters using ????.. .

A ASCII
B Unicode
C UTF-8
D All of these
MCQ 171 Information System

UTF-8 is compatible with both ????.. .

A ASCII
B Unicode
C Both and
D None of these
MCQ 172 Information System

Base use ?????.. bytes for each character according to internal calculations.

A zero
B one
C one or more
D all of these
MCQ 173 Information System

How much bytes are used by field is decided by whom ?

A Users
B Administrator
C Software
D All of these
MCQ 174 Information System

????? type is used to store numerical information.

A Alphabetic type
B Numeric type
C Binary type
D Calendar type
MCQ 175 Information System

?????.. 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
MCQ 176 Information System

Numeric data type attributes are described by the ?????.. .

A binary value
B signed
C unsigned
D all of these
MCQ 177 Information System

How many numeric types are data type available in data type in Base ?

A 4
B 8
C 10
D 14
MCQ 178 Information System

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
MCQ 179 Information System

?????. no. consumes the least memory.

A Tyny Integer
B Small Integer
C Yes/No (Boolean)
D Decimal
MCQ 180 Information System

How many bit uses boolean number ?

A 1
B 2
C 4
D 8
MCQ 181 Information System

????.. can be stored as yes/no type of data.

A Tyny Integer
B Small Integer
C Yes/No (Boolean)
D Decimal
MCQ 182 Information System

?????. number stores numbers that have decimal places.

A Boolean numbers
B Floating point numbers
C Integer point numbers
D Small integer numbers
MCQ 183 Information System

Which data type use maximum memory ?

A Boolean numbers
B Floating point numbers
C Integer point numbers
D Small integer numbers
MCQ 184 Information System

?????.. 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
MCQ 185 Information System

How much range of Yes/No [Boolean] type data type ?

A 1 Bit
B 1 Byte
C 2 Bytes
D 4 Bytes
MCQ 186 Information System

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
MCQ 187 Information System

How much size does Tiny Integer [TINYINT] data type consists ?

A 1 Bit
B 1 Byte
C 2 Byte
D 4 Byte
MCQ 188 Information System

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
MCQ 189 Information System

How much size does Small Integer [SMALLINT] type of data type consist ?

A 1 Bit
B 1 Byte
C 2 Byte
D 4 Byte
MCQ 190 Information System

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
MCQ 191 Information System

How much size does Integer [INTEGER] type of data type consists ?

A 1 Bit
B 1 Byte
C 2 Bytes
D 4 Bytes
MCQ 192 Information System

Does Integer [INTEGER] type of data type consist of signed or not ?

A Yes
B No
C or
D Can?t say
MCQ 193 Information System

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
MCQ 194 Information System

How much size does Biglnt [BIGING] type of data type consist ?

A 2 Byte
B 4 Byte
C 8 Byte
D Unlimited
MCQ 195 Information System

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
MCQ 196 Information System

What is the size of Number [NUMERIC] type of data type ?

A 2 Bytes
B 4 Bytes
C 8 Bytes
D Unlimited
MCQ 197 Information System

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
MCQ 198 Information System

How much size does Decimal [DECIMAL] type of data type consists ?

A 2 Bytes
B 4 Bytes
C 8 Bytes
D Unlimited
MCQ 199 Information System

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
MCQ 200 Information System

How much size does Real [REAL] type of data type consist ?

A 2 Bytes
B 4 Bytes
C 8 Bytes
D Unlimited
MCQ 201 Information System

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
MCQ 202 Information System

How many data types are there in calendar in Base ?

A 2
B 3
C 4
D 5
MCQ 203 Information System

Which option display calendar type data type ?

A Date [DATE]
B Time [TIME]
C Date[TIMESTAMP]
D All of these
MCQ 204 Information System

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
MCQ 205 Information System

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
MCQ 206 Information System

?????. 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
MCQ 207 Information System

Which type of information is stored in calendar type of data type ?

A Year, month, day
B Hour, minute, second
C Both and
D None of these
MCQ 208 Information System

Date type attributes allows storing year, month and day as it is stored in ?????. .

A base
B system
C application
D administrator
MCQ 209 Information System

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
MCQ 210 Information System

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
MCQ 211 Information System

?????. 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
MCQ 212 Information System

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
MCQ 213 Information System

Which type of data type is used for InTime and OutTime ?

A Date [DATE]
B Date [TIMESTAMP]
C Time [TIME]
D All of these
MCQ 214 Information System

How many data types are available in binary type in base ?

A 2
B 3
C 4
D 5
MCQ 215 Information System

Which option display a data type of binary type ?

A Image [LONGVARBINARY]
B Binary [VARBINARY]
C Binary (fix) [BINARY]
D All of these
MCQ 216 Information System

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
MCQ 217 Information System

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
MCQ 218 Information System

?????. 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
MCQ 219 Information System

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
MCQ 220 Information System

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
MCQ 221 Information System

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
MCQ 222 Information System

In which step of data base does the key-field of the table is decided ?

A 1
B 2
C 3
D 4
MCQ 223 Information System

????? can identify each record of a table uniquely.

A Master field
B Data base field
C Key-field
D Model field
MCQ 224 Information System

Each table should contain at least ?????. type of field.

A extra ordinary
B infinite
C unique
D all of these
MCQ 225 Information System

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
MCQ 226 Information System

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
MCQ 227 Information System

Primary key values can not contain ?????.. .

A null value
B duplicate
C both and
D none of these
MCQ 228 Information System

Particular attribute may or may not contain any values are known as ??????.. .

A not value
B null value
C none value
D no value
MCQ 229 Information System

What is null value ?

A Unknown value
B Absent value
C Missing value
D All of these
MCQ 230 Information System

How many reasons are available for null value in attribute ?

A 2
B 3
C 4
D 5
MCQ 231 Information System

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 and
D None of these
MCQ 232 Information System

A table can not have primary key more than ?????. .

A one
B two
C more than one
D unlimited
MCQ 233 Information System

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
MCQ 234 Information System

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
MCQ 235 Information System

How many steps you can see while you start base ? opening screen data base window ?

A 2
B 3
C 4
D 5
MCQ 236 Information System

Which option display step for creating a data base ?

A Select data base
B Save and Proceed
C Both and
D None of these
MCQ 237 Information System

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 and
D None of these
MCQ 238 Information System

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
MCQ 239 Information System

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
MCQ 240 Information System

What is the website of OpenOffice ?

A www.OpenOffice.com
B www.OpenOffice.org
C www.OpenOffice.in
D www.OpenOffice.edu
MCQ 241 Information System

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
MCQ 242 Information System

How many option are there in data base of Base for creating a table ?

A 2
B 3
C 4
D 5
MCQ 243 Information System

In the following option, which option is shown for creating table in Base ? Data base Wizard ?

A Design View
B Table Wizard
C Both and
D None of these
MCQ 244 Information System

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
MCQ 245 Information System

Which the default extension of base for data base file ?

A .odb
B .odt
C .odp
D .odg
MCQ 246 Information System

How many steps are available for creating a table using Table Wizard ?

A 2
B 3
C 4
D 5
MCQ 247 Information System

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
MCQ 248 Information System

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
MCQ 249 Information System

In to how many categories does different types of tables are divided in table wizard ?

A 2
B 3
C 4
D 5
MCQ 250 Information System

Which option displays the category of different tables in table wizard ?

A Personal, Company
B Personal, Private
C Business, Personal
D Business, Private
MCQ 251 Information System

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
MCQ 252 Information System

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
MCQ 253 Information System

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
MCQ 254 Information System

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
MCQ 255 Information System

How many objects are seen in main data base ?

A 3
B 4
C 5
D 6
MCQ 256 Information System

Which object is shown in main window of data base ?

A Tables, Queries
B Forms, Reports
C Macros, Moduls
D Both and
MCQ 257 Information System

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
MCQ 258 Information System

Which object is selected as default in base ?

A Forms
B Tables
C Queries
D Reports
MCQ 259 Information System

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
MCQ 260 Information System

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
MCQ 261 Information System

How many variables are associated with variables to define ?Field? of ?Design View1 in table ?

A 3
B 4
C 5
D 6
MCQ 262 Information System

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
MCQ 263 Information System

Which option is given field name a facility in design view of table ?

A Field Name
B Description
C Field Type
D Field Property
MCQ 264 Information System

Which option gives facility of field data type in design view table ?

A Field Name
B Description
C Field Type
D Field Property
MCQ 265 Information System

Which option gives facility to write description for field in table design view ?

A Field Name
B Description
C Field Type
D Field Property
MCQ 266 Information System

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
MCQ 267 Information System

Which option is optional in design view of table wizard ?

A Field Name
B Description
C Field Type
D All of these
MCQ 268 Information System

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
MCQ 269 Information System

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
MCQ 270 Information System

To create a table its easy in ?????.. .

A table Wizard
B design view
C both and
D none of these
MCQ 271 Information System

How many option is given in main window to create table in task pen ?

A 2
B 3
C 4
D 5
MCQ 272 Information System

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 and
D None of these
MCQ 273 Information System

How many column are there in design view of table ?

A 3
B 4
C 5
D 6
MCQ 274 Information System

Which column is shown from design view of table ?

A Field Name
B Field Type
C Description
D All of these
MCQ 275 Information System

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
MCQ 276 Information System

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
MCQ 277 Information System

What will be done after creating a structure of table ?

A Editing in table
B Store table
C Organize table
D Check table
MCQ 278 Information System

Table which is made by design view is called ?????.. in base.

A data base table
B user table
C composite table
D master table