By solving the Computer Class 11 GSEB Solutions and GSEB Class 11 Computer Question Paper April 2014 (For Science Stream) will be able to know the exam pattern in the exam.
GSEB Std 11 Computer Question Paper April 2014 (For Science Stream)
Question 1.
The meaning of ………………. is that we have total 4 records in our table and at present our cursor is on the second record.
(A) record 2 of 2 × 2
(B) record 2 of 2 + 2
(C) record 2 of 4
(D) record 4 of 2
Answer:
(C) record 2 of 4
Question 2.
To delete a record from the table …………..
(A) right click the selected record and choose delete record option from the sub menu.
(B) all the given three options.
(C) press DEL key from the keyboard.
(D) select Delete option from Edit menu.
Answer:
(B) all the given three options.
Question 3.
Which of the following operator is used with wild card character ?
(A) Equal
(B) =
(C) Like
(D) Is
Answer:
(C) Like
Question 4.
Which command is used to make new table in SQL view ?
(A) Make table
(B) Table
(C) Select table
(D) Create table
Answer:
(D) Create table
Question 5.
Which of the following statement is false ?
(A) Query cannot be written on a query.
(B) All the given three options.,
(C) Query can be stored as an object in database and reused.
(D) Query can be created using wizard.
Answer:
(A) Query cannot be written on a query.
Question 6.
Which of the following is used to group the result of a query ?
(A) Arrange by
(B) Set of
(C) Order by
(D) Group by
Answer:
(D) Group by
Question 7.
Which delimiter is used to surround the date in a query criterion ?
(A) $ (dollar)
(B) # (hash)
(C) “ ’’(double quote)
(D) ‘ ’(single quote)
Answer:
(B) # (hash)
Question 8.
Which language is used in relational database to solve the query ?
(A) COBOL
(B) FORTRAN
(C) SQL
(D) BASIC
Answer:
(C) SQL
Question 9.
SQL stands for ?
(A) Simple Question for large Databases.
(B) Stmctured Queries for large Databases.
(C) Simple Query Language.
(D) Structured Query Language.
Answer:
(D) Structured Query Language.
Question 10.
Which query, when run, displays a dialog box asking to enter the value to match the criteria for retrieving the data ?
(A) Parameter query
(B) Update query
(C) Select query
(D) Insertquery
Answer:
(A) Parameter query
Question 11.
Which command is used to remove table in SQL view ?
(A) Drop table
(B) Dropdown table
(C) Select table
(D) Erase table
Answer:
(A) Drop table
Question 12.
Reports in Base can be based on which of the following objects ?
(A) Query and table both
(B) None of the given three options
(C) Query
(D) Table
Answer:
(A) Query and table both
Question 13.
Which thing is used to present informations in an attractive, arranged and decisive manner in Base ?
(A) Tables
(B) Reports
(C) Forms
(D) Queries
Answer:
(B) Reports
Question 14.
What is an alias ?
(A) Alias is used to print query.
(B) Alias is nowhere related to query.
(C) Alias is creation of duplicate query.
(D) Alias is used to give meaningful name to fields selected in a query.
Answer:
(D) Alias is used to give meaningful name to fields selected in a query.
Question 15.
Which of the following operator is used as Wild card character in Base ?
(A) –
(B) *
(C) &
(D) +
Answer:
(B) *
Question 16.
In the language of databases, a ………….. is a front end for data entry and editing.
(A) report
(B) query
(C) form
(D) table
Answer:
(C) form
Question 17.
In step ……………… of report wizard, you will be asked to give the title of the report.
(A) fifth
(B) third
(C) eighth
(D) sixth
Answer:
(D) sixth
Question 18.
Base is used for creating which of the following ?
(A) Report
(B) All the given three options
(C) Form
(D) Table
Answer:
(B) All the given three options
Question 19.
By clicking on which button, all the fields of table can be transferred to report ?
(A) →
(B) >>
(C) ←
(D) <<
Answer:
(B) >>
Question 20.
For what main purpose a form is designed ?
(A) To create tables
(B) To view query result
(C) To display data
(D) To enter data
Answer:
(D) To enter data
Question 21.
Report wizard is used to create report from how many tables at a time ?
(A) Three
(B) More than three
(C) One
(D) Two
Answer:
(C) One
Question 22.
Which option is used to select a field ?
(A) Double click
(B) Right click
(C) CTRL + click
(D) Click
Answer:
(C) CTRL + click
Question 23.
Help text created by user can be generally associated with which of the following object ?
(A) Control field on form
(B) Report
(C) Table
(D) Form
Answer:
(D) Form
Question 24.
The term Cloud in’ Cloud Computing’ represents which of the following ?
(A) People
(B) Internet
(C) Wireless
(D) Hard drives
Answer:
(A) People
Question 25.
Google Drive is an example of which of the following cloud types ?
(A) Personal cloud
(B) Business cloud
(C) Private cloud
(D) Public cloud
Answer:
(A) Personal cloud
Question 26.
The activity that we perform with the use of a computer is generally termed as ……………..
(A) booting
(B) creating
(C) computing
(D) remote sensing
Answer:
(C) computing
Question 27.
Which of the following is full form of PDA ?
(A) Private Data Access
(B) Private Data Assistant
(C) Personal Digital Access
(D) Personal Digital Assistant
Answer:
(D) Personal Digital Assistant
Question 28.
Which of the following is a model of cloud computing ?
(A) SaaS
(B) All the given three options
(C) PaaS
(D) laaS
Answer:
(B) All the given three options
Question 29.
Which of the following is correct full form of laaS ?
(A) Information as a Service
(B) Industry as a Service
(C) Infrastructure as a Service
(D) Internet as a Service
Answer:
(C) Infrastructure as a Service
Question 30.
Which of the following represents the maximum storage capacity of the microchip used in RFID ?
(A) 1000 bytes
(B) 500 bytes
(C) 10 bytes
(D) 2000 bytes
Answer:
(D) 2000 bytes
Question 31.
Which of the following is an advantage of cloud ?
(A) Immediate access to computing resources.
(B) All the given three options.
(C) No worries about running out of storage.
(D) Easier to maintain a cloud network.
Answer:
(B) All the given three options.
Question 32.
The typical mobile computing device has …………….. primary components.
(A) communication
(B) all the given three options.
(C) software
(D) hardware
Answer:
(B) all the given three options.
Question 33.
…………….. is the most popular means of communications used for wireless data
transfer within a fixed location.
(A) Wi-Fi
(B) Android
(C) 2G
(D) 3G
Answer:
(A) Wi-Fi
Question 34.
At least how many satellites does the GPS receiver require to calculate only latitude and longitude ?
(A) Three
(B) None of the given three options
(C) One
(D) Two
Answer:
(A) Three
Question 35.
…………. is one of the widely used systems for navigation applications.
(A) Cloud Computing
(B) GPRS
(C) GPS
(D) MMS
Answer:
(C) GPS
Question 36.
The idea of Bluetooth was initially conceived by a company named ………….. .
(A) HTC
(B) Micromax
(C) Nokia
(D) Ericsson
Answer:
(D) Ericsson
Question 37.
…………… is the oldest satellite phone operator.
(A) Nokia
(B) Micromax
(C) Inmarsat
(D) Ericsson
Answer:
(C) Inmarsat
Question 38.
Which of the following is correct full form of NAS ?
(A) New Approved System
(B) New Attached Storage
(C) National Attached System
(D) Network Attached Storage
Answer:
(D) Network Attached Storage
Question 39.
2G had data speed of approximately ……………
(A) 19.2 Kbps
(B) 3 Mbps
(C) 1.2 Mbps
(D) 1.2 Kbps
Answer:
(C) 1.2 Mbps
Question 40.
Which of the following refers to a program launched in 1992 as a step towards green computing ?
(A) ENERGY SAVE
(B) SAVE ENERGY
(C) STAR ENERGY
(D) ENERGY STAR
Answer:
(D) ENERGY STAR
Question 41.
Which of the following is correct full form of 3G ?
(A) 3rd Global
(B) 3rd Genetics
(C) 3rd Generation
(D) Three Grand
Answer:
(C) 3rd Generation
Question 42.
One of the most widely used technology for identification and tracking of objects used in the market is …………….
(A) Cloud Computing
(B) GPRS
(C) RFID
(D) GPS
Answer:
(C) RFID
Question 43.
A biometric system generally is made of ……………. components.
(A) five
(B) seven
(C) one
(D) three
Answer:
(A) five
Question 44.
: w in Vim editor is used for which of the following activities ?
(A) To quit editing mode without saving changes made in the file.
(B) All the given three options.
(C) To save file and remain in editing mode.
(D) To save file and quit editing mode.
Answer:
(C) To save file and remain in editing mode.
Question 45.
By pressing which of the following key, we can go from command mode to last line mode ?
(A) Esc (Escape)
(B) i
(C) : (colon)
(D) ; (semicolon)
Answer:
(C) : (colon)
Question 46.
Which of the following statements is used to search for phrase in the file ?
(A) : ! cmd
(B) /phrase < ENTER >
(C) : set is
(D) : help cmd
Answer:
(A) : ! cmd
Question 47.
Which of the following keys are used to delete a word ?
(A) d$
(B) d*
(C) dd
(D) dw
Answer:
(D) dw
Question 48.
Note that while assigning values to the shell variables using the assignment operator ‘=’,
…………
(A) there should be space on left side of =
(B) there should be space on right side of =
(C) there should be no spaces on either side of =
(D) there should be spaces on either side of =
Answer:
(C) there should be no spaces on either side of =
Question 49.
In linux …………… command clear the screen.
(A) clear screen
(B) screen clear
(C) els
(D) clear
Answer:
(D) clear
Question 50.
If the shell is unable to understand a word as a variable, it will interpret it as a ……………..
(A) Linux directory
(B) All the given three options
(C) Linux command
(D) Linux file
Answer:
(C) Linux command
Question 51.
Which command will you type to execute the script named max.sh ?
(A) bash max
(B) All the given three options
(C) sh max.sh
(D) sh max
Answer:
(C) sh max.sh
Question 52.
To see the processes associated with the current shell we can issue the …………….. command without any parameters.
(A) sp
(B) pid
(C) pi
(D) ps
Answer:
(D) ps
Question 53.
To remove the process from memory we use the ………….. command.
(A) remove
(B) kill
(C) delete
(D) clear
Answer:
(B) kill
Question 54.
How many logical operators are allowed by shell while testing a condition ?
(A) Four
(B) Six
(C) Two
(D) Three
Answer:
(D) Three
Question 55.
Which of the following can be used in place of test command used in if condition ?
(A) Check command
(B) All the given three options
(C) Curly braces
(D) Square brackets
Answer:
(D) Square brackets
Question 56.
Which of the following keyword specifies the end of the IF statement ?
(A) fi
(B) stop-if
(C) end-if
(D) end if
Answer:
(A) fi
Question 57.
Which of the following command is used to compress directory ?
(A) comp
(B) compress
(C) cmp
(D) tar
Answer:
(D) tar
Question 58.
Which of the following operator is used for greater than or equal to comparison in Linux ?
(A) – ge
(B) – eg
(C) > =
(D) = >
Answer:
(A) – ge
Question 59.
Which of the following command is used to compare two files ?
(A) Comp
(B) Compares
(C) Grep
(D) Cmp
Answer:
(D) Cmp
Question 60.
Which loop iterates till the condition evaluates to false ?
(A) For
(B) Case
(C) While
(D) Until
Answer:
(D) Until
Question 61.
Which of the following allows us to specify a list of values in its statement ?
(A) For
(B) If
(C) While
(D) Until
Answer:
(A) For
Question 62.
What is returned after using the function in shell script ?
(A) User code
(B) Function code
(C) Status code
(D) Master code
Answer:
(C) Status code
Question 63.
Which of the following statement is true for Kwrite ?
(A) It is not an editor
(B) It is available with GNOME Desktop environment.
(C) It is a Command line editor.
(D) It is a Graphical editor.
Answer:
(D) It is a Graphical editor.
Question 64.
In which of the following mode Vim editor works ?
(A) Last line mode
(B) All the given three options
(C) Command mode
(D) Insert mode
Answer:
(B) All the given three options
Question 65.
What is $1 in Linux ?
(A) option
(B) shell variable
(C) function
(D) command line argument
Answer:
(D) command line argument
Question 66.
rm command in Linux is used for what ?
(A) Rename a file
(B) Remove a file
(C) Move a directory
(D) Rename a directory
Answer:
(B) Remove a file
Question 67.
Which operator allows us two or more conditions to be combined in a test ?
(A) – o (OR)
(B) – a (AND) and – o (OR) both
(C) ! (NOT)
(D) -a (AND)
Answer:
(B) – a (AND) and – o (OR) both
Question 68.
What is small subscripts within a shell script called ?
(A) until loop
(B) function
(C) if condition
(D) while loop
Answer:
(B) function
Question 69.
While creating a shell script in Linux ……………. decision making instructions can be used.
(A) three
(B) four
(C) one
(D) two
Answer:
(B) four
Question 70.
All kinds of facts, figures and details related to people, places, things or events is known as …………..
(A) information
(B) data
(C) variable
(D) field
Answer:
(B) data
Question 71.
In Linux all programs are executed as
(A) process
(B) process id (PID)
(C) command
(D) shell script
Answer:
(D) shell script
Question 72.
By using ……………. more than one commands can be combined.
(A) >
(B) <
(C) 1 (pipe)
(D) =
Answer:
(C) 1 (pipe)
Question 73.
Which of the following is an object maintained by base ?
(A) Chart
(B) Clip Art
(C) Table
(D) Flow Chart
Answer:
(C) Table
Question 74.
Which data type can be used to store text ?
(A) Text
(B) Date
(C) Decimal
(D) Integer
Answer:
(A) Text
Question 75.
Which one of the following is a database ?
(A) Spreadsheet
(B) All the given three options
(C) Oracle
(D) FireFox
Answer:
(C) Oracle
Question 76.
The alphabet R in RDBMS stands for which of the following ?
(A) Random
(B) Ring
(C) Rotational
(D) Relational
Answer:
(D) Relational
Question 77.
Which of the following is a default extension of base database file ?
(A) .odb
(B) .dbf
(C) .bdf
(D) .odf
Answer:
(A) .odb
Question 78.
The presentation of information in an organized and readable format as per the user requirement is known as ……………
(A) query
(B) report
(D) table
(D) form
Answer:
(A) query
Question 79.
To insert records into the table, we must …………… the table first.
(A) minimize
(B) close
(C) open
(D) save
Answer:
(C) open
Question 80.
Which data type is used to store sound in base database ?
(A) Long
(B) Huge
(C) Binary
(D) Sound
Answer:
(C) Binary
Question 81.
Which of the following is a true statement ?
(A) Primary key can be combination of more than one field.
(B) Primary key is always numeric field.
(C) Primary key can contain null values.
(D) Primary key can contain duplicate values.
Answer:
(A) Primary key can be combination of more than one field.
Question 82.
A question asked within the database environment is known as ……………
(A) query
(B) report
(C) table
(D) form
Answer:
(A) query
Question 83.
“If user deletes or updates the referenced field, all the related records will hold null value in the related field”. To implement this, which of the following option is possible ?
(A) Set null
(B) Set default
(C) No action
(D) Update cascade
Answer:
(A) Set null
Question 84.
The pencil icon is an …………..
(A) record icon
(B) remove icon
(C) edit icon
(D) drawing icon
Answer:
(C) edit icon
Question 85.
Which of the following refers to data redundancy ?
(A) Decomposition of tables.
(B) Unnecessary duplication of data or repetition of data.
(C) Unnecessary duplication of data.
(D) Repetition of data.
Answer:
(D) Repetition of data.
Question 86.
Which of the following type of relationship exists between person and chair in a school ?
(A) Many to Many
(B) Many to One
(C) One to One
(D) One to Many
Answer:
(C) One to One
Question 87.
Which of the following statement is true for testing whether the file with the specified name exists and has size greater than 0 (zero) or not ?
(A) test – s filename
(B) check – s filename
(C) test – size filename
(D) check- size filename
Answer:
(A) test – s filename
Question 88.
Which of the following property is equivalent to NOT NULL ?
(A) Required
(B) Format
(C) Length
(D) Default
Answer:
(A) Required
Question 89.
By which of the following way the table data can be sorted ?
(A) In ascending order and descending order both
(B) None of the given three options
(C) In ascending order
(D) In descending order
Answer:
(A) In ascending order and descending order both
Question 90.
…………… can be defined as field or combination of fields whose values are borrowed from another table.
(A) Composite primary key
(B) None of the given three options
(C) Primary key
(D) Foreign key
Answer:
(D) Foreign key
Question 91.
Which of the following symbol is used to break the flow of control in the case statement ?
(A) ++
(B) >>
(C) **
(D) ;;
Answer:
(D) ;;
Question 92.
Which of the following operations can be performed on a record in database ?
(A) Update
(B) All the given three options
(C) Insert
(D) Delete
Answer:
(B) All the given three options
Question 93.
‘Auto Value’ property can be set for field with which of the following data type ?
(A) Integer
(B) Boolean
(C) Text
(D) Image
Answer:
(C) Text
Question 94.
The table which contains primary key is known as ……………..
(A) child table
(B) primary table
(C) master table
(D) parent table
Answer:
(C) master table
Question 95.
…………… is a process that suggests decomposition of single table into – multiple tables, thus creating a parent-child relationship.
(A) Update cascade
(B) Data normalization
(C) Repetition of data
(D) Action
Answer:
(B) Data normalization
Question 96.
The result of a select query is generally represented as which of the following components ?
(A) Constraint
(B) Relation
(C) Table
(D) Query
Answer:
(C) Table
Question 97.
How many steps are there to make query with the help of wizard ?
(A) Six
(B) Eight
(C) Three
(D) Four
Answer:
(B) Eight
Question 98.
The black pointing arrow icon 
indicates a …………… at any given moment of time.
(A) new record of the table.
(B) first record of the table.
(C) last record of the table.
(D) current record of the table.
Answer:
(D) current record of the table.
Question 99.
In query design “Like, Is, Between In” are which type of operator ?
(A) Comparison
(B) None of the given three options
(C) Special
(D) Logical
Answer:
(C) Special
Question 100.
Which of the following is an aggregate function ?
(A) Vlookup
(B) Hlookup
(C) Square root
(D) Sum
Answer:
(D) Sum