
CPT 231 Midterm Part 1
Authored by Reza Naqvi
Computers
University
Used 3+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
40 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
What does a relational database use to uniquely identify each row in a table?
indexes
foreign keys
non-primary keys
primary keys
2.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Assuming the third row in the OrderOptions table has an OrderOptionsID of 3, what does the following SQL statement do?
DELETE FROM OrderOptions
WHERE OrderOptionsID = 3
It deletes the OrderOptionsID column from the OrderOptions table
It deletes the first three rows from the OrderOptions table
It deletes the row in the OrderOptions table that has an ID of 3
It deletes all rows except the first three rows from the OrderOptions table
3.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Code example 19-1
SELECT VendorName, InvoiceNumber, InvoiceDate, InvoiceTotal
FROM Vendors INNER JOIN Invoices
ON Vendors.VendorID = Invoices.VendorID
WHERE InvoiceTotal >= 500
ORDER BY VendorName DESC
(Refer to code example 19-1.) How many columns will the result set have?
7
6
5
4
4.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
To communicate with a DBMS, the application software sends
command objects
SQL Queries
dataset requests
primary keys
5.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
What does the following SQL statement add to the Terms table?
INSERT INTO Terms (TermsDueDays) VALUES (90)
A row with a value of 90 for the TermsDueDays column
90 rows with a column of TermsDueDays
All rows where the TermsDueDays column has a value of 90
A TermsDueDays column with a default value of 90
6.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Which of the following can a SELECT statement not do?
Retrieve data
Create calculated fields
Combine data from two tables
Modify selected data
7.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
The data that’s retrieved by a SELECT statement is called a
check constraint
SQL query
data reader
result set
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
40 questions
SIMULASI DIGITAL - X
Quiz
•
KG - Professional Dev...
45 questions
UAS BSD 1
Quiz
•
University
44 questions
Round 1 Code2duo
Quiz
•
University
40 questions
Grade 6-Sistem Komputer
Quiz
•
6th Grade - University
45 questions
อจ.ฉี
Quiz
•
University
40 questions
Database Systems Quiz
Quiz
•
University
35 questions
Kuis Aplikasi Kamus Digital
Quiz
•
8th Grade - University
36 questions
MOC 20345 Test
Quiz
•
University
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
10 questions
Probability Practice
Quiz
•
4th Grade
15 questions
Probability on Number LIne
Quiz
•
4th Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
6 questions
Appropriate Chromebook Usage
Lesson
•
7th Grade
10 questions
Greek Bases tele and phon
Quiz
•
6th - 8th Grade
Discover more resources for Computers
12 questions
IREAD Week 4 - Review
Quiz
•
3rd Grade - University
20 questions
Endocrine System
Quiz
•
University
7 questions
Renewable and Nonrenewable Resources
Interactive video
•
4th Grade - University
30 questions
W25: PSYCH 250 - Exam 2 Practice
Quiz
•
University
5 questions
Inherited and Acquired Traits of Animals
Interactive video
•
4th Grade - University
20 questions
Implicit vs. Explicit
Quiz
•
6th Grade - University
7 questions
Comparing Fractions
Interactive video
•
1st Grade - University
38 questions
Unit 8 Review - Absolutism & Revolution
Quiz
•
10th Grade - University