Saturday, March 25, 2023

MCQ Question - Computer Networking and Telecommunication

MCQ Question - Computer Networking and Telecommunication



Select the best answer
a)      Which refers to the communication media? [SLC 2064]
i. UTP cable      ii. Fiber optic cable        iii. Radio wave  iv. All
b) Which is Network operating system(NOS)? [SLC 2064]
i. Linux            ii. Windows XP             iii. MS-DOS     iv. All
c) Which refers to the communication media? [SLC 2065]
i) UTP cable     ii) Fiber optic cable       iii) Satellite       iv) All of the above
d) Which one is not a network topology? [SLC 2066]
i) Star               ii) Ring             iii) Client Server                        iv) Bus
e) Which is not a communication media? [SLC 2067]
i) Wire              ii) Microwave               iii) Satellite                   iv) NIC
f) In which topology network devices are connected through hub? [SLC 2067]
i) Ring topology            ii) Bus topology            iii) Star topology           iv) None of the above
g) Which of the following is not a protocol? [SLC 2068]
i) POP ii) TCP/IP         iii) NOS                        iv) FTP
h) In which communication media data transfer high? [SLC 2068]
i) Twisted pair   ii) Co-axial cable           iii) Fiber optics              iv) Microwave
i) Which is not unguided media? [SLC 2069]
i) Fiber optics    ii) Microwave   iii) Infrared       iv) Radio wave
j) Which one is bounded media? [SLC 2070]
i) Fibre optics    ii) Microwave   iii) Infrared       iv)Laser
k) Which one is an operating system software? [SLC 2070]
i) MS-Word      ii) MS-Excel     iii) Firefox        iv) MS-DOS
l) Which is NOT a guided media? [SLC 2066 S]
i) UTP Cable     ii) STP Cable    iii) Satellite       iv) Fiber Optics
m)Modem converts [SLC 2066 S]
i) Sound into digital       ii) Digital into sound      iii) Both i) and ii)          iv) None
o) Which one is an example of bounded media? [SLC 2067 S]
i) Fiber optics    ii) Microwave transmission        iii)Laser transmission     iv) infrared transmission
            p) Which of the following is not a guided data communication media? [SLC 2068 S]
i) Coaxial cable             ii) Fiber optic    iii) twisted pair              iv) Satellite
q) Which of the following network connects computer to the Internet? [SLC 2069 S]
i) Intranet                      ii) LAN            iii) WAN                      iv) MAN
q) Media used to transfer data in forms of light? [SLC 2070 S]
                       i. Microwave   ii. Fiber optical   iii. Radio wave   iv. Satellite

Database Management System

Database Management System [ MS Access] [255 OBJECTIVES MCQ AND QUESTIONS N ANSWERS]




Practice MS Access [DBMS]

255 Questions Collections

1. 40 Theory Questions.
2. 75 Multiple Choice Questions
4. 80 True and False
5. 40 Fill in the Blanks

6. 20 Match the following

40 Theory Questions
1.      What is database? Give four examples of database.
2.      State the advantages of managing database information in access.
3.      Differentiate between database and database management system.
4.      Differentiate between computerized and non-computerized database.
5.      What is data? Write with examples.
6.      Differentiate between data and information.
7.      What is MS-Access?
8.      Define DBMS with example.
9.      Define RDBMS with example.
10.   List any four features of DBMS.
11.    List any four features of MS-Access?
12.   What are the different objects of MS-Access?
13.   What is data type? Write any four data types of MS-Access.
14.   List any four types of field properties used by MS-Access.
15.   What is validation rule? Define validation text.
16.   Differentiate between text and memo.
17.   What is referential integrity?
18.   Define field.
19.   Differentiate between field and record.
20.   While designing table structure which data types are suitable to store information about teacher’s name, address, salary and date of birth.
21.   What happens when we enter text in a numeric field?
22.   What is Primary key? Why is it needed?
23.   Write any two uses of Primary key?
24.   Define sorting and filtering in MS-Access.
25.   How is sorting different from filtering?
26.   How can data redundancy be controlled in MS-Access?
27.   Define table. Write different ways to create a table.
28.   What is form? Mention the methods to create a form.
29.   Define query. Mention different types of query.
30.   What are the advantages of query?
31.   What are the purposes of query in MS-Access?
32.    What is select query? For what it can be used?
33.   What is update query?
34.   Write the append query?
35.   Differentiate between select query and action query.
36.   What is report? List any two methods to create report.
37.   What is the importance of report?
38.   Differentiate between form and report.
39.   Differentiate between Form and Query.
40.   Who is DBA? Write his/her responsibilities.



