CBSE Class 11 Computer Science Introduction To Database Management System MCQs

Question : All kinds of facts, figures and details related of people, places, things or events is known as____

a) Information

b) Data

c) Decisions

d) Process

Answer : Data

Question : All kinds of facts, figures and details related of people, places, things or events is known as_____

a) Information

b) Data

c) Decisions

d) Process

Answer : Data

Question : _______ can be described as the required result obtained from processing of data.

a) Information

b) Data

c) Decisions

d) Process

Answer : Information

Question : _______ is nothing but processed data.

a) Information

b) Data

c) Decisions

d) Process

Answer : Information

Question : _______ is a collection of related data items stored in an organized manner.

a) Data

b) Office

c) Database

d) Library

Answer : Database

Question : ________ arrangement of things always makes searching easier as and when required.

a) Database

b) Information

c) Simple

d) Logical

Answer : Logical

Question : The underlying structure of database is known as _______.

a) Data design

b) Data model

c) Data structure

d) None of these

Answer : Data model

Question : _______ is a collection of related data items stored in an organized manner.

a) Data

b) Office

c) Database

d) Library

Answer : Database

Question : ________ arrangement of things always makes searching easier as and when required.

a) Database

b) Information

c) Simple

d) Logical

Answer : Logical

Question : The underlying structure of database is known as ______

a) Data design

b) Data model

c) Data structure

d) None of these

Answer : Data model

Question : To work with computerized database, a.......... has to be first defined and created.

a) Field

b) Table

c) Database

d) Query

Answer : Database

Question : All tasks related to database handling is known as________

a) Work system

b) Tasks

c) Data transaction

d) Database management system

Answer : Database management system

Question : Oracle, Ingress, DB2, SQL Server, MS Access are examples of____

a) HDD

b) DBMS

c) OpenOffice

d) Base

Answer : DBMS

Question : To keep the database ready with latest up-to-date data, _____ tasks are expected to be performed regularly.

a) Adding data into database

b) Editing the content

c) Removing unnecessary data

d) All of these

Answer : All of these

Question : OpenOffice Base is based on a ________

a) Relational data model

b) Relational table

c) Office model

d) None of these

Answer : Relational data model

Question : Base is a collection of related data objects known as _____

a) Tables

b) Queries

c) Reports

d) All of these

Answer : All of these

Question : ______ is the basic unit for storing data in database.

a) Desk

b) Chair

c) Table

d) Report

Answer : Table

Question : ________ are real world objects about which information is to be stored in database.

a) Tables

b) Entities

c) Queries

d) Reports

Answer : Entities

Question : Attributes of an entity are represented in the form of______

a) Columns

b) Rows

c) Tables

d) Fields

Answer : Columns

Question : Attributes of an entity are also termed as_______

a) Columns

b) Rows

c) Tables

d) Fields

Answer : Fields

Question : Collection of all these fields forms a_______

a) Record

b) Form

c) Tables

d) Reports

Answer : Reports

Question : _______ is an object which allows entering the data in the table and editing or deleting existing data in the table.

a) Record

b) Form

c) Tables

d) Reports

Answer : Form

Question : A question asked within the database environment is known as ________.

a) Table

b) Form

c) Query

d) Report

Answer : Query

Question : The presentation of information in an organized and readable format as per user requirement is known as _________.

a) Table

b) Form

c) Query

d) Report

Answer : Report

Question : Data can be in any form, ____

a) Written

b) Oral

c) Computerized

d) All of these

Answer : All of these

Question : Data helps in decision-making _______.

a) Process

b) Work

c) Relation

d) None of these

Answer : Process

Question : _______ forms the foundation for decision Making

a) Data

b) Information

c) Database

d) A Network

Answer : Information

Question : A school attendance record is a ________.

a) Field

b) Record

c) Database

d) Collection

Answer : Database

Question : The words _____ and Organized form a very important part in definition of database.

a) Hierarchical

b) Network

c) Related

d) Database

Answer : Related

Question : A ______ describes the way of storing and retrieving data.

a) Database

b) Data record

c) Data store

d) Data model

Answer : Data model

Question : All tasks related to database handling is known as_________management.

a) Database

b) Information

c) Computerized

d) Process

Answer : Database

Question : ________is a type of data model.

a) Hierarchical

b) Network

c) Relational

d) All of these

Answer : All of these

Question : _______ can be defined as system designed for efficient storage, maintenance and retrieval of data.

a) BASE

b) DBMS

c) Database

d) Data Model

Answer : DBMS

Question : _______ is a Relational Database Management System (RDBMS).

a) BASE

b) Office

c) MS Word

d) Excel

Answer : BASE

Question : _______ is the organization of data into collections of two dimensional tables.

a) RDBMS

b) Database

c) Relations

d) Base

Answer : Relations

Question : Relational model is based on the theory of sets and relations of mathematics were designed by______.

