Digital Electronics and Programming Fundamentals

Compendium of practice questions covering Digital Electronics, Program Development, Data Structures, Error Handling, and Database Application Development based on lecture notes.

What do the electronic states 0 and 1 represent in digital electronics?

0 represents OFF or LOW, and 1 represents ON or HIGH.

What is the difference between a bit and a byte?

A bit (binary digit) is the smallest unit of data (0 or 1), whereas a byte consists of 8 bits.

Under what condition is the output of an AND gate equal to 1?

The output is 1 only when both inputs are 1.

Describe the function of a NOT gate.

A NOT gate reverses the input, meaning 1 becomes 0 and 0 becomes 1.

What are the five phases of the Software Development Life Cycle (SDLC)?

Phase 1: Problem Analysis, Phase 2: Solution Design, Phase 3: Implementation, Phase 4: Testing, and Phase 5: Deployment and Maintenance.

What does an IPO chart help a programmer identify?

It helps identify Input (data entered), Process (calculations performed), and Output (results displayed).

Define an algorithm.

A step-by-step procedure for solving a problem.

What is the difference between a syntax error and a logic error?

A syntax error occurs when language rules are broken (preventing compilation), while a logic error occurs when the program runs but produces incorrect results.

What is a variable in programming?

A named memory location used to store data that can change during program execution.

Provide examples of the Integer and Real/Double data types.

Integer examples include $15$, and Real/Double examples include $15.75$.

What is an array, and how is it indexed?

An array is a collection of related values stored under one variable name, accessed via an index (starting at 0).

How does a two-dimensional array store data?

It stores data in rows and columns, similar to a table.

What is the purpose of a primary key in a database?

It is a field that uniquely identifies each record in a table to prevent duplicates and make searching easier.

What is a Database Management System (DBMS)?

Software used to create and manage databases, such as Microsoft Access, MySQL, Oracle, or SQL Server.

In a database, what is the difference between a Query and a Report?

A query is used to search for and retrieve specific information, while a report presents that information in a structured format for analysis or printing.

What is Input Validation?

A process that checks whether data entered by the user is acceptable (e.g., ensuring age is numeric) before it is processed.

What occurs during a runtime error?

An error that occurs while the program is executing, such as dividing by zero ($10 / 0$), which usually causes the program to crash.

Identify the three types of testing mentioned in the transcript.

Unit Testing (individual code sections), System Testing (the entire program), and User Testing (testing by users to meet requirements).