1)     What is database? Give two examples.
Ans: Database is a collection of related and organized information that can be used for different purpose.
Two examples of database are:
i) Dictionary
ii) Telephone Directory

2)     Differentiate between data and table.
Ans:
Data
Table
i)    Data can be numbers, letters or symbols representing facts and figures which may or may not give any sense.
i)     Table is an object of database that stores large volume of data in the form of rows and columns.

3)     State the advantages of managing database information in access.
Ans:The advantages of managing database information in access are:
i) It controls data redundancy which means duplication of data.
ii) It allows sharing the existing data by different programs.
iii) Large volume of data can be stored and updated easily.
iv) It provides high security of data as well as maintains accurate database.

4)     Differentiate between database and database management system
Ans:

Database
Database Management System
i)    Database is a collection of related and organized information that can be used for different purposes
i)      DBMS is software which is used to manage data in an organized way.
ii)   E.g.: Telephone directory, Dictionary, etc.
iii) E.g.: MS-Access, Oracle

5)     Differentiate between computerized and non-computerized database.
Ans:

Computerized
Non-Computerized
i)     It can store large volume of data.
i) It is limited by physical storage available.
ii)   It is very fast to find a specific record.
ii) It can take a while to manually search through all of the records.
iii) Data can be sorted into ascending or descending order on multiple criteria.
iii) Difficult to sort data on more than one criteria
iv) The database can be kept secure by use of passwords.
iv) The only security would be locking up the records.


6)     What is data? Write with examples.
Ans:Data can be numbers, letters or symbols representing facts and figures which may or may not give any sense.
E.g.: Ram, student, 20, etc.
7)     What is information?
Ans: Information is an organized collection of related data, which gives a complete sense. For example: “He is a boy.” , etc.


8)     Differentiate between data and information.
Ans:

Data
Information
i) Data can be numbers, letters or symbols representing facts and figures which may or may not give any sense.
i) Information is an organized collection of related data which gives a complete sense.
ii) E.g.: Ram, student, 20, etc.
ii) E.g.: Ram is a student. He is 20 years old., etc.
9)     Differentiate between record and table.
Ans:

Record
Table
i) Record is a collection of multiple related fields in a row which gives complete information about a person or thing.
i) Table is an object of database that stores large volume of data in the form of rows and columns.
10)  What is MS-Access?
Ans:MS-Access is a relational database management system developed by Microsoft Corporation which is used to store and manipulates large volume of data in the form of table.

11)  Define DBMS with example.
Ans:DBMS is a software which is used to manage data in an organized way.
E.g.: MS-Access, Oracle, etc.

12)  11. Define RDBMS with example.
Ans: It is a database management system that is based on the relation model in which data is stored in the form of tables and the relationship among the data is also stored in the form of tables.
E.g.: SQL, MS-Access, Oracle, etc.

13)  List any four featured of DBMS.
Ans: The four features of DBMS are:
i) It controls data redundancy which means duplication of data.
ii) It allows sharing the existing database by different programs.
iii) Large volume of data can be stored and updated easily.
iv) It provides high security of data as well as maintains accurate database.

14)   List any four features of MS-Access?
Ans: The four features of MS-Access are:
i) It provides the flexible ways to add, edit, delete and display the related data.
ii) Queries help to view, change and analyse the data indifferent ways.
iii) Forms are used for viewing and editing the information.
iv) Reports are used for summarizing and printing the data.

15)  Define the term of input mask and relationship.
Ans:
Input mask: It is a field property that controls the value of a record and sets in a specific format.
Relationship: It is an association among several entities (table).

16)  What is caption?
Ans: Caption is a field property which displays an alternate name for the field to make the field name more explanatory. It can contain up to 2048 characters.

17)  What are the different objects of MS-Access?
Ans: The different objects of MS-Access are:
i)Table
ii)Form
iii)Query
iv)Report

18)  What is data type?
Ans: It is an attribute for a field that determines what type of data it can contain.

19)  Write any four data types of MS-Access.
Ans: Any four data types of MS-Access are:
i)Text
ii)Number
iii)Memo
iv)Currency

20)  List any four types of field properties used by MS-Access.
Ans: The four types of field properties of MS-Access are:
i)Caption
ii)Format
iii)Validation rule
iv)Input mask

21)  What is validation rule? Define validation text.
Ans:
Validation rule: A field property which enables to limit values that can be accepted into a field is known as validation rule.
Validation text: A field property which allows type text to be displayed if the user input value is prohibited by the validation rule is known as validation text.
22)  Differentiate between text and memo.
Ans:
Text
Memo
i) It is used for storing text or combination of text and numbers.
i) It is used for storing lengthy text and numbers.
ii) It can store up to 2055 characters.
ii) It can store up to 65,535 characters.
23)  What is field size? What is the use of ‘Format’ field property?
Ans: Field size is a field property that specifies the maximum number of characters allowed in the field.
The use of ‘Format’ field property is to display data in a different format.

