NEW
Font size
WorksheetsSoftware Development Concepts 2
Total questions: 10
Worksheet time: 5mins
Which of the following statements BEST describes the primary function of a boolean value in a program?
To hold large amounts of text data
To represent either a 'true' or 'false' state
To store the date and time values
To represent numerical values
Which of the following fundamental data types is specifically used to represent real numbers, including those with decimal or fractional parts, in a programming context?
Integer
Float
Char
Boolean
In a high-level programming language, you have a repeating sequence of actions that needs to process different sets of data at various points in your code. Which programming concept is BEST suited to bundle these actions for future reuse and maintain a DRY (Don't Repeat Yourself) approach?
Defining an array that holds pieces of the repeating code
Creating a function that encapsulates the repeating actions
Creating a loop structure to continuously perform the repeating actions
Establishing a list of variables for each repeating action
Your company's CEO has just tasked your IT team with creating a safeguarding measure that could be used to completely restore the customer database in the event of a system failure or data loss. This measure should include a comprehensive backup of all data and structures in a format that can be used to recreate the original database. What term BEST describes this safety measure?
Using query builders and report generation tools
The process of assigning roles and permissions
Manual scripting of SQL commands for database interaction
Creating a Database Dump
In SQL, which statements are used to grant or deny specific rights to user accounts over objects in the database?
Data Manipulation Language (DML)
Data Definition Language (DDL)
Data Query Language (DQL)
Data Control Language (DCL)
Which of the following is an example of programmatic access to a database?
Sending an email with data to be manually inputted into the database
Calling a database through an API endpoint
Manual data entry into the database using a GUI interface
Exporting data from the database to a CSV file using a GUI based database management tool
In database management, what does the term "User Interface/Utility Access" primarily refer to?
The process of adjusting the server settings
Assigning roles and permissions to users
The use of GUI-based tools or software to interact with and perform operations on a database
The process of directly modifying data in a database via SQL commands
Which of the following BEST describes the way a function should be used in a program?
Functions should be used to repeat a block of code continuously until the program ends
Functions should be used to store different types of data values
Functions should never be used in a program
Functions should be used to group related code into a single callable unit
Liam, a software engineer at a tech company, is designing a program that will perform calculations related to the speed of sound. The speed of sound in air under standard conditions is 343 meters per second. Which programming recommendation would work BEST for representing the speed of sound in his program?
Use a function to represent the speed of sound
Use an input parameter to represent the speed of sound
Use a mutable variable to represent the speed of sound
Use a constant to represent the speed of sound
For which of the following languages can you not use pseudocode?
JavaScript
Python
Java
Every language can be pseudocoded to help a programmer plan out their next steps
Every language can be pseudocoded to help a programmer plan out their next steps
