Question Discussion & Solution

Here the pattern is,

Sum of the three digits of a number is equal to 5.

203 – 2 + 0 + 3 = 5,

500 – 5 + 0 + 0 = 5,

600 – 6 + 0 + 0 = 6

401 – 4 + 0 + 1 = 5

The correct answer is Primary key.

Key Points

• The foreign key is not necessarily the primary key in its current table.
  • It only has to contain the same information that is held in another table’s primary key.
  • Foreign keys are the columns of a table that points to the primary key of another table. They act as a cross-reference between tables.

Additional Information​ 

• A report generator is a computer program whose purpose is to take data from a source such as a database, XML stream or a spreadsheet, and use it to produce a document in a format which satisfies a particular human readership.
• The data dictionary is a set of information describing the contents, format, and structure of a database and the relationship between its elements, used to control access to and manipulation of the database.
• Schema objects are logical structures created by users. Objects such as tables or indexes hold data or can consist of a definition only, such as a view or synonym.

The sound that Elephant makes is called a Trumpet.

Similarly,

the sound that Horse make is called Neigh.

Hence, Horse is related to “Neigh”.

Additional Information 

Some important animal sounds:

(E_Name, Salary_in_Lakhs) is the key

(E_Name, Salary_in_Lakhs) → {E_ID, E_Age, E_mail}

E_Name: Nitesh is repeated

Check only for Nitesh

(Nitesh, 9) → (XE005, 24, nitestSE@123)

(Nitesh, R) → (XE023, 24, nitestCE@123)

Since right hand side is not same

Therefore, R cannot be equal to 9

The correct answer is Software program.

• An operating system is system software that manages computer hardware, software resources, and provides common services for computer programs. Operating systems are found on many devices such as a computer, mobile phones, video games etc.
• Software program
  • It is a set of instructions, or a set of modules or procedures, through which computer operation is performed.
  • It is often called a software application and a software product.

Additional Information

• Computer system
  • A Computer system is usually defined as a combination of both hardware and software working together.
  • Hardware is the physical components of a computer and software is the programs that run on a computer.
• Network
  • It is a collection of computers, servers, mainframes, network devices, peripherals, or other devices connected to one another to allow the sharing of data.
  • E.g - The Internet, often referred to as the ‘Net’, consists of a complex network of computers connected by high-speed communication technologies like satellites, microwave devices, etc.
• Hardware device
  • Computer hardware includes the physical parts of a computer, such as a case, central processing unit (CPU), monitor, mouse, keyboard, computer data storage, graphics card, sound card, speakers and motherboard.
  • It accepts the data (input) from the user.
  • The computer has memory chips, which are designed to hold data until it is needed.
  • It processes this data into information. The computer has an electronic brain called the Central Processing Unit, which is responsible for processing all data into information according to the instructions given to the computer.
  • It then returns the processed information (output) to the user.