24)  Write down the use of Lookup Wizard and Hyperlink data types.
Ans: The use of Lookup Wizard is that it creates a field that allows choosing a value from another table or from a list of values by using a list box or combo box.
The use of Hyperlink is that it stores hyper like addresses like email addresses, websites, database objects or other field.

25)  Define indexing. Mention its types.
Ans: Indexing is one of the important properties of database that speed up searching and storing of records using on the field.
Its types are:
·        Primary indexing
·        Secondary indexing
·        Clustering indexing

26)  What is referential integrity?
Ans: Referential integrity is a set of rules used by RDBMS to make sure that the relationships between tables are valid and that the related data is not accidentally changed or deleted.

27)  Define field.
Ans: A column in a table is called field, and it contains a specific piece of information within a record.

28)  Differentiate between field and record.
Ans:
Field
Record
i) A column in a table is called field, and it contains a specific piece of information within a record.
i) Record is a collection of multiple related fields in a row which gives complete information about a person or thing.
ii) E.g.: Name, Address, Telephone
ii)E.g.: Ram Chabahil 4468790
29)  While designing table structure which data types are suitable to store information about teacher’s name, address, salary and date of birth.
Ans:
Teacher’s name - Text
Address – Text
Salary – Currency
Date of birth – Date/Time

30)  What happens when we enter text in a numeric field?
Ans: If we enter text in a numeric field then it displays the errors.

31)  What is Primary key? Why is it needed?
Ans: Primary key is a field that uniquely identifies the record. It is needed because it neither accepts duplicate values now null values.

32)  Write any two uses of Primary key?
Ans: The uses of Primary key are:
i) To reduce and control duplication of record in a table.
ii) To set the relationship between tables.

33)  What is composite and foreign key?
Ans: The group of primary key that consists of two or more attributes is called composite key.
Foreign key is a unique field or combination of fields in linked table whose value matches with a primary key in another table.

34)  Define sorting and filtering in MS-Access
Ans: Sorting means grouping all the records in a table either in ascending or descending order based on a key field of the record
Filtering is an option that selects the required records and displays the result.

35)  How is sorting different from filtering?
Ans: Sorting arranges the record either in ascending or descending order whereas filtering selects the required records and displays the result.

36)  What are the advantages of sorting?
Ans: The advantages of sorting are:
i) It helps to find specific information quickly.
ii) It helps to arrange data in alphabetical order.

37)  What are the advantages of form over table?
Ans: The advantages of form over a table are:
i) It allows to design the layout of field on screen in any arrangement.
ii) It shows only the information we want to see.
iii) It can display one complete record at a time.

38)  How can data redundancy be controlled in MS-Access?
Ans: Data redundancy can be controlled in MS-Access by the use of “Primary Key”.

39)  Define table. Write different ways to create a table.
Ans: Table is an object of database that stores large volume of data in the form of rows and columns.
The different ways to create table are:
i) Using design view
ii) Using wizard

40)  Write down the importance of table.
Ans: The importance of table are:
·        Different properties of a field can be set in a table.
·        It provides options for primary key which helps to make data consistent.

41)  What is form? Mention the methods to create a form
Ans: Form is an object of database which provides graphical interface to enter data into the tables or multiple linked tables.
Methods to create a form are:
i) By using auto forms features.
ii) By using the form wizard features.
iii) By using your own in design view.

42)  Write down the importance of form.
Ans: The importances of form are:
·        It provides an interactive platform for input of data into the database.
·        It helps to display data in more presentable form than a datasheet.

43)  Define query. Mention different types of query.
Ans: Query is an object of a database which extracts and arranges information from a table.
The different types of query are:
i) Select query
ii) Action query
In action query, we have update query, append query, delete query and make-table query.

44)  What are the advantages of query?
Ans: The advantages of query are:
i) We can filer, perform calculations and summarize data.
ii) Large volume of records can be updated or deleted at a same time.
iii) It retrieves and display records including some fields or all the fields of a table or multiple linked tables.

45)  What are the purposes of query in MS-Access?
Ans: The purpose of query in MS-Access are:
i) To view records including some fields or all the fields of a table or multiple linked tables.
ii) To perform mathematical calculation of a data.
iii) To sort the records on the basis of one or more key fields.
iv) To perform mass update, delete or append new records to a table.

46)   What is select query? For what it can be used?
Ans: A select query is the most common categories and is used for extracting specific information from one or more tables in a database.
We use select query to group records and calculate sums, counts and average, minimum and maximum.

