Computer Science Important MCQ

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-important-mcq

Computer science important mcq online test

Q. The term “Data” refers to:

  1. The electronic representation of the information( or data
  2. Basic information
  3. Row Facts and figures
  4. Both A and C

Answer :- (C)

Q. Rows of a relation are known as the _______.

  1. Degree
  2. Tuples
  3. Entity
  4. 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?

  1. Entity
  2. Column
  3. Cardinality
  4. None of the above

Answer :- (C)

Q. Which one of the following is a type of Data Manipolation Command?

  1. Create
  2. Alter
  3. Delete
  4. 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?

  1. Create
  2. Update
  3. Delete
  4. 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?

  1. Aggregation
  2. Generalization
  3. Specialization
  4. 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?

  1. Specialization
  2. Generalization
  3. Aggregation
  4. None of the above

Answer :- (B)

Q. Which one of the following commands is used to restore the database to the last committed state?

  1. Savepoint
  2. Rollback
  3. Commit
  4. 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.

  1. Translators
  2. Programs
  3. Keys
  4. 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?

  1. Data file diagram
  2. Data flow document
  3. Data flow diagram
  4. 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?

  1. ASCII
  2. RS232C
  3. 2
  4. 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?

  1. Ring
  2. Local area
  3. Hierarchical
  4. 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?

  1. Simplex
  2. Half Duplex
  3. Full Duplex
  4. Double Duplex

Answer :- (D) Double Duplex

Q. What is the worst case of a linear search algorithm?

  1. When the searching item is present in the middle of the list.
  2. When the searching item is the last element in the list.
  3. When the searching is not available in the list.
  4. 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?

  1. Dynamic Programming algorithms
  2. Divide and Conquer algorithm
  3. Brute Force algorithm
  4. None of them

Answer :- (A) Dynamic Programming algorithms

Q. The use of Boolean algebra is ____________.

  1. in building the algebraic functions.
  2. in building logic symbols.
  3. in circuit theory.
  4. 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.

  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. When the wildcard in a WHERE clause is usefol?

  1. When an exact match is required in a SELECT statement.
  2. When an exact match is not possible in a SELECT statement.
  3. When an exact match is required in a CREATE statement.
  4. 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?

  1. FOREIGN KEY
  2. PRIMARY KEY
  3. UNIQUE
  4. ALTERNATE KEY

Answer :- (D)

Q. Which operator is used to compare the NolL values in SQL?

  1. Equal
  2. IN
  3. IS
  4. None of Above

Answer :- (C)

Q. Which of the following is the correct order of a SQL statement?

  1. SELECT, GROUP BY, WHERE, HAVING
  2. SELECT, WHERE, GROUP BY, HAVING
  3. SELECT, HAVING, WHERE, GROUP BY
  4. SELECT, WHERE, HAVING, GROUP BY

Answer :- (B)

Q. Group of operations that form a single logical unit of work is known as

  1. View
  2. Network
  3. Unit
  4. Transaction

Answer :- (D)

Q. A CASE SQL statement is ________?

  1. A way to establish a loop in SQL.
  2. A way to establish an IF-THEN-ELSE in SQL
  3. A way to establish a data definition in SQL
  4. All of the above.

Answer :- (B)

Q. What is the outcome of the prefix expression +, -, *, 3, 2, /, 8, 4, 1?

  1. 12
  2. 11
  3. 5
  4. 4

Answer :- (C)

Q. Which data structure is required to convert the infix to prefix notation?

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

Answer :- (A)

कृपया शेयर जरुर करें -

Leave a Comment