Class 12 Computer Science MCQ set

 

Class 12 Computer Science MCQ set

Set - 1

1)  In which type of database model each node can have only one parent and multiple child?

a)  Hierarchical                         b)  Network

c)  Relational                             d)  Multilevel

2)  In which type of transmission media data are transmitted in the form of photons instead of electrons?

a)  Twisted pair                    b)  Co-axial

c)  Fibre optics                    d)  Infrared

3)  How many layers are there in OSI (Open System Interconnection) model?

a) 4                                    b) 5

c) 6                                    d) 7

4)  Which of the following is not the event object of JavaScript?

a)  onsubmit                            b)  onclick

c)  onselect                               d)  onpost

5)  What is the Total memory allocated by union?

a)  Sum of all                                b)  Highest among all

c)  Lowest among all                   d)  None of above

6)  Which of the following is the correct declaration of pointer variable?

a)  int &p;                                            b)  int *p;

c)  int p*;                                              d)  int p&;

 7)  Which of the following is not a file operation mode?

a)  r                                                            b)  a

c)  w+                                                   d)  rw

8)  Which property of OOP means same function behave differently?

a)  Inheritance                                    b)  Encapsulation

c)  Polymorphism                               d)  Abstraction

9)  The network of physical devices which are built-in with sensors, hardware and software?

a)  AI                                                       b)  VR

c)  IOT                                                    d)  Cloud computing

Solutions of Set - 1

1.       a) Hierarchical       2.       c) Fibre optics      3.   d) 7           4.       d) onpost    5.       b) Highest among all

6.       b) int *p;                  7.       d) rw                      8.       c) Polymorphism              9.       c) IOT 

Set - 2

1)  Which of the following is not DBMS?

a)  dBase                                b)  FoxPro

c)  Oracle                                d)  PHP

2)  In which type of transmission media sender and receiver may not be in LOS (Line of Sight)?

a)  Microwave                                    b)  Radiowave

c)  Infrared                                          d)  Optical Fibre

3)  Which of the following is not a protocol?

a)  FTP                                                    b)  SMTP

c)  POP                                                    d)  UTP

4)  Which of the following statement is used to insert image in HTML?

a)  <image source = “  “>                            b)  <img source = “  “>

c)  <img src = “  “>                                        d)  <image src = “  “>

5)  Which of the following is DML statement?

a)  DROP, ALTER, CREATE                    b)  SELECT, INSERT, UPDATE, DELETE

c)  TRUNCATE, PROVOKE                    d)  None of above

6)  How can we access variable insight structure having following statement. struct employee

{

int id;

char n[10];

};

struct employee e;

a)  e.id                                            b)  e_id

c)  id.e                                            d)  id_e

7)  Which of the following is not the features of OOP?

a)  Inheritance                                b)  Encapsulation

c)  Polymorphism                            d)  Looping

8)  Which of the following is not the phase of SDLC?

a)  System analysis                            b)  System design

c)  System testing                               d)  System deploying

9)  Which of the following is service model of cloud computing?

a)  IaaS                                                b)  PaaS

c)  SaaS                                                d)  All of above

Solutions of Set - 2

1.       d) PHP                    2.       b) Radiowave            3.       d) UTP            4.       c) <img src = “ “>

5.       b) SELECT, INSERT, UPDATE, DELETE        6.       a) e.id        7.       d) Looping

8.       d) System deploying       9. d) All of above

Set 3

1)  Which of the statements are used in DDL?

a)  CREATE, ALTER and DROP                    b)  CREATE, INSERT and SELECT

c)  INSERT, UPDATE and DELETE             d)  DELETE, ALTER and DROP

2)  With SQL, how do you select all the records from table named “Persons” where the value of the column “FirstName” ends with an “a”?

a)  SELECT * FROM Persons WHERE FirstName = ‘a’  

b)  SELECT * FROM Persons WHERE FirstName LIKE ‘a%’

c)  SELECT * FROM Persons WHERE FirstName LIKE ‘%a’

