Home › Quizzes › Computer (NCO)

Computer (NCO)

This test contains computers and IT related questions for class 12.

25 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

Which operator is used to access a structure element using a pointer?

  1. Dot(.)
  2. Pointer (&)
  3. Pointer (*)
  4. Arrow (->)
  5. Not(~)
Question 2 Multiple Choice (Single Answer)

Which SQL command comes under data definition language?

  1. Select
  2. Drop
  3. Grant
  4. Revoke
  5. Update
Question 3 Multiple Choice (Single Answer)

The break statement causes an exit

  1. from the innermost loop or switch
  2. only from the innermost switch
  3. only from the innermost loop
  4. from the program
  5. from the outermost loop
Question 4 Multiple Choice (Single Answer)

Deriving a class from another derived class is called

  1. single inheritance
  2. multilevel inheritance
  3. polymorphism
  4. message passing
  5. multiple inheritance
Question 5 Multiple Choice (Single Answer)

Which operator causes a sequence of operations to be performed?

  1. Comma operator ( , )
  2. Dot operator( . )
  3. Cast operator
  4. Address of operator (&)
  5. Pointer operator( * )
Question 6 Multiple Choice (Single Answer)

Which loop executes a sequence of statements multiple times and abbreviates the code that manages the loop variable?

  1. Do...while loop
  2. For loop
  3. While loop
  4. Nested loop
  5. If statement
Question 7 Multiple Choice (Single Answer)

In which data integrity can rows used by other records not be deleted?

  1. User-defined integrity
  2. Entity integrity
  3. Domain integrity
  4. Referential integrity
  5. Unique integrity
Question 8 Multiple Choice (Single Answer)

Which join operation returns row when there is a match in both tables?

  1. Full join
  2. Left join
  3. Cartesian join
  4. Inner join
  5. Self join
Question 9 Multiple Choice (Single Answer)

‘AS’ clause is used in SQL for

  1. projection operation
  2. join operation
  3. rename operation
  4. selection operation
  5. delete operation
Question 10 Multiple Choice (Single Answer)

The expression: int *(*a)[5] means that

  1. a is pointer to integer
  2. a is pointer to an array of pointers to integer
  3. a is pointer to function which returns integer
  4. a is a pointer to array of size 5
  5. an array of pointer to function returning pointer to function returning pointer to integer.
Question 11 Multiple Choice (Single Answer)

Which SQL datatype has maximum length of 4000 characters with variable length unicode?

  1. The data type char
  2. The data type nvarchar
  3. The data type varchar
  4. The data type varbinary
  5. The data type nchar
Question 12 Multiple Choice (Single Answer)

Which SQL logical operator is used to search the presence of a row in a specified table that meets certain criteria?

  1. Exists operator
  2. Unique operator
  3. All operator
  4. Any operator
  5. In operator
Question 13 Multiple Choice (Single Answer)

For (x=4,y=3; x && x!=y; x--)y++;
cout<< “x = %d“<< x << “y = %d “<< y; returns

  1. x = 0 y = 7
  2. x = %d0 y = %d 7
  3. There is an error in the given code.
  4. x = 1 y = 5
  5. x = 6 y = 3
Question 14 Multiple Choice (Single Answer)

In C++, redefining the entire element is called

  1. shadowing
  2. function overriding
  3. function overloading
  4. function definition
  5. operator overloading
Question 15 Multiple Choice (Single Answer)

Which preprocessor directives allows to include or discard part of the code of a program?

  1. Line control
  2. Pragma directive
  3. Macro definitions
  4. Conditional inclusions
  5. Error directive
Question 16 Multiple Choice (Single Answer)

In _____, each node (file server, workstations and peripherals) is connected directly to a central network hub, switch or concentrator.

  1. star topology
  2. tree topology
  3. ring topology
  4. mesh topology
  5. bus topology
Question 17 Multiple Choice (Single Answer)

Which protocol is used for e-mail messages on the internet?

  1. POP3
  2. IRC
  3. IMAP
  4. FTP
  5. HTTP
Question 18 Multiple Choice (Single Answer)

Data link layer and physical layer use

  1. DNS protocol
  2. TCP protocol
  3. ethernet protocol
  4. SPX protocol
  5. IP protocol
Question 19 Multiple Choice (Single Answer)

DHCP is a protocol which automatically assigns internet addresses to computers and users. DHCP stands for

  1. Dynamic Host Connection Protocol
  2. Dynamic Host Configuration Protocol
  3. Distributed Host Configuration Protocol
  4. Domain Host Configuration Protocol
  5. Domain Host Connection Protocol
Question 20 Multiple Choice (Single Answer)

Give an advantage of star topology.

  1. Failure of one node or link doesn't affect the rest of network.
  2. Cable length required for this topology is the least compared to other networks.
  3. Each segment is provided with dedicated point to point wiring to the central hub.
  4. Expansion and modification in topology can be done without disrupting other nodes.
  5. Each computer has equal access to resources.
Question 21 Multiple Choice (Single Answer)

Which of the following is a disadvantage of ring topology?

  1. Network is highly dependent on the wire which connects different components.
  2. It is difficult to detect and troubleshoot fault at individual station.
  3. Performance as well as the number of nodes which can be added in such topology is dependent on the capacity of central device.
  4. There are high chances of redundancy in many of the network connections.
  5. Scalability of the network depends on the type of cable used.
Question 22 Multiple Choice (Single Answer)

Interception of communications by an unauthorised party is called

  1. denial of service
  2. spoofing
  3. phishing
  4. eavesdropping
  5. virus
Question 23 Multiple Choice (Single Answer)

Which level of abstraction describes what data is actually stored in the database?

  1. Logical view
  2. Only view
  3. Conceptual view
  4. Physical view
  5. Abstract view
Question 24 Multiple Choice (Single Answer)

In network security, a logic bomb is

  1. an undocumented way of gaining access to a system that is built into the system
  2. a program or subsection of a program designed with malevolent intent
  3. a program or code fragment that hides inside a program and performs a disguised function
  4. a self contained and independent program that is usually designed to propagate or spawn itself on infected systems and to seek other systems via available networks
  5. anything that can disrupt the operation, functioning, integrity or availability of a network or system
Question 25 Multiple Choice (Single Answer)

___________ uses the concept of a mathematical relation as its basic building block and has its theoretical basis in set theory and first order predicate logic.

  1. Network model
  2. Hierarchical model
  3. Object oriented model
  4. Relational model
  5. Object relational model
← Back to Quizzes