47)  What is update query?
Ans: Update query is a type of action query which make global changes in data of a table or more linked tables.

48)  Write the append query?
Ans: The use of append query is to add a group of records from one or more tables to the end of one or more tables.
49)  Write down the importance of query?
Ans: The importances of query are:
·        It allows user to make calculations and change data in automated fashion.
·        It provides option to delete all the unwanted data matching certain criteria.

50)  Differentiate between select query and action query.
Ans:
Select query
Action query
i) It is a query which extracts specific information from one or more tables.
i) It is a query which makes changes to many records in just one operation.
ii) It cannot make changes in tales.
ii) It can do changes in tables by update, append.
51)  What is report? List any two methods to create report.
Ans: Report is an object of database which displays the output in an effective way to present the data in a printed format.
The methods are:
i) Using design view
ii) Using report wizard

52)  What is the importance of report?
Ans: The importance of report are:
i) It displays the information the way we want to view it.
ii) It presents the information retrieved through queries or tables.
iii) It presents the information in designed layouts by adding necessary titles, setting font colour or font size, etc.

53)  Why is report created?
Ans: Report is created to print documents according to users specifications of the summarized information through query or table.

54)  What is the data source for report?
Ans: The data sources for report are table and query.

55)  Differentiate between form and report.
Ans:
Forms
Report
i) Forms are used to enter, view, and edit information.
i) Reports are used only to view information.
ii) Forms are usually displayed on the screen.
ii) Reports can be previewed on the screen, but they are usually printed.
iii) Forms generally provide a detailed took at records and usually for the people who actually work with the database.
iii) Reports are often used to group and summarize data, and are often for the people who don’t work with the database but who use its information for other business task.

75 Multiple Choice Questions 
1.      What is extension of access database? (MS-Access 2003 version)
DBF                       MDB                MBD                DBM
2.      _____ is the table design creating option to create custom table design.
Datasheet                Design view                  Wizard             Link Table
3.      A field name can be up to _____ characters long.
40                          46                    64                    2048
4.      _____ is a data type used for lengthy text and numbers
Text                       Long Text                     OLE Object                  Memo
5.      Data type that requires 8 bytes of storage.
Yes/No                   Currency                       Long Integer                 All of them
6.      The name of caption can be declared up to _____ characters.
1024                       2024                             2048                             2005
7.      Memory space used by a auto number data type is _____
1 Byte                    2 Bytes                         4 Bytes                         8 Bytes
8.      The primary key contains _____ value.
Null                        No Null                                    Number                  Auto number
9.      Which specifies the expression that checks the invalid data.
Validation Rule                   Validation Text             Input Mask       Required
10.   _____ is not a field property of MS-Access.
Caption                   Index                            Color                            Format
11.   Format symbol that converts all characters to uppercase.
@                           &                                 <                                  >
12.   What kind of data is kept in memo field?                                                     
(i) Hyperlink        (ii) Software      (iii) Data           (iv) Pictures
13.   What is the default size of Access?                                                  
(i) 10                (ii) 20               (iii) 30              (iv) 50
14.   Which is not the database?
i. Phone diary                      ii. Mark ledger  iii. Attendance Register    iv. Report Card
15.   MS-Access is a software.
i. Utility                  ii. Application               iii. System        iv. None of the above.
16.   Which is DBMS?
i. Database              ii. Metabase                  iii. dBase          iv. MS-Excel.
17.   The object of MS-Access that stores data is known as________
i. Query                  ii. Table                        iii. Form                       iv. Report
18.   Which of the following is not the data type used in MS-Access?
i. Date/Time                        ii. Counter                    iii. Hyperlink                iv. Caption
19.   The object of MS-Access that is used to prepare read-to-print document is_________
i. Query      ii. Table            iii. Form           iv. Report
20.   A field property that limits the data to be entered in a field is___________
i. Validation Rule    ii. Format                      iii. Input Mask              iv. Indexed
21.   Which is the subtype of number data type?
i. Integer                 ii. Byte                         iii. Single                      iv. All of the above.
22.   __________allows MS-Access to query and sort record faster.
i. Sorting                ii. Editing                     iii. Filtering                   iv. Indexing
23.   The maximum number of characters that can be stored in a field is determined by_
i. Field Type                       ii. Field Size                 iii. Field Length iv. Field width
24.   The logical field data type of MS-Access is______________
i. Yes/No                ii. True/False                 iii. On/Off                     iv. All of the above.
25.   The field size of logical field data type is __________ in MS-Access.
i. 1 bit                                ii. 1 byte                       iii. 2 bytes                     iv. 2 bits
26.   A (n) ____________________ is an organized collection of the related information.
            Object              database            Property                        document
