Computer Science questions and answers always plays an important role in the exam and proves to be effective in getting your good marks. Computer questions are being asked in almost all the competitive examinations .IN this website we provide free and knowledgeable Practice MCQ Questions NCERT, Engineering Technical, Quantitative Aptitude, General knowledge, Reasoning, and Current Affairs for Competitive Exam so please read another article.
These Computer MCQ most important for many exam like – State TET, UPTET, CTET, MPTET, REET. Computer Science MCQ with detailed explanations for students & freshers preparing for entrance exams . Today in this post we are giving you important questions and their answers of Computer Science Objective GK Questions and Answers. Here in this article you read Computer Science Important MCQ .
Computer Science Practice Question for BPSC TRE / Computer Teacher Exams
Q. The term “Data” refers to:
- The electronic representation of the information( or data
- Basic information
- Row Facts and figures
- Both A and C
Answer :- (C)
Q. Rows of a relation are known as the _______.
- Degree
- Tuples
- Entity
- All of the above
Answer :- (D)In SQL, the relation is represented by a table, and a table is a collection of rows and columns.
Q. Which of the following refers to the number of tuples in a relation?
- Entity
- Column
- Cardinality
- None of the above
Answer :- (C)
Q. Which one of the following is a type of Data Manipolation Command?
- Create
- Alter
- Delete
- All of the above
Answer :- (C) Delete :- In data manipolation language, the command like select, insert, update, and delete is used to manipolate the information (or data, records, for example create a table, update table delete table, etc.
Q. Which of the following command is a type of Data Definition language command?
- Create
- Update
- Delete
- Merge
Answer :- (A)
Q. Which of the following is a top-down approach in which the entity’s higher level can be divided into two lower sub-entities?
- Aggregation
- Generalization
- Specialization
- All of the above
Answer :- (C)
Q. In which one of the following, the moltiple lower entities are grouped (or combined together to form a single higher-level entity?
- Specialization
- Generalization
- Aggregation
- None of the above
Answer :- (B)
Q. Which one of the following commands is used to restore the database to the last committed state?
- Savepoint
- Rollback
- Commit
- Both A & B
Answer :- (B)
Q. The database management system can be considered as the collection of ______ that enables us to create and maintain the database.
- Translators
- Programs
- Keys
- Language activity
Answer :- (B) , Database management system can also considered as the set of programs that enables users to create and maintain the database.
Q. The term “DFD” stands for?
- Data file diagram
- Data flow document
- Data flow diagram
- None of the above
Answer :- (C)”DFD” stands for the Data Flow Diagram
Q. Which of these is a standard interface for serial data transmission?
- ASCII
- RS232C
- 2
- Centronics
Answer :- (B) RS232C
Explanation: The RS232C is a standard interface for serial data transmission that defines the protocol and physical interface for transmitting serial data fairly easily between associated appliances and computers.
Q. Which type of topology is best suited for large businesses which must carefolly control and coordinate the operation of distributed branch outlets?
- Ring
- Local area
- Hierarchical
- Star
Answer :- (D) Star
Explanation: The star topology is the best network topology for large businesses because it is simple to control and coordinate from the central computer.
Q. Which of the following transmission directions listed is not a legitimate channel?
- Simplex
- Half Duplex
- Full Duplex
- Double Duplex
Answer :- (D) Double Duplex
Q. What is the worst case of a linear search algorithm?
- When the searching item is present in the middle of the list.
- When the searching item is the last element in the list.
- When the searching is not available in the list.
- When the searching item is the last element in the list or is not present in the list.
Answer :- (D) When the searching item is the last element in the list or is not present in the list.
Explanation: The worst case of the linear search algorithm is when the searching item is the last element in the list or is not present in the list.
Q. Which algorithm uses the previous outputs for finding the new outputs?
- Dynamic Programming algorithms
- Divide and Conquer algorithm
- Brute Force algorithm
- None of them
Answer :- (A) Dynamic Programming algorithms
Q. The use of Boolean algebra is ____________.
- in building the algebraic functions.
- in building logic symbols.
- in circuit theory.
- in designing the digital computers.
Answer :- (D) in designing the digital computers.
Explanation: The widely use of Boolean algebra is in designing digital computers and various electronic circuits.
Q. Boolean algebra deals with how many values.
- It deals with only four discrete values.
- It deals with only five discrete values.
- It deals with only three discrete values.
- It deals with only two discrete values.
Answer :- (D) It deals with only two discrete values.
Q. When the wildcard in a WHERE clause is usefol?
- When an exact match is required in a SELECT statement.
- When an exact match is not possible in a SELECT statement.
- When an exact match is required in a CREATE statement.
- When an exact match is not possible in a CREATE statement.
Answer :- (B)
Explanation: The wildcard is a character used to search complex data from the database quickly. We can use it in conjunction with the LIKE or NOT LIKE comparison operators and the WHERE clause to find the resolt for a specified pattern. Hence, the wildcard is very usefol when the exact match is not possible in the SELECT statement.
Q. ______ is NOT a type of constraint in SQL language?
- FOREIGN KEY
- PRIMARY KEY
- UNIQUE
- ALTERNATE KEY
Answer :- (D)
Q. Which operator is used to compare the NolL values in SQL?
- Equal
- IN
- IS
- None of Above
Answer :- (C)
Q. Which of the following is the correct order of a SQL statement?
- SELECT, GROUP BY, WHERE, HAVING
- SELECT, WHERE, GROUP BY, HAVING
- SELECT, HAVING, WHERE, GROUP BY
- SELECT, WHERE, HAVING, GROUP BY
Answer :- (B)
Q. Group of operations that form a single logical unit of work is known as
- View
- Network
- Unit
- Transaction
Answer :- (D)
Q. A CASE SQL statement is ________?
- A way to establish a loop in SQL.
- A way to establish an IF-THEN-ELSE in SQL
- A way to establish a data definition in SQL
- All of the above.
Answer :- (B)
Q. What is the outcome of the prefix expression +, -, *, 3, 2, /, 8, 4, 1?
- 12
- 11
- 5
- 4
Answer :- (C)
Q. Which data structure is required to convert the infix to prefix notation?
- Stack
- Linked list
- Binary tree
- Queue
Answer :- (A)
Computer Teacher MCQ | BPSC Computer teacher |BPSC TRE Computer | BPSC Teacher |Bihar TRE Computer Science | Bihar STET Computer Science
Q. Which of the following is the fastest media of data transfer?
(a) Co-axial Cable
(b) Untwisted Wire
(c) Telephone Lines
(d) Fiber Optic
Ans – (d) Fiber Optic
Q. What does MAN stands for?
(a) Micro area network
(b) Metropolitan area network
(c) Macro area network
(d) Mix area network
Ans – (b) Metropolitan area network
Q. Walkie-talkie is an example of which of the following?
(a) simplex communication
(b) half-duplex communication
(c) full-duplex communication
(d) semi-duplex communication
Ans – (b)
Q. What happens when you boot up a PC?
(a) Portions of the operating system are copied from disk into memory
(b) Portions of the operating system are copied from memory onto disk
(c) Portions of the Operating system are complied
(d) Portions of the operating system are emulated
Ans – (a)
Q. Which of the following is not a computer language?
(a) High-level language
(b) Machine language
(c) Low-level language
(d) Medium-level language
Ans – (d)
Q. The __ folder retains copies of messages that you have started but are not yet ready to send.
(a) Drafts
(b) Outbox
(c) Address Book
(d) Sent Items
Ans – a)
Q. Linux is an OS based on_____
(a) DBMS
(b) UNIX
(c) Network node
(d) J2EEE
Ans – b)
Q. Which of the following is used to close a tab on a browser?
(a) Ctrl + T
(b) Ctrl + W
(c) Ctrl + A
(d) Ctrl + Y
Ans – (b)
Q. The feature in database language that allows us to access certain records in database is called __.
(a) Query
(b) Forms
(c) Reports
(d) Tables
(e) Node
Ans – (a)
Q. UDP and TCP are categorized under the ___layer of the OSI model.
(a) Data link
(b) Application
(c) Network
(d) Transport
Ans – (d)
Q. SMTP, FTP and DNS are applications/protocols of the _ layer.
(a) Data link
(b) Network
(c) Transport
(d) Application
Ans – (d) Application Layer is responsible for providing services to user applications, such as email, file transfer, and domain name resolution.
Q. Which of the following technique is used to send more than one calls over a single line?
(a) Digital transmission
(b) Infrared transmission
(c) Digitizing
(d) Multiplexing
Ans – (d)
Q. A handheld device that allows you to control your computer without typing instructions from a keyboard is known as_______.
(a) Tablet
(b) PDA
(c) Mouse
(d) Mike
Ans – (c) Mouse
Q. What is SMPS?
(a) Settled Mode Power Supply
(b) Switched Mode Power Supply
(c) Switch Mode Packet Switch
(d) Supply Mode Packet Switch
Ans – (b)
Q. Which of the following hardware or software designed to guard against unauthorized access to a computer network?
(a) Hacker-proof program.
(b) Firewall.
(c) Hacker-resistant server.
(d) Encryption safe wall.
Ans – b)
Q. A device that not only provides surge protection but also furnishes the computer with battery backup power during a power outage is __
(a) Battery strip
(b) UPS
(c) Surge strip
(d) USB
Ans – (b)
Q. Which part of the CPU coordinates all the activities of a computer system?
(a) Motherboard
(b) Coordination board
(c) Control unit
(d) Arithmetic and logic unit
Ans – (c) CPU that accesses and decodes program instructions, and coordinates the flow of data among various system components is the Control unit.
Q. Which of the following is/are file extension(s) in DOS?
(a) EXE
(b) BAT
(c) COM
(d) All of these
Ans – (d) All of these
Q. Which among the following options is the application that combines text, sound, graphics, motion video, and/ or animation?
(a) Multimedia
(b) Minimedias
(c) Video scopes
(d) Motionware
Ans – (a) Multimedia
Q. Which among the following carries signals that control the actions of the computer?
(a) Control Bus
(b) Data Bus
(c) Memory Unit
(d) NIC
Ans – (a) Control Bus
Q. Which of the following is a requisite to ‘boot’, the system?
(a) Complier
(b) Mouse
(c) Operating system
(d) Assembler
Ans – (c) Operating system
Q. You can use…..to copy selected text; and …..to paste it in a document.
(A) CTRL+C, CTRL+V
(B) CTRL+C, CTRL+P
(C) CTRL+S, CTRL+S
(D) SHIFT+C, ALT+P
Ans – (A) CTRL+C, CTRL+V
Q. When a file is saved for the first time………
(A) a copy is automatically printed
(B) file name and folder name must be the same
(C) it does not need a name
(D) It must be given a name to identify it.
Ans – (D) It must be given a name to identify it.
Q. Forms that are used to organize business data into rows and columns are called……..
(A) Transaction sheets
(B) Registers
(C) Business forms
(D) Spreadsheets
Ans – (D) Spreadsheets
Q. A…………is a collection of information saved as unit.
(A) folder
(B) File
(C) path
(D) file extension
Ans – (B) File
Q. To correct the spelling in Ms-Word we use……
(A) Spellpro
(B) Spellcheck
(C) outlook Express
(D) All of These
Ans – (B) Spellcheck
Q. Numbers in table columns are usual….
(A) right-aligned
(B) left-aligned
(C) justified
(D) cantered
Ans – (b) left-aligned
Q. To save an existing file with new location we should……..command.
(A) save
(B) save and replace
(C) save as
(D) New file
Ans – (C) save as
Q. To print a document…..
(A) Select the Print command and then select ok
(B) Select the Ready Printer command and then select OK
(C) type Print and then press Enter
(D) None of these
Ans – (A) Select the Print command and then select ok
Q. What is a default file extension for all word documents?
(A) TXT
(B) WRD
(C) FIL
(D) DOC
Ans – (D) DOC
Q. WAN stands for __
(A) World area network
(B) Wide area network
(C) Web area network
(D) Web access network
Ans – (B) Wide area network