GSEB Class 11 Computer Question Paper April 2016 (For Science Stream)

By solving the Computer Class 11 GSEB Solutions and GSEB Class 11 Computer Question Paper April 2016 (For Science Stream) will be able to know the exam pattern in the exam.

GSEB Std 11 Computer Question Paper April 2016 (For Science Stream)

Question 1.
Who reads the radio frequency signal and transfers the information to a processing device generally a Radio Frequency Reader in RFID system ?
(A) Transceiver
(B) Transponder
(C) Hard disk
(D) Antenna
Answer:
(A) Transceiver

Question 2.
Which of the following is an earliest applications of Radio Frequency Identification (RFID) ?
(A) Food tracking
(B) Animal tracking
(C) Book tracking
(D) Ticketing
Answer:
(B) Animal tracking

Question 3.
The idea of Bluetooth was initially conceived by which of the following company ?
(A) Ericsson
(B) Apple
(C) Symbian
(D) Kinetics
Answer:
(A) Ericsson

Question 4.
Which of the following is an oldest satellite phone operator ?
(A) Inmarsat
(B) Dursat
(C) Thursat
(D) Nrayasat
Answer:
(A) Inmarsat

Question 5.
Google provides us a free drive space of how many GB, shared between Google Drive and Google+ Photos ?
(A) 4 GB
(B) 2 GB
(C) 1 GB
(D) 5 GB
Answer:
(D) 5 GB

Question 6.
Which of the following is one of the most used cloud service for Customer Relationship Management (CRM) software ?
(A) Interaction.co.in
(B) Customer.com
(C) Salesforce.com
(D) System.com
Answer:
(C) Salesforce.com

Question 7.
Which of the following is a model of cloud computing ?
(A) PaaS
(B) IaaS
(C) All of these
(D) SaaS
Answer:
(C) All of these

Question 8.
When we start editing a file using Vim editor, the editor will be opened in which mode ?
(A) Command mode
(B) Last line mode
(C) Delete mode
(D) Insert mode
Answer:
(A) Command mode

Question 9.
By pressing which key, we can toggle between command mode and insert mode in Linux ?
(A) Tab
(B) Esc
(C) Alt
(D) Enter
Answer:
(B) Esc

Question 10.
Which command is used to save file and quit editing mode in Linux ?
(A) : q
(B) : k
(C) : v
(D) : wq
Answer:
(D) : wq

Question 11.
To delete one word from text file which command is used in linux ?
(A) ul
(B) ds
(C) dw
(D) dl
Answer:
(C) dw

Question 12.
The Linux shell will execute all the commands available within the text file in the specified sequence, this text file is known as ……………..
(A) Action script
(B) Kernel script
(C) Linux script
(D) Shell script
Answer:
(D) Shell script

Question 13.
Which text editors are generally best suited for creating text file in Linux ?
(A) Pico
(B) Vi or Vim
(C) All of these
(D) Nano
Answer:
(C) All of these

Question 14.
In Base, who provides a way to present the information retrieved in an attractive, arranged and decisive manner ?
(A) Report
(B) Macro
(C) Modules
(D) Table
Answer:
(A) Report

Question 15.
In Base, how many types of reports can be generated ?
(A) 1
(B) 2
(C) 4
(D) 3
Answer:
(B) 2

Question 16.
What is the color of tooltip text also known as Help text while creating form in Base ?
(A) Red
(B) Blue
(C) Green
(D) Yellow
Answer:
(D) Yellow

Question 17.
Which of the following is an example of mobile operating system ?
(A) iOS
(B) Symbian
(C) All of these
(D) Android
Answer:
(C) All of these

Question 18.
Which of the following Wi-Fi standard gives the lowest data rate (6 Mbits/s to 54 Mbits/s) and has an outdoor of 120 meters ?
(A) 802.11 n
(B) 802.11 a
(C) 802.11 g
(D) 802.11 b
Answer:
(B) 802.11 a

