stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Database Fundamentals Flashcards | StudBud
Explore
/
Database Fundamentals
Database Fundamentals
16 terms
·
StudBud Administration
·
170 plays
Test your knowledge on databases!
Flashcards
16 cards
F
Practice quiz
P
Host live
L
Questions
16
Answers
1
A clustered index improves the performance of queries that...
Return large result sets
Return a range of values by using the = operator
Do not use ORDER BY or GROUP BY clauses
2
The VARCHAR data type contains only numeric characters
True
False
3
Fix the statement: A view can be used to ensure referential integrity
Save historical data before deleting it from the base table
Save an extra copy of data stored in a separate table
Limit access to specific rows or columns of data in a table
No change is needed
4
Adding a ___ on the FlightNumber column physically sorts rows in the table by FlightNumber
Clustered Index
Non-Clustered Index
Foreign Key
5
Fix the statement:Use the FROM keyword in a SELECT statement to return rows with conditions
WHERE
ORDER BY
No change is needed
UNION
6
Create an SQL query to retrieve only the names of songs that sold more than 1000 CDs
SELECT * FROM SongInformation WHERE CDsSold= 1000
SELECT * FROM SongInformation
SELECT name FROM CDsSold WHERE CDsSold> 1000
SELECT name FROM SongInformation WHERE CDsSold> 1000
7
You need to change Tia's name to Kimberly. Which statement do you choose
UPDATE GivenName = 'Kimberly' FROM Volunteer
SET GivenName = 'Kimberly' FROM Voulunteer
UPDATE Volunteer SET GivenName='Kimberly'WHERE GivenName=Tia
SET Volunteer TO GivenName = 'Kimberly' WHERE GivenName= Tia
8
You need to ensure that a column or combination of columns uniquely identifies each row
Primary Key
Default Key
Secondary Key
Foreign Key
9
To establish a relationship between data in two tables, which constraint should you define?
Index Key
Foreign Key
Link Key
Default Key
10
Fix the statement: The CREATE TABLE command removes one or more table definitions and all data
DROP TABLE
TRUNCATE TABLE
No change is needed
ALTER TABLE
11
Combine the results of two queries into a single result that contains all rows. Which SQL works
JOIN
UNION
TRUNCATE
EXCEPT
12
The INT data type contains only whole numbers
True
False
13
Adding a ___ on the Airline column retrieves data faster, but will not physically sort rows
Foreign Key
Clustered Index
Non-Clustered Index
14
Fix the statement: In a database table, each
column
represents a unique record
Table
No change is needed
Row
Index
15
A clustered index improves the performance of queries on columns that...
Are accessed sequentially
Are accessed randomly
Are not unique or contain many common values
16
The NUMERIC data type contains only numbers that have decimal places
True
False
