Question

The programmer usually enters source code into a computer using: A) Pseudocode B) A text editor. C) A hierarchy chart. D) A compiler. E) None of the above

Answer 1

In database design, a junction table would most likely be indexed but with the Unique property set to No because it contains foreign keys from two tables that can have duplicate values, given many-to-many relationships.

Step-by-step explanation:

If you're designing a database and considering which fields might require an index with the Unique property set to No, the correct choice would be a junction table. Junction tables, also known as associative or linking tables, are used in many-to-many relationships between two tables to join them together. Each record in a junction table typically contains the primary keys from the two connecting tables, known as foreign keys. Since these foreign keys will often repeat (as a single record on one side of the relationship can have many associated records on the other side), the Unique property for these indexes should be No to allow for duplicate values.

In contrast, fields such as Last Name would likely not be indexed with the Unique property set to No, because last names are not typically used to uniquely identify records in a database. A secondary key or an alternate key would usually be set with the Unique property set to Yes to ensure that each value in the column is unique and can thus serve as an alternative means to uniquely identify a record.

Answer 2

A programmer typically uses a text editor to enter source code which is then compiled into a machine-readable format.

Step-by-step explanation:

The programmer usually enters source code into a computer using a text editor. This is the environment where code is written and initially saved as a source file, which is a plain text file containing the sequence of commands that the computer will execute. Options such as pseudocode and hierarchy charts are tools for planning and designing programs but are not where actual code is written. Once the source code is written, a compiler is then used to translate that code into a machine-readable format so that it can be run on a computer.