Search Previous Year Questions

Find real questions from previous competitive exam papers with answers and solutions.

Leave the keyword blank to browse saved questions for your selected exam, newest papers first. Add a keyword, year or topic to narrow the results.

Browse complete papers
Showing 10 question(s)
Clear

Question 31

UPPCL Technician 2021• Computer Knowledge (CCC Level)

Which of the following options is equal to 256 nibbles?

  1. AOption (a)

    128 bytes

  2. BOption (b)

    4 kilobytes

  3. COption (c)

    512 bits

  4. DOption (d)

    8 kilobyte

View answer & explanation

Correct answer

Answer: (a)A.

128 bytes

Why this answer is correct

The correct answer is 128 bytes.

Key Points

  • The data is measured in the computer system in bits. It is the smallest unit to measure the data.
  • When the 4 bits of the memory unit are called together as a nibble.
  • When the 8 bits of the memory unit are called together as a byte.
  • So, it can state that 2 nibbles =1 byte.

Therefore 256 nibbles = (256/2) bytes =128 bytes.

Thus the correct answer is 128 bytes.

Additional Information

  • The other storage units used in the computer system are KiloBytes(KB), MegaBytes (MB), GigaBytes(GB), and TeraByte(TB).
  • 1 KB= 1024 bytes; 1MB= 1024 KB;  1GB= 1024 MB;   1TB= 1024 GB.
  • Above terabytes, there are some more storage units. These are petabytes (PB), exabytes (EB), zettabytes (ZB), and yottabytes (YB).

Question 32

UPPCL Technician 2021• Computer Knowledge (CCC Level)

From the following options, what is the keyboard shortcut to add a new slide to an existing Microsoft Power Point presentation?

  1. AOption (a)

    Alt+N

  2. BOption (b)

    Ctrl+M

  3. COption (c)

    Alt+W

  4. DOption (d)

    Ctrl+N

View answer & explanation

Correct answer

Answer: (b)B.

Ctrl+M

Why this answer is correct

The correct answer is CTRL + M.

Key Points

The following keyboard shortcuts are used in MS PowerPoint for the Windows version.

  • Alt + N: This keyboard shortcut is used to open the insert tab in Microsoft PowerPoint presentation.
  • Ctrl + M: This keyboard shortcut to add a new slide to an existing Microsoft PowerPoint presentation
  • Alt + W: This keyboard shortcut is used to go to the view tab in Microsoft PowerPoint.
  • Ctrl + N: This keyboard shortcut is used to open a new presentation in Microsoft PowerPoint.

Thus the correct answer is CTRL + M.

Additional Information

  • The main creators of MS PowerPoint software are Robert Gaskins and Dennis Austin, launched in 1987. PowerPoint Presentation area is useful for every person and practised usage. Given below area unit one or two of the foremost fields where PPT is extremely useful:
  • Education – With e-learning and smart classes being chosen as a typical mode of education lately, PowerPoint displays can facilitate making education loads interactive and attract students towards the modified version of learning.
  • Marketing – Among the sphere of commerce, PowerPoint displays are going to be terribly necessary. Practice graphs and charts, numbers are going to be shown loads plain and clearly which may be ignored by the viewer if being scanned.
  • Business – To raise investors or to point out the increase or decrease in profits, MS PowerPoint is going to be used.
  • Depicting Growth – Since every graphic and text is going to be adscititious throughout a presentation, the portrayal of the enlargement of an organization, business, student’s marks, etc. is easier than practice PPT.

Question 33

UPPCL Technician 2021• Computer Knowledge (CCC Level)

Which of the following requires continuous refreshing to retain data?

  1. AOption (a)

    SRAM

  2. BOption (b)

    EEPROM

  3. COption (c)

    EPROM

  4. DOption (d)

    DRAM

View answer & explanation

Correct answer

Answer: (d)D.

DRAM

Why this answer is correct

The correct answer is DRAM.

Key Points

  • The word RAM stands for Random Access Memory. It is a very fast internal memory of the CPU. It holds data temporarily. After switching off the computer, data are deleted from the RAM. There are two variants of RAM. These are SRAM and DRAM.
  • SRAM: The word SRAM stands for Static Random Access Memory. The SRAM is comparatively the fastest memory. SRAM chips use a matrix of 6-transistors and no capacitors. Transistors don't need the power to forestall outpouring, therefore SRAM needn't be invigorated on a daily basis. There is an additional area within the matrix, thence SRAM uses a lot of chips than DRAM for an equivalent quantity of space for storing, creating the producing prices higher. SRAM is therefore used as cache memory and has no time access.
  • DRAM: The word DRAM stands for Dynamic Random Access Memory. DRAM always refresh itself to maintain the organised data. This is done by putting the memory on a refresh circuit that rewrites the information many hundred times per second. DRAM is employed for many system memory because it is affordable and tiny in size. DRAMs are created from memory cells, that are composed of 1 capacitor and one electronic transistor.

