CSCE 4350 (Garlick)

which http repsonse code indicates that the resource was found ok

200

A good way to think of REST is:

A database management system

I want to view the actual data stored in a MariaDB table through phpMyAdmin. Which menu is my best choice?

Browse

explain database normalization:

Cleaning up your data and making sure there is no redundant information

I can only have one table in a database

False

As a client, I want to retrieve something from a web server. I should use this command:

GET

I want to group the data in a query by certain columns. For example, I want a count of the movies each actor has been in. Which clause would be helpful?

GROUP BY

phpMyAdmin could be considered a ____ for mySQL (answer is three letters)

GUI

SELECT Region, COUNT(*) FROM Country_________

Group by region

I want to match a pattern in the WHERE clause of my SELECT statement I should use:

LIKE

I want to match a pattern in the WHERE clause of my SELECT statement. I should use:

LIKE

There is a table of products (Table A) There is another Table of Products which have a small parts warning (table B) I want to see a query of every single product and whether it has a small parts warning or not. This best fits with a(n)

Left Join

Whoa my database returned way too many results. What SQL keyword should i use to just see a certain number of results?

Limit

Pick the SQL function that does NOT exist

PERC()

Several metrics can be analyzed from the data in a database. For ana pp company, pick the metric that does NOT exist:

QPD

Summarize this query:

Raise the product prices by 5% for products supplied by supplier 15

SELECT price COUNT(*) FROM app_list GROUP BY PRICE; what does this SQL do?

Returns a count of the total number of apps for each prince in the table.

SELECT COUNT(Role) FROM employees WHERE Role = "Racketeer"; This query finds:

The number of racketeers in our employees table

I could connect remotely to a database (or DBMS) on another computer via the internet

True

Be careful when using the SQL UPDATE statement. If you omit the _____ clause, ALL records will be updated!

WHERE

Im using a WHERE clause in my SQL statement. im trying to match any strings in the "School" field that contain "UNT" anywhere in the string.

WHERE School like "%UNT%"

The primary key for couchDB is:

_id

A subquery could best be described as:

a query within a query

In a student "entity or table", 'Last_Name' would be considered

attribute

Crows foot is a way to show ____ in an Entity Relationship Diagram

cardinality in relationships between entities

I need several to have logic in my select statements for several if-then scenarios. I should use

case statement

I want to know how many people are in the students table. SELECT _________(*) FROM students;

count

To find the column names for a particular table, I would go to the:

database schema

The ACID test applies to

database trasactions

Choose the correct hierarchy for PilaDB

database->stack->element

I am creating an SQL COUNT statement, but i only want to count duplicate values once. I should use this keyword

distinct

AWS DynamoDB requires you to define all fields in a table before the table can be used

false

Altering the structure of schema of a table AFTER data is entered is not possible in SQL due to potential data corruption

false

Despite the name, NoSQL databases must use SQL for CRUD operations

false

I want to remove the Justin Bieber record from the celebs table. ALTER TABLE celebs FROM COLUMN 'Justin Bieber';

false

Null and zero are the same thing from a database standpoint

false

The FROM clause, and any subsequent JOIN in a query are always executed last

false

The database installed for Wordpress must reside on the same server as the wordpress scripts themselves

false

The reduce function first retrieves a keyed set of data. Then, the map function takes the values reduced to each key, and transforms them into a single value. Using this combination allows you to retrieve summaries directly from the database

false

This query finds the names of all employees that have not been assigned a building

false

This query will not work because it does not indicate which column each piece of data should go in

false

You need to write CREATE TABLE statements to create the associated database when installing wordpress

false

deleting entire tables is not possible in SQL for security reasons.I

false

in MVC, the Controller is typically the database

false

in MVC, the controler is typically the database

false

phpMyAdmin requires the Ruby programming language to run

false

Choose the best answer: When we join orders and customers, we join on customer_id. which is a(n)_______ in orders and the primary key in customers

foreign key

This is a column that contains the primary key of another table in the database

foreign key

type the 4 letter word that you think of first when i say "I'm going to be dealing with multiple tables in SQL"

join

A "Persistence layer" or "DOA" would be most associated with the

model

A persistence layer or DAO's would be associated with the

model

The database ______ is what describes the structure of the tables, and the datatypes that each column of the table can contain

model

A language for writing queries or "asking questions of the database" to retrieve the desired data is:

mySQL

The database _______ is what describes the structure of the tables, and the data types that each column of the table can contain

object

I want to paginate the results of my SQL query. In other words, I would like to have page 1 be results 1-10, page 2 be 11-20, and so on. A useful keyword for me to remember would be:

offset

An attribute or group of attributes that uniquely identifies an instance of the entity in an ERD is the:

primary key

The column in a database table that uniquely identifies the record is a:

primary key

In my SQL statement SELECT * FROM customers WHERE id = 123: the * means...

select all of the columns

I want to create storage of the students in a class, holding their ID numbers, names, and grades. I will build a(n)

table

3NF is more strict than 1NF

true

A KPI might be pulled from a database and displayed in real time on an office wall to track metrics

true

A Primary Key for an entity or table is part of the Entity Relationship Diagram (ERD)

true

A foreign key and primary key can both exist in the same table

true

A goal of the data layer in web application would be to abstract the actual SQL, so that the programmer could store things n objects and have those objects written to the database without writing SQL

true

A primary key for an entity or table is part of an Entity Relationship Diagram (ERD)

true

Before moving to 2NF, a database needs to be in 1NF

true

CouchDB allows you to store binary files

true

DROP TABLE is potentially more dangerous statement than DELETE

true

DynamoDB can scale automatically to increased demand

true

Foreign keys come from another table

true

I could backup a database to SQL format using phpMyAdmin

true

If my user has the proper permissons, I can both mi=odify the data in the database, and add a column to a table in phpMyAdmin

true

LEFT OUTER JOIN will return every row in the left table, and if the join condition is NOT met, NULL values are used to fill in the columns from the right table

true

ORDER BY lets you sort results of a query in either ascending or descending order

true

The results of every SQL query is a table

true

This query lists 2 most populous cities in Mexico.

true

When i leave a comment on a wordpress blog post, some PHP code grabs the comment, likely sanitizes it, and then inserts it into the database table

true

With the proper user permissions, it would be possible to delete an AWS DynamoDB tablel with javascript in a web page

true

mySQL or MariaDB must be installed before installing wordpress

true

part of setting up a Digital Ocean droplet is choosing the physical location of the server

true

phpMyAdmin can be targeted by hackers since it is another point of access to the database

true

subqueries are used to complete an SQL transformation by nesting one query with another

true

you can bulk load data in JSON format into DynamoDB table

true

Choose the method by which a DynamoDB table could NOT be updated

with css