CSCE 4350 UPDATED ACTUAL Questions And Correct Answers
Terms in this set (69)
All database indexes are created automatically by the FALSE
DMBS
The ideal situation for a database index is: A large table that is searched frequently on one column and rarely updated
SQL Statements for Building an Index / Removing an CREATE INDEX / DROP INDEX
Index:
What is the ideal database column for an index A column in a table with many records that contains few NULLS and is searched
frequently
To use a database index, use the "USE INDEX FALSE
[indexname]" syntax
Pick the most likely use of your UNT ID in myUNT a Primary Key
The column in a database table that uniquely identifies primary key
the record is a
Pick the word most associated with 'record' in a database row
I want to create storage of the students in a class, holding table
their ID number, names, and grades. I will build a
I could connect remotely to a database (or DBMS) on True
another computer via the Internet
I want to match a pattern in the WHERE clause of my LIKE
SELECT statement. I should use:
SELECT price, COUNT(*) Returns a count of the total number of apps for each price in the table
FROM app_list
GROUP BY price;
What does this SQL do?
I want to remove the 'Justin Beiber' record from the FALSE
celebs table.
ALTER TABLE celebs DROP COLUMN 'Justin Beiber';
A primary key for an entity or table is part of an Entity TRUE
Relationship Diagram (ERD)
Crow's foot is a way to show __________ in an Entity cardinality in relationships between entities
Relationship Diagram
, In my SQL Statement select all of the columns
SELECT * FROM Customers WHERE id = 123;
the * (asterisk) means...
A 'Transaction' is a group of actions in SQL... where if one action in the transaction fails, they can all be 'rolled back' or un-done
I have a table of all the Countries in the world called GROUP BY Region
'Country'. This table lists each Country, and also the
'Region' the country is in (North American, Caribbean,
etc). I want to find a count of the number of Countries in
each Region. What am I missing at the end of my SQL?
SELECT Region, COUNT(*) FROM Country ______ ;
Deleting entire tables is not possible in SQL for security FALSE
reasons.
Altering the structure of schema of a table AFTER data is FALSE
entered is not possible in SQL due to potential data
corruption.
Whoa - my database returned way too many results. LIMIT
What SQL keyword should I use to just see a certain
number of results?
There is a Table of Products (Table A). LEFT JOIN
There is another Table of the product IDs from Table A
which have a Small Parts Warning (this is 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):
SELECT DISTINCT building_nameFROM buildings LEFT FALSE
JOIN employeesON building_name = buildingWHERE
building IS NULL;
This query finds the names of all employees that have not
been assigned a building
The result of every SQL query is a table TRUE
This query lists the 2 most populous cities in Mexico. TRUE
This query will not work because it does not indicate FALSE
which column each piece of data should go in.
This query finds: The number of Racketeers in our 'employees' table
For the DELETE SQL statement it's recommended that TRUE
you run the constraint in a SELECT query first to ensure
that you are removing the right rows.
Terms in this set (69)
All database indexes are created automatically by the FALSE
DMBS
The ideal situation for a database index is: A large table that is searched frequently on one column and rarely updated
SQL Statements for Building an Index / Removing an CREATE INDEX / DROP INDEX
Index:
What is the ideal database column for an index A column in a table with many records that contains few NULLS and is searched
frequently
To use a database index, use the "USE INDEX FALSE
[indexname]" syntax
Pick the most likely use of your UNT ID in myUNT a Primary Key
The column in a database table that uniquely identifies primary key
the record is a
Pick the word most associated with 'record' in a database row
I want to create storage of the students in a class, holding table
their ID number, names, and grades. I will build a
I could connect remotely to a database (or DBMS) on True
another computer via the Internet
I want to match a pattern in the WHERE clause of my LIKE
SELECT statement. I should use:
SELECT price, COUNT(*) Returns a count of the total number of apps for each price in the table
FROM app_list
GROUP BY price;
What does this SQL do?
I want to remove the 'Justin Beiber' record from the FALSE
celebs table.
ALTER TABLE celebs DROP COLUMN 'Justin Beiber';
A primary key for an entity or table is part of an Entity TRUE
Relationship Diagram (ERD)
Crow's foot is a way to show __________ in an Entity cardinality in relationships between entities
Relationship Diagram
, In my SQL Statement select all of the columns
SELECT * FROM Customers WHERE id = 123;
the * (asterisk) means...
A 'Transaction' is a group of actions in SQL... where if one action in the transaction fails, they can all be 'rolled back' or un-done
I have a table of all the Countries in the world called GROUP BY Region
'Country'. This table lists each Country, and also the
'Region' the country is in (North American, Caribbean,
etc). I want to find a count of the number of Countries in
each Region. What am I missing at the end of my SQL?
SELECT Region, COUNT(*) FROM Country ______ ;
Deleting entire tables is not possible in SQL for security FALSE
reasons.
Altering the structure of schema of a table AFTER data is FALSE
entered is not possible in SQL due to potential data
corruption.
Whoa - my database returned way too many results. LIMIT
What SQL keyword should I use to just see a certain
number of results?
There is a Table of Products (Table A). LEFT JOIN
There is another Table of the product IDs from Table A
which have a Small Parts Warning (this is 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):
SELECT DISTINCT building_nameFROM buildings LEFT FALSE
JOIN employeesON building_name = buildingWHERE
building IS NULL;
This query finds the names of all employees that have not
been assigned a building
The result of every SQL query is a table TRUE
This query lists the 2 most populous cities in Mexico. TRUE
This query will not work because it does not indicate FALSE
which column each piece of data should go in.
This query finds: The number of Racketeers in our 'employees' table
For the DELETE SQL statement it's recommended that TRUE
you run the constraint in a SELECT query first to ensure
that you are removing the right rows.