Question 19.
In Base, the background of the Form can be shown by which of the following ?
(A) Graphic (Picture)
(B) Text
(C) Both Color and Graphic (Picture)
(D) Color
Answer:
(C) Both Color and Graphic (Picture)

Question 20.
In Base by using which button, we can delete a record in Form ?

Answer:

Question 21.
Which option of referential integrity states that a user should not be allowed to delete or update any record if its related record exists in some other table ?
(A) Set default
(B) Update cascade
(C) No action
(D) Set null
Answer:
(C) No action

Question 22.
Base automatically assigns some predefined field size to which data types ?
(A) Yes / No
(B) Memo
(C) All of these
(D) Numeric
Answer:
(C) All of these

Question 23.
The setting of “Entry required” field property is what in Base ?
(A) True or False
(B) 1 or 0
(C) Y or N
(D) Yes or No
Answer:
(D) Yes or No

Question 24.
Which property specifies format for displaying and printing data that we enter in the field in Base ?
(A) Default value
(B) Auto value
(C) Format
(D) Length
Answer:
(C) Format

Question 25.
Which principle can be stated as, no unmatched foreign key values should exist in the database ?
(A) Cascade update
(B) Redundancy
(C) Normalization
(D) Referential Integrity
Answer:
(D) Referential Integrity

Question 26.
Conceptually there can be how many types of relationship between any tables of database ?
(A) 2
(B) 3
(C) 1
(D) 4
Answer:
(B) 3

Question 27.
Who determine how the values in the field are stored and displayed in Base ?
(A) Field properties
(B) Relationships of data
(C) Update cascade
(D) Data redundancy
Answer:
(A) Field properties

Question 28.
Sum = ‘expr $num1 + $num2’ what does the term expr means in above sentence ?
(A) explain
(B) expression
(C) express
(D) execute
Answer:
(B) expression

Question 29.
Which command is used without any parameters to see the processes associated with current shell ?
(A) ps
(B) cs
(C) ws
(D) ls
Answer:
(A) ps

Question 30.
In Linux, what will be the exit status of “IF” statement, if it has been executed successfully ?
(A) No
(B) 1
(C) 0 (zero)
(D) Yes
Answer:
(C) 0 (zero)

Question 31.
In shell script which symbol is used to indicate comment ?
(A) *
(B) #
(C) =
(D) ?
Answer:
(B) #

Question 32.
To execute the shell script, which command is used ?
(A) sh or bash
(B) x or wq
(C) execute
(D) script or vi
Answer:
(A) sh or bash

Question 33.
Which command expects the user to key in the data on the standard input device in Linux ?
(A) write
(B) input
(C) data input
(D) read
Answer:
(D) read

Question 34.
When we want to store some descriptive data, which may have more than 255 characters, then which data type will be useful in base ?
(A) Text (Fix)
(B) Text (Var Char) Ignore case
(C) Memo
(D) Text
Answer:
(C) Memo

Question 35.
In Base, for least memory consuming side of memory, we have which data type ?
(A) Number
(B) Decimal
(C) Small int
(D) Boolean number
Answer:
(D) Boolean number

Question 36.
Table wizard of Base software consists of which readymade tables ?
(A) Personal
(B) Both Business and Personal
(C) Financial
(D) Business
Answer:
(B) Both Business and Personal

Question 37.
In Base software, by clicking on which button we can select all the fields that are visible under available fields list ?
(A) << (B) >
(C) >>
(D) < Answer: (C) >>

Question 38.
In design view of base software, which of the following allows us to assign a data type to each field ?
(A) Field type
(B) Description
(C) Field properties
(D) Field name
Answer:
(A) Field type

Question 39.
When we edit the data in Base, the black pointing arrow icon will be replaced with pencil icon, which is also known as …………….
(A) Edit Icon
(B) Green Icon
(C) Record Icon
(D) Format Icon
Answer:
(A) Edit Icon

