Computer Awareness Quiz - 30

Ans. (a)
Sol. Union operation performs a set union of two ‘similarly structured’ tables. 

Ans. (a)
Sol. Tuple is a row. 

Ans. (d)
Sol. A field is category of information. 

Ans. (b)
Sol. Key is a property of the entire relation (relation is a table). 

 Ans.(d)
Sol. As the installation cost of thinnet coaxial cable is less, it is also known as cheapernet. 

Ans.(b)
Sol. Earliest computers used Machine language. 

Ans.(d)
Sol. Drop Down menu is also called drop down list or pull-down list. 

Ans.(c)
Sol. Email is transmission of files and messages through computer network. 

Ans.(c)
Sol. Spooler is a program in computing that is used to line up print jobs by storing them in the buffer for a short time and allows the printer to print at the time when it is use.  

Ans. (b)
Sol. PowerPoint is used to make presentations/slide shows. 

Ans. (d)
Sol. All are memory access mechanism which a CD Player can use.  

Ans. (a)
Sol. Each box in a spreadsheet is called a cell. 

Ans.(b)
Sol.  ALU does the arithmetic and logical operations in a computer system. 

Ans. (a)
 Sol. The key F12 opens a SaveAs dialog box. 

Ans. (c) 
Sol. Text left aligned and numbers right aligned is default alignment in Excel.

Ans. (e)
 Sol. Functions are predefined formulas and are already available in Excel. They are used to compute dynamically the results from Excel data. 

Ans. (b) 
Sol. It is a formula to get sum of the data from cell number S3 to S10. 

Ans. (e)
 Sol. All of the given options are different types of router functions. 

Ans.(c)
Sol. Spider is an important element of a search engine that browses the Internet in a systematic manner. 

Ans. (b)
Sol.  System disk is used to cold boot a PC. 

Ans.(b)
Sol. Except Virtual Reality all other are obvious security threats to computers and data. 

Ans.(b)
Sol. Except option (b) all others are the symptoms of a computer virus 

Ans.(a)
Sol. VIRUS stands for Vital Information Resources Under Siege 

Ans.(a)
Sol. Creeper virus is a computer virus that is most commonly recognized as the first computer virus. 

Ans.(b)
Sol. A data bus connects internal components to the motherboard and acts as a carrier for the data. 

Ans.(b)
Sol. Television is an example of simplex communication. 

Ans.(d)
Sol. Font grammar is not related with font. 

Ans.(d
Sol. Both options (a) and option (c) are correct to set text in Italics. 

Ans.(a)
Sol. A function inside another function is called a nested function. 

Ans.(c)
Sol. An excel workbook can contain many sheets including worksheets and chart sheets.