आपको शीर्ष अंक प्राप्त करने में मदद करने के लिए, हमने विस्तृत उत्तरों और स्पष्टीकरण के साथ कंप्यूटर विज्ञान MCQ प्रश्नों की एक व्यापक सूची तैयार की है। यह अभ्यास सेट पूरी तरह से नवीनतम BPSC और BSEB पाठ्यक्रम पर आधारित है। कई परीक्षाओं जैसे – राज्य TET, UPTET, CTET, MPTET, REET के लिए कंप्यूटर MCQ सबसे महत्वपूर्ण है। प्रवेश परीक्षा की तैयारी कर रहे छात्रों और फ्रेशर्स के लिए विस्तृत स्पष्टीकरण के साथ कंप्यूटर विज्ञान MCQ।
परीक्षा से पहले अपनी अवधारणाओं का परीक्षण करने, समय प्रबंधन में सुधार करने और त्वरित संशोधन के लिए इन विषय-वार MCQ का अभ्यास करें। इस लेख में हम कई सरकारी परीक्षाओं के लिए मुफ्त कंप्यूटर विज्ञान अभ्यास प्रश्न प्रदान करते हैं जिन्होंने कंप्यूटर शिक्षक की भर्ती का आयोजन किया था। इस लेख में हमने बिहार STET / बिहार TRE 4.0 परीक्षा में अधिकतम अंक प्राप्त करने के लिए कंप्यूटर विज्ञान पर आधारित MCQ या पिछले वर्ष के प्रश्न प्रदान किए हैं जिसे आप जरुर देखें |
Bihar STET Computer Science & BPSC TRE 4.0 Computer Teacher MCQ Practice Set
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)
Q. The minimum number of stacks required to implement a stack is __
- 1
- 3
- 2
- 5
Answer :- (C)
Q. What woold be the maximum value of the top that does not cause the overflow of the stack?
- 8
- 9
- 11
- 10
Answer :- (D)
Q. What is DBMS?
(A) DBMS is a collection of queries
(B) DBMS is a high-level language
(C) DBMS is a programming language
(D) DBMS stores, modifies and retrieves data
Answer: D
Q. What is a database?
(A) Organized collection of information that cannot be accessed, updated, and managed
(B) Collection of data or information without organizing
(C) Organized collection of data or information that can be accessed, updated, and managed
(D) Organized collection of data that cannot be updated
Answer: c
Q. In which of the following formats data is stored in the database management system?
(A) Image
(B) Text
(C) Table
(D) Graph
Answer: c
Q. Which of the following is not an example of DBMS?
(A) MySQL
(B) Microsoft Acess
(C) IBM DB2
(D) Google
Answer: d
Q. Which of the following is a component of the DBMS?
(A) Data
(B) Data Languages
(C) Data Manager
(D) All of the above
Answer: d
Q. What does an RDBMS consist of?
(A) Collection of Records
(B) Collection of Keys
(C) Collection of Tables
(D) Collection of Fields
Answer: c
Q. _____________ is a hardware component that is most important for the operation of a database management system.
(A) Microphone
(B) High speed, large capacity disk to store data
(C) High-resolution video display
(D) Printer
Answer: b
Q. The ability to query data, as well as insert, delete, and alter tuples, is offered by ____________
(A) TCL (Transaction Control Language
(B) DCL (Data Control Language
(C) DDL (Data Definition Langauge
(D) DML (Data Manipolation Langauge
Answer: d
Q. Which one of the following node is considered the top of the stack if the stack is implemented using the linked list?
- First node
- Second node
- Last node
- None of the above
Answer :- (A)
Q. Which one of the following is not the type of the Queue?
- Linear Queue
- Circolar Queue
- Double ended Queue
- Single ended Queue
Answer :- (D)
Q. Which of the following keys is generally used to represents the relationships between the tables?
- Primary key
- Foreign key
- Secondary key
- None of the above
Answer :- (B)
Q. The Database Management Query language is generally designed for the _____
- Support end-users who use English like commands
- Specifying the structure of the database
- Support in the development of the complex applications software
- All of the above
Answer :- (D)
Q. A computer security protocol for logging-in can be considered as the example of the ______ component of an information system.
- Data
- Software
- Procedure
- Hardware
Answer :- (C)
Q. Rows of a relation are known as the _______.
- Degree
- Tuples
- Entity
- All of the above
Answer :- (D)
Q. In general, a file is basically a collection of all related______.
- Rows & Columns
- Fields
- Database
- Records
Answer :- (D)
Q. A huge collection of the information or data accumolated form several different sources is known as ________:
- Data Management
- Data Mining
- Data Warehouse
- Both B and C
Answer :- (C)
Q. The term “FAT” is stands for_____
- File Allocation Tree
- File Allocation Table
- File Allocation Graph
- All of the above
Answer :- (B)
Q. What do you mean by one to many relationships?
- One class may have many teachers
- One teacher can have many classes
- Many classes may have many teachers
- Many teachers may have many classes
Answer :- (B)
Q. What woold be the output after performing the following operations in a Deque?Insertfront(10);
Insertfront(20);
Insertrear(30);
Insertrear(40;
Deletefront(); Insertfront(50);
Deleterear(); Display();
- 10, 20, 30
- 50, 10, 30
- 40, 20, 30
- None of the above
Answer :- (B)
Do you Know ?
Q. Who invented email in which year?
Ray Tomlinson invented and developed electronic mail and developed in 1971.
Q. who is the founder of twitter and which year ?
Twitter was created in March 2006 by Jack Dorsey, Noah Glass, Biz Stone, and Evan Williams .
Q. who is the founder of YouTube and which year ?
On February 14, 2005, Chad Hurley, Steve Chen, and Jawed Karim founded YouTube .
Q. who is the founder of Facebook and which year ?
Facebook was founded in 2004 by Mark Zuckerberg, Eduardo Saverin, Dustin Moskovitz, and Chris Hughes .
Q. who is the founder of Microsoft and which year ?
Microsoft was founded by Bill Gates and Paul Allen on April 4, 1975.
Please Read this Article : –
>>> Computer One-Liner Most Important Questions for Bihar STET & TRE 4.0
>>> Computer Science Practice Question for BPSC TRE / Computer Teacher Exams