A data type that can hold a singular character.

What statement regarding NoSQL databases is correct?

Each row can store different types of data.

BEST describe the permissions a user has for a database object after creating the object while logged in their account.

The object's creator has complete control over that object.

A collection of characters, ie. words, sentences, names and addresses.

Creating a simple website form to survey visitors about their favorite hobbies would MOST likely be for what purpose?

To directly input the survey data into a database.

What is an example of Notational System?

Decimal numbers, are 0 9. And found in IPV4 addresses ( ie. 192.168.10.1)

What is the purpose of Flowcharts?

A flowchart is a graphical way to see the program from start to end.

Which of the following is an advantage of using a relational database over a key/value pair database?

Relational databases use SQL to retrieve data from the database.

What is a float? Pick the best answer.

A float is ( can hold) any number with a decimal.

A data type allows a program to interpret the data it receives.

An interger, or int, is (can hold) any whole number.

What statement regarding NoSQL databases is correct?

They are more scalable than relational databases.

Which of the following would be a significant advantage of switching from Excel to a database for storing customer data?

A databases makes analyzing a million records as easy as a few hundred.

Which is an example of why an application or utility would need a database for persistent data storage?

A customer fills out an online form to order a Bluetooth speaker.

You created an array that can hold 15 items, all integer data type. To add a 16th integer. Which is the best approach.

Create a vector and replace the array with it.

studbud

ITF+ Domains IV & V Programming & Databases

84 termsStudBud Administration11 plays

Imported from external platform

Flashcards84 cardsFPractice quizPHost liveL

Questions 84

Answers