27.   Field size, format, input mask, caption and default values are:
            Key elements                field properties              Navigating modes          data types
28.   The _________________ key uniquely identifies each record
            Primary            database                        Object              premier
29.   ___________________ is a set of rules used by Access to ensure that the relationships between tables are valid and that the related data is not accidentally changed or deleted.
            Relationship                  Referential integrity                   Query               Forms
30.   A Database Management System can be used to                               .
i. retrieve information          ii. search information    iii. sort information   iv. all of the above
31.   The storage size of date and time is                        .
i.4 bytes                  ii.6 bytes           iii.8 bytes          iv.12 bytes
32.   The data type appropriate to store address is                   .
i. Memo                  ii. Currency                   iii. Text                         iv. Auto number
33.   A collection of records for a single subject, such as all of the customer records.
i. Field                    ii. Record                      iii. Table                      iv. Data
34.   Which of the following is not a data type in Microsoft Access?
i. Text                      ii. Currency                  iii. Hypertext                 iv. Date/Time
35.   The default field size of “AutoNumber” data type is                 .
i. Byte                    ii. Integer                      iii. Long Integer                        iv. Long Integer
36.   Which of the following is not MS-Access database object?
i. Table                      ii. Form                     iii. Query                         iv. Print
37.   Which of the following data type is appropriate to store gender of person in terms M or F?
i. Memo                    ii. Currency              iii. Yes no                         iv. Auto number
38.   Form is designed for
i. filters data              ii. Sort data               iii. Sort data                      iv. Modify data
39.   Query is used to
i. retrieves data from database          ii. Create table in database    iii. Print database      iv. All  
40.   Report is used for
i. Printing database               ii. Process database     iii. Filter database           iv. None
41.   Which of the following is not a data type?
i. Picture                  ii.date/time                  iii.text                              iv.number
42.   What field type is used to store picture in a table?
i.memo                  ii.OLE                          iii.hyperlink                     iv.None
43.   Which is the example of Relational Database Management System?
i.Oracle                ii.FoxBASE                  iii.Sybase                          iv.FoxPro

44.   The datatype which is used for only integer value.
i.text                     ii.currency                    iii.number                         iv.OLE
45.   What kind of data are kept in memo field?
i.Name of Student     ii.Students phone number     iii.Students Bio data     iv.Students picture

46.   Which of the following is the datatype of MS-Access?
i.yes/no                ii.true/false                   iii.on/off                               iv.All
47.   A field is also known as
i.records               ii.column                     iii.Database                          iv.entity
48.   Which component of MS-Access is used to enter data?
Query                     Forms               Report              Both (i) and (ii)
49.   __________ is a Database Management System.
DBase                    MSAV              EXCEL            All of above
50.   A column in MS-Access Table is __________
Field                       Query               Database           Record
51.   MS-Access is a
DBMS                    RDBMS           Database           Metabase
52.   A row in a table is known as _____________.
Field                       Content             Record              Text table
53.   Which is the database?
Data of SLC Exam  Oracle              MS-Access                   Excel
54.   MS-Access is used to create _____________.
Database     DBMS              Record              Table
55.   Number field is used for storing only _______________.
Number      Text and Number          Number and Time         Number and Year
56.   ___________ is not DBMS.
Oracle                    dBase               FoxPro             Paint
57.   Which is an example of database?
DBase                    MS-Access       Telephone Directory      All
58.   Report is the printed output we generate from _______________.
Table                      Query               Forms               Both (i) and (ii)
59.   Which of them is not a data type?
Memo                     Yes/No             Time/Date         Caption
60.   Which is the subtypes for the number data type?
Hyperlink   Bit                    Index                Integer
61.   database is a
i.tool of editing documents               ii. way to automate common tasks
ii. collection of related information
62.   a collection of records for a single subject,such as all of the customer record is called 
i.Field                     ii.Record                       iii.Table
63.   …………… defines a standard pattern for the appearance of all data entered in the field
i.format                  ii.input mask                 iii.default value
64.   Which component of MS-ACCESS does not allow entering data?
i. Table                   ii. Query                       iii. Form           iv. None of them
65.   …………… is not the data type of MS-Access.
i) Number   ii) Text             iii) Memo         iv) Form
66.   …………… is the DBMS.
i) Fox-Pro   ii) MS-Excel                 iii) Lotus-123    iv) All of the above
67.   Primary key does not accept ……………
i) Text                    ii) Number        iii) Null value    iv) None of the above
68.   Which is not a type of query?
i) Search     ii) Select           iii) Update        iv)All of the above
69.    Collecting multiple related files is called:
i)Records    ii)Table iii) Forms          iv)Query
70.   The data type appropriate to store salary is:
i)Memo      ii)Currency       iii)Text             iv) Auto number
71.   Which of the following is not a database application?
          i) Oracle                   ii) Foxpro         iii) MS-Access      iv) MS-Excel
