11 DBMS MCQ 5

1. Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?
a) Candidate key
b) Sub key
c) Super key
d) Foreign key


Answer:c
Explanation:Super key is the superset of all the keys in a relation.
2. Consider attributes ID , CITY and NAME . Which one of this can be considered as a super key ?
a) NAME
b) ID
c) CITY
d) CITY , ID


Answer:b
Explanation:Here the id is the only attribute which can be taken as a key. Other attributes are not uniquely identified .
3. The subset of super key is a candidate key under what condition ?
a) No proper subset is a super key
b) All subsets are super keys
c) Subset is a super key
d) Each subset is a super key


Answer:a
Explanation:The subset of a set cannot be the same set.Candidate key is a set from a super key which cannot be the whole of the super set
4. A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.
a) Rows
b) Key
c) Attribute
d) Fields


Answer:b
Explanation:Key is the constraint which specifies uniqueness.
5. Which one of the following attribute can be taken as a primary key ?
a) Name
b) Street
c) Id
d) Department


Answer:c
Explanation:The attributes name , street and department can repeat for some tuples.But the id attribute has to be unique .So it forms a primary key.
6. Which one of the following cannot be taken as a primary key ?
a) Id
b) Register number
c) Dept_id
d) Street


Answer:d
Explanation:Street is the only attribute which can occur more than once.
7. A attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation .
a) Candidate
b) Primary
c) Super
d) Sub


Answer:b
Explanation:The primary key has to be referred in the other relation to form a foreign key in that relation .
8. The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as primary key is called
a) Referential relation
b) Referencing relation
c) Referenced relation
d) Referred relation


Answer:b
Explanation:None.
9. The ______ is the one in which the primary key of one relation is used as a normal attribute in another relation .
a) Referential relation
b) Referencing relation
c) Referenced relation
d) Referred relation


Answer:c
Explanation:None.
10. A _________ integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.
a) Referential
b) Referencing
c) Specific
d) Primary


Answer:a
Explanation:A relation, say r1, may include among its attributes the primary key of another relation, say r2. This attribute is called a foreign key from r1, referencing r2. The relation r1 is also called the referencing relation of the foreign key dependency, and r2 is called the referenced relation of the foreign key
x

10 DBMS MCQ4

1. A relational database consists of a collection of
a) Tables
b) Fields
c) Records
d) Keys
Answer:a
Explanation:Fields are the column of the relation or tables.Records are each row in relation.Keys are the constraints in a relation .

2. A ________ in a table represents a relationship among a set of values.
a) Column
b) Key
c) Row
d) Entry
Answer:c
Explanation:Column has only one set of values.Keys are constraints and row is one whole set of attributes.Entry is just a piece of data.

3. The term _______ is used to refer to a row.
a) Attribute
b) Tuple
c) Field
d) Instance
Answer:b
Explanation:Tuple is one entry of the relation with several attributes which are fields.

4. The term attribute refers to a ___________ of a table.
a) Record
b) Column
c) Tuple
d) Key
Answer:b
Explanation:Attribute is a specific domain in the relation which has entries of all tuples.

5. For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.
a) Domain
b) Relation
c) Set
d) Schema
Answer:a
Explanation:The values of the attribute should be present in the domain.Domain is a set of values permitted .

6. Database __________ , which is the logical design of the database, and the database _______,which is a snapshot of the data in the database at a given instant in time.
a) Instance, Schema
b) Relation, Schema
c) Relation, Domain
d) Schema, Instance
Answer:d
Explanation:Instance is a instance of time and schema is a representation.

7.Course(course_id,sec_id,semester)
Here the course_id,sec_id and semester are __________ and course is a _________ .
a) Relations, Attribute
b) Attributes, Relation
c) Tuple, Relation
d) Tuple, Attributes
Answer:b
Explanation:The relation course has a set of attributes course_id,sec_id,semester .

8. Department (dept name, building, budget) and Employee (employee_id , name, dept name,salary)
Here the dept_name attribute appears in both the relations .Here using common attributes in relation schema is one way of relating ___________ relations.
a) Attributes of common
b) Tuple of common
c) Tuple of distinct
d) Attributes of distinct
Answer:c
Explanation:Here the relations are connected by the common attributes.

9. A domain is atomic if elements of the domain are considered to be ____________ units.
a) Different
b) Indivisbile
c) Constant
d) Divisible
Answer:b
Explanation:None.

