[MCQS] OCEAN Publication Computer Science All Chapters

 

UNIT 1: Database Management System (DBMS)

Question 1: A collection of interrelated files in a computer is a _______

i. Record

ii. Database

iii. Field

iv. File manager

 

Question 2: Attributes can be defined for

i. Pages

ii. Macro

iii. Switch board

iv. Entity

 

Question 3: Key represent relationship between table is called .....

i. primary

ii. secondary

iii. foreign

iv. None of these

 

Question 4: Which of the following is valid SQL type?

i. CHARACTER

ii. FLOAT

iii. NUMBER

iv. All

 

Question 5: In RDBMS terminology for a row is ...

i. tuple

ii. relational

iii. attribute

iv. degree

 

Question 6: What do you mean by one-to-many relationships?

i. One class may have many teachers

ii. One teacher can have many classes

iii. Many classes may have many teachers

iv. Many teachers may have many classes

 

Question 7: Which of the following provides the ability to query information from the database and insert tuples into, delete tuples from, and modify tuples in the database?

i. DML (Data Manipulation Language)

ii. Query

iii. Relational Schema

iv. DDL (Data Definition Language)  

 

Question 8: A top-to-bottom relationship among the items in a database is established by a

i. Hierarchical schema

ii. Network schema

iii. Relational Schema

iv. All of the above  

 

Question 9: Which of the following can be used to extract or filter the data & information from the data warehouse?

i. Data redundancy

ii. Data recovery tool

iii. Data mining

iv. Both B and C

 

Question 10: Which of the following command is a type of Data Definition language command?

i. Create

ii. Update

iii. Delete

iv. Merge

 

Question 11: Which one of the following is a type of Data Manipulation Command?

i. Create

ii. Alter

iii. Delete

iv. All of the above

 

Question 12: Which one of the following keywords is used to find out the number of values in a column?

i. TOTAL

ii. COUNT

iii. SUM

iv. ADD

 

Question 13: .......................... is the process of organizing data into related tables.

i. Normalization

ii. Generalization

iii. Specialization

iv. None of the above

 

Question 14: Which normal form is considered adequate for relational database design?

i. 2 NF

ii. 3 NF

iii. 4 NF

iv. BCNF

 

Question 15: The database security responsible for providing...

i. Authentication

ii. Encryption

iii. Access control

iv. All of these

 

Question 16: Data integrity means...

i. providing first access to stored data

ii. ensuring correctness and consistency of data

iii. providing data sharing

iv. none of the above

 

Question 17: Which of the following is the advantage of a distributed database over a centralized database?

i. Module wise growth

ii. Simplicity and ease

iii. Slow Response

iv. None of the above

 

UNIT 2: Data Communication and Networking

Question 1: Which of the through is share the data of two computer?

i. Library

ii. Network

iii. Grouping

iv. Integrated system

 

Question 2: A half-duplex communication channel permits information to travel

i. At timed intervals

ii. One direction only

iii. Both ways, but not at once

iv. Both ways at once

 

Question 3: In specific, if the systems use separate protocols, which one of the following devices is used to link two systems?

i. Repeater

ii. Gateway

iii. Bridge

iv. Hub 1   

 

Question 4: The first Network was called ________

i. CNNET

ii. NSFNET

iii. ASAPNET

iv. ARPANET

 

Question 5: Which of the following is not a network topology?

i. Star

ii. Ring

iii. Bus

iv. Peer to Peer

 

Question 6: Which software prevents the external access to a system?

i. Firewall

ii. Gateway

iii. Router

iv. Virus checker

 

Question 7: The location of a resource on the internet is given by its?

i. Protocol

ii. URL

iii. E-mail address

iv. ICQ

 

Question 8: Which one of the following is the most common internet protocol?

i. HTML

ii. NetBEUI

iii. TCP/IP

iv. IPX/SPX

 

Question 9: Bluetooth is an example of

i. Wide area network

ii. Virtual private network

iii. Local area network

iv. Personal area network

 

Question 10: A ______________ set of rules that governs data communication.

i. Protocols

ii. Standards

iii. RFCs

iv. Servers

 

Question 11: ______________ allows LAN users to share computer programs and data.

i. Communication server

ii. Print server

iii. File server

iv. Network

 

Question 12: Which connector does the STP cable use?

i. BNC