72.   Memory space consumed by a currency data type maximally is …………
          i) 2 bytes                  ii) 4 bytes         iii) 8 bytes        iv) 1 GB
73.        c) The default data type of MS-Access is:
          i) Number     ii)Text              iii) Memo         iv) Auto number
74.   Which is suitable data type to store video?
i) Text              ii) Number        iii) Hyperlink    iv) OLE object
75.   …………….. query changes value in main table.
         i) Select                     ii) Update         iii) Both (i) &(ii)           iv) None of the above

Answers:
1.MDB
2.Design View
3.64
4.Memo
5.Currency
6. 2048
7. 4 Bytes
8.No null
9.Validation Rule
10.Color
11.>
12.Data
13.50
14. Report Card
15.Application
16.dBASE
17.Table
18.Counter
19.Report
20.Validation Rule
21.All of above
22.Indexing
23.Field Size
24.Yes/No
25.! Bit
26.database
27.field properties
28.primary
29.Referential integrity
30.all of the above
31.8 bytes
32.text
33.table
34.hypertext
35.Byte
36.Print
37.yes/no
38. modify data
39.retrive data form database
40.Printing Database
41.Picture
42.OLE
43.Oracle
44.Number
45.Students Picture
46.Yes/no
47.Column
48.Forms
49.DBASE
50.Field
51.RDBMS
52.Record
53.data of SLC exam
54.Database
55.Number
56.Paint
57.Telephone Directory
58.Both (i) and (ii)
59.Caption
60.integer
61.collection of related information
62.Table
63.input mask
64.Query
65.Form
66.Fox-Pro
67.Null value
68.Search
69.Table
70.Currency
71.MS_EXcel
72.8 bytes
73.Text
74.OLE Object
75.Update

80 True and False Questions

1.      A field name refers to the category of information about a subject.
2.      You cannot delete a field in a database once they have been defined.
3.      The primary key is an optional field in MS-Access table.
4.      The primary key in a table is a field that contains information unique to the records.
5.      Many related fields makeup a record and many records makeup table.
6.      A query is used to select fields and records from one or more tables.
7.      A select query retrieve data from one or more tables using criteria you specify.
8.      Form is a graphical interface through which data can be printed or displayed is specified format.
9.      Database has been being used knowingly or unknowingly in our daily life.
10.   The maximum field size of text field is 255 characters.
11.   Pictures and graphics cannot be stored in the table in MS Access 2007.
12.   Form is the source of table.
13.   The primary key field of a table allows the duplication of data.
14.   Report is used to enter the data into the table in MS-Access 2007.
  1. Field names are used to define properties for a database.
  2. Lookup Wizard is a tool that automates many database tasks.
  3. Default field size of text type of data is 65535 characters.
  4. Date/Time type of data requires 8 bytes of memory.
  5. Removing a primary key does not delete a field.
  6. FORMAT property allows us to delete data from database.
  7. Subtype of number data type is integer.
  8. Deleting a field does not delete data in the field.
  9. Validation rule is used to specify whether a value is required in a field.
24.   Indexed field property speeds up searching and sorting of records based on a field.
25.   You cannot insert any field after entering data in the table.
26.   Query allows viewing the desired records only.
27.   Logical field has the size 2.
28.   The information can be used as data for the further processing.
29.   A database can be managed manually.
30.   DBMS is application software.
31.   The Auto Number data type generates random number automatically whenever a new record is added to a table.
32.   A query can be created without tables.
33.   A report can be used to modify data of a table.
34.   Form allows you to select specific data from one or more tables.
35.   The default field size for a field with a data type of Text is 50 characters.
36.   Microsoft Access is a Relational Database Management System.
37.   A query is a collection of related data stored in an organized manner.
38.   A form is a user-friendly way of entering, displaying an editing data stored in a table.
39.   Queries are used to display records onscreen to make them easier to enter new records and to make change in an existing records.
40.   Primary key field cannot be left blank.
41.   We cannot change data type of a field.
42.   Memo field is used to store long information beyond of the text.
43.   Yes/No Logical field stores one bit of data.
44.   Query can be used to apply mathematical calculations in the table.
45.   We can make the form as the source of table.
46.   A form allows displaying one complete information at once.
47.   A query is used to select records from many tables.
48.   Index decreases the speed of the query and sort operations.
49.   Report is used to prepare database for final printing.
50.   A database file of MS-Access can have only one table.
51.   The extension of MS-Access database file is MDB.
52.   A field can’t be declared with data type.
53.   Logical value can also be stored in database.
54.   Hyperlink field type in used to store photographs.
55.   A query cannot be the source for a form.
56.   Primary key field may contain the same value in two records.
57.   A report can be used to delete record from a table.
58.   Index accelerates the query and sort operation.
59.   DBMS is word processing software.
60.   A row in a table is called field and it contains a specific piece of informarion within a record.
61.   Data validation enables you to limit the values that can be accepted into a field.
62.   A default value is one that is not displayed automatically for the field into a field.
63.   The data filter selects the required records and displays the result.
64.   Default data type of MS-Access is a number.
65.   Action query makes changes in a table.
  1. A query is database object that creates a datasheet of selected fields and records from one or more tables.