d)  SELECT * FROM Persons WHERE FirstName = ‘%a%’

3)  Which of the following statements is true about a star topology?

a)  Each device is connected to a switch or hub                b)  Each device is connected to each other

c)  Each device is connected to a trunk                             d)  Each device is connected to a terminal

4)  Which of the following is the correct syntax to display “Stay Safe” in an alert box using JavaScript?

a)  alert-box(“Stay Safe”);                                b)  confirm(“Stay Safe”);

c)  msgbox“Stay Safe”);                                    d)  alert(“Stay Safe”);

5)  What is the use of <A> tag?

a)  To insert an image.                                    b)  To create a link

c)  To create a hyperlink.                                d)  To create a list.

6) What is the output of given C program? 

void main( )

{

char str1[] = “FIRST” ; char str2[] = “SECOND” ; strcpy(str2,str1); printf(“%s %s”, str1, str2); printf(“%d”, (str1 != str2)); printf(“%d”, strcmp(str1, str2)); }

a)  FIRST FIRST 0 0                                    b)  FIRST FIRST 1 1

c)  FIRST FIRST 1 0                                     d)  FIRST FIRST 0 1

7)  Where is a class derived in inheritance?

a)  Superclass                                        b)  Subclass

c)  Subsetclass                                        d)  Relativeclass

8)  Which of these is the correct order of the SDLC?

a)  Analysis, Design, Coding, Testing, Implementation

b)  Analysis, Design, Testing, Implementation, Coding

c)  Implementation, Coding, Analysis, Design, Testing

d)  Design, Testing, Implementation, Coding, Analysis

9)  Why is cloud computing popular nowadays?

a)  Cost-sharing and easily accessible                        b)  As modern technology and costly

c)  Accessible and freely available                               d)  Affordable to all

Set 3 Solution

1.       a) CREATE, ALTER and DROP

2.       c) SELECT * FROM Persons WHERE FirstName LIKE ‘%a’

3.       a) Each device is connected to a switch or hub

4.       d) alert(“Stay Safe”);

5.       c) To create a hyperlink.

6.       c) FIRST FIRST 1 0

7.       a) Subclass

8.       a) Analysis, Design, Coding, Testing, Implementation

9.       a) Cost-sharing and easily accessible

Ch-1 Database Management System (DBMS)

1.  A relational database consists of a collection of ....

a. Tables          b. Fields          c. Records       d. Keys

2.  A term          is used to refer to a row.

a. Attribute      b. Tuple           c. Field            d. Instance

3.  The term attribute refers to a          of a table.

a. Record        b. Column       c. Tuple           d. Key

4.  CREATE TABLE employee(name VARCHAR, ID INTEGER); What type of statement is this?

a. DML            b. DDL           c. View            d. Integrity Constraint

5.  In the given query , which of the keyword has to be inserted? INSERT INTO employee 

a. Table             b. Values        c. Relation       d. Field

6.  In the          normal form, a composite attribute is converted to individual attributes.

a. First              b. Second       c. Third            d. Fourth

7.  With SQL, how do you slect all the records from a table named "persons" where the value of the column "FirstName" ends with an "a"?

a.  SELECT * FROM Persons WHERE FirstName='a'

b.  SELECT * FROM Persons WHERE FirstName LIKE 'a%'

c.  SELECT * FROM Persons WHERE FirstName LIKE '%a'

d.  SELECT * FROM Persons WHERE FirstName='%a%'

8.  The UPDATE SQL clause can           

a.  update only one row at a time                    b.  update more than one row at a time

c.  delete more than one row at a time           d.  delete only one row at a time

9.  Which SQL keyword is used to retrieves a maximum value?

a. MOST         b. TOP              c. MAX          d. UPPER

10.  Which of the following is not a DDL command?

a. UPDATE               b. TRUNCATE           c. ALTER       d. None of the above

Answer key: Chapter 1:

1.  a            2.  b        3.  b        4.  b        5.  b            6.  a            7.  c        8.  b        9.  c    10. a