Computer Science Most Expected Question Answer

Computer Science Important Questions : Computer science questions are most important for any competitive Examination. If you prepare for any competitive exam such as Computer teacher,Programmer ,IBPS, RRB, RBI, SBI, NABARD ,any competitive exams you prepare this Computer MCQ based Questions. These questions are most popular for your exams.

Through this post you will see the Best Computer Science MCQ . Computer awareness is Important topics for competitive exams. we have compiled most expected computer science MCQ . Here you learn Computer science question answer. Today in this post we are going to share with you Computer Science Most Expected Question Answer .

computer questions and answers

Computer Science questions and answers

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

Q. Who developed the basic architecture of computer?

  1. Blaise Pascal
  2. Charles Babbage
  3. John Von Neumann
  4. None of the above

Answer :- C. John Von Neumann

Q. Which of the following allows simoltaneous write and read operations?

  1. ROM
  2. EROM
  3. RAM
  4. None of the above

Answer :- C. RAM

Q. CISC stands for –

  1. Complex Instruction Set Computer
  2. Complete Instruction Sequential Compilation
  3. Complex Instruction Sequential Compiler
  4. None of the above

Answer :- (A) Complex Instruction Set Computer

Q. RISC stands for –

  1. Reduce Instruction Set Computer
  2. Risk Instruction Sequential Compilation
  3. Risk Instruction Source Compiler
  4. None of the above

Answer :- (A) Reduce Instruction Set Computer

Q. Which of the following is an essential data transfer technique?

  1. MMA
  2. DMA
  3. CAD
  4. CAM

Answer :- (B) DMA

Q.Which of the following is used as an intermediate to extend the processor BUS?

(A) Gateway
(B) Router
(C) Connector
(D) Bridge

D. Bridge

Q.The method of accessing the I/O devices by repeatedly checking the status flags is_________

(A) Memory-mapped I/O
(B) Program-controlled I/O
(C) I/O mapped
(D) None of the Above

B. Program-controlled I/O

Q.The process where in the processor constantly checks the status flags is called as _________

(A) Polling
(B) Inspection
(C) Reviewing
(D) None of the Above

A. Polling

Q. Which operator is used to compare a value to a specified list of values?

  1. ANY
  2. BETWEEN
  3. ALL
  4. IN

Answer :- D

Q. Which of the following is not considered as a peripheral device?

  1. CPU
  2. Keyboard
  3. Monitor
  4. All of the above

Answer :- CPU

Q. Which of the following memory of the computer is used to speed up the computer processing?

  1. Cache memory
  2. RAM
  3. ROM
  4. None of the above

Answer :- Cache memory

Q. Computer address bus is –

  1. Moltidirectional
  2. Bidirectional
  3. Unidirectional
  4. None of the above

Answer :- Unidirectional

Q. Where is the document temporarily stored during working on a document on PC?

  1. ROM
  2. CPU
  3. RAM
  4. Flash memory

Answer :- RAM

Q. Which of the following topology is used in Ethernet?

  1. Ring topology
  2. Bus topology
  3. Mesh topology
  4. Star topology

Answer :- Bus topology

Q. What does one thousand bytes represent?

  1. Kilobyte (KB
  2. Megabyte (MB
  3. Gigabyte (GB
  4. Terabyte (TB

Answer :- Kilobyte (KB)

Q. What does a computer bus line consists of?

  1. Set of parallel lines
  2. Accumolators
  3. Registers
  4. None of the above

Answer :- Set of parallel lines

Q. Which of the following building block can be used to implement any combinational logic circuit?

  1. AND
  2. OR
  3. NAND
  4. None of the above

Answer :- (C) NAND

Q. Which of the following is not a valid SQL type?

  1. FLOAT
  2. NUMERIC
  3. DECIMAL
  4. CHARACTER

Answer :- C

Q. Which datatype can store unstructured data in a column?

  1. CHAR
  2. RAW
  3. NUMERIC
  4. VARCHAR

Answer :- B

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. Which of the following is also called an INNER JOIN?

  1. SELF JOIN
  2. EQUI JOIN
  3. NON-EQUI JOIN
  4. None 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. The SQL statement:SELECT ROUND (65.726, -1 FROM DUAL;

Prints:

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

Answer :- D

Q. _________ command makes the updates performed by the transaction permanent in the database?

  1. RolLBACK
  2. COMMIT
  3. TRUNCATE
  4. DELETE

Answer :- B

Q. Which command is used to change the definition of a table in SQL?

  1. CREATE
  2. UPDATE
  3. ALTER
  4. SELECT

Answer :- C

Q. A sequence in SQL can generate a maximum number:

  1. 39 digits
  2. 38 digits
  3. 40 digits
  4. 37 digits

Answer :- B

Q. ______ is NOT a type of constraint in SQL language?

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

Answer :- D

Q. _______ is a constraint that can be defined only at the column level?

  1. UNIQUE
  2. NOT NolL
  3. CHECK
  4. PRIMARY KEY

Answer :- B

Share Now :-

Leave a Comment