stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Module 4-5 Review Flashcards | StudBud
Explore
/
Module 4-5 Review
Module 4-5 Review
19 terms
·
StudBud Administration
·
17 plays
Review Software Development and Database Fundamentals
Flashcards
19 cards
F
Practice quiz
P
Host live
L
Questions
19
Answers
1
Which of the following would work BEST stored as a flat file rather than stored in a database?
Contact list
Directions to doctor's office
Store inventory
Movie theater locations
2
Which of the following is a compiled language?
Java
Perl
JavaScript
Powershell
3
Which SQL command is used to completely remove a table and all its data?
ALTER
DELETE
UPDATE
DROP
4
What would be the output if the Breakfast program ran on a Sunday? See pseudocode below.
Waffles
Bacon and eggs
Pancakes
Oatmeal
5
Which of the following is the closest to machine language?
Compiled languages
Query languages
Scripted languages
Assembly languges
6
Which describes something in a database that refers to the unique identifier in the parent table?
Attribute
Schema
Foreign key
Constraint
7
For which of these is a RDBMS MOST commonly used?
Storing information
Creating diagrams
Building flowcharts
Generating reports
8
A program needs to choose apples, oranges, or bananas based on a user's input. Which is best to use?
Comment
Datatype
Variable
If
9
Which of these relational database constructs is used to ensure VALID values are entered for a column?
Schema
Permissions
Column
Constraint
10
A system admin want to RETURN RESULTS for a time range within a db. Which command should he use?
UPDATE
INSERT
DELETE
SELECT
11
Which data type should be used when creating a variable to hold a postal code?
Float
Boolean
Integer
String
12
Joe is writing a program that needs to store a # that changes over the duration of the program's run. He should use ...
A Function
A Variable
A Loop
A Constant
13
Which of the following database concepts would MOST likely use a CSV file?
Data persistence
Data importing
Data reports
Data querying
14
Step-by-step instructions and conditional statements that will be used by a computer program to solve a problem is a(n)
Algorithm
Pseudocode
Software
Flowchart
15
Reports analyzing a company's sales, inventory, marketing, and salary data are needed. BEST place to store this data is
a word processor
a flat file
a network share
a database
16
Which of the following is a value that uniquely identifies a database record?
Foreign key
Public key
Private key
Primary key
17
An admin grants permission for a user to access data in a DB. Which action was performed?
Data gathering
Data definition
Data manipulation
Data correlation
18
A function is BEST used for enabling programs to
define variables to hold different values
be divided into reusable components
define needed constant values
hold a list of numbers
19
Jan needs to store output in a place that can be accessed quickly. The data doesn't need to remain persistent. Use a -
RDBMS
memory
SSD
flat file