Thus the correct answer is DRAM.

Additional Information

  • ROM: The word ROM stands for Read Only Memory. It is permanent memory that the user will solely read but cannot write of it. This sort of memory is non-volatile. The data is kept for good in such recollections throughout manufacture. A memory stores such directions that square measure needed to begin a computing system. This operation is remarked as bootstrap.
  • Memory chips don't seem to be solely utilized in the computing system however conjointly in different electronic things like cleaning machines and microwave ovens. MROM, PROM, EPROM and EEPROM are the types of ROM.

Question 34

UPPCL Technician 2021• Computer Knowledge (CCC Level)

State whether the following statements are true or false.

(i) WinZip does not do any compression.

(ii) Linux is a system software.

  1. AOption (a)

    (i) - True, (ii) - True

  2. BOption (b)

    (i) - True, (ii) - False

  3. COption (c)

    (i) - False, (ii) - False

  4. DOption (d)

    (i) - False, (ii) - True

View answer & explanation

Correct answer

Answer: (d)D.

(i) - False, (ii) - True

Why this answer is correct

The correct answer is (i) - False, (ii) - True.

Key Points

  • WinZip: WinZip is known as an application software. The main application of WinZip files is to achieve and compress the file for the Windows operating system, macOS. IOS, Android.
  • Linux: Linux is an operating system that acts like Unix operating system or the system software. The code used to build Linux is free and available for the public to view, edit and use. Ubuntu is the popular version of Linux. Linux uses a command line interface as well as the graphical user interface.

Thus the correct answer is (i) - False, (ii) - True.

Additional Information

  • When a user interacts with the computer system through some software, then it is known as application software.
  • The system software is known as the base for the other software. System software uses a low-level programming language.

Question 35

UPPCL Technician 2021• Computer Knowledge (CCC Level)

Click the ______ if you want to get a window out of the screen temporarily without closing it .

  1. AOption (a)

    minimise button

  2. BOption (b)

    scroll bar

  3. COption (c)

    maximise button

  4. DOption (d)

    status bar

View answer & explanation

Correct answer

Answer: (a)A.

minimise button

Why this answer is correct

The correct answer is the minimise button.

Key Points

  • Minimise button: By clicking on the minimise button a window out of the screen temporarily without closing it. The minimise button minimizes the current window to the taskbar. But the task will not close. It will keep running in the background. By clicking it again in the taskbar, it will return to the screen.
  • Scroll bar: The scroll bar helps to scroll down or scroll up the content in windows. It also scrolls horizontally through the window.
  • Maximise button: By clicking on the maximise button a window went to full-screen mode. Other applications cannot be seen at that time on the screen.
  • Status bar: The status bar shows the status of the cursor movement and other statuses of the current window.

 Thus the correct answer is the minimise button.

Question 36

UPPCL Technician 2021• Computer Knowledge (CCC Level)

A CPU directly interacts with a ______ to access data during a program’s execution.

  1. AOption (a)

    RAM

  2. BOption (b)

    ROM

  3. COption (c)

    hard disk

  4. DOption (d)

    magnetic tape

View answer & explanation

Correct answer

Answer: (a)A.

RAM

Why this answer is correct

The correct answer is RAM.

Key Points

  • The word RAM stands for Random Access Memory. It is a very fast internal memory of the CPU. It holds data temporarily. After switching off the computer, data are deleted from the RAM. A CPU directly interacts with RAM to access data during a program’s execution. There are two variants of RAM. These are SRAM and DRAM.
  • The word SRAM stands for Static Random Access Memory. The SRAM is comparatively the fastest memory. SRAM chips use a matrix of 6-transistors and no capacitors. There is an additional area within the matrix, thence SRAM uses a lot of chips than DRAM for an equivalent quantity of space for storing, creating the producing prices higher. SRAM is therefore used as cache memory and has no time access. The word DRAM stands for Dynamic Random Access Memory. DRAM always refresh itself to maintain the organised data. This is done by putting the memory on a refresh circuit that rewrites the information many hundred times per second. DRAM is employed for many system memory because it is affordable and tiny in size. DRAMs are created from memory cells, that are composed of 1 capacitor and one electronic transistor.