Question 40.
Data types available in Base can be divided into how many categories ?
(A) 2
(B) 3
(C) 4
(D) 1
Answer:
(B) 3

Question 41.
In Base by pressing which keys, we can select labels in Form ?
(A) ENTER + Click
(B) CTRL + Click
(C) DEL + Click
(D) ALT + Click
Answer:
(B) CTRL + Click

Question 42.
In Base, which of the following is known as wildcard character ?
(A) –
(B) *
(C) &
(D) +
Answer:
(B) *

Question 43.
In Base with wildcard character, we can use which of the following operator ?
(A) Like
(B) Equal
(C) ! =
(D) ls
Answer:
(A) Like

Question 44.
In the language of database, what is used as front end for data entry and editing ?
(A) Static report
(B) Forms
(C) Macro
(D) Queries
Answer:
(B) Forms

Question 45.
In Base, we can create form by which of the following ways ?
(A) Using Design view
(B) Both by using Wizard and Design view
(C) Using Function
(D) Using Wizard
Answer:
(B) Both by using Wizard and Design view

Question 46.
In Base, there are how many ways to initiate Form wizard ?
(A) 3
(B) 1
(C) 2
(D) 4
Answer:
(C) 2

Question 47.
In Base, if you want to apply color in Form, then which of the following option is to be selected ?
(A) Apply styles
(B) Set name
(C) Set data entry
(D) Arrange controls
Answer:
(A) Apply styles

Question 48.
In IF statement, in place of square brackets which command can be used in Linux ?
(A) cmp
(B) test
(C) grep
(D) file
Answer:
(B) test

Question 49.
In Linux, how many logical operators are there ?
(A) 2
(B) 3
(C) 4
(D) 1
Answer:
(B) 3

Question 50.
Which logical operator results to true if both conditions are true, otherwise false in Linux ?
(A) !
(B) – 0
(C) – α
(D) – n
Answer:
(C) – α

Question 51.
The IF statement can work with which of the following in Linux ?
(A) Strings
(B) Files
(C) All of these
(D) Numerical values
Answer:
(C) All of these

Question 52.
In shell script to perform numerical test, which relational operator is used for “equal to” ?
(A) – ne
(B) – gt
(C) – lt
(D) – eq
Answer:
(D) – eq

Question 53.
Which block will be executed in IF statement, if the condition is evaluated to true in Linux ?
(A) case
(B) elif
(C) fi
(D) then
Answer:
(D) then

Question 54.
The end of IF statement is indicated by which statement in linux ?
(A) fi
(B) case
(C) elif
(D) then
Answer:
(A) fi

Question 55.
Which of the following is an unmanned moon mission launched by ISRO in October 2008 ?
(A) Cyaan – 1
(B) Chandrayaan – 1
(C) None of these
(D) Chandra – 10
Answer:
(B) Chandrayaan – 1

Question 56.
Which system consists of a network of 24 satellites placed into orbit above earth ?
(A) RFD
(B) SSP
(C) DIS
(D) GPS
Answer:
(D) GPS

Question 57.
The Transponder is RFID tag which is programmed in microchip and is capable of storing information of around how many bytes ?
(A) 8000 bytes or more
(B) 6000 bytes or more
(C) 2000 bytes or less
(D) 5000 bytes or more
Answer:
(C) 2000 bytes or less

Question 58.
Which of the following generally involves identification of humans based on their characteristics or behaviour ?
(A) Robotics
(B) Kinetics
(C) Kinematics
(D) Biometrics
Answer:
(D) Biometrics

Question 59.
Which of the following application is used in customer service segment to identify the caller ?
(A) GPS
(B) Biometric
(C) Automated identification of caller
(D) RFID
Answer:
(C) Automated identification of caller

Question 60.
Which device may consist of single terabyte hard disk or array of such hard disk ?
(A) NAS
(B) PAN
(C) AAS
(D) SAN
Answer:
(A) NAS

