04 COMP N/W MCQ 1

1-1 Computer Network is
A. Collection of hardware components and computers
B. Interconnected by communication channels
C. Sharing of resources and information
D. All of the Above


ANSWER:D

1-2 What is a Firewall in Computer Network?
A. The physical boundary of Network
B. An operating System of Computer Network
C. A system designed to prevent unauthorized access
D. A web browsing Software


ANSWER:C


1-3 How many layers does OSI Reference Model has?
A. 4
B. 5
C. 6
D. 7


ANSWER:D


1-4 DHCP is the abbreviation of
A. Dynamic Host Control Protocol
B. Dynamic Host Configuration Protocol
C. Dynamic Hyper Control Protocol
D. Dynamic Hyper Configuration Protocol


ANSWER:B


1-5 IPV4 Address is
A. 8 bit
B. 16 bit
C. 32 bit
D. 64 bit


ANSWER:C


1-6 DNS is the abbreviation of
A. Dynamic Name System
B. Dynamic Network System
C. Domain Name System
D. Domain Network Service


ANSWER:C


1-7 What is the meaning of Bandwidth in Network?
A. Transmission capacity of a communication channels
B. Connected Computers in the Network
C. Class of IP used in Network
D. None of Above



ANSWER:A


1-8 ADSL is the abbreviation of
A. Asymmetric Dual Subscriber Line
B. Asymmetric Digital System Line
C. Asymmetric Dual System Line
D. Asymmetric Digital Subscriber Line



ANSWER:D


1-9 What is the use of Bridge in Network?
A. to connect LANs
B. to separate LANs
C. to control Network Speed
D. All of the above



ANSWER:A


1-10 Router operates in which layer of OSI Reference Model?
A. Layer 1 (Physical Layer)
B. Layer 3 (Network Layer)
C. Layer 4 (Transport Layer)
D. Layer 7 (Application Layer)



ANSWER:B

03 DBMS MCQ 3

1.In E-R diagram, attribute is represented by …….
 (A)Rectangle
 (B)Square
 (C)Double Rectangle
 (D)Eclipse
2. The number of attribute in a relation is called its __________
 (A) Row
 (B) Column
 (C) Degree
 (D) None of the above
3. In a relational database, each tuple is divided into fields called
 (A) Relations
 (B) Domains
 (C)Queries
 (D) None of the above
4. Which of the following is a part of the Oracle database system
(A)Free lists
(B) Front end
(C) Network
(D) None of the above
5. Which of the following is used with database?
(A)ATM
(B)Payment gateway
(C)Data mining
(D)None of the above
6. In SQL, TCL stands for ___________
(A) Transmission control Language
(B) Transaction Central Language
(C) Ternary Control Language
(D) Transaction Control Language
7. Dr. E.F Codd represented…… rules that a database must obey if
        it has to be considered truly relational.
(A) 10
(B) 15
(C) 14
(D) 12
8.In E-R diagram, attribute is represented by …….
 (A)Rectangle
 (B) Square
 (C) Double Rectangle
 (D) Eclipse
9. A collection of conceptual tools for describing data, relationships, semantics and constraints is referred to as ………
 (A) Data Model
 (B) E-R Model
 (C) DBMS
 (D) All of the above
10. In E-R Diagram, weak entity is represented by…..
 (A) Rectangle
 (B)Square
 (C)Double Rectangle
 (D) Circle

02 DBMS MCQ 2

1. ……is a bottom –up approach in which two lower level entities
combine to form a higher level entity.
 (A) Aggregation
 (B) Specialization
 (C) Generalization
 (D) None of the above
2. An entity set that does not have sufficient attributes to form a
primary key, is a …..
(A) Primary entity set
(B) Weak Entity set
(C)Strong Entity set
(D) None of the above
3. An entity that is related with itself is known as …….
 (A) Binary relationship
 (B) Recursive relationship
 (C)Ternary relationship
 (D) None of the above
4. Which SQL command delete all the records and does not remove
 the structure?
(A) Drop
(B) Insert
(C)Truncate
(D) None of the above
5. In …. Database, data is organized in the form of trees with
nodes.
(A) Hierarchical
(B) Relational
(C) Network
(D) None of the above
6. Which command is used to retrieve records from one or more
table?
(A) Delete
(B)Insert
(C)Drop
(D) Select
7. Which of the following constraint is used to limit the value range
that can be placed in a column?
(A) Check
(B) Default
(C) Unique
(D) None of the above
8.Which of the following is a data definition language (DDL)
Command?
 (A) Delete
 (B) Insert
 (C) Drop
 (D) None of these
9._________ allows a unique number to be generated when a new
Record is inserted into a table.
 (A) Insert into select
 (B) Insert into
 (C) Select Into
 (D) Auto increment
10. This method of online analytical processing stores data in both a relation and a multi-dimensional database.
(A) HOLAP
(B) ROLAP
(C) OLAP
(D) UDA
11.Which concept would a data model NOT be expected to know?
A Class
(B) Object
(C) UML
(D) FMP
12. A Foreign key in one table points to a ________________key in another table .
(A) Alternate
(B) Default
(C) Primary Key
(D) None of the above

01 DBMS MCQ 1


1. Rows of a relation are called ______________
 (A) Entity
 (B) Degree
 (C) tuples
 (D) None of the above
2. In SQL, Which of the following is a Data Manipulation Language
 (DML) Command?
 (A) Create
 (B) Alter
 (C) Merge
 (D) Drop
3. Which of the following categories of the data integrity RDBMS
 will enforce specific business rules?
 (A)Entity Integrity
 (B)Domain Integrity
 (C)User-Defined Integrity
 (D)None of the above
4. The number of tuples in a relation is termed as_____________
(A) Cardinality
(B) Entity
(C) Column
(D) None of the above

5. Rows of a relation are called ______________
 (A) Entity
 (B) Degree
 (C) tuples
 (D) None of the above
6. In SQL, Which of the following is a Data Manipulation Language
 (DML) Command?
 (A) Create
 (B) Alter
 (C) Merge
 (D) Drop
7. Which of the following categories of the data integrity RDBMS
 will enforce specific business rules?
 (A)Entity Integrity
 (B)Domain Integrity
 (C)User-Defined Integrity
 (D)None of the above
8. The number of tuples in a relation is termed as_____________
(A) Cardinality
(B) Entity
(C) Column
(D) None of the above
9. ……. is a top- down approach in which one higher level entity can
 be divided into two lower level entities
(A) Aggregation
(B) Specialization
(C) Generalization
(D) None of the above
10. E-R modeling technique is a ___________
(A) top-down approach
(B) bottom-up approach
(C) User –Defined
(D) None of the above