Thus the correct answer is RAM.

 Additional Information

  • ROM: The word ROM stands for Read Only Memory. It is permanent memory that the user will solely read but cannot write of it. This sort of memory is non-volatile. The data is kept for good in such recollections throughout manufacture. A memory stores such directions that are needed to begin a computing system. This operation is remarked as bootstrap. Memory chips don't seem to be solely utilized in the computing system however conjointly in different electronic things like cleaning machines and microwave ovens. MROM, PROM, EPROM and EEPROM are the types of ROM.
  • Hard disk: The hard disk is recognised as secondary memory. It is permanent in nature. The size of the hard disk is depending on the users' requirements.
  • Magnetic tape: The magnetic tape is the primary storage unit which is circular in size. Audio files, video files are recorded by using the magnetic tapes.

Question 37

UPPCL Technician 2021• Computer Knowledge (CCC Level)

What is the value of the following Microsoft Excel function?

=ROUNDUP(2.5,0)

  1. AOption (a)

    1

  2. BOption (b)

    2

  3. COption (c)

    Error

  4. DOption (d)

    3

View answer & explanation

Correct answer

Answer: (d)D.

3

Why this answer is correct

The correct answer is 3.

Key Points

  • ROUNDUP(): In MS Excel, the roundup() function is used to convert the decimal number to the next closest whole number or the decimal number. The syntax for roundup() is given below:

                     =roundup(decimal number, number of unit)

  • For example, =roundup(5.86,1). The result will be 5.9.
  • In the same manner, =ROUNDUP(2.5,0) will produce 3. Because after the decimal point, the number of the unit is 0.

Thus the correct answer is 3.

Additional Information

  • MS Excel, a spreadsheet program, is widely used for varied functions, as a result, the info is simple to avoid wasting time, and data is accessible and removed with zero discomforts and less labour. Given below area unit some necessary advantages of exploitation MS Excel:
  • Easy To Store Data: Since there's no limit to the number of data that may be saved in an exceeding program, MS Excel is widely accustomed to saving or analysing information. Filtering info in stand out is simple and convenient.
  • Easy To Recover Data: If the data is written on a bit of paper, finding it should take longer, however, this is often not the case with Excel spreadsheets. Finding convalescent information is simple.
  • Application of Mathematical Formulas: Doing calculations has become more accessible and less time-taking with the formulas possibility in MS Excel.
  • More Secure: These spreadsheets are countersigned and secured in an exceedingly portable computer or laptop computer and therefore the chance of losing them is much lesser as compared to information written in registers or pieces of paper.
  • Data at One Place: Earlier, information was to be unbroken in several files and registers once the work was done. Now, this has become convenient as over one worksheet is accessible in an exceedingly single MS Excel file.
  • Neater and Clearer Visibility of Information: Once the info is saved within the type of a table, analysing it becomes easier. Thus, info may be a program that's a lot of legible and comprehensible.

Question 38

UPPCL Technician 2021• Computer Knowledge (CCC Level)

Which of the following facilitates creating and printing letters and emails, or labels and envelopes for a group of persons in Microsoft Word?

  1. AOption (a)

    Mail Merge

  2. BOption (b)

    Pivot Table

  3. COption (c)

    Drop Cap

  4. DOption (d)

    Pagination

View answer & explanation

Correct answer

Answer: (a)A.

Mail Merge

Why this answer is correct

The correct answer is Mail Merge.

Key Points

  • Mail Merge: In MS Word, a unique feature lets the user helps to create a batch of documents that are personalized for each recipient. This unique feature is known as a mail merge. In mail merge, the main document, the source of data and the document to be merged are referred to as the three important parts. The main document of the mail merge consists of text, images, information or instructions etc. The source of data holds the recipients' information which is going to be attached one by one to the main document. After merging the whole data, the merged mail is ready to be sent.

  • Pivot Table: In the pivot table data can interact with each other to generate the final result. The pivot table is mainly used to generate a sort of report as per the given conditions.

  • Drop Cap: A special feature in MS Word, that makes the story or paragraph more attractive. By using the drop cap, the first letter can be written in a very big size.

  • Pagination: Pagination is done by adding the page number in the desired location in MS Word. It helps to understand the sequence of the content written in MS Word.

Thus the correct answer is Mail Merge.