10. The tuples of the relations can be of ________ order.
a) Any
b) Same
c) Sorted
d) Constant
Answer:a
Explanation:The values only count .The order of the tuples does not matter.

09 OS MCQ 3

3-1 Which of the following file format supports in Windows 7?
A) NTFS
B) BSD
C) EXT
D) All of the above

3-2 The Primary job of the operating system is
A) Manage Commands
B) Manage Users
C) Manage Programs
D) Manage Resources

3-3 What is the meaning of “Hibernate” in Windows XP/Windows 7?
A) Restart the Computer in safe mode
B) Restart the Computer in hibernate mode
C) Shutdown the Computer terminating all the running applications
D) Shutdown the Computer without closing the running applications

3-4 Who is called a supervisor of computer activity?
A) Memory
B) Operating System
C) I/O Devices
D) Control Unit

3-5 Virtual Memory is
A) Extremely Large Main memory
B) Extremely Large Secondary memory
C) An illusion of extremely large main memory
D) An illusion of extremely large secondary memory

3-6 Operating System manages
A) Memory
B) Processor
C) I/O devices
D) All of the above

3-7 What should be the first step while OS upgrading?
A) Delete old Operating System
B) Backup old Operating System
C) Backup Critical Data
D) Format Hard Disks

3-8 Unix Operating System is an
A) Multi User Operating System
B) Time Sharing Operating System
C) Multi Tasking Operating System
D) All the Above

3-9 In which type of the following OS, the response time is very crucial.
A) Network Operating System
B) Real Time Operating System
C) Batch Operating System
D) Unix Operating System

3-10 The file system “NTFS” stands for
A) New Type File System
B) Never Terminated File System
C) New Technology File System
D) Non Terminated File System
 Answers
1 – A 2 – D 3 – D 4 – B 5 – C 
 6 – D 7 – C 8 – D 9 – B 10 – C

08 OS MCQ 2

2-1. When a computer is first turned on or restarted, a special type of
absolute loader called ____ is executed
A. Compile and Go loader
B. Boot loader
C. Bootstrap loader
D. Relating loader

2-2. Which of the following Operating systems is better for
implementing a Client-Server network
A. MS DOS
B. Windows 95
C. Windows 98
D. Windows 2000

2-3. The operating system manages
A. Memory
B. Processes
C. Disks and IO devices
D. all of the above

2-4. Usually, in MSDOS, the primary hard disk drives has the drive letter ____
A. A
B. B
C. C
D. D

2-5. What is the function of an operating system?
A. Manages computer’s resources very efficiently
B. Takes care of scheduling jobs for execution
C. Manages the flow of data and instructions
D. All of the above

2-6. Which is not the function of the Operating System?
A. Memory management
B. Disk management
C. Application management
D. Virus Protection

2-7. Which Operating System doesn’t support networking between
computers?
A. Windows 3.1
B. Windows 95
C. Windows 2000
D. Windows NT

2-8. Which Operating System doesn’t support long file names?
A. OS2
B. Windows 95
C. MS-DOS
D. Windows NT

2-9. Which file keeps commands to execute automatically when OS is
started?
A. command.com
B. any batch file
C. autoexec.bat
D. config.sys

2-10. What should be the extension to execute files?
A. EXE
B. BAT
C. COM
D. All of the above
Answers
1 – C 2 – D   3 – D   4 – C   5 – D   
6 – D   7 – A   8 – C   9 – C   10 – D

07 OS MCQ 1

1-1. ______ is used in operating system to separate mechanism from policy
A. Single level implementation
B. Two level implementation
C. Multi level implementation
D. None

1-2. The operating system creates _____ from the physical computer
A. Virtual space
B. Virtual computers
C. Virtual device
D. None

1-3. ______ shares characteristics with both hardware and software
A. Operating system
B. Software
C. Data
D. None

1-4. Multiprogramming systems:
A. Are easier to develop than single programming systems
B. Execute each job faster
C. Execute more jobs in the same time period
D. Are used only one large mainframe computers.
1-5. Which is the first program run on a computer when the computer boots up?
A. System software
B. Operating system
C. System operations
D. None

1-6. Which is built directly on the hardware?
A. Computer Environment
B. Application Software
C. Operating System
D. Database System

