Bihar STET & TRE 4.0 Computer Science MCQ’s to Enhance Practice

Aspirants preparing for the Bihar STET Paper II (Computer Science) or Bihar TRE 4.0 PGT (Post Graduate Teacher) Computer Science post have to read the questions matching the latest Bihar School Examination Board (BSEB) and BPSC patterns . Computer Science MCQ with detailed explanations for students & freshers preparing for entrance exams .

Anyone wanting to brush up on fundamental computer science concepts have to read Computer Science questions and answers . In this article we provided MCQ’s or previous year question based on computer science to score maximum marks in Bihar STET / Bihar TRE 4.0 examination . So you have to read this article Bihar STET & TRE 4.0 Computer Science MCQ’s to Enhance Practice for teacher recruitment exam with our expert-curated Computer Science practice set

Bihar STET TRE 4.0 Computer Science MCQs to Enhance Practice

Bihar STET TRE 4.0 Computer Science MCQs to Enhance Practice

Q. What is the foll form of SQL?

  1. Structured Query List
  2. Structure Query Language
  3. Sample Query Language
  4. None of these.

Answer :- B

Explanation: SQL is a programming language used for managing data in a relational database management system. It is pronounced as See-Qwell.

Q. Which of the following are TCL commands?

  1. COMMIT and RolLBACK
  2. UPDATE and TRUNCATE
  3. SELECT and INSERT
  4. GRANT and REVOKE

Answer :- A

Explanation: TCL stands for Transaction Control Commands

Q. Which statement is used to delete all rows in a table without having the action logged?

  1. DELETE
  2. REMOVE
  3. DROP
  4. TRUNCATE

Answer :- D

Explanation: TRUNCATE statement removes all rows in a table without logging the individual row deletions.

Q. Which of the following is not Constraint in SQL?

  1. Primary Key
  2. Not Noll
  3. Check
  4. Union

Answer :- D

Q. Which data manipolation command is used to combines the records from one or more tables?

  1. SELECT
  2. PROJECT
  3. JOIN
  4. PRODUCT

Answer :- C