ii. RJ-11

iii. RJ-45

iv. RJ-69

 

Question 13: Fiber optics possess following properties

i. Immune electromagnetic interference

ii. Very less signal attenuation

iii. Very hard to tap

iv. All of the mentioned  

 

Question 14: Which of the following is not the Networking Devices?

i. Gateways

ii. Linux

iii. Routers

iv. Firewalls

 

Question 15: The star topology is used in ________

i. LAN

ii. MAN

iii. WAN

iv. interconnected

 

Question 16: Cable TV, Digital Subscriber Line (DSL) are examples of ________

i. Interconnection of network

ii. LAN

iii. MAN

iv. WAN

 

Question 17: Each IP packet must contain

i. Only source address

ii. Only destination address

iii. Source and Destination address

iv. Source or Destination address  

 

Question 18: What is the meaning of Bandwidth in Network?

i. Transmission capacity of a communication channels

ii. Connected Computers in the Network

iii. Class of IP used in Network

iv. None of Above  

 

Question 19: How many layers does OSI Reference Model has?

i. 4

ii. 5

iii. 6

iv. 7

 

Question 20: In a Client-Server computer network or architecture, all nodes can _______ data.

i. sends

ii. receive

iii. send and receive

iv. None

 

Question 21: The Internet addresses are _______ bits in length in the IPV4 addressing scheme.

i. 16

ii. 64

iii. 32

iv. 48

 

UNIT 3:  Web technology II

Question 1: Which of the following is correct about features of JavaScript?

i. It cannot Handling dates and time.

ii. JavaScript is an object-based scripting language.

iii. JavaScript is not interpreter-based scripting language.

iv. All of the above

 

Question 2: Which company developed JavaScript?

i. Netscape

ii. Bell Labs

iii. Sun Microsystems

iv. IBM

 

Question 3: When interpreter encounters an empty statement, what it will do:

i. Shows a warning

ii. Prompts to complete the statement

iii. Throws an error

iv. Ignores the statements

 

Question 4: Which of the following is not JavaScript Data Types?

i. Undefined

ii. Number

iii. Boolean

iv. Float

(JavaScript uses "Number" for both integers and floats)

Question 5: Inside which HTML element do we put the JavaScript?

i. <script>

ii. <javascript>

iii. <scripting>

iv. <js>

 

Question 6: Where is the correct place to insert a JavaScript?

i. The <body> section

ii. The <head> section

iii. Both the <head> section and the <body> section are correct

iv. None of these

 

Question 7: What is the correct syntax for referring to an external script called "xxx.js"?

i. <script src="aaa.js">

ii. <script name="aaa.js">

iii. <script href="aaa.js">

iv. <script jname="aaa.js">

 

Question 8: How do you write "Hello World" in an alert box?

i. msg("Hello World");

ii. msgBox("Hello World");

iii. alertBox("Hello World");

iv. alert("Hello World");

 

Question 9: How do you create a function in JavaScript?

i. function = myFunction()

ii. function myFunction()

iii. function:myFunction()

iv. myFunction function()

 

Question 10: How to write an IF statement for executing some code if "i" is NOT equal to 5?

i. if (i != 5)

ii. if (i <> 5)

iii. if i != 5 then

iv. if i <> 5

 

Question 11: How does a FOR loop start?

i. for (i <= 5; i++)

ii. for (i = 1 to 5)

iii. for (i = 0; i <= 5; i++)

iv. for i = 0; i <= 5

 

Question 12: Which event occurs when the user clicks on an HTML element?

i. onmouseover

ii. onmouseout

iii. onchange

iv. onclick

 

Question 13: A collection of elements of the same data type which may either in order or not, is called _______.

i. String

ii. Array

iii. Serialized Object

iv. Object

 

Question 14: PHP Stands for?

i. PHP Hypertex Processor

ii. PHP Hyper Markup Processor

iii. PHP Hyper Markup Preprocessor

iv. PHP Hypertext Preprocessor

 

Question 15: Who is known as the father of PHP?

i. Drek Kolkevi

ii. List Barely

iii. Rasmus Lerdorf

iv. None of the above

 

Question 16: PHP is an example of ______________ scripting language.

i. Client-side

ii. Server-side

iii. Browser-side

iv. In-side

 

Question 17: PHP scripts are enclosed within ______________.