1-7. Which of the following Operating System does not implement
multitasking truly?
A. Windows 98
B. Windows NT
C. Windows XP
D. MS DOS

1-8. Which runs on computer hardware and serve as platform for other software to run on?
A. Operating System
B. Application Software
C. System Software
D. All

1-9. Which is the layer of a computer system between the hardware and the user program
A. Operating environment
B. Operating system
C. System environment
D. None

1-10. The primary purpose of an operating system is:
A. To make the most efficient use of the computer hardware
B. To allow people to use the computer,
C. To keep systems programmers employed
D. To make computers easier to use

Answers
1 – B  2 – B  3 – A 4 – C  5 – B 
 6 – C  7 – D  8 – A  9 – B  10 – A

06 COMP N/W MCQ 3

*NOTE:ANSWER KEY AT BOTTOM OF PAGE

 3-1. Why IP Protocol is considered as unreliable?
A. A packet may be lost
B. Packets may arrive out of order
C. Duplicate packets may be generated
D. All of the above

3-2. What is the minimum header size of an IP packet?
A. 16 bytes
B. 10 bytes
C. 20 bytes
D. 32 bytes

3-3. Which of following provides reliable communication?
A. TCP
B. IP
C. UDP
D. All of the above

3-4. What is the address size of IPv6 ?
A. 32 bit
B. 64 bit
C. 128 bit
D. 256 bit

3-5. What is the size of Network bits & Host bits of Class A of IP
address?
A. Network bits 7, Host bits 24
B. Network bits 8, Host bits 24
C. Network bits 7, Host bits 23
D. Network bits 8, Host bits 23

3-6. What does Router do in a network?
A. Forwards a packet to all outgoing links
B. Forwards a packet to the next free outgoing link
C. Determines on which outing link a packet is to be forwarded
D. Forwards a packet to all outgoing links except the originated link

3-7. The Internet is an example of
A. Cell switched network
B. circuit switched network
C. Packet switched network
D. All of above

3-8. What does protocol defines?
A. Protocol defines what data is communicated.
B. Protocol defines how data is communicated.
C. Protocol defines when data is communicated.
D. All of above

3-9. What is the uses of subnetting?
A. It divides one large network into several smaller ones
B. It divides network into network classes
C. It speeds up the speed of network
D. None of above

3-10. Repeater operates in which layer of the OSI model?
A. Physical layer
B. Data link layer
C. Network layer
D. Transport layer


ANSWER
 1 – D
 2 – C
 3 – A
 4 – C
 5 – A
 6 – C
 7 – C
 8 – D
 9 – A
 10 – A

05 COMP N/W MCQ 2

2-1 Each IP packet must contain
A. Only Source address
B. Only Destination address
C. Source and Destination address
D. Source or Destination address

ANSWER:-C


2-2 Bridge works in which layer of the OSI model?
A. Appliation layer
B. Transport layer
C. Network layer
D. Datalink layer

ANSWER:-D



2-3 _______ provides a connection-oriented reliable service for sending
messages
A. TCP
B. IP
C. UDP
D. All of the above

ANSWER:-A



2-4 Which layers of the OSI model are host-to-host layers?
A. Transport, Session, Persentation, Application
B. Network, Transport, Session, Presentation
C. Datalink, Network, Transport, Session
D. Physical, Datalink, Network, Transport

ANSWER:-A



2-5 Which of the following IP address class is Multicast
A. Class A
B. Class B
C. Class C
D. Class D

ANSWER:-D



2-6 Which of the following is correct regarding Class B Address of IP
address
A. Network bit – 14, Host bit – 16
B. Network bit – 16, Host bit – 14
C. Network bit – 18, Host bit – 16
D. Network bit – 12, Host bit – 14

ANSWER:-A



2-7 The last address of IP address represents
A. Unicast address
B. Network address
C. Broadcast address
D. None of above

ANSWER:-C



2-8 How many bits are there in the Ethernet address?
A. 64 bits
B. 48 bits
C. 32 bits
D. 16 bits

ANSWER:-B



2-9 How many layers are in the TCP/IP model?
A. 4 layers
B. 5 layers
C. 6 layers
D. 7 layers

ANSWER:-A



2-10 Which of the following layer of OSI model also called end-to-end
layer?
A. Presentation layer
B. Network layer
C. Session layer
D. Transport layer

ANSWER:-D