a) EG. Codd

b) A.B. Codd

c) EE Codd

d) E.E Codd

Answer : E.E Codd

Question : A________ consists format, style and widgets like radio button, list box that provide easy and systematic way to populate table with data.

a) Record

b) Form

c) Tables

d) Reports

Answer : Form

Question : A ________ displays subset of data contained in various tables of a database.

a) Table

b) Form

c) Query

d) Report

Answer : Query

Question : Base has a facility to prepare effective professional _________.

a) Report

b) Relations

c) Form

d) Report

Answer : Report

Question : _________ can be defined as characteristics of an entity.

a) Attributes

b) Properties

c) Decisions

d) Forms

Answer : Attributes

Question : The________ name of the attributes will always have to confirm to the conventions imposed by the software.

a) Physical

b) Logical

c) Format

d) First

Answer : Physical

Question : ________ is the convention to name the attributes in Base.

a) Start all attributes names with a letter

b) Do not use space between words

c) Only use underscore as a special character

d) All of the above

Answer : All of the above

Question : _______ is a way to define storage structure of the field.

a) Accuracy

b) Data type

c) Design type

d) All of these

Answer : Data type

Question : There are ______ categories of Data Types in Base.

a) One

b) Two

c) Three

d) Four

Answer : Three

Question : Text (VARCHAR) data type accepts_______ data.

a) Numeric

b) Alphanumeric

c) Binary

d) Calendar

Answer : Alphanumeric

Question : The _________ data type has a limitation on number of characters that can be used.

a) Character

b) Alphanumeric

c) Numeric

d) Binary

Answer : Character

Question : To store descriptive data _____ data type is used.

a) Character

b) Memo

c) Descriptive

d) Alphanumeric

Answer : Memo

Question : The_______code needs only one bye to store a character.

a) ASCII

b) Unicode

c) Variable

d) None of these

Answer : ASCII

Question : Base uses______ to store alphanumeric characters.

a) ASCII

b) Unicode

c) UTF-8

d) All of these

Answer : UTF-8

Question : _______ standard uses more byes per character.

a) ASCII

b) Unicode

c) UTF-8

d) None of these

Answer : Unicode

Question : A ________ number uses just one bit.

a) Boolean

b) ASCII

c) Unicode

d) UF-8

Answer : Boolean

Question : ______ data type attributes are described by the number of bytes they used and whether they are signed or unsigned.

a) Numeric

b) Alphanumeric

c) Binary

d) Calendar

Answer : Numeric

Question : The range for Smallest is ______

a) -123456 to 123456

b) -32768 to 32768

c) Unlimited

d) 0 - 255

Answer : -32768 to 32768

Question : _______ is a Numeric Type attribute.

a) Real

b) Decimal

c) Binary

d) All of these

Answer : All of these

Question : _______ data type attribute stores the time of the day.

a) Time

b) Day

c) Calendar

d) Timestamp

Answer : Time

Question : _______ data type is used to store information like year, month, day.

a) Numeric

b) Alphanumeric

c) Binary

d) Calendar

Answer : Calendar

Question : The _____ type attribute stores information that comes as a long string of zeros and ones.

a) Image

b) Binary

c) Array

d) Byte

Answer : Binary

Question : Maximum length of a Var Binary data type is

a) 1GB

b) 1.5 GB

c) 2 GB

d) 2.5 GB

Answer : 2 GB

Question : Field names like "Pin code" or "Mobile Number" should be assigned _______ data type.

a) Numeric

b) Alphanumeric

c) Text

d) Binary

Answer : Text

Question : Base sorts numbers in a Text field from______

a) Right to left

b) Left to right

c) Bottom to top

d) Top to bottom

Answer : Left to right

Question : The field that has a unique importance in a table is known as ________ field.

a) Key

b) Main

c) Unique

d) Important

Answer : Key

Question : In terms of database, a field or combination of fields capable of identifying each record uniquely is known as ______

a) Main key

b) Unique key

c) Primary key

d) All of these

Answer : Primary key

Question : A ________value means unknown or missing value.

a) Empty

b) Void

c) Null

d) Zero

Answer : Null

Question : ______ is a combination of more than one field serving as Primary Key.

a) Composite Primary Key

b) Complete Primary key

c) Compulsory Primary Key

d) Unique Primary key

Answer : Composite Primary Key

Question : ______ is an example of an attribute.

a) Supplier Name

b) Description

c) Entity

d) None of these

Answer : Supplier Name

Question : _______ is an example of an attribute.

a) Supplier Name

b) Description

c) Entity

d) None of these

Answer : Supplier Name

Question : _____is the correct format of writing field name.

a) First name

b) First_name

c) F Name

d) All of these

Answer : All of these

Question : The name actually used in the internal structure of our tables is called a ______ name.

a) Mental

b) Physical