i. <?php> ... </php>

ii. <?php ... ?>

iii. <?php ... ?php

iv. <p> ... </p>

 

Question 18: Which of the following method sends input to a script via a URL?

i. Post

ii. Get

iii. Both

iv. None

 

Question 19: Which one of the following databases has PHP supported almost since the beginning?

i. Oracale database

ii. SQL

iii. SQL+

iv. MySQL

 

Question 20: Which one of the following statements is used to create a table?

i. CREATE TABLE table_name (column_name column_type);

ii. CREATE table_name (column_name column_type)

iii. CREATE table_name (column_name column_type);

iv. CREATE TABLE table_name (column_type column_name);

 

UNIT 4: Programming in C

Question 1: C is ______________ type of programming language.?

i. Object Oriented

ii. Procedural

iii. Bit level language

iv. Functional

 

Question 2: C programming language was developed by

i. Dennis Ritchie

ii. Ken Thompson

iii. Bill Gates

iv. Peter Norton

 

Question 3: C language is used in the development of.?

i. Databases

ii. Graphic applications

iii. Word Processors

iv. All of the above

 

Question 4: C language uses the ______________ to convert the code into machine language.

i. Compiler

ii. Interpreter

iii. Both compiler and interpreter

iv. None of the above

 

Question 5: Identify wrong C Keywords below.

i. union, const, var, float

ii. short, unsigned, continue, for

iii. signed, void, default, goto

iv. sizeof, volatile, do, if

(Because var is not a valid C keyword)

Question 6: Which of the following symbol is used to denote a pre-processor statement?

i. !

ii. #

iii. -

iv. ;

 

Question 7: Which of the following are tokens in C?

i. Keywords

ii. Variables

iii. Constants

iv. All of the above

 

Question 8: The continue command cannot be used with

i. for

ii. switch

iii. do

iv. while

 

Question 9: In C, a Union is

i. memory location

ii. memory store

iii. memory screen

iv. None of these

(More accurately: A union is a user-defined data type similar to a structure, where all members share the same memory location.)

 

Question 10: Which is the correct way to declare a pointer?

i. int_ptr;

ii. int *ptr;

iii. *int ptr;

iv. None of these

 

Question 11: Which is more appropriate for reading in a multi-word string?

i. gets()

ii. print()

iii. scanf()

iv. puts().

 

Question 12: Function argument can be

i. A structure member

ii. A pointer variable

iii. A complete structure

iv. All of the above.

 

Question 13: Every C Program should contain which function.?

i. print()

ii. show()

iii. scanf()

iv. main()

 

Question 14: Which of the following comments about the ++ operator is correct?

i. It is a unary operator

ii. The operand can come before or after the operator

iii. It cannot be applied to an expression

iv. All of the above   

 

Question 15: What is the keyword used to declare a C file pointer.?

i. file

ii. FILE

iii. FILEFP

iv. filefp

 

UNIT 5: Object- Oriented Programming (OOP)

Question 1: Who developed object-oriented programming?

i. Adele Goldberg

ii. Dennis Ritchie

iii. Alan Kay

iv. Andrea Ferro

 

Question 2: Which of the following is not an OOPS concept?

i. Encapsulation

ii. Exception

iii. Polymorphism

iv. Abstraction

 

Question 3: Which feature of OOPS described the reusability of code?

i. Abstraction

ii. Encapsulation

iii. Polymorphism

iv. Inheritance

 

Question 4: Which of the following definition is incorrect for polymorphism?

i. Polymorphism helps in redefining the same functionality

ii. Polymorphism concept is the feature of object-oriented programming (OOP)

iii. It always increases the overhead of function definition

iv. Ease in the readability of the program

 

Question 5: Which of the following OOP concept binds the code and data together and keeps them secure from the outside world?

i. Polymorphism

ii. Inheritance

iii. Abstraction

iv. Encapsulation

 

Question 6: Which of following is shared structure of a set of similar objects

i. class

ii. Encapsulation

iii. Inheritance

iv. None

 

UNIT 6: Software Process Model

Question 1: What is the first step in the software development lifecycle?

i. System Design

ii. Coding

iii. System Testing

iv. Preliminary Investigation and Analysis

 

Question 2: Which one of the following activities is not recommended for software processes in software engineering?

i. Software Evolution

