Databases and Programming concepts (3-3-4)

What is the difference between a procedure and a function?

• A procedure does something, while a function does something and then returns a value to the main program.

• A function does something, while a procedure does something and then returns a value to the main program.

• A procedure is a container that can grow or shrink in size during program execution as elements are added or removed, while a function cannot be resized.

• A function is a container that can grow or shrink in size during program execution as elements are added or removed, while a procedure cannot be resized.

What type of programming concept allows for a variable size container?

• A procedure

• An array

• A vector

• A function

What is an interpreted programming language?

• Interpreted languages represent machine code in human-readable text and are typically specific to a particular hardware architecture.

• Interpreted languages do not need to be compiled and are designed to retrieve specific records from a data set.

• Interpreted languages do not need to be compiled because the code gets converted to machine code at runtime.

• Interpreted languages organize data through structured nested tags and are rendered by a web browser.

In a program, what does a loop do?

• A loop is a container that can be used as a term to reference multiple values or elements.

• A loop accesses a program element, such as a stored value, class, method, or interface.

• A loop performs one or more instructions until a condition is met.

• Loops grow or shrink in size as elements are added or removed.

What is the best way to install a web application on your computer?

• You do not install a web application on your computer. You access it through your browser.

• Go to the vendor's website and have them mail it to you and install it when the disk arrives.

• Download it from the browser and install it on the computer.

• Call in an IT specialist to come install it for you.

You want to check whether a condition has been met, and if it has, perform one action. Otherwise, you want your program to perform a second action. What sort of programming operation would help achieve this?

• A programming identifier

• A conditional branch

• A simple array

• A continuous loop

What three things define an object?

• Properties, attributes, and methods

• Branches, loops, and operators.

• Data, information, and insights

• Stored value, class, and interface

What shows the structure of code without using the specific syntax of any one language?

• Pseudocode

• Variables

• Functions

• Conditional statements

How does Microsoft SQL Server differ from Microsoft Excel when used to store a dataset?

• Excel is an example of relational database software that is better suited for larger volumes of information and more users, whereas SQL Server is a flat file system.

• Excel is an example of relational database software, whereas SQL Server is a flat file system that is better suited for larger volumes of information and more users.

• Excel is an example of a flat file system that is better suited for larger volumes of information and more users, whereas SQL Server is relational database software.

• Excel is an example of a flat file system, whereas SQL Server is relational database software that is better suited for larger volumes of information and more users.

Which of the following is NOT an example of unstructured data?

• PowerPoint presentation

• Image files

• Text files

• Relational databases