c) Hypothetical

d) Theoretical

Answer : Physical

Question : _______is a special character used in naming of an attribute.

a) Underscore

b) Hash

c) Dollar

d) Dash

Answer : Underscore

Question : In ______ back notations, each word in field name starts with capital letter.

a) Tiger

b) Horse

c) Camel

d) Lion

Answer : Camel

Question : First Name, Last Name, Address Line are examples of _____ notations.

a) Tiger

b) Horse

c) Camel

d) Lion

Answer : Camel

Question : Alphanumeric type, Calendar type or Binary type are all _______ types available in Base.

a) Data

b) Information

c) Database

d) A Network

Answer : Data

Question : The data type of Text is _______.

a) Long Var Char

b) Var Char

c) Var Char Ignore Case

d) Both (B) and (C)

Answer : Both (B) and (C)

Question : ______ data type stores more than 255 character.

a) Text

b) Memo

c) Numeric

d) Text(fix)

Answer : Memo

Question : _______ data type stores information marks, salary or balance in bank account.

a) Text

b) Memo

c) Numeric

d) Text (fix)

Answer : Memo

Question : The range for Boolean is _____

a) 0 - 100

b) 0-1

c) Unlimited

d) 0 - 255

Answer : 0-1

Question : The data type of Memo is _____

a) Char

b) Long Var Char

c) Var Char

d) Var Char Ignore Case

Answer : Long Var Char

Question : The data type of Text(fix) is ________

a) Char

b) Long Var Char

c) Var Char

d) Var Char Ignore Case

Answer : Char

Question : The range for Tinylnt is ____

a) 0 - 100

b) 0-1

c) Unlimited

d) 0 - 255

Answer : 0 - 255

Question : The range for Numeric is ______

a) 0 - 100

b) 0-1

c) Unlimited

d) 0 - 255

Answer : Unlimited

Question : Defining a______.key is a must for each table.

a) Main

b) Unique

c) Primary

d) All of these

Answer : Primary

Question : In a table "Supplier", there are fields called "Scode", "Supplier Name", "Supplier Address". _____filed should be taken as a Primary key for being unique.

a) Supplier Name

b) Supplier Address

c) Supplier

d) Scode

Answer : Scode

Question : A JPEG or an MP3 file will be stored undo_______ data type.

a) Binary

b) Calendar

c) Image

d) Music

Answer : Binary

Question : Base gives us _______ options to start working with database.

a) One

b) Two

c) Three

d) Four

Answer : Two

Question : The Table Wizard of Base software which consists of ready made tables divided into_______categories.

a) One

b) Two

c) Three

d) Four

Answer : Two

Question : Tables like Photographs, Recipes, Plants etc are available under_______tables list.

a) Personal

b) Business

c) Samples

d) Available

Answer : Samples

Question : Text[VARCHAR], Text (fix) [CHAR], Number [Numeric] are all kinds of _______ types.

a) Name

b) Properties

c) Description

d) Field

Answer : Field

Question : While defining each field, it is associated with _______ terms.

a) One

b) Two

c) Three

d) Four

Answer : Four

Question : Creating tables using ________ view is more beneficial.

a) Design

b) Wizard

c) Personal

d) Name

Answer : Design

Question : To designate a Primary key_______ click on the field o open a sub-menu.

a) Left

b) Right

c) Top

d) Bottom

Answer : Right

Question : Full form of DBMS is ________.

a) Database Management Software

b) Database Management System

c) Design Management Software

d) None of these

Answer : Database Management System

Question : To create a new database, the user has to choose_________option.

a) Create a new database

b) Open an existing database file

c) Connect to an existing database file

d) None of these

Answer : Create a new database

Question : To not to make the database public, select the option _____

a) Yes, register the database

b) No, do not register the database

c) Open database for editing

d) None of these

Answer : No, do not register the database

Question : The Table Wizard of Base software consists of ready made tables like _______ and Personal.

a) Official

b) Non-official

c) Business

d) All of these

Answer : Business

Question : In the ________ pane of the Database objects like Tables, Queries, Forms and Reports can be seen.

a) Left

b) Right

c) Top

d) Bottom

Answer : Left

Question : While creating a table, entering the ______ of each field is a good practice.

a) Text

b) Number

c) Details

d) Description

Answer : Description

Question : The field ______ are used to control and validate the data that is to be entered.

a) Description

b) Properties

c) Details

d) Name

Answer : Properties

Question : To delete any object created in Base,_____click the object icon and click on delete option.

a) Left

b) Right

c) Top

d) Bottom

Answer : Right

Question : The is a Field type.

a) Text (fix)

b) Number

c) Decimal

d) All of these

Answer : All of these

Question : The tables which store data that has all the information like Product, Employee, Customer etc. are termed as_____tables.

a) Sub

b) Master

c) Main

d) Transaction

Answer : Master