HERE ARE THE answers and explanation to the second set of Computer Operator MCQ Practice Sheets 75-02. The correct answers are marked with blue color. Explanation of each question is marked with green color.
You can download this solution as PDF file. Please find the link at the bottom of this post.
Computer Operator MCQ Practice Sheet 75-02
Q1. The process of removing unwanted part of an image is called.
Explanation: Many times you may need to remove unwanted part of images and for that, you can crop it. Neither Hiding nor Cutting will remove some part of an image, so they are not valid options. Scaling is to change the size of the image and not removing some part. Thus only option B is the correct answer.
Q2. The space kept between the margins and the start of a paragraph is called
b. Space Before
d. Line Spacing
Explanation: Gutter is binding margin towards the inside margin. Space before adds some spacing to the paragraph where this setting is applied. Line spacing is the space maintained between lines. Indentation is pushing paragraph inside from left or right. Thus, Indentation is the correct answer for this question.
Q3. A database language concerned with the definition of the whole database structure and schema is?
d. None of above
Explanation: DML, CDL, and DDL are different kind of database languages. DML works with data stored inside database such as insert, remove, update data items and records. DCL works with users and privileges of database such as adding, removing users, granting and revoking permissions to/from database users. DDL works with the structure of database such as creating, deleting, updating columns, tables etc. Thus DDL is the correct answer.
Q4. In a one-to-many relationship the table in one side is called ___ and on many side is called ____
a. Child, Parent
b. Parent, Child
c. Sister, Sister
d. Father, Son
Explanation: Take an example of Class and Student tables having a one-to-many relationship. One record in Class table has many related records in Students table. In such situation record in Class table is parent record which has many child records in Students table. Class table is parent table whose primary key is the foreign key in Student table and student table is called child table. Thus option B is the correct answer.
Q5. Any data or instruction entered into the memory of a computer is considered as:
Explanation: When you input any data into the computer it is stored in memory waiting for further processing. The output is the information obtained after processing which may be in the form of printout or display on a monitor. Storage is copying contents of memory into the secondary storage devices such as hard disk. Information is the result of processing useful to the end user. Thus option A is the correct answer to this question.
Q6. In Computer Network terminology, the process of combining multiple signals into one signal over a shared medium is known as?
Explanation: Muxing or multiplexing is the process of combining multiple signals into one signal so that data from multiple sources or kinds is possible to transmit. Because of muxing, it is possible to deliver hundreds of TV Channels through a single cabling (Cable TV). Thus Option C is the correct answer to this question.
Q7. Microsoft Edge is an example of
a. Word Processing Application
b. Image Processing Application
c. Web Browsing Application
d. Website Development Interface
Explanation: Microsoft Edge is a web browser developed by Microsoft and included in Windows 10, Windows 10 Mobile and Xbox One, replacing Internet Explorer as the default web browser on all device classes. Thus option C is the correct answer for this question.
Q8. Getting data from a cell located in other workbook is
Explanation: Addressing cells using workbook name, sheet name, Column name and Row number is referencing. Thus cell addresses are also called cell reference. To access a cell or to get data from a cell C10 in the Annual sheet of a workbook Budget.xls we reference that cell as [Budget.xlsx]Annual!C10. Thus option b is correct for this question.
Q9. Which of the following is true for =SUM(C3:D8, F3:G8)
a. The formula returns error
b. Returns the total of all the cells in both the ranges
c. Returns the total of all the cells in C3:D8 cells
d. Returns the total of all the cells in F3:G8 cells
Explanation: According to the syntax of =SUM() function it returns the total of all the cells in both ranges. You can supply a range of different values separated by a comma. Thus Option B is correct Answer for this question.
Q10. Which of the following tag displays an image on a webpage?
a. <pic src=”mcqsets.com.jpg”>
b. <img src=”mcqsets.com.jpg”>
c. <pic loc=”mcqsets.com.jpg”>
d. <img loc=”mcqsets.com.jpg”>
Explanation: IMG tag is used to display images in web pages and SRC attribute of IMG tag tells which image to display. Thus option B is correct for this question.
Solution to 75-02 Download PDF