FC0-U71 Practice Test 24 — 15 Questions

Question 1

A developer writes the following pseudocode for a process that finds the largest number in a list:

SET max = first element
FOR each number in list
   IF number > max THEN
      SET max = number
   END IF
ENDFOR
OUTPUT max

What programming concept does this pseudocode represent?

Accepted Answer

Algorithm. An algorithm is a step-by-step procedure to solve a problem. This pseudocode describes a specific algorithm (finding the maximum).

Answer

API

Answer

Data structure

Answer

Flowchart

Question 2

A development team is using a stack data structure to manage function calls. Which of the following correctly describes the order in which items are removed from a stack?

Accepted Answer

Last-In-First-Out (LIFO). A stack follows Last-In-First-Out (LIFO), meaning the most recently added item is removed first.

Answer

Random order

Answer

First-In-First-Out (FIFO)

Answer

Based on priority

Question 3

A product manager creates a list of user stories for a new feature. The development team estimates effort for each story and selects a set to complete in a two-week iteration. Daily standup meetings are held to discuss progress. At the end of the iteration, the team demonstrates working software to stakeholders. Which development framework is being used?

Accepted Answer

Scrum. Scrum is an agile framework that uses fixed-length sprints (iterations), user stories, daily standups, and sprint reviews.

Answer

Waterfall

Answer

V-Model

Answer

Kanban

Question 4

A company's IT department is deploying a new payroll system. Before the system goes live, a group of employees from the accounting department test the system to ensure it meets their requirements and is usable. This type of testing is known as:

Accepted Answer

User acceptance testing. User acceptance testing (UAT) is performed by end users to validate that the system meets their needs and is ready for production.

Answer

System testing

Answer

Unit testing

Answer

Integration testing

Question 5

A developer writes a set of instructions to sort an array of numbers in ascending order. The instructions include steps like 'compare first two numbers, swap if out of order, move to next pair, repeat until no swaps are needed.' This step-by-step procedure is known as a(n):

Accepted Answer

Algorithm. An algorithm is a step-by-step procedure to solve a problem. The description matches the bubble sort algorithm.

Answer

Pseudocode

Answer

Flowchart

Answer

Data structure

Question 6

A testing team is verifying a new version of an e-commerce website. They run a set of pre-existing test cases to ensure that recent changes have not broken any previously working functionality. What type of testing is this?

Accepted Answer

Regression testing. Regression testing checks that new code changes do not adversely affect existing features.

Answer

Unit testing

Answer

System testing

Answer

Integration testing

Question 7

A web developer is creating a weather application that retrieves data from a third-party service. The service requires an identifier to track usage and authenticate requests. The developer includes this identifier in the HTTP header of each request. What is this identifier called?

Accepted Answer

API key. An API key is a unique identifier used to authenticate and authorize API requests, often passed in headers.

Answer

JWT

Answer

Session ID

Answer

OAuth token

Question 8

A programmer needs to represent the logic of a program that includes decisions and loops. Which tool is most suitable for visually representing this logic?

Accepted Answer

Flowchart. A flowchart uses symbols like diamonds for decisions and rectangles for processes to visually represent program logic.

Answer

Algorithm

Answer

Data structure

Answer

Pseudocode

Question 9

A junior developer is learning about data structures. The developer needs to choose a data structure for the following scenarios:
- Storing a list of items where order matters and items can be accessed by index.
- Storing key-value pairs for fast lookups.
Which TWO data structures should the developer consider?

Accepted Answer

Dictionary. An array (or list) allows indexed access and maintains order. A dictionary (hash map) allows fast key-based lookups.

Answer

Tree

Answer

Stack

Answer

Queue

Question 10

A software development team is working on a project with fixed requirements and a strict deadline. The project manager decides to use a methodology where each phase must be completed before moving to the next. Which development methodology is being used?

Accepted Answer

Waterfall. The waterfall model follows sequential phases with fixed scope, making it suitable for predictable projects with stable requirements.

Answer

Agile

Answer

Scrum

Answer

Spiral

Question 11

An organization is implementing a new payroll system. Before final deployment, a group of actual payroll employees test the system to ensure it meets their business needs and processes payroll correctly. Which testing phase is this?

Accepted Answer

User acceptance testing. User acceptance testing (UAT) involves end users validating that the system meets their requirements.

Answer

Unit testing

Answer

System testing

Answer

Integration testing

Question 12

Which SQL statement is used to remove all rows from a table while keeping the table structure?

Accepted Answer

DELETE FROM table_name;. DELETE removes rows based on a condition or all rows if no WHERE clause is used, but TRUNCATE also removes all rows. However, DELETE is the standard DML command.

Answer

DROP TABLE

Answer

ALTER TABLE

Answer

REMOVE FROM table_name;

Question 13

Which of the following is a characteristic of a relational database table?

Accepted Answer

Rows represent records and columns represent fields. In a relational database, each row represents a single record (tuple) and each column represents an attribute (field).

Answer

Rows represent fields and columns represent records

Answer

Each table must have a composite key

Answer

Tables are stored in a hierarchical structure

Question 14

Which DBMS is an example of a proprietary relational database system?

Accepted Answer

Oracle Database. Oracle Database is proprietary (commercial). MySQL, PostgreSQL, and SQLite are open-source.

Answer

MySQL

Answer

PostgreSQL

Answer

SQLite

Question 15

Which of the following SQL statements will add a new row to the 'Products' table?

Accepted Answer

INSERT INTO Products VALUES ('Widget', 10.99). INSERT INTO table VALUES (value1, value2, ...) adds a new row.

Answer

UPDATE Products SET name='Widget', price=10.99

Answer

CREATE ROW IN Products ('Widget', 10.99)

Answer

ADD INTO Products VALUES ('Widget', 10.99)