Additional Information

  • The leading creators of MS Word software are Charles Simonyi and Richard Brodie, launched in 1983 under Microsoft corporation.
  • Microsoft word is recognised as a word processing software which means that a user can rewrite, erase or modify a document as per the requirement.
  • The documents created in MS Word are very high in quality. MS Word creates reports, stories, letters, resumes etc.
  • It allows users to edit or modify the new or existing document with colour or any other formats like bold, italic and underline.
  • In MS Word, the users can write the stories in paragraph format.
  • The file extension used in MS Word is .doc or .docx.

Question 39

UPPCL Technician 2021• Computer Knowledge (CCC Level)

What is the keyboard shortcut to go to the last cell of a row in Microsoft Excel?

  1. AOption (a)

    Alt+right arrow

  2. BOption (b)

    Ctrl+right arrow

  3. COption (c)

    Ctrl+left arrow

  4. DOption (d)

    Ctrl+top arrow

View answer & explanation

Correct answer

Answer: (b)B.

Ctrl+right arrow

Why this answer is correct

The correct answer is the Ctrl+right arrow.

Key Points

  • Alt + right arrow: This keyboard shortcut is used to go forward.
  • Ctrl + right arrow: This keyboard shortcut is used to go to the last cell of a row in Microsoft Excel.
  • Ctrl + left arrow: This keyboard shortcut is used to go to the first cell of the current row in Microsoft Excel.
  • Ctrl + top arrow: This keyboard shortcut is used to go to the top cell of the current column in Microsoft Excel.

Thus the correct answer is the Ctrl + right arrow.

Additional Information

  • Given below area unit some necessary advantages of exploitation MS Excel:
  • Easy To Store Data: Since there's no limit to the number of data that may be saved in an exceeding program, MS Excel is widely accustomed to saving or analysing information. Filtering info in stand out is simple and convenient.
  • Easy To Recover Data: If the data is written on a bit of paper, finding it should take longer, however, this is often not the case with Excel spreadsheets. Finding convalescent information is simple.
  • Application of Mathematical Formulas: Doing calculations has become more accessible and less time-taking with the formulas possibility in MS Excel.
  • More Secure: These spreadsheets are countersigned and secured in an exceedingly portable computer or laptop computer and therefore the chance of losing them is much lesser as compared to information written in registers or pieces of paper.
  • Data at One Place: Earlier, information was to be unbroken in several files and registers once the work was done. Now, this has become convenient as over one worksheet is accessible in an exceedingly single MS Excel file.
  • Neater and Clearer Visibility of Information: Once the info is saved within the type of a table, analysing it becomes easier. Thus, info may be a program that's a lot of legible and comprehensible.

Question 40

UPPCL Technician 2021• Computer Knowledge (CCC Level)

Which of the following is defined as a global collection of computer networks that are linked together by devices called 'routers' and use a common set of protocols for data transmission?

  1. AOption (a)

    Internet

  2. BOption (b)

    LAN

  3. COption (c)

    VPN

  4. DOption (d)

    Intranet

View answer & explanation

Correct answer

Answer: (a)A.

Internet

Why this answer is correct

The correct answer is the Internet.

Key Points

  • Local Area Network (LAN): In the Local Area Network, computers are connected through a common line. In this network system, the range of the area is limited. Ethernet and Wi-Fi are the two most important technologies used in LAN. The LAN can be used in the home, school, library, etc.
  • Virtual Private Network (VPN): In the Virtual Private Network, computers are acted as an extended private network. VPN users can send and receive the data like private network users, even though they are not connected to any private network.
  • Intranet: When an organisation is using a network system for their private use then the network system is referred to as an Intranet. It's designed for the exclusive use of a corporation and its associates, like workers, customers, and alternative licensed individuals. It offers a secure platform to convey info and share knowledge with licensed users. The database, links, forms, and applications or any confidential data may be created and offered to the employees through the computer network within the organisation.
  • Internet: The Internet is referred to as a  world network that connects billions of computers across the world with one another. It uses a commonplace web protocol suite (TCP/IP) to attach billions of computer or digital device users worldwide. It can be possible only because the cables like optical fibres and different wireless and networking technologies are connected properly. At present, the Internet is the quickest mean of causation or exchanging data and information between computers across the world.

Thus the correct answer is the Internet. 

Additional Information

  • The Internet was developed by Bob Kahn and Vint Cerf in the year 1970. They began the planning of what we tend to these days grasp because of the ‘Internet’.
  • At the very beginning, the Internet was known as ARPANET, which stands for Advanced Research Projects Agency Network. This was presupposed to be a communications system for the accumulation of the US of America - a network that might conjointly survive a nuclear attack.
  • It eventually became a fortunate nationwide experimental packet network.