67.   Graphics can also be stored in MS-Access database.
68.   Maximum field size of memo field is 256 characters. 
69.   A query is used to select fields and records from many tables.
70.   MS-ACCESS is a spread-sheet software.
71.   The data in primary key field need to be unique and not null.
72.   Primary key does not accept null value.
73.   Memo datatype cannot be indexed.
74.   A query is used to select fields and records from many tables.
75.   MS-Access is not a spreadsheet software.
76.   Default text field size is of 255 characters.
77.   A database can contain multiple tables.
78.   A row in a table is known as record.
79.   Data like sound and pictures are held by memo data type.
80.   Update Query does not change the data of table.


Answers:
1.True
2.Fasle
3.True
4.True
5.True
6. True
7. True
8.False
9.True
10.True
11.False
12.Flase
13.Flase
14.False
15.False
16.True
17.False
18.True
19.True
20.False
21.True
22.False
23.False
24.True
25.False
26.False
27.False
28.True
29.True
30.Ture
31.False
32.False
33.False
34.False
35.True
36.True
37.False
38.True
39.False
40.True
41.False
42.True
43.True
44.True
45.False
46.True
47.True
48.False
49.True
50.False
51.True
52.True
53.True
54.False
55.False
56.False
57.False
58.True
59.Flase
60.False
61.True
62.Flase
63.True
64.False
65.True
66.True
67.True
68.False
69.True
70.False
71.True
72.True
73.True
74.True
75.True
76.False
77.True
78.True
79.False
80.False

40 Fill in the Blanks
1.      ___________________ is an organized collection of related data in tabular form.
2.      DBMS is a general program deigned to manage a ___________________
3.      ___________________ is the raw facts to generate information.
4.      _________________________ is the processed value which we get after we get after processing by the computer.
5.      SQL stands for _________________________
6.      A primary key cannot contain the___________________ values.
7.      ___________________is the linking field between two values.
8.      A text data type allows the field to contain up to ___________________ characters.
9.      A _____________ is a collection of related data.
10.   A ______________ contains records and field.
11.   A ______________ is a fixed field which uniquely identifies every record in a table.
12.   You cannot enter duplicate values in a _______________ field.
13.   A combination of two or more keys which can be used as a primary key is called a _________________ key.
14.   Maximum width of field is _________.
15.   Memo field can hold ___________ characters.
16.   Access is a__________________ database management system software.
17.   The default field size for text type is _______________ characters.
18.   An _______________    is the format we will assign for the introduction of values into a field.
19.   The   _______________ property is used to define a default value that is automatically entered in field when you add a new record, at o time of data entry.
20.     _______________ allows you to retrieve specific information from a table in Microsoft Access 2003.
21.     _______________   help us to retrieve and view only those records from the database tables that meet a specific condition or criteria set by us.
22.       _______________ enable you to format your data in an attracting and informative layout for printing.
23.   A collection of related data of a person or anything is known as _______________.
24.   A column in a table is called _____________ and row in a table is called____________.
25.   Primary key value must not be_______________.
26.   ______________ is the field types used to store text that is more than 255 character.
27.   ______________ field type automatically enters number in a field which increase by one for every new record.
28.   We can change data type of field in _______________ view.
29.   ___________________ is used to make sure that the data entered in a field is within the criteria set by the user.
30.   ________________ query is used to change record in a table at a single operation.
31.   _______________ query is used to delete records from the table.
32.   A    _____________extracts and arranges information from a table in a manner that you specify.
33.   Delete query is an example of __________________                 
34.   Query that makes changes in table is called__________________
  1. _______________is a complex set of software program that controls the organization, storage, management, retrieval of data in database.
  2. The smallest unit of data organization is called a _______________
  3. _______________is a relational database management system where data is arranged in the form of tables .
  4. A _______________is a database object that creates a datasheet of selected fields and records from one or more tables.
  5. A _______________Is a database object used primarily to display records on screen, to make it easier to enter new records and to make changes to the existing records.
  6. The _______________View window is the place where you design reports from a scratch or add your own touches to reports you create with the report wizard.

