[1] Which of the following is a Web browser?
A.
Paint
B.
PowerPoint
C.
Firefox
D.
Word
Ans:
Firefox
Explanation :
Paint, PowerPoint and Word are application software.
[2] Which type of system can learn and adjust to new circumstances by themselves?
A.
Database management system
B.
Expert systems
C.
Geographical systems
D.
Neural networks
Ans:
Neural networks
Explanation :
Neural Networks can learn and adjust to new circumstances.
[3] In PROM, P stands for?
A.
Plausible
B.
Program
C.
Programmable
D.
Proper
Ans:
Programmable
Explanation :
PROM is an acronym for Programmable Read Only Memory.
[4] The ‘Slides’ category/group of commands is available under which tab in MS PowerPoint 2016?
A.
Home
B.
Design
C.
Slide Show
D.
View
Ans:
Home
Explanation :
The ‘Slides’ category/group of commands is available under Home Tab.
[5] Choose the Odd one out:
A.
Home
B.
Insert
C.
Layout
D.
Slide Show
Ans:
Layout
Explanation :
Except Layout, all others are tabs in MS PowerPoint 2016 ribbon. Following is the sequence of Tabs in PowerPoint File, Home, Insert, Design, Transition, Animation, Slide Show, Review, View, Add-ins.
[6]Which output device transfers processed information into a printed page?
A.
Scanner
B.
Printer
C.
Monitor
D.
CD-ROM
Ans:
Printer
Explanation :
Printers transfer processed information into printed page. Different types of printer are Ink Jet, Laser, drum etc.
[7] Which type of system can learn and adjust to new circumstances by themselves?
A.
Database management system
B.
Expert systems
C.
Geographical systems
D.
Neural networks
Ans:
Neural networks
Explanation :
Neural Networks can learn and adjust to new circumstances.
[8] Pascaline is among which of the type of machine?
A.
Mechanical machine
B.
Arithmetic machine
C.
Division machine
D.
Difference machine
Ans:
Arithmetic machine
Explanation :
Pascal's calculator is a mechanical calculator invented by Blaise Pascal in the early 17th century. It was called the arithmetic machine and later became known as the Pascaline.
[9] Which of the following diagrams graphically represents an inter-relationship among entities and logical schema of a database?
A.
Entity-relationship diagram
B.
Data flow diagram
C.
Control flow diagram
D.
Sequence diagram
Ans:
Entity-relationship diagram
Explanation :
A relationship is an association among entities. We can use the Entity-Relationship Diagram (ERD) to represent an inter-relationship between the entities of a database.
[10] Which of the following keys is a field in one table that is used as a primary key field in another table?
A.
Primary key
B.
Foreign key
C.
Candidate key
D.
Identity key
Ans:
Foreign key
Explanation :
Foreign key is a field in one table that is used as the primary key in another table. Whenever a relationship is created between two tables, a common field acts as the primary key in the first table and the foreign key in the second table.
[11] By what name are two or more fields of a database table called when they are collectively used to specify the primary key?
A.
Composite key
B.
Primary key
C.
Foreign key
D.
Candidate key
Ans:
Composite key
Explanation :
Composite key is formed when two or more fields of a database table are combined together in order to uniquely identify the records stored in the table.
[12] Which of the following is not a normal form in DBMS?
A.
First Normal Form (1NF)
B.
Second Normal Form (2NF)
C.
Third Normal Form (3NF)
D.
Ninth Normal For (9NF)
Ans:
Ninth Normal For (9NF)
Explanation :
In DBMS, the commonly used normal forms are 1NF, 2NF, 3NF and BCNF.
[13] If you change Windows 98 to Windows XP, which action will you be performing?
A.
Revise
B.
Upgrade
C.
Update
D.
Patch
Ans:
Upgrade
Explanation :
It will be called upgrade.
[14] A symbol on the screen that represents a disk, document or program that you can select _.
A.
keys
B.
caps
C.
icon
D.
monitor
Ans:
icon
Explanation :
con is a symbol on screen that may represent many things.
[15] means that the data contained in a database is accurate, consistent and reliable.
A.
Data redundancy
B.
Data integrity
C.
Data reliability
D.
Data consistency
Ans:
Data integrity
Explanation :
Data integrity means that the data contained in a database is accurate, consistent and reliable.
[16] The feature in database language that allows us to access certain records in database is called .
A.
Query
B.
Forms
C.
Reports
D.
Tables
Ans:
Query
Explanation :
Query allows us to access certain records in database.
[17] Which of the following is not aggregate function?
A.
MIN
B.
MAX
C.
AVG
D.
None of these
Ans:
None of these
Explanation :
All of these are aggregate functions.
[18] 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
Ans:
Domain
Explanation :
Set of permitted values is called the domain of that attribute. (Relation is a table. Attributes describe the instances in the row of a database.)
[19] The operation performs a set union of two ‘similarly structured’ tables.
A.
Union
B.
Join
C.
Product
D.
Intersect
Ans:
Union
Explanation :
Union operation performs a set union of two ‘similarly structured’ tables.
[20] Which of the following appropriately relates with starting up an operating system?
A.
Starting
B.
Entering
C.
Formatting
D.
Booting
Ans:
Booting
Explanation :
Booting is a startup sequence that starts the operating system of a computer when it is turned on. A boot sequence is the initial set of operations that the computer performs when it is switched on. Every computer has a boot sequence.
[21] In MS-DOS 6.22, which part identifies that product uniquely?
A.
MS
B.
DOS
C.
Ms - DOS
D.
6.22
Ans:
6.22
Explanation :
MS-DOS 6.22; 6.22 is the version number which identifies it uniquely.
[22] Who is the father of computers?
A.
Ada Byron
B.
Charles Babbage
C.
Blaise Pascal
D.
Herman Hollerith
Ans:
Charles Babbage
Explanation :
Charles Babbage is the father of computers.
[23] Who invented the machine to add numbers quickly and accurately?
A.
Joseph Marie Jacquard
B.
Gottfried Wilhelm von Leibniz
C.
Blaise Pascal
D.
Herman Hollerith
Ans:
Blaise Pascal
Explanation :
Blaise Pascal developed a machine that was used to perform additions quickly and accurately. This machine was called the adding machine or Pascaline.
[24] Except for the function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
A.
IF
B.
AND
C.
OR
D.
NOT
Ans:
IF
Explanation :
IF function allows you to make logical comparisons between a value and what you expect. It returns some value on meeting a condition.
[25] Macros are available in Excel 2016 under which Tab?
A.
Insert
B.
Format
C.
View
D.
Data
Ans:
View
Explanation :
View Tab-> Macros
Explanation :
Paint, PowerPoint and Word are application software.
[2] Which type of system can learn and adjust to new circumstances by themselves?
A.
Database management system
B.
Expert systems
C.
Geographical systems
D.
Neural networks
Ans:
Neural networks
Explanation :
Neural Networks can learn and adjust to new circumstances.
[3] In PROM, P stands for?
A.
Plausible
B.
Program
C.
Programmable
D.
Proper
Ans:
Programmable
Explanation :
PROM is an acronym for Programmable Read Only Memory.
[4] The ‘Slides’ category/group of commands is available under which tab in MS PowerPoint 2016?
A.
Home
B.
Design
C.
Slide Show
D.
View
Ans:
Home
Explanation :
The ‘Slides’ category/group of commands is available under Home Tab.
[5] Choose the Odd one out:
A.
Home
B.
Insert
C.
Layout
D.
Slide Show
Ans:
Layout
Explanation :
Except Layout, all others are tabs in MS PowerPoint 2016 ribbon. Following is the sequence of Tabs in PowerPoint File, Home, Insert, Design, Transition, Animation, Slide Show, Review, View, Add-ins.
[6]Which output device transfers processed information into a printed page?
A.
Scanner
B.
Printer
C.
Monitor
D.
CD-ROM
Ans:
Printer
Explanation :
Printers transfer processed information into printed page. Different types of printer are Ink Jet, Laser, drum etc.
[7] Which type of system can learn and adjust to new circumstances by themselves?
A.
Database management system
B.
Expert systems
C.
Geographical systems
D.
Neural networks
Ans:
Neural networks
Explanation :
Neural Networks can learn and adjust to new circumstances.
[8] Pascaline is among which of the type of machine?
A.
Mechanical machine
B.
Arithmetic machine
C.
Division machine
D.
Difference machine
Ans:
Arithmetic machine
Explanation :
Pascal's calculator is a mechanical calculator invented by Blaise Pascal in the early 17th century. It was called the arithmetic machine and later became known as the Pascaline.
[9] Which of the following diagrams graphically represents an inter-relationship among entities and logical schema of a database?
A.
Entity-relationship diagram
B.
Data flow diagram
C.
Control flow diagram
D.
Sequence diagram
Ans:
Entity-relationship diagram
Explanation :
A relationship is an association among entities. We can use the Entity-Relationship Diagram (ERD) to represent an inter-relationship between the entities of a database.
[10] Which of the following keys is a field in one table that is used as a primary key field in another table?
A.
Primary key
B.
Foreign key
C.
Candidate key
D.
Identity key
Ans:
Foreign key
Explanation :
Foreign key is a field in one table that is used as the primary key in another table. Whenever a relationship is created between two tables, a common field acts as the primary key in the first table and the foreign key in the second table.
[11] By what name are two or more fields of a database table called when they are collectively used to specify the primary key?
A.
Composite key
B.
Primary key
C.
Foreign key
D.
Candidate key
Ans:
Composite key
Explanation :
Composite key is formed when two or more fields of a database table are combined together in order to uniquely identify the records stored in the table.
[12] Which of the following is not a normal form in DBMS?
A.
First Normal Form (1NF)
B.
Second Normal Form (2NF)
C.
Third Normal Form (3NF)
D.
Ninth Normal For (9NF)
Ans:
Ninth Normal For (9NF)
Explanation :
In DBMS, the commonly used normal forms are 1NF, 2NF, 3NF and BCNF.
[13] If you change Windows 98 to Windows XP, which action will you be performing?
A.
Revise
B.
Upgrade
C.
Update
D.
Patch
Ans:
Upgrade
Explanation :
It will be called upgrade.
[14] A symbol on the screen that represents a disk, document or program that you can select _.
A.
keys
B.
caps
C.
icon
D.
monitor
Ans:
icon
Explanation :
con is a symbol on screen that may represent many things.
[15] means that the data contained in a database is accurate, consistent and reliable.
A.
Data redundancy
B.
Data integrity
C.
Data reliability
D.
Data consistency
Ans:
Data integrity
Explanation :
Data integrity means that the data contained in a database is accurate, consistent and reliable.
[16] The feature in database language that allows us to access certain records in database is called .
A.
Query
B.
Forms
C.
Reports
D.
Tables
Ans:
Query
Explanation :
Query allows us to access certain records in database.
[17] Which of the following is not aggregate function?
A.
MIN
B.
MAX
C.
AVG
D.
None of these
Ans:
None of these
Explanation :
All of these are aggregate functions.
[18] 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
Ans:
Domain
Explanation :
Set of permitted values is called the domain of that attribute. (Relation is a table. Attributes describe the instances in the row of a database.)
[19] The operation performs a set union of two ‘similarly structured’ tables.
A.
Union
B.
Join
C.
Product
D.
Intersect
Ans:
Union
Explanation :
Union operation performs a set union of two ‘similarly structured’ tables.
[20] Which of the following appropriately relates with starting up an operating system?
A.
Starting
B.
Entering
C.
Formatting
D.
Booting
Ans:
Booting
Explanation :
Booting is a startup sequence that starts the operating system of a computer when it is turned on. A boot sequence is the initial set of operations that the computer performs when it is switched on. Every computer has a boot sequence.
[21] In MS-DOS 6.22, which part identifies that product uniquely?
A.
MS
B.
DOS
C.
Ms - DOS
D.
6.22
Ans:
6.22
Explanation :
MS-DOS 6.22; 6.22 is the version number which identifies it uniquely.
[22] Who is the father of computers?
A.
Ada Byron
B.
Charles Babbage
C.
Blaise Pascal
D.
Herman Hollerith
Ans:
Charles Babbage
Explanation :
Charles Babbage is the father of computers.
[23] Who invented the machine to add numbers quickly and accurately?
A.
Joseph Marie Jacquard
B.
Gottfried Wilhelm von Leibniz
C.
Blaise Pascal
D.
Herman Hollerith
Ans:
Blaise Pascal
Explanation :
Blaise Pascal developed a machine that was used to perform additions quickly and accurately. This machine was called the adding machine or Pascaline.
[24] Except for the function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
A.
IF
B.
AND
C.
OR
D.
NOT
Ans:
IF
Explanation :
IF function allows you to make logical comparisons between a value and what you expect. It returns some value on meeting a condition.
[25] Macros are available in Excel 2016 under which Tab?
A.
Insert
B.
Format
C.
View
D.
Data
Ans:
View
Explanation :
View Tab-> Macros
Explanation :
PROM is an acronym for Programmable Read Only Memory.
[4] The ‘Slides’ category/group of commands is available under which tab in MS PowerPoint 2016?
A.
Home
B.
Design
C.
Slide Show
D.
View
Ans:
Home
Explanation :
The ‘Slides’ category/group of commands is available under Home Tab.
[5] Choose the Odd one out:
A.
Home
B.
Insert
C.
Layout
D.
Slide Show
Ans:
Layout
Explanation :
Except Layout, all others are tabs in MS PowerPoint 2016 ribbon. Following is the sequence of Tabs in PowerPoint File, Home, Insert, Design, Transition, Animation, Slide Show, Review, View, Add-ins.
[6]Which output device transfers processed information into a printed page?
A.
Scanner
B.
Printer
C.
Monitor
D.
CD-ROM
Ans:
Printer
Explanation :
Printers transfer processed information into printed page. Different types of printer are Ink Jet, Laser, drum etc.
[7] Which type of system can learn and adjust to new circumstances by themselves?
A.
Database management system
B.
Expert systems
C.
Geographical systems
D.
Neural networks
Ans:
Neural networks
Explanation :
Neural Networks can learn and adjust to new circumstances.
[8] Pascaline is among which of the type of machine?
A.
Mechanical machine
B.
Arithmetic machine
C.
Division machine
D.
Difference machine
Ans:
Arithmetic machine
Explanation :
Pascal's calculator is a mechanical calculator invented by Blaise Pascal in the early 17th century. It was called the arithmetic machine and later became known as the Pascaline.
[9] Which of the following diagrams graphically represents an inter-relationship among entities and logical schema of a database?
A.
Entity-relationship diagram
B.
Data flow diagram
C.
Control flow diagram
D.
Sequence diagram
Ans:
Entity-relationship diagram
Explanation :
A relationship is an association among entities. We can use the Entity-Relationship Diagram (ERD) to represent an inter-relationship between the entities of a database.
[10] Which of the following keys is a field in one table that is used as a primary key field in another table?
A.
Primary key
B.
Foreign key
C.
Candidate key
D.
Identity key
Ans:
Foreign key
Explanation :
Foreign key is a field in one table that is used as the primary key in another table. Whenever a relationship is created between two tables, a common field acts as the primary key in the first table and the foreign key in the second table.
[11] By what name are two or more fields of a database table called when they are collectively used to specify the primary key?
A.
Composite key
B.
Primary key
C.
Foreign key
D.
Candidate key
Ans:
Composite key
Explanation :
Composite key is formed when two or more fields of a database table are combined together in order to uniquely identify the records stored in the table.
[12] Which of the following is not a normal form in DBMS?
A.
First Normal Form (1NF)
B.
Second Normal Form (2NF)
C.
Third Normal Form (3NF)
D.
Ninth Normal For (9NF)
Ans:
Ninth Normal For (9NF)
Explanation :
In DBMS, the commonly used normal forms are 1NF, 2NF, 3NF and BCNF.
[13] If you change Windows 98 to Windows XP, which action will you be performing?
A.
Revise
B.
Upgrade
C.
Update
D.
Patch
Ans:
Upgrade
Explanation :
It will be called upgrade.
[14] A symbol on the screen that represents a disk, document or program that you can select _.
A.
keys
B.
caps
C.
icon
D.
monitor
Ans:
icon
Explanation :
con is a symbol on screen that may represent many things.
[15] means that the data contained in a database is accurate, consistent and reliable.
A.
Data redundancy
B.
Data integrity
C.
Data reliability
D.
Data consistency
Ans:
Data integrity
Explanation :
Data integrity means that the data contained in a database is accurate, consistent and reliable.
[16] The feature in database language that allows us to access certain records in database is called .
A.
Query
B.
Forms
C.
Reports
D.
Tables
Ans:
Query
Explanation :
Query allows us to access certain records in database.
[17] Which of the following is not aggregate function?
A.
MIN
B.
MAX
C.
AVG
D.
None of these
Ans:
None of these
Explanation :
All of these are aggregate functions.
[18] 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
Ans:
Domain
Explanation :
Set of permitted values is called the domain of that attribute. (Relation is a table. Attributes describe the instances in the row of a database.)
[19] The operation performs a set union of two ‘similarly structured’ tables.
A.
Union
B.
Join
C.
Product
D.
Intersect
Ans:
Union
Explanation :
Union operation performs a set union of two ‘similarly structured’ tables.
[20] Which of the following appropriately relates with starting up an operating system?
A.
Starting
B.
Entering
C.
Formatting
D.
Booting
Ans:
Booting
Explanation :
Booting is a startup sequence that starts the operating system of a computer when it is turned on. A boot sequence is the initial set of operations that the computer performs when it is switched on. Every computer has a boot sequence.
[21] In MS-DOS 6.22, which part identifies that product uniquely?
A.
MS
B.
DOS
C.
Ms - DOS
D.
6.22
Ans:
6.22
Explanation :
MS-DOS 6.22; 6.22 is the version number which identifies it uniquely.
[22] Who is the father of computers?
A.
Ada Byron
B.
Charles Babbage
C.
Blaise Pascal
D.
Herman Hollerith
Ans:
Charles Babbage
Explanation :
Charles Babbage is the father of computers.
[23] Who invented the machine to add numbers quickly and accurately?
A.
Joseph Marie Jacquard
B.
Gottfried Wilhelm von Leibniz
C.
Blaise Pascal
D.
Herman Hollerith
Ans:
Blaise Pascal
Explanation :
Blaise Pascal developed a machine that was used to perform additions quickly and accurately. This machine was called the adding machine or Pascaline.
[24] Except for the function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
A.
IF
B.
AND
C.
OR
D.
NOT
Ans:
IF
Explanation :
IF function allows you to make logical comparisons between a value and what you expect. It returns some value on meeting a condition.
[25] Macros are available in Excel 2016 under which Tab?
A.
Insert
B.
Format
C.
View
D.
Data
Ans:
View
Explanation :
View Tab-> Macros
Explanation :
Except Layout, all others are tabs in MS PowerPoint 2016 ribbon. Following is the sequence of Tabs in PowerPoint File, Home, Insert, Design, Transition, Animation, Slide Show, Review, View, Add-ins.
[6]Which output device transfers processed information into a printed page?
A.
Scanner
B.
Printer
C.
Monitor
D.
CD-ROM
Ans:
Printer
Explanation :
Printers transfer processed information into printed page. Different types of printer are Ink Jet, Laser, drum etc.
[7] Which type of system can learn and adjust to new circumstances by themselves?
A.
Database management system
B.
Expert systems
C.
Geographical systems
D.
Neural networks
Ans:
Neural networks
Explanation :
Neural Networks can learn and adjust to new circumstances.
[8] Pascaline is among which of the type of machine?
A.
Mechanical machine
B.
Arithmetic machine
C.
Division machine
D.
Difference machine
Ans:
Arithmetic machine
Explanation :
Pascal's calculator is a mechanical calculator invented by Blaise Pascal in the early 17th century. It was called the arithmetic machine and later became known as the Pascaline.
[9] Which of the following diagrams graphically represents an inter-relationship among entities and logical schema of a database?
A.
Entity-relationship diagram
B.
Data flow diagram
C.
Control flow diagram
D.
Sequence diagram
Ans:
Entity-relationship diagram
Explanation :
A relationship is an association among entities. We can use the Entity-Relationship Diagram (ERD) to represent an inter-relationship between the entities of a database.
[10] Which of the following keys is a field in one table that is used as a primary key field in another table?
A.
Primary key
B.
Foreign key
C.
Candidate key
D.
Identity key
Ans:
Foreign key
Explanation :
Foreign key is a field in one table that is used as the primary key in another table. Whenever a relationship is created between two tables, a common field acts as the primary key in the first table and the foreign key in the second table.
[11] By what name are two or more fields of a database table called when they are collectively used to specify the primary key?
A.
Composite key
B.
Primary key
C.
Foreign key
D.
Candidate key
Ans:
Composite key
Explanation :
Composite key is formed when two or more fields of a database table are combined together in order to uniquely identify the records stored in the table.
[12] Which of the following is not a normal form in DBMS?
A.
First Normal Form (1NF)
B.
Second Normal Form (2NF)
C.
Third Normal Form (3NF)
D.
Ninth Normal For (9NF)
Ans:
Ninth Normal For (9NF)
Explanation :
In DBMS, the commonly used normal forms are 1NF, 2NF, 3NF and BCNF.
[13] If you change Windows 98 to Windows XP, which action will you be performing?
A.
Revise
B.
Upgrade
C.
Update
D.
Patch
Ans:
Upgrade
Explanation :
It will be called upgrade.
[14] A symbol on the screen that represents a disk, document or program that you can select _.
A.
keys
B.
caps
C.
icon
D.
monitor
Ans:
icon
Explanation :
con is a symbol on screen that may represent many things.
[15] means that the data contained in a database is accurate, consistent and reliable.
A.
Data redundancy
B.
Data integrity
C.
Data reliability
D.
Data consistency
Ans:
Data integrity
Explanation :
Data integrity means that the data contained in a database is accurate, consistent and reliable.
[16] The feature in database language that allows us to access certain records in database is called .
A.
Query
B.
Forms
C.
Reports
D.
Tables
Ans:
Query
Explanation :
Query allows us to access certain records in database.
[17] Which of the following is not aggregate function?
A.
MIN
B.
MAX
C.
AVG
D.
None of these
Ans:
None of these
Explanation :
All of these are aggregate functions.
[18] 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
Ans:
Domain
Explanation :
Set of permitted values is called the domain of that attribute. (Relation is a table. Attributes describe the instances in the row of a database.)
[19] The operation performs a set union of two ‘similarly structured’ tables.
A.
Union
B.
Join
C.
Product
D.
Intersect
Ans:
Union
Explanation :
Union operation performs a set union of two ‘similarly structured’ tables.
[20] Which of the following appropriately relates with starting up an operating system?
A.
Starting
B.
Entering
C.
Formatting
D.
Booting
Ans:
Booting
Explanation :
Booting is a startup sequence that starts the operating system of a computer when it is turned on. A boot sequence is the initial set of operations that the computer performs when it is switched on. Every computer has a boot sequence.
[21] In MS-DOS 6.22, which part identifies that product uniquely?
A.
MS
B.
DOS
C.
Ms - DOS
D.
6.22
Ans:
6.22
Explanation :
MS-DOS 6.22; 6.22 is the version number which identifies it uniquely.
[22] Who is the father of computers?
A.
Ada Byron
B.
Charles Babbage
C.
Blaise Pascal
D.
Herman Hollerith
Ans:
Charles Babbage
Explanation :
Charles Babbage is the father of computers.
[23] Who invented the machine to add numbers quickly and accurately?
A.
Joseph Marie Jacquard
B.
Gottfried Wilhelm von Leibniz
C.
Blaise Pascal
D.
Herman Hollerith
Ans:
Blaise Pascal
Explanation :
Blaise Pascal developed a machine that was used to perform additions quickly and accurately. This machine was called the adding machine or Pascaline.
[24] Except for the function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
A.
IF
B.
AND
C.
OR
D.
NOT
Ans:
IF
Explanation :
IF function allows you to make logical comparisons between a value and what you expect. It returns some value on meeting a condition.
[25] Macros are available in Excel 2016 under which Tab?
A.
Insert
B.
Format
C.
View
D.
Data
Ans:
View
Explanation :
View Tab-> Macros
Explanation :
Neural Networks can learn and adjust to new circumstances.
[8] Pascaline is among which of the type of machine?
A.
Mechanical machine
B.
Arithmetic machine
C.
Division machine
D.
Difference machine
Ans:
Arithmetic machine
Explanation :
Pascal's calculator is a mechanical calculator invented by Blaise Pascal in the early 17th century. It was called the arithmetic machine and later became known as the Pascaline.
[9] Which of the following diagrams graphically represents an inter-relationship among entities and logical schema of a database?
A.
Entity-relationship diagram
B.
Data flow diagram
C.
Control flow diagram
D.
Sequence diagram
Ans:
Entity-relationship diagram
Explanation :
A relationship is an association among entities. We can use the Entity-Relationship Diagram (ERD) to represent an inter-relationship between the entities of a database.
[10] Which of the following keys is a field in one table that is used as a primary key field in another table?
A.
Primary key
B.
Foreign key
C.
Candidate key
D.
Identity key
Ans:
Foreign key
Explanation :
Foreign key is a field in one table that is used as the primary key in another table. Whenever a relationship is created between two tables, a common field acts as the primary key in the first table and the foreign key in the second table.
[11] By what name are two or more fields of a database table called when they are collectively used to specify the primary key?
A.
Composite key
B.
Primary key
C.
Foreign key
D.
Candidate key
Ans:
Composite key
Explanation :
Composite key is formed when two or more fields of a database table are combined together in order to uniquely identify the records stored in the table.
[12] Which of the following is not a normal form in DBMS?
A.
First Normal Form (1NF)
B.
Second Normal Form (2NF)
C.
Third Normal Form (3NF)
D.
Ninth Normal For (9NF)
Ans:
Ninth Normal For (9NF)
Explanation :
In DBMS, the commonly used normal forms are 1NF, 2NF, 3NF and BCNF.
[13] If you change Windows 98 to Windows XP, which action will you be performing?
A.
Revise
B.
Upgrade
C.
Update
D.
Patch
Ans:
Upgrade
Explanation :
It will be called upgrade.
[14] A symbol on the screen that represents a disk, document or program that you can select _.
A.
keys
B.
caps
C.
icon
D.
monitor
Ans:
icon
Explanation :
con is a symbol on screen that may represent many things.
[15] means that the data contained in a database is accurate, consistent and reliable.
A.
Data redundancy
B.
Data integrity
C.
Data reliability
D.
Data consistency
Ans:
Data integrity
Explanation :
Data integrity means that the data contained in a database is accurate, consistent and reliable.
[16] The feature in database language that allows us to access certain records in database is called .
A.
Query
B.
Forms
C.
Reports
D.
Tables
Ans:
Query
Explanation :
Query allows us to access certain records in database.
[17] Which of the following is not aggregate function?
A.
MIN
B.
MAX
C.
AVG
D.
None of these
Ans:
None of these
Explanation :
All of these are aggregate functions.
[18] 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
Ans:
Domain
Explanation :
Set of permitted values is called the domain of that attribute. (Relation is a table. Attributes describe the instances in the row of a database.)
[19] The operation performs a set union of two ‘similarly structured’ tables.
A.
Union
B.
Join
C.
Product
D.
Intersect
Ans:
Union
Explanation :
Union operation performs a set union of two ‘similarly structured’ tables.
[20] Which of the following appropriately relates with starting up an operating system?
A.
Starting
B.
Entering
C.
Formatting
D.
Booting
Ans:
Booting
Explanation :
Booting is a startup sequence that starts the operating system of a computer when it is turned on. A boot sequence is the initial set of operations that the computer performs when it is switched on. Every computer has a boot sequence.
[21] In MS-DOS 6.22, which part identifies that product uniquely?
A.
MS
B.
DOS
C.
Ms - DOS
D.
6.22
Ans:
6.22
Explanation :
MS-DOS 6.22; 6.22 is the version number which identifies it uniquely.
[22] Who is the father of computers?
A.
Ada Byron
B.
Charles Babbage
C.
Blaise Pascal
D.
Herman Hollerith
Ans:
Charles Babbage
Explanation :
Charles Babbage is the father of computers.
[23] Who invented the machine to add numbers quickly and accurately?
A.
Joseph Marie Jacquard
B.
Gottfried Wilhelm von Leibniz
C.
Blaise Pascal
D.
Herman Hollerith
Ans:
Blaise Pascal
Explanation :
Blaise Pascal developed a machine that was used to perform additions quickly and accurately. This machine was called the adding machine or Pascaline.
[24] Except for the function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
A.
IF
B.
AND
C.
OR
D.
NOT
Ans:
IF
Explanation :
IF function allows you to make logical comparisons between a value and what you expect. It returns some value on meeting a condition.
[25] Macros are available in Excel 2016 under which Tab?
A.
Insert
B.
Format
C.
View
D.
Data
Ans:
View
Explanation :
View Tab-> Macros
Explanation :
A relationship is an association among entities. We can use the Entity-Relationship Diagram (ERD) to represent an inter-relationship between the entities of a database.
[10] Which of the following keys is a field in one table that is used as a primary key field in another table?
A.
Primary key
B.
Foreign key
C.
Candidate key
D.
Identity key
Ans:
Foreign key
Explanation :
Foreign key is a field in one table that is used as the primary key in another table. Whenever a relationship is created between two tables, a common field acts as the primary key in the first table and the foreign key in the second table.
[11] By what name are two or more fields of a database table called when they are collectively used to specify the primary key?
A.
Composite key
B.
Primary key
C.
Foreign key
D.
Candidate key
Ans:
Composite key
Explanation :
Composite key is formed when two or more fields of a database table are combined together in order to uniquely identify the records stored in the table.
[12] Which of the following is not a normal form in DBMS?
A.
First Normal Form (1NF)
B.
Second Normal Form (2NF)
C.
Third Normal Form (3NF)
D.
Ninth Normal For (9NF)
Ans:
Ninth Normal For (9NF)
Explanation :
In DBMS, the commonly used normal forms are 1NF, 2NF, 3NF and BCNF.
[13] If you change Windows 98 to Windows XP, which action will you be performing?
A.
Revise
B.
Upgrade
C.
Update
D.
Patch
Ans:
Upgrade
Explanation :
It will be called upgrade.
[14] A symbol on the screen that represents a disk, document or program that you can select _.
A.
keys
B.
caps
C.
icon
D.
monitor
Ans:
icon
Explanation :
con is a symbol on screen that may represent many things.
[15] means that the data contained in a database is accurate, consistent and reliable.
A.
Data redundancy
B.
Data integrity
C.
Data reliability
D.
Data consistency
Ans:
Data integrity
Explanation :
Data integrity means that the data contained in a database is accurate, consistent and reliable.
[16] The feature in database language that allows us to access certain records in database is called .
A.
Query
B.
Forms
C.
Reports
D.
Tables
Ans:
Query
Explanation :
Query allows us to access certain records in database.
[17] Which of the following is not aggregate function?
A.
MIN
B.
MAX
C.
AVG
D.
None of these
Ans:
None of these
Explanation :
All of these are aggregate functions.
[18] 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
Ans:
Domain
Explanation :
Set of permitted values is called the domain of that attribute. (Relation is a table. Attributes describe the instances in the row of a database.)
[19] The operation performs a set union of two ‘similarly structured’ tables.
A.
Union
B.
Join
C.
Product
D.
Intersect
Ans:
Union
Explanation :
Union operation performs a set union of two ‘similarly structured’ tables.
[20] Which of the following appropriately relates with starting up an operating system?
A.
Starting
B.
Entering
C.
Formatting
D.
Booting
Ans:
Booting
Explanation :
Booting is a startup sequence that starts the operating system of a computer when it is turned on. A boot sequence is the initial set of operations that the computer performs when it is switched on. Every computer has a boot sequence.
[21] In MS-DOS 6.22, which part identifies that product uniquely?
A.
MS
B.
DOS
C.
Ms - DOS
D.
6.22
Ans:
6.22
Explanation :
MS-DOS 6.22; 6.22 is the version number which identifies it uniquely.
[22] Who is the father of computers?
A.
Ada Byron
B.
Charles Babbage
C.
Blaise Pascal
D.
Herman Hollerith
Ans:
Charles Babbage
Explanation :
Charles Babbage is the father of computers.
[23] Who invented the machine to add numbers quickly and accurately?
A.
Joseph Marie Jacquard
B.
Gottfried Wilhelm von Leibniz
C.
Blaise Pascal
D.
Herman Hollerith
Ans:
Blaise Pascal
Explanation :
Blaise Pascal developed a machine that was used to perform additions quickly and accurately. This machine was called the adding machine or Pascaline.
[24] Except for the function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
A.
IF
B.
AND
C.
OR
D.
NOT
Ans:
IF
Explanation :
IF function allows you to make logical comparisons between a value and what you expect. It returns some value on meeting a condition.
[25] Macros are available in Excel 2016 under which Tab?
A.
Insert
B.
Format
C.
View
D.
Data
Ans:
View
Explanation :
View Tab-> Macros
Explanation :
Composite key is formed when two or more fields of a database table are combined together in order to uniquely identify the records stored in the table.
[12] Which of the following is not a normal form in DBMS?
A.
First Normal Form (1NF)
B.
Second Normal Form (2NF)
C.
Third Normal Form (3NF)
D.
Ninth Normal For (9NF)
Ans:
Ninth Normal For (9NF)
Explanation :
In DBMS, the commonly used normal forms are 1NF, 2NF, 3NF and BCNF.
[13] If you change Windows 98 to Windows XP, which action will you be performing?
A.
Revise
B.
Upgrade
C.
Update
D.
Patch
Ans:
Upgrade
Explanation :
It will be called upgrade.
[14] A symbol on the screen that represents a disk, document or program that you can select _.
A.
keys
B.
caps
C.
icon
D.
monitor
Ans:
icon
Explanation :
con is a symbol on screen that may represent many things.
[15] means that the data contained in a database is accurate, consistent and reliable.
A.
Data redundancy
B.
Data integrity
C.
Data reliability
D.
Data consistency
Ans:
Data integrity
Explanation :
Data integrity means that the data contained in a database is accurate, consistent and reliable.
[16] The feature in database language that allows us to access certain records in database is called .
A.
Query
B.
Forms
C.
Reports
D.
Tables
Ans:
Query
Explanation :
Query allows us to access certain records in database.
[17] Which of the following is not aggregate function?
A.
MIN
B.
MAX
C.
AVG
D.
None of these
Ans:
None of these
Explanation :
All of these are aggregate functions.
[18] 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
Ans:
Domain
Explanation :
Set of permitted values is called the domain of that attribute. (Relation is a table. Attributes describe the instances in the row of a database.)
[19] The operation performs a set union of two ‘similarly structured’ tables.
A.
Union
B.
Join
C.
Product
D.
Intersect
Ans:
Union
Explanation :
Union operation performs a set union of two ‘similarly structured’ tables.
[20] Which of the following appropriately relates with starting up an operating system?
A.
Starting
B.
Entering
C.
Formatting
D.
Booting
Ans:
Booting
Explanation :
Booting is a startup sequence that starts the operating system of a computer when it is turned on. A boot sequence is the initial set of operations that the computer performs when it is switched on. Every computer has a boot sequence.
[21] In MS-DOS 6.22, which part identifies that product uniquely?
A.
MS
B.
DOS
C.
Ms - DOS
D.
6.22
Ans:
6.22
Explanation :
MS-DOS 6.22; 6.22 is the version number which identifies it uniquely.
[22] Who is the father of computers?
A.
Ada Byron
B.
Charles Babbage
C.
Blaise Pascal
D.
Herman Hollerith
Ans:
Charles Babbage
Explanation :
Charles Babbage is the father of computers.
[23] Who invented the machine to add numbers quickly and accurately?
A.
Joseph Marie Jacquard
B.
Gottfried Wilhelm von Leibniz
C.
Blaise Pascal
D.
Herman Hollerith
Ans:
Blaise Pascal
Explanation :
Blaise Pascal developed a machine that was used to perform additions quickly and accurately. This machine was called the adding machine or Pascaline.
[24] Except for the function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
A.
IF
B.
AND
C.
OR
D.
NOT
Ans:
IF
Explanation :
IF function allows you to make logical comparisons between a value and what you expect. It returns some value on meeting a condition.
[25] Macros are available in Excel 2016 under which Tab?
A.
Insert
B.
Format
C.
View
D.
Data
Ans:
View
Explanation :
View Tab-> Macros
Explanation :
It will be called upgrade.
[14] A symbol on the screen that represents a disk, document or program that you can select _.
A.
keys
B.
caps
C.
icon
D.
monitor
Ans:
icon
Explanation :
con is a symbol on screen that may represent many things.
[15] means that the data contained in a database is accurate, consistent and reliable.
A.
Data redundancy
B.
Data integrity
C.
Data reliability
D.
Data consistency
Ans:
Data integrity
Explanation :
Data integrity means that the data contained in a database is accurate, consistent and reliable.
[16] The feature in database language that allows us to access certain records in database is called .
A.
Query
B.
Forms
C.
Reports
D.
Tables
Ans:
Query
Explanation :
Query allows us to access certain records in database.
[17] Which of the following is not aggregate function?
A.
MIN
B.
MAX
C.
AVG
D.
None of these
Ans:
None of these
Explanation :
All of these are aggregate functions.
[18] 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
Ans:
Domain
Explanation :
Set of permitted values is called the domain of that attribute. (Relation is a table. Attributes describe the instances in the row of a database.)
[19] The operation performs a set union of two ‘similarly structured’ tables.
A.
Union
B.
Join
C.
Product
D.
Intersect
Ans:
Union
Explanation :
Union operation performs a set union of two ‘similarly structured’ tables.
[20] Which of the following appropriately relates with starting up an operating system?
A.
Starting
B.
Entering
C.
Formatting
D.
Booting
Ans:
Booting
Explanation :
Booting is a startup sequence that starts the operating system of a computer when it is turned on. A boot sequence is the initial set of operations that the computer performs when it is switched on. Every computer has a boot sequence.
[21] In MS-DOS 6.22, which part identifies that product uniquely?
A.
MS
B.
DOS
C.
Ms - DOS
D.
6.22
Ans:
6.22
Explanation :
MS-DOS 6.22; 6.22 is the version number which identifies it uniquely.
[22] Who is the father of computers?
A.
Ada Byron
B.
Charles Babbage
C.
Blaise Pascal
D.
Herman Hollerith
Ans:
Charles Babbage
Explanation :
Charles Babbage is the father of computers.
[23] Who invented the machine to add numbers quickly and accurately?
A.
Joseph Marie Jacquard
B.
Gottfried Wilhelm von Leibniz
C.
Blaise Pascal
D.
Herman Hollerith
Ans:
Blaise Pascal
Explanation :
Blaise Pascal developed a machine that was used to perform additions quickly and accurately. This machine was called the adding machine or Pascaline.
[24] Except for the function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
A.
IF
B.
AND
C.
OR
D.
NOT
Ans:
IF
Explanation :
IF function allows you to make logical comparisons between a value and what you expect. It returns some value on meeting a condition.
[25] Macros are available in Excel 2016 under which Tab?
A.
Insert
B.
Format
C.
View
D.
Data
Ans:
View
Explanation :
View Tab-> Macros
Explanation :
Data integrity means that the data contained in a database is accurate, consistent and reliable.
[16] The feature in database language that allows us to access certain records in database is called .
A.
Query
B.
Forms
C.
Reports
D.
Tables
Ans:
Query
Explanation :
Query allows us to access certain records in database.
[17] Which of the following is not aggregate function?
A.
MIN
B.
MAX
C.
AVG
D.
None of these
Ans:
None of these
Explanation :
All of these are aggregate functions.
[18] 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
Ans:
Domain
Explanation :
Set of permitted values is called the domain of that attribute. (Relation is a table. Attributes describe the instances in the row of a database.)
[19] The operation performs a set union of two ‘similarly structured’ tables.
A.
Union
B.
Join
C.
Product
D.
Intersect
Ans:
Union
Explanation :
Union operation performs a set union of two ‘similarly structured’ tables.
[20] Which of the following appropriately relates with starting up an operating system?
A.
Starting
B.
Entering
C.
Formatting
D.
Booting
Ans:
Booting
Explanation :
Booting is a startup sequence that starts the operating system of a computer when it is turned on. A boot sequence is the initial set of operations that the computer performs when it is switched on. Every computer has a boot sequence.
[21] In MS-DOS 6.22, which part identifies that product uniquely?
A.
MS
B.
DOS
C.
Ms - DOS
D.
6.22
Ans:
6.22
Explanation :
MS-DOS 6.22; 6.22 is the version number which identifies it uniquely.
[22] Who is the father of computers?
A.
Ada Byron
B.
Charles Babbage
C.
Blaise Pascal
D.
Herman Hollerith
Ans:
Charles Babbage
Explanation :
Charles Babbage is the father of computers.
[23] Who invented the machine to add numbers quickly and accurately?
A.
Joseph Marie Jacquard
B.
Gottfried Wilhelm von Leibniz
C.
Blaise Pascal
D.
Herman Hollerith
Ans:
Blaise Pascal
Explanation :
Blaise Pascal developed a machine that was used to perform additions quickly and accurately. This machine was called the adding machine or Pascaline.
[24] Except for the function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
A.
IF
B.
AND
C.
OR
D.
NOT
Ans:
IF
Explanation :
IF function allows you to make logical comparisons between a value and what you expect. It returns some value on meeting a condition.
[25] Macros are available in Excel 2016 under which Tab?
A.
Insert
B.
Format
C.
View
D.
Data
Ans:
View
Explanation :
View Tab-> Macros
Explanation :
All of these are aggregate functions.
[18] 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
Ans:
Domain
Explanation :
Set of permitted values is called the domain of that attribute. (Relation is a table. Attributes describe the instances in the row of a database.)
[19] The operation performs a set union of two ‘similarly structured’ tables.
A.
Union
B.
Join
C.
Product
D.
Intersect
Ans:
Union
Explanation :
Union operation performs a set union of two ‘similarly structured’ tables.
[20] Which of the following appropriately relates with starting up an operating system?
A.
Starting
B.
Entering
C.
Formatting
D.
Booting
Ans:
Booting
Explanation :
Booting is a startup sequence that starts the operating system of a computer when it is turned on. A boot sequence is the initial set of operations that the computer performs when it is switched on. Every computer has a boot sequence.
[21] In MS-DOS 6.22, which part identifies that product uniquely?
A.
MS
B.
DOS
C.
Ms - DOS
D.
6.22
Ans:
6.22
Explanation :
MS-DOS 6.22; 6.22 is the version number which identifies it uniquely.
[22] Who is the father of computers?
A.
Ada Byron
B.
Charles Babbage
C.
Blaise Pascal
D.
Herman Hollerith
Ans:
Charles Babbage
Explanation :
Charles Babbage is the father of computers.
[23] Who invented the machine to add numbers quickly and accurately?
A.
Joseph Marie Jacquard
B.
Gottfried Wilhelm von Leibniz
C.
Blaise Pascal
D.
Herman Hollerith
Ans:
Blaise Pascal
Explanation :
Blaise Pascal developed a machine that was used to perform additions quickly and accurately. This machine was called the adding machine or Pascaline.
[24] Except for the function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
A.
IF
B.
AND
C.
OR
D.
NOT
Ans:
IF
Explanation :
IF function allows you to make logical comparisons between a value and what you expect. It returns some value on meeting a condition.
[25] Macros are available in Excel 2016 under which Tab?
A.
Insert
B.
Format
C.
View
D.
Data
Ans:
View
Explanation :
View Tab-> Macros
Explanation :
Union operation performs a set union of two ‘similarly structured’ tables.
[20] Which of the following appropriately relates with starting up an operating system?
A.
Starting
B.
Entering
C.
Formatting
D.
Booting
Ans:
Booting
Explanation :
Booting is a startup sequence that starts the operating system of a computer when it is turned on. A boot sequence is the initial set of operations that the computer performs when it is switched on. Every computer has a boot sequence.
[21] In MS-DOS 6.22, which part identifies that product uniquely?
A.
MS
B.
DOS
C.
Ms - DOS
D.
6.22
Ans:
6.22
Explanation :
MS-DOS 6.22; 6.22 is the version number which identifies it uniquely.
[22] Who is the father of computers?
A.
Ada Byron
B.
Charles Babbage
C.
Blaise Pascal
D.
Herman Hollerith
Ans:
Charles Babbage
Explanation :
Charles Babbage is the father of computers.
[23] Who invented the machine to add numbers quickly and accurately?
A.
Joseph Marie Jacquard
B.
Gottfried Wilhelm von Leibniz
C.
Blaise Pascal
D.
Herman Hollerith
Ans:
Blaise Pascal
Explanation :
Blaise Pascal developed a machine that was used to perform additions quickly and accurately. This machine was called the adding machine or Pascaline.
[24] Except for the function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
A.
IF
B.
AND
C.
OR
D.
NOT
Ans:
IF
Explanation :
IF function allows you to make logical comparisons between a value and what you expect. It returns some value on meeting a condition.
[25] Macros are available in Excel 2016 under which Tab?
A.
Insert
B.
Format
C.
View
D.
Data
Ans:
View
Explanation :
View Tab-> Macros
Explanation :
MS-DOS 6.22; 6.22 is the version number which identifies it uniquely.
[22] Who is the father of computers?
A.
Ada Byron
B.
Charles Babbage
C.
Blaise Pascal
D.
Herman Hollerith
Ans:
Charles Babbage
Explanation :
Charles Babbage is the father of computers.
[23] Who invented the machine to add numbers quickly and accurately?
A.
Joseph Marie Jacquard
B.
Gottfried Wilhelm von Leibniz
C.
Blaise Pascal
D.
Herman Hollerith
Ans:
Blaise Pascal
Explanation :
Blaise Pascal developed a machine that was used to perform additions quickly and accurately. This machine was called the adding machine or Pascaline.
[24] Except for the function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
A.
IF
B.
AND
C.
OR
D.
NOT
Ans:
IF
Explanation :
IF function allows you to make logical comparisons between a value and what you expect. It returns some value on meeting a condition.
[25] Macros are available in Excel 2016 under which Tab?
A.
Insert
B.
Format
C.
View
D.
Data
Ans:
View
Explanation :
View Tab-> Macros
Explanation :
Blaise Pascal developed a machine that was used to perform additions quickly and accurately. This machine was called the adding machine or Pascaline.
[24] Except for the function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
A.
IF
B.
AND
C.
OR
D.
NOT
Ans:
IF
Explanation :
IF function allows you to make logical comparisons between a value and what you expect. It returns some value on meeting a condition.
[25] Macros are available in Excel 2016 under which Tab?
A.
Insert
B.
Format
C.
View
D.
Data
Ans:
View
Explanation :
View Tab-> Macros
Explanation :
View Tab-> Macros