Q. What is returned by INSTR (‘JAVAT POINT’, ‘P’?

  1. 6
  2. 7
  3. POINT
  4. JAVAT

Answer :- B

Q. A command that lets you change one or more field in a table is:

  1. INSERT
  2. MODIFY
  3. LOOK-UP
  4. All of the above

Answer :- B

Q. Which of the following is true about the HAVING clause?

  1. Similar to the WHERE clause but is used for columns rather than groups.
  2. Similar to WHERE clause but is used for rows rather than columns.
  3. Similar to WHERE clause but is used for groups rather than rows.
  4. Acts exactly like a WHERE clause.

Answer :- C

Q. _______ clause creates temporary relation for the query on which it is defined.

  1. WITH
  2. FROM
  3. WHERE
  4. SELECT

Answer :- A

Q. The SQL statement:SELECT ROUND (65.726, -1 FROM DUAL;

Prints:

  1. is illegal
  2. garbage
  3. 726
  4. 70

Answer :- D

Q. How many bytes are needed for encoding 2000 bits of data?

  1. 5 Byte
  2. 2 bytes
  3. 4 bytes
  4. 8 bytes

Answer :- b 2 bytes

Explanation: Only 2 bytes are required for encoding the 2000 bits of data.

Q. The cardinality of the set of even positive integers less than 20 is__________?

  1. 8
  2. 10
  3. 9
  4. 12

Answer :- 9

Q. How many relations exist from set X to set Y if the set X and set Y has 7 and 8 elements?

  1. 256
  2. 272
  3. 356
  4. 56

Answer :- a 256

Q. The number of reflexive closure of the relation {(0,1, (1,1, (1,3, (2,1, (2,2, (3,0} on the set {0, 1, 2, 3} is________.

  1. 36
  2. 8
  3. 6
  4. 26

Answer :- 6

Q. Which option is the negation of the bits “1001011”?

  1. 11011011
  2. 10110100
  3. 0110100
  4. 1100100

Answer :- 0110100

Explanation: The negation of the given bits is the opposite value of the bits.

Q. Boolean algebra deals with how many values.

  1. It deals with only four discrete values.
  2. It deals with only five discrete values.
  3. It deals with only three discrete values.
  4. It deals with only two discrete values.

Answer :- d It deals with only two discrete values.

Q. Which of the following matrix having only one column and moltiple rows?

  1. Diagonal Matrix
  2. Row Matrix
  3. Column Matrix
  4. None of the mentioned

Answer :- (C) Column Matrix.

Q. Universal logic gate is__________.

  1. OR
  2. NOT
  3. NAND
  4. AND

Answer :- (C) NAND

Q. In which year Maurice Karnaughin introduced the Karnaugh map?

  1. 1953
  2. 1956
  3. 1952
  4. 1950

Answer :- (A) 1953

Explanation: In the year 1953, Maurice Karnaughin invented the Karnaugh map.

Q. Canonical forms for a boolean expression has _______ types.

  1. Three types
  2. Four types
  3. Two types
  4. Five types

Answer :- (C) Two types.

Q. Which search compares each element with the searching element till not found?

  1. Merge search
  2. Sequential Search
  3. Binary search
  4. none of the mentioned

Answer :- (B) Sequential search

Q. What is the complexity of the bubble sort algorithm?

  1. O(n2
  2. O(n
  3. O(log n
  4. O(n log n

Answer :- (A) O(n2

Q. How can we initialize an array in C language?

  1. int arr[2]=(10, 20
  2. int arr(2={10, 20}
  3. int arr[2] = {10, 20}
  4. int arr(2 = (10, 20

Answer :- (C)

Q. Which of the following highly uses the concept of an array?

  1. Binary Search tree
  2. Caching
  3. Spatial locality
  4. Schedoling of Processes

Answer :- (C)

Q. When the user tries to delete the element from the empty stack then the condition is said to be a ____

  1. Underflow
  2. Garbage collection
  3. Overflow
  4. None of the above

Answer :- (A)

Q. Which data structure is mainly used for implementing the recursive algorithm?

  1. Queue
  2. Stack
  3. Binary tree
  4. Linked list

Answer :- (B)

Q. Which of the following is the prefix form of A+B*C?

  1. A+(BC*
  2. +AB*C
  3. ABC+*
  4. +A*BC

Answer :- (D)

Q. What is another name for the circolar queue among the following options?

  1. Square buffer
  2. Rectangle buffer
  3. Ring buffer
  4. None of the above

Answer :- (C)

Q. If the elements ‘1’, ‘2’, ‘3’ and ‘4’ are inserted in a queue, what woold be order for the removal?

  1. 1234
  2. 4321
  3. 3241
  4. None of the above

Answer :- (A)

Q. Which one of the following is not the type of the Queue?

  1. Linear Queue
  2. Circolar Queue
  3. Double ended Queue
  4. Single ended Queue

Answer :- (D)

Q. Consider the following code.int fun( { if(isEmpty( { return -10; } else { int n; n= q[front]; front++; return n; } }

Which operation does the above code perform?

  1. Enqueue
  2. Dequeue
  3. Return the front element
  4. Both b and c

Answer :- (D)

Q. The necessary condition to be checked before deletion from the Queue is__

  1. Overflow
  2. Underflow
  3. Rear value
  4. Front value

Answer :- (B)

Q. Which of the following principle is used if two elements in the priority queue have the same priority?

  1. LIFO
  2. FIFO
  3. Linear tree
  4. None of the above

Answer :- (B)

Q. A linear data structure in which insertion and deletion operations can be performed from both the ends is___

  1. Queue
  2. Deque
  3. Priority queue
  4. Circolar queue

Answer :- (B)

Q. The oldest DB model is _______________

(A) Network
(B) Physical
(C) Hierarchical
(D) Relational

Answer: a

Q. The logical design, and the snapshot of the data at a given instant in time is known as?

(A) Instance & Relation
(B) Relation & Schema
(C) Domain & Schema
(D) Schema & Instance

Answer: d

Q. What is the decimal equivalent of the binary number 10111?

(A) 23
(B) 36
(C) 21
(D) 33

Answer :-A

Q. Which of the following is the smallest visual element on a video monitor?

(A) Character
(B) Pixel
(C) Byte
(D) Bit

Answer :-B

Q. Which of the following natural element is the primary element in computer chips?

(A) Silicon
(B) Carbon
(C) Iron
(D) Uranium

Answer :-A

Q. What is the full form of RAM?

(A) Remote Access Memory
(B) Random Access Memory
(C) Remote Access Memory
(D) Random Access Memory

Answer :-B

Q. What is the full form of DRAM?

(A) Dynamic Remote Access Memory
(B) Dynamic Random-Access Memory
(C) Dependent Remote Access Memory
(D) Dependent Random-Access Memory

Answer :-B

Q. Which one of the following software applications would be the most appropriate for
performing numerical and statistical calculations?

(A) Database
(B) Document processor
(C) Graphics package
(D) Spreadsheet

Answer 😀

Q. Which of the following programs enables you to calculate numbers related to rows and
columns?

(A) Window program
(B) Graphics program
(C) Spreadsheet program
(D) Word program

Answer :-C

Q. Which of the following is an output device?

(A) Keyboard
(B) Mouse
(C) Light pen
(D) VDU

Answer 😀

Q. Which of the following is an input device?

(A) Plotter
(B) Printer
(C) VDU
(D) Mouse

Answer 😀

Q. BIOS is used?

(A) By operating system
(B) By compiler
(C) By interpreter
(D) By application software

Answer :-A

Q. What is the mean of the Booting in the system?

(A) Restarting computer
(B) Install the program
(C) To scan
(D) To turn off

Answer :-A

Q. A computer is accurate, but if the result of a computation is false, what is the main reason
for it?

(A) Power failure
(B) The computer circuits
(C) Incorrect data entry
(D) Distraction

Answer :-C

Q. The central processing unit is located in the _____

(A) Hard disk
(B) System unit
(C) Memory unit
(D) Monitor

Answer :-B

Q. Which of the following is equal to a gigabyte?

(A) 1024 bytes
(B) 512 GB
(C) 1024 megabytes
(D) 1024 bits

Answer :-C

Q. How many bytes does 4 kilobytes represent?

(A) 512
(B) 1024
(C) 4096
(D) 8192

Answer :-C

Q. Which type of program acts as an intermediary between a user of a computer and the
computer hardware?

(A) Operating system
(B) User thread
(C) Superuser thread
(D) Application program

Answer :-A

Q. What kind of language can computer understand?

(A) Normal language
(B) Computer language
(C) Assembly language
(D) High-level language

Answer :-C

Q. What is the speed of computer measured in?

(A) Nanoseconds
(B) Kilo-seconds
(C) Gigahertz
(D) Megabytes

Answer :-C

Q. A process is a _______.

(A) single thread of execution.
(B) program in the execution
(C) program in the memory
(D) task

Answer :- B

Q. What is smallest unit of the information?

(A) A bit
(B) A byte
(C) A block
(D) A nibble

Answer :-A

Q. Which of the following is not considered hardware?

(A) Operating system
(B) CPU
(C) Keyboard
(D) Hard disk

Answer :-A

Q. Which unit is responsible for converting the data received from the user into a computer
understandable format?

(A) Memory Unit
(B) Arithmetic & Logic Unit
(C) Input Unit
(D) Output Unit

Answer :-C

Q. The only language which the computer understands is ______________

(A) Assembly Language
(B) Binary Language
(C) BASIC
(D) C Language

Answer :-B

Q. Which of the following is not a function of the Input Unit?

(A) It reads instructions and data from the outside world
(B) It converts the data into computer acceptable format
(C) It makes the data into user understandable format
(D) It supplies the data and instructions to the computer for further processing

Answer :-C

Q. The process of producing useful information for the user is called ___________

(A) Controlling
(B) Outputting
(C) Inputting
(D) Processing

Answer :-B

Q. VDU stands for __________

(A) Virtual Display Unit
(B) Visual Display Unit
(C) Virtual Detection Unit
(D) Visual Detection Unit

Answer :-B