Answers:
1.database
2.database
3.Data
4.Information
5.Structured Query Language
6. duplicate or null
7. Foreign Key
8.255
9.database
10.table
11.primary key
12.primary
13.composite
14.64 characters
15.65,535
16.Rational
17.50
18.input mask
19.default value
20.Filtering
21.Query
22.Report
23.database
24.field and record
25.null
26.Memo
27.Auto Number
28.table design
29.Validation Rule
30.Action Query
31.Delet
32.query
33.action query
34.update query
35.DBMS
36.field
37.MS_Access
38.query
39.form
40.report design


20 Match the Following
1.
Data                                     -presentation of result
Record                                 -organized collection of data information
Field                                    -graphical interface for data entry
Report                                 -column on datasheet
Query                                  -value
Table                                   -software
Primary key                        -row on a datasheet  
DBMS                                -retrieving editing information conditionally
Form                                  -sorting data in rows and columns
Database                            -a field with unique field content

2.
Number                                    50
Yes/No                         8 bytes
Currency                       Long integer
Text                             1 bit
                        short integer

3.
Data redundancy                       Error message
Validation Text             Pattern of data in a field
Input Mask                   Lookup wizard
Validation Rule             Data duplication
                        Limits the value

4.
Indexing data                Retrieves data
Long text                      Caption
FoxPro                         Memo field
Label for a field            DBMS
                              Searching fast

5.
Text                             2048 characters
Currency                       up to 255 Characters
Memo                           8 Bytes
Hyperlink                     0-65535 Characters
                              4 Bytes
6.
 Data Integrity               No. of character can be entered
Automatic                     Contains distinct value
Field size                      Validation Rule
Primary key                  Indexed
                                    Default value

7.
Query                           A collection of programs that enables you to store, modify, and extracts information from a database
DBMS                          A field which uniquely identifies every record in a table.
Table                            A set of information stored about a particular entry.
Record                          An arrangement of data in row and column format.         
Primary Key                 A database object that creates a datasheet of selected fields and records from one or more tables.

8.
OLE                                         Formatted printout
Form                                        Picture
Indexing                                   Data Entry
Report                                     Fast Searching
                              Text

9.
Query                                  Printed format
Form                            Stores data
Table                            Allows view, edit, input data
Report                          Extracts selected record
                  DBMS
10.
Data type                      Field property
Format                         Relationship
Form                           Referential Integrity
One-to-one                   Database Object
 Memo
11.
Index                                  database
Data redundancy                software
Record                                easy to search
DBMS                                repetition of data
                             Tuple

12.
Form                            database
Primary key                        data type
Advance Filter                    text control
Hyperlink                            unique identification of record
                              Query

13.
Sort                                      mass change
Single precision                   DBMS
FoxPro                                 memo field
Update query                       sub type of number
                                      Arranging data

14.
Mark ledger                          Predefined formats
Wild cards                            database
Wizard                                  primary key
Relationship                          * and?
                                       Report

15.
Query               Printed format
Form                Stored data
Table                Allows view, edit, input data
Report              Extracts the selected record for view
                        DBMS

16.
Default value    255 Characters
Fox Pro            Column Name
ext                    DBMS
Field                 Field Properties
                        Search fast






17.
OLE                             Report
Data entry                     Picture
Indexing                       Table
Formatted printout         Fast searching
                                    Form
           
18.
Indexing                       Limits the value
Report                          Data type
Validation Rule             Error messages
Hyper link                    Final output
                                    Search fast

19.
OLE                             Data Entry
Hyperlink                     Formatted  Hardcopy
Report                          1 GB
Form                            Up to 255 characters
                                    Up to 2048 characters

20.
Indexing Data               Size upto 1 GB
Form                            Column of datasheet
Field                             Row on a datasheet
OLE object                   Searching Fast
                               Graphical interface for data entry

Answers:
1.d,j,I,c,a,h,b,e,f,g
2.d,c,a,b,-
3.b,c,-,a,d
4.-,d,b,c,a
5.d,a,b,c,-
6. c,d,a,-,b
7. b,e,d,c,a
8.d,a,b,c,-
9.d,c,b,a,-
10.b,d,-,c,a
11.-,d,a,b,c
12.-,d,a,b,c
13.d,c,-,b,a
14.c,a,d,b,-
15.Repeated with Q. Number 9
16.c,d,b,a,-
17.d,a,-,c,b
18.c,d,-,b,a
19.d,c,a,-,b
20.d,c,-,a,b


***

Class 12 Computer Science MCQ set

  Class 12 Computer Science MCQ set According to the new curriculum and grid of NEB, there is an abrupt change in question pattern. Computer...