Search Previous Year Questions

To copy a cell, you would drag the cell border while simultaneously holding down the Ctrl key when you have one or more cells to copy.

The maximize button is used to fit the view to the whole screen present before the user.

The correct answer is Uniquely identify a record

• There is always one primary key in a table for each record which is used to uniquely identify that record.
• KEYS in DBMS is an attribute or set of attributes that help you to identify a row(tuple) in a relation(table). They allow you to find the relation between two tables. Keys help you uniquely identify a row in a table by a combination of one or more columns in that table. The Key is also helpful for finding a unique record or row from the table. The database key is also helpful for finding a unique record or row from the table.
• There are mainly seven different types of Keys in DBMS and each key has its different functionality:

1. Super Key -  A super key is a group of single or multiple keys that identifies rows in a table.
2. Primary Key -  is a column or group of columns in a table that uniquely identify every row in that table.
3. Candidate Key -  is a set of attributes that uniquely identify tuples in a table. Candidate Key is a super key with no repeated attributes.
4. Alternate Key -  is a column or group of columns in a table that uniquely identify every row in that table.
5. Foreign Key -  is a column that creates a relationship between two tables. The purpose of Foreign keys is to maintain data integrity and allow navigation between two different instances of an entity.
6. Compound Key -  has two or more attributes that allow you to uniquely recognize a specific record. It is possible that each column may not be unique by itself within the database.
7. Composite Key -  An artificial key which aims to uniquely identify each record is called a surrogate key. These kinds of keys are unique because they are created when you don't have any natural primary key.
8. Surrogate Key -  An artificial key which aims to uniquely identify each record is called a surrogate key. These kinds of keys are unique because they are created when you don't have any natural primary key.

The correct answer is Spreadsheet.

• Microsoft Excel is an electronic spreadsheet program.
• The files created in Microsoft Excel is known as a workbook.
• A spreadsheet is a computer application used for organization, analysis, and storage of data in tabular form.
• The first electronic spreadsheet on mainframe and the time-sharing computer was LANPAR developed in the year 1969.

Important Points

• A spreadsheet consists of a table of cells arranged into rows and columns.
• The total number of rows in a worksheet of Excel 2007 is 1048576.
• The total number of columns in a worksheet of Excel 2007 is 16384.

The correct answer is Hexadecimal.

Key Points

• The hexadecimal Number system Contains 16 digits.
• The base of this number system is 16.
• It comprises 0,1,2,3,4,5,6,7,8,9,A,B,C,D,E,F.

Additional Information

• About Binary number system:
• There are only 2 digits in the Binary system, which are 0 and 1.
• The base of this number system is 2.
• This number system is used by all digital computers to convert the data input from decimal to its binary equivalent.
• About Decimal number system:
• It contains 10 digits.
• It comprises 0,1,2,3,4,5,6,7,8,9.
• The base of this number is 10.
• About Octal number system:
• It contains 8 digits.
• The base of this number is 8.

Compatibility, with regard to computers, refers to the software being able to run on the computer .

A multiplexer is used to establish connection directed towards different output lines. It has 2n lines for input which means it can direct output to n different lines. So it can be used as a connector as well as a switching device.

The correct answer is Integrated Services Digital Network.

Key Points

• ISDN- Integrated Services Digital Network
• It is a circuit-switched telephone network system that transmits both data and voice over a digital line.
• It was designed to move outdated landline technology to digital.
• These digital lines are commonly telephone lines and exchanges established by the government.
• Before ISDN, it was not possible for ordinary telephone lines to provide fast transmission over a single line.

Additional Information

• ISDN was formally standardized in 1988 and gained some significant popularity in the 1990s as a faster (128 Kbps) alternative to the 56 Kbps dial-up connection for internet access.
• However, as soon as telecom companies switched from analog to digital infrastructures, modern long-distance networking and broadband internet technologies eventually made it an obsolete technology.

The correct answer is CAD Computer Aided Design

Key Points

• CAD or Computer Aided Design is a software used in the computer systems by engineers, architects, drafters, artists and others to create, analyze, optimize and modify a design or even create 2D and 3D technical illustrations.

​

Additional Information

• CAD/CAM applications are used to both design a product and program manufacturing processes, specifically, CNC machining. CAM software uses the models and assemblies created in CAD software, like Fusion 360, to generate toolpaths that drive machine tools to turn designs into physical parts.

Administrator or another user can access someone else's computer remotely using Telnet. It provided access to a command-line interface (usually, of an operating system) on a remote host.