1
What is a char?
A data type that can hold a singular character.
An integer.
A greeting amongst elderly friends.
The value 5x is a char.
2
Which of the following programming language types is the lowest-level language?
Compiled
Query
Interpreted
Assembly
3
What statement regarding NoSQL databases is correct?
They store data the same as relational databases.
They are less scalable than relational databases.
Each row must store the same type of data.
Each row can store different types of data.
4
BEST describe the permissions a user has for a database object after creating the object while logged in their account.
The object's creator can deny permissions to the object for user accounts.
The object's creator has all permissions except those limited by the DENY.
The object's creator has complete control over that object.
The object's creator is limited to permissions given by the GRANT command.
5
A user, Ann, is granted permissions to a database. What is this an example of?
Direct/manual access
Data manipulation
Data definition
Data collection
6
Which of the following language types would a web developer MOST likely use to create a website?
Query
Compiled
Interpreted
Assembly
7
You have created a relational database. Which of the following elements uniquely identifies a record in the database?
Primary key
Field
Foreign key
Schema
8
A NOT NULL __________ is a rule that prevents certain fields in a database from being left blank.
schema
scalability
query builder
constraint
9
Michael, an administrator, needs to add a column to an existing table. Which command should he use?
CREATE
INSERT
ALTER
UPDATE
10
What is a string?
A collection of characters, ie. words, sentences, names and addresses.
A data type that represents whole numbers in programming.
Strings are designated by no quotes.
A string is a collection of yarn parts.
11
Which of the following database features would provide a formatted, easy-to-read listing of the results of a query?
Record
Form
SQL command
Report
12
A value that's used to identify a record from a linked table is called a ________________.
Primary Key
Borrowed Key
Foreign Key
Linked Key
13
Which of the following is a NoSQL database?
MongoDB
Microsoft SQL Server
Oracle Database
MySQL
14
Creating a simple website form to survey visitors about their favorite hobbies would MOST likely be for what purpose?
To create a database to store the survey data.
To directly input the survey data into a database.
To transfer the survey data from one database to another.
To create a flat file for each person who fills out the survey.
15
Which of the following database concepts describes the ability to grant rights for specific objects, tables, or columns?
Data Definition Language (DDL)
Programmatic access
Direct access
Permissions
16
Name a primary architectural component of a table for storing database information in a relational database.
Variables
Fields
Forms
Strings
17
You need to use a code designation for non-English letters. Which notational system does the developer need to use?
ASCII
Strings
Unicode
International
18
Which of the following numbers is written in hexadecimal format?
18AF
100101
100101.11
3268
19
What is an example of Notational System?
Programming languages, such as Python, Java, C++, and Ruby.
Decimal numbers, are 0 9. And found in IPV4 addresses ( ie. 192.168.10.1)
Geographic coordinate systems, such as latitude and longitude.
A system of numbering when taking notes in school.
20
What is the purpose of Flowcharts?
A flowchart is a graphical way to see the program from start to end.
To track the Macey's day parade.
A file system.
To see comments within code.
21
To create a copy of entire database. Which SQL (Structured Query Language) commands can be used?
CREATE BACKUP database_name
BACKUP DATABASE database_name
CREATE BACKUP DATABASE database_name
BACKUP database_name
22
You want to write code that directly accesses the computer's hardware. What type of language should you use?
Assembly
Query
Complied
Interpreted
23
Which of the following programming language types is the lowest-level language?
Interpreted
Compiled
Query
Assembly
24
Which of the following is an advantage of using a relational database over a key/value pair database?
Relational databases allow for unstructured data.
They do not require all fields to be associated with each data object.
Relational databases require much less storage space.
Relational databases use SQL to retrieve data from the database.
25
Not using SQL commands, provide graphical interface tool to quickly find product information in a relational database.
User interface access
DBMS (database management system)
Query builder
Collaboration software
26
What type of high-level programming language is translated into machine code once and then executed many times?
Compiled
Scripted
Markup
Scripting
27
What is a float? Pick the best answer.
7 or 26.
Random generated numbers.
A float is ( can hold) any number with a decimal.
In the Macy's Day Parade.
28
You have increased the number of compute nodes for your cloud-based database instance. Which term describes this action?
Scaling out
Scaling in
Scaling down
Scaling up
29
write a program that needs to accept an input of someone's name. What type of variable should the programmer create?
Unicode
String
Float
Char
30
To understand the sequence of a program, from start to finish. Which is the best to use for this purpose?
Pseudocode
Object
Flowchart
Function
31
What is a Data Type?
Tells the computer its not you its me.
A file system.
A data type allows a program to interpret the data it receives.
A classification of hardware based on processing speed and capabilities.
32
Which of the following database objects provides a summary of data?
Tables
Forms
Queries
Reports
33
Which of the following are examples of object-oriented programming languages?
XML
C
SQL
Java
34
What is an Integer?
Slang for a guy liking a girl.
A number like 2.5 or 0.92.
A string of characters.
An interger, or int, is (can hold) any whole number.
35
Looping logic makes use of which of the following statements?
when
while
loop
if
36
What statement regarding NoSQL databases is correct?
Each row must store the same types of data.
Each row must store the same type of data.
They are less scalable than relational databases.
They are more scalable than relational databases.
37
Which of the following are the fundamental types of relational methods associated with Structured Query Language (SQL)?
Define the database structure
Back up the data in a database
Increase the storage space for the database
Upgrade the database software
38
A program shows the number 11010.11. Which data type is this?
Boolean
Binary
Float
Integer
39
Which of the following numbers is written in hexadecimal format?
3268.3
100101.11
100101
18AF
40
To understand the sequence of a program, from start to finish. Which of the following is the best use for this purpose?
Flowchart
Object
Pseudocode
Function
41
Which of the following would be a significant advantage of switching from Excel to a database for storing customer data?
A database is useful for tracking simple data, such as customer addresses.
A database is difficult to secure due to users different privilege levels.
A database is useful for transferring information between systems.
A databases makes analyzing a million records as easy as a few hundred.
42
Access methods a developer uses on an application so they can read, write, update, and delete database records?
User interface access
Programmatic access
Query builder
Direct access
43
Which is an example of why an application or utility would need a database for persistent data storage?
A student creates and saves a graphic image.
A business manager edits and saves a PowerPoint presentation.
A system manager edits and saves a network device's configuration.
A customer fills out an online form to order a Bluetooth speaker.
44
Which of the following are examples of interpreted language?
Markup
Compiled
Query
Scribbled
45
Which of the following are examples of object-oriented programming languages? (Choose two.)
C programming language
Java
XML
Monty
46
A program shows the number 11010.11. Which data type is this?
Binary
Boolean
Float
Integer
47
You created an array that can hold 15 items, all integer data type. To add a 16th integer. Which is the best approach.
Create a separate variable for the 16th integer.
Create a vector and replace the array with it.
Convert the integers to floats and add the 16th integer.
Add it to the existing array.
48
Which type of database does not use a rigid schema?
Cloud
On-premises
NoSQL
Relational
49
A school has a database with for tables, but it needs a fifth table. Which command is used to accomplish this task?
INSERT
ALTER
UPDATE
CREATE
50
Which of the following are examples of object-oriented programming languages?
Python
Lava
XML
C programming language
51
Commands to build a database query to return the results from the start of January through the end March?
INSERT
UPDATE
ALTER TABLE
SELECT
52
Which of the following consists of columns and rows of numerical or text data?
Document database
Database dump
Relational database
Key/value database
53
Which of the following can be used to ask a database questions and receive the data we're looking for?
Forms
Reports
Queries
Tables
54
For code that directly accesses the computer hardware. Which is the best type of language for the programmer to use
Assembly
Query
Interpreted
Complied
55
What are conditional statements?
Statements instruct computer to execute a set of instructions repeatedly.
Statements used for errors & exceptions may occur during program execution.
There is no such thing.
Are a type of programming construct.
56
What is a Loop?
A type of function used for mathematical calculations in programming.
A data structure used for storing multiple values of the same data type.
Loops repeat a block of code, exits when a condition is met.
A sequence of instructions in computer program that is executed only once.
57
Looping logic makes use of which of the following statements?
if
when
while
loop
58
Which of the following languages provides a command for inserting new records in new rows into a database?
DCL (Data Control Language)
HTML (HyperText Markup Language)
DDL (Data Definition Language)
DML (Data Manipulation Language)
59
Which of the following are examples of interpreted language?
Scripted
Query
Compiled
Markdown
60
Flowcharts depict which one of the following?
Functions
Objects
Programs
Identifiers
61
A database administrator, added a foreign key to a table in a database. Which describes the purpose of a foreign key?
To allow the storage of unstructured data.
For one database to reference another database.
To provide a way to distinguish records within a table.
For one table to reference records in another table.
62
A database can store a variety of data in each table. Which is the BEST example of a variety of data within a table?
A table with a variety of string fields
A table with date, purchase amount, and customer name fields
A table with integer, float, and decimal fields
A string field that allows for numbers, characters, and punctuation
63
You have increased the amount of RAM available for your cloud-based database instance. Which term describes this action?
Scaling down
Scaling in
Scaling up
Scaling out
64
Your code needs to execute the same code for each month of the year. Which type of loop is best suited for this?
If
Switch
For
Assembly
65
Writing a program that needs to accept an input of someone’s name. What type of variable should the programmer create?
String
Unicode
Float
Char
66
What type of programming language is designed to retrieve data from a database? Query
Assembly
Query
Interpreted
Compiled
67
Which of the following is an example of a markup language?
Python
SQL
XML (extensible markup language)
Java
68
A developer needs to use code designation for non-English letters. Which notational system does the developer need?
Strings
Unicode
ASCII
International
69
What is Pseudocode?
Pseudocode means Fake code.
Code written in an advanced programming language used by programmers.
A visual representation of a program's flowchart.
Helps explain the purpose of the universe, step by step, in plain language.
70
Which of the following is MOST likely used to represent international text data?
Octal
Hexadecimal
ASCII
Unicode
71
Which of the following is an example of a markup language?
Java
SQL
XML
Python
72
What type of high-level programming language is translated into machine code once and then executed many times?
Markup
Scripted
Scripting
Compiled
73
Which of the following programming languages requires a compiler?
Microsoft PowerShell
Assembly
C (programming language)
Linux bash
74
Which type of database uses a rigid schema?
On-premises
NoSQL
Cloud
Relational
75
What is another term used to refer to a field?
Collection
Column
Foreign key
Row
76
What have we learned about Objects?
Objects are a collection of attributes, properties, and methods.
Can be seen and touched.
Methods can be represented in 0s and 1s.
Objects can be represented in boolean
77
SQL commands help manage permissions in database using direct database access method to run several SQL commands on RB
DELETE
GRANT
SELECT
UPDATE
78
You are creating a function that must return either true or false. Which data type should the function return?
Integer
Boolean
String
Character
79
What type of programming language is designed to retrieve data from a database?
Assembly
Compiled
Query
Interpreted
80
Flowcharts depict which of the following?
Objects
Functions
Programs
Identifiers
81
A database has become corrupted. Which SQL command would you use to import the most recent database backup?
INSERT INTO
UPDATE
RESTORE
DROP TABLE
82
Which of the following are basic architectural components of a relational database?
XML
Constraints
Primary keys
Fields
83
Laura, your manager, instructs you to remove a table from a database permanently. Which command should you use?
ALTER
DROP
REMOVE
DELETE
84
What is a Boolean?
A boolean, or bool, can hold a value of true or false.
A boolean is an unuseful data type.
Is a type of soup.
An integer number.

ITF+ Domains IV & V Programming & Databases Flashcards | StudBud