Question 61.
In shell script, the process of repeating the same commands for number of times, is known as …………….
(A) Repeating
(B) Rotation
(C) Continue
(D) Looping
Answer:
(D) Looping

Question 62.
Linux provides how many keywords, to perform repetitive actions ?
(A) 2
(B) 3
(C) 4
(D) 1
Answer:
(B) 3

Question 63.
Which file test condition is used if a directory with specified name exists in Linux ?
(A) – d name
(B) – r name
(C) – w name
(D) – s name
Answer:
(A) – d name

Question 64.
In shell script when number of comparison increases, which other statement can be used ?
(A) until
(B) case
(C) do
(D) for
Answer:
(B) case

Question 65.
In case statements, all the statements written within the section are executed until which symbol is encountered in Linux ?
(A) #
(B) ;;
(C) =
(D) *
Answer:
(B) ;;

Question 66.
In case statement, which symbol is used that allows a user to exit the script or perform additional processing after displaying an appropriate message in Linux ?
(A) ;;
(B) =
(C) *
(D) #
Answer:
(C) *

Question 67.
The end of case statement is specified by which keyword in Linux ?
(A) for
(B) exit
(C) esac
(D) fi
Answer:
(C) esac

Question 68.
Which of the following is used for free online storage option ?
(A) Mozy
(B) Divshare
(C) All of these
(D) A Drive
Answer:
(B) Divshare

Question 69.
Which of the following refers to program launched in 1992 was the first step towards green computing ?
(A) Save Earth
(B) Energy Planet
(C) Save Energy
(D) Energy Star
Answer:
(D) Energy Star

Question 70.
Some Internet-enabled TVs are capable of streaming data from which of the following ?
(A) Amazon
(B) Picasa Web Albums.
(C) All of these
(D) Youlhbe
Answer:
(C) All of these

Question 71.
Which of the following model of cloud computing is a business organization which is a software company that creates software using tools and/or libraries from service provider ?
(A) SaaS
(B) IaaS
(C) DaaS
(D) PaaS
Answer:
(D) PaaS

Question 72.
Which of the following is a dedicated network for storage and it provides access to consolidated, block level data storage ?
(A) SAN
(B) PAN
(C) TAS
(D) NAS
Answer:
(A) SAN

Question 73.
Which application is a collection of related data objects known as Tables, Queries, Reports and Application modules ?
(A) Base
(B) Flash
(C) Writer
(D) Synfig
Answer:
(A) Base

Question 74.
In table, which of the following are real world objects about which information is to be stored in database ?
(A) Attribute
(B) Entity
(C) Data
(D) Relationship
Answer:
(B) Entity

Question 75.
In Linux using which loop, each value mentioned within the list will be executed ?
(A) while
(B) until
(C) if
(D) for
Answer:
(D) for

Question 76.
In Linux, while statement repeats the set of commands specified between which keywords ?
(A) do and done
(B) start and end
(C) begin and end
(D) case ….. esac
Answer:
(A) do and done

Question 77.
In Linux, which loop executes till the condition is false ?
(A) while
(B) until
(C) case
(D) for
Answer:
(B) until

Question 78.
What is used in Linux shell script to make scripting more modular ?
(A) Functions
(B) Loop
(C) Decision statement
(D) Commands
Answer:
(A) Functions

Question 79.
All kinds of facts, figures and details related to people, places, things or events is known as what in base ?
(A) Database
(B) Variable
(C) Data
(D) Information
Answer:
(C) Data

Question 80.
The required result obtained from processing of data is known as ?
(A) Database
(B) Variable
(C) Data
(D) Information
Answer:
(D) Information

Question 81.
In Base, while designing query using wizard which of the following work is done in seventh step ?
(A) To print a query.
(B) To give aliases for selected field names.
(C) Not related to query.
(D) To copy a query.
Answer:
(B) To give aliases for selected field names.