ii. Software Verification

iii. Software Testing & Validation

iv. Software designing

 

Question 3: The agile software development model is built based on

i. Linear Development

ii. Incremental Development

iii. Iterative Development

iv. Both Incremental and Iterative Development

 

Question 4: What is the name of the approach that follows step-by-step instructions for solving a problem?

i. An Algorithm

ii. A Plan

iii. Flowchart

iv. Sequential Structure

 

Question 5: Which of the following word correctly summarized the importance of software design?

i. Quality

ii. Complexity

iii. Efficiency

iv. Accuracy  

 

Question 6: Find out which phase is not available in SDLC?

i. Coding

ii. Testing

iii. Maintenance

iv. Abstraction

 

Question 7: Design phase followed by ________.

i. Coding

ii. Testing

iii. Maintenance

iv. All of these

 

Question 8: Which of the following is system design tool?

i. CASE

ii. DFD

iii. UML

iv. All of these

 

Question 9: Which step of SDLC performs cost/benefits analysis?

i. Feasibility study

ii. Analysis

iii. Design

iv. Maintenance

 

Question 10: The main activity of the design phase of the system life cycle is to?

i. Replace the old system with the new one

ii. Develop and test the new system

iii. Understand the current system

iv. Propose alternatives to the current system

 

Question 11: A system analyst does not need to consider ______________?

i. Technical feasibility

ii. Economics feasibility

iii. Operational feasibility

iv. None of these

 

Question 12: Software engineers shall ______________?

i. Act consistently with the public interest

ii. Act in a manner that is in the best interests of his expertise and favour

iii. Ensure that their products only meet the SRS

iv. All of the above

 

UNIT 7: Recent Trends in Technology

Question 1: Artificial Intelligence is about ______________.

i. Playing a game on Computer

ii. Making a machine Intelligent

iii. Programming on Machine with your Own Intelligence

iv. Putting your intelligence in Machine

 

Question 2: Who is known as the "Father of AI"?

i. Fisher Ada

ii. Alan Turing

iii. John McCarthy

iv. Allen Newell

 

Question 3: The application/applications of Artificial Intelligence is/are

i. Expert Systems

ii. Gaming

iii. Vision Systems

iv. All of the above

 

Question 4: Which of the following is essential concept related to Cloud?

i. Reliability

ii. Productivity

iii. Abstraction

iv. All of the mentioned

 

Question 5: Which of the following is Cloud Platform by Amazon?

i. Azure

ii. AWS

iii. Cloudera

iv. All of the mentioned

 

Question 6: Which of the following is best known service model of SaaS?

i. SaaS

ii. IaaS

iii. PaaS

iv. All of the mentioned

 

Question 7: Data in ______________ bytes size is called Big Data.

i. Tera

ii. Giga

iii. Peta

iv. Meta

 

Question 8: Businesses can utilize outside intelligence while taking decisions

i. Improved customer service

ii. Better operational efficiency

iii. Lower operational efficiency

iv. All of the above

 

Question 9: ______________ is a collection of data that is huge in volume, yet growing exponentially with time.

i. Big Database

ii. Big Data

iii. Big Data file

iv. Big DBMS

 

Question 10: ______________ describes e-commerce.

i. Doing business offline

ii. Doing business electronically

iii. Surfing online

iv. Both A & B

 

Question 11: Which segment do Daraz and Amazon belong?

i. B2B

ii. B2C

iii. C2B

iv. C2C

 

Question 12: Which type of e-commerce focuses on consumers dealing with each other?

i. B2B

ii. B2C

iii. C2B

iv. C2C

 

Question 13: Electronic Exchange of business documents in a standard format is known as ________.

i. E-commerce

ii. E-Business

iii. EDI (Electronic Data Interchange)

iv. None of these

 

Question 14: Which of the following is mobile software?

i. Android

ii. iOS

iii. Blackberry

iv. All of these

 

Question 15: Which of the following is not mobile hardware?

i. Laptop

ii. Desktop

iii. Tablets

iv. Smartphones

 

Question 16: Which of the following is the way in which an IoT device is associated with data?

i. Internet

ii. Cloud

iii. Automata

iv. Network

 

Question 17: An IoT network is a collection of ______________ devices.

i. Signal

ii. Machine to Machine

iii. Interconnected

iv. Network to Network