Question 82.
In Base, once query is completed, we can view query result immediately by choosing which of the following options ?
(A) Show Query
(B) Change Query
(C) Display Query
(D) Open Query
Answer:
(C) Display Query

Question 83.
In Base, by clicking on which option of Query design toolbar, we will get output of Query ?
(A) Execute Query
(B) Show Query
(C) Final Query
(D) Run Query
Answer:
(D) Run Query

Question 84.
In Base, while we are using query, text must be enclosed within which delimeter ?
(A) “ ” (Double quote)
(B) $ (Dollar)
(C) # (Hash)
(D) ‘ ’ (Single quote)
Answer:
(D) ‘ ’ (Single quote)

Question 85.
In Base, which of the following is used as set of rules for fetching information from a table, or from several table, at once ?
(A) Field
(B) Report
(C) Form
(D) Query
Answer:
(D) Query

Question 86.
In Base, while creating query using wizard which step mentions the sort order in which output of query will be displayed ?
(A) Second
(B) Third
(C) Fourth
(D) First
Answer:
(A) Second

Question 87.
Combination of more than one field designated, as a primary key is also known as what in Base ?
(A) Foreign key
(B) Master key
(C) Parent key
(D) Composite primary key
Answer:
(D) Composite primary key

Question 88.
One value of referred table is associated with multiple values in referencing table in Base and is called which type of relationship ?
(A) Many-to-many
(B) Many-to-one
(C) One-to-many
(D) One-to-one
Answer:
(C) One-to-many

Question 89.
The process of correcting the data entered previously in Base is known as …………….
(A) Formatting
(B) Deleting
(C) Clearing
(D) Editing
Answer:
(D) Editing

Question 90.
Which term is used in Base for un-necessary duplication or repetition of data ?
(A) Cascade
(B) Data editing
(C) Data redundancy
(D) Referential Integrity
Answer:
(C) Data redundancy

Question 91.
What is known as a process that suggests decomposition of single table into multiple tables, thus creating a parent-child relationship in Base ?
(A) Primary key
(B) Composition
(C) Update relationship
(D) Normalization
Answer:
(D) Normalization

Question 92.
The table which contains primary key in Base is known as ………………
(A) Child table
(B) Master table
(C) Sub table
(D) Super table
Answer:
(B) Master table

Question 93.
What can be defined as field or combination of fields whose values are borrowed from another table in Base ?
(A) Composite key
(B) Foreign key
(C) Master key
(D) Primary key
Answer:
(B) Foreign key

Question 94.
Which of the following statement is true for Query in Base ?
(A) Query can be written only once.
(B) Query cannot be created using wizard.
(C) Query cannot be written on a query.
(D) Query can be stored as an object in database and reused.
Answer:
(D) Query can be stored as an object in database and reused.

Question 95.
Which of the following is used to group the result of a query in Base ?
(A) Order by
(B) Group by
(C) Arrange by
(D) Set of
Answer:
(B) Group by

Question 96.
Which of the following is not a comparison operator in Base ?
(A) <= and >=
(B) = and < >
(C) or and not
(D) < and >
Answer:
(C) or and not

Question 97.
In Base, which calculation includes numeric, date and text calculations on each record using data from one or more fields ?
(A) Custom calculation
(B) Wild card
(C) Calculator
(D) Function
Answer:
(A) Custom calculation

Question 98.
In Base, which queries are designed to accept values from the user at run time ?
(A) Asking Query
(B) Parameter Query
(C) Argument Query
(D) Structured Query
Answer:
(B) Parameter Query

Question 99.
What is the full form of SQL ?
(A) Simple Question for large Database
(B) Structured Query Language
(C) Structured Queries for large Databases
(D) Simple Query Language
Answer:
(B) Structured Query Language

Question 100.
Which of the following is not an aggregate function in Base ?
(A) Count
(B) Sum
(C) Average
(D) Square